Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

On July 31, 2022, Sheridan Company had a cash balance per books of $6,325.00. The statement from Dakota State Bank on that date showed a

On July 31, 2022, Sheridan Company had a cash balance per books of $6,325.00. The statement from Dakota State Bank on that date showed a balance of $7,875.80. A comparison of the bank statement with the Cash account revealed the following facts.

1. The bank service charge for July was $16.00.
2. The bank collected $1,705.00 from a customer for Sheridan Company through electronic funds transfer.
3. The July 31 receipts of $1,387.30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31.
4. Company check No. 2480 issued to L. Taylor, a creditor, for $354.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $345.00.
5. Checks outstanding on July 31 totaled $2,018.10.
6. On July 31, the bank statement showed an NSF charge of $760.00 for a check received by the company from W. Krueger, a customer, on account.

(a)

Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first. Round answers to 2 decimal places, e.g. 5,275.25.)

SHERIDAN COMPANY Bank Reconciliation choose the accounting period For the Year Ended July 31, 2022For the Month Ended July 31, 2022July 31, 2022

select an opening name for section one Deposits in transitOutstanding checksCash balance per bank statementError in recording check No. 2480Electronic funds transfer receivedAdjusted cash balance per bankNSF checkBank service charge

$enter a dollar amount

select between addition and deduction AddLess:

select a reconciling item Electronic funds transfer receivedNSF checkBank service chargeDeposits in transitCash balance per bank statementOutstanding checksAdjusted cash balance per bankError in recording check No. 2480

enter a dollar amount

enter a subtotal of the two previous amounts

select between addition and deduction AddLess:

select a reconciling item Deposits in transitElectronic funds transfer receivedCash balance per bank statementError in recording check No. 2480Outstanding checksAdjusted cash balance per bankBank service chargeNSF check

enter a dollar amount

select a closing name for section one NSF checkError in recording check No. 2480Bank service chargeElectronic funds transfer receivedCash balance per bank statementOutstanding checksDeposits in transitAdjusted cash balance per bank

$enter a total amount for the first section

select an opening name for section two NSF checkDeposits in transitError in recording check No. 2480Bank service chargeOutstanding checksAdjusted cash balance per booksCash balance per booksElectronic funds transfer received

$enter a dollar amount

select between addition and deduction AddLess:

select a reconciling item NSF checkCash balance per booksOutstanding checksDeposits in transitBank service chargeError in recording check No. 2480Adjusted cash balance per booksElectronic funds transfer received

enter a dollar amount

enter a subtotal of the two previous amounts

select between addition and deduction AddLess:

select a reconciling item Error in recording check No. 2480Cash balance per booksElectronic funds transfer receivedOutstanding checksAdjusted cash balance per booksNSF checkDeposits in transitBank service charge

$enter a dollar amount

select a reconciling item Error in recording check No. 2480Electronic funds transfer receivedBank service chargeNSF checkDeposits in transitAdjusted cash balance per booksOutstanding checksCash balance per books

enter a dollar amount

select a reconciling item Bank service chargeAdjusted cash balance per booksOutstanding checksDeposits in transitError in recording check No. 2480NSF checkElectronic funds transfer receivedCash balance per books

enter a dollar amount

enter a subtotal of the three previous amounts

select a closing name for section two Adjusted cash balance per booksDeposits in transitCash balance per booksError in recording check No. 2480Outstanding checksElectronic funds transfer receivedNSF checkBank service charge

$enter a total amount for the second section

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions