Question
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started