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

1.The bank service charge for July was $22.00.2.The bank collected $1,650.00 from a customer for Sheridan Company through electronic funds transfer.3.The July 31 receipts of $1,326.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 $364.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $346.00.5.Checks outstanding on July 31 totaled $1,972.10.6.On July 31, the bank statement showed an NSF charge of $705.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.)

SHERIDAN COMPANY

Bank Reconciliation

choose the accounting period

select an opening name for section one

$enter a dollar amount

select between addition and deduction

:

select a reconciling item

enter a dollar amount

enter a subtotal of the two previous amounts

select between addition and deduction

:

select a reconciling item

enter a dollar amount

select a closing name for section one

$enter a total amount for the first section

select an opening name for section two

$enter a dollar amount

select between addition and deduction

:

select a reconciling item

enter a dollar amount

enter a subtotal of the two previous amounts

select between addition and deduction

:

select a reconciling item

$enter a dollar amount

select a reconciling item

enter a dollar amount

select a reconciling item

enter a dollar amount

enter a subtotal of the three previous amounts

select a closing name for section two

$enter a total amount for the second section