How to provide a bank reconciliation?

Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No.5888 for $1,037 and No. 5893 for $514. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation From the September 30 Bank Statement PREVIOUS BALANCE 18,000 TOTAL CHECKS AND DEBITS 9,916 TOTAL DEPOSITS AND CREDITS 11,445 CURRENT BALANCE 19,529 CHECKS AND DEBITS Date No. Amount @9/03 5888 1,037 @9/04 5902 760 09/07 5901 1,837 09/17 646 NSF 09/20 5905 960 09/22 5903 421 09/22 5904 2,102 09/28 5907 278 09/29 5909 1,875 DEPOSITS AND CREDITS Date Amount 09/05 1,182 09/12 2,291 09/21 4,084 09/25 2,336 09/30 22 IN 09/30 1,530 CM CHECKS AND DEBITS Date No. Amount 09/03 5888 1,037 09/04 5902 760 09/07 5901 1,837 09/17 646 NSF 09/20 5905 960 09/22 5903 421 09/22 5904 2,102 09/28 5907 278 @9/29 5909 1,875 DEPOSITS AND CREDITS Date Amount 09/05 1,182 09/12 2,291 09/21 4,084 09/25 2,336 09/30 22 IN 09/30 1,530 CM From Chavez Company's Accounting Records Cash Receipts Deposited Cash Date Debit Sept. 5 1,182 2,291 4,084 25 2,336 30 1,715 11,608 Cash Payments Cash Check No. Credit 5901 1,837 5902 760 5903 421 5904 2,063 5905 960 5906 1,034 5907 278 5908 379 59e9 1,875 9,607 PR Debit Credit Cash Date Explanation Aug. 31 Balance Sept. 30 Total receipts 3e Total payments Acct. No. 101 Balance 16,449 28,057 18,450 11,608 R12 D23 9,607 Additional Information (a) Check No. 5904 is correctly drawn for $2,102 to pay for computer equipment; however, the recordkeeper misread the amount and entered it in the accounting records with a debit to Computer Equipment and a credit to Cash of $2.063. (b) The NSF check shown in the statement was originally received from a customer, S. Nilson, payment of her account Its return has not yet been recorded by the company (c) The credit memorandum (CM) is from the collection of a $1,530 note for Chavez Company by the bank. The collection (a) Check No. 5904 is correctly drawn for $2,102 to pay for computer equipment, however, the recordkeeper misread the amount and entered it in the accounting records with a debit to Computer Equipment and a credit to Cash of $2,063. (b) The NSF check shown in the statement was originally received from a customer, S. Nilson, in payment of her account. Its return has not yet been recorded by the company. (c) The credit memorandum (CM) is from the collection of a $1,530 note for Chavez Company by the bank. The collection is not yet recorded