Donna's Day care - Bank Reconciliation :

Prepare the bank reconciliation statement as at July 31 for Donna's Day care based on the information provided below.

Prepare the bank reconciliation statement using Word or Excel and upload that file here below:

Cash balance per bank, July 31	$5,586
Cash balance per general ledger, July 31	5,055
Outstanding cheques	1,816
Deposit in transit	750
NSF cheque returned by bank, for accounts receivable	450
July interest earned, on bank statement	15
Wrote cheque no. 800 as for $1,100; recorded payment in books for $800.
Bank erroneously recorded a $5,800 deposit for $6,000.