I am having problems getting the bank reconciliation for the pictures below.
Required information [The following information applies to the questions displayed below.] 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,074 and No. 5893 for $495. 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 TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 20,000 9, 845 11, 796 21, 951 CHECKS AND DEBITS DEPOSITS AND CREDITS Date NO . Amount Date Amount 09/03 5888 1, 074 09/05 1, 116 09/04 5902 748 09/12 2, 291 09/07 5901 1, 847 09/17 644 NSF 09/21 4, 312 09/25 2 , 381 09/20 5905 903 09/30 16 IN 09/22 5903 410 09/30 1, 680 CM 09/22 5904 2, 062 09/28 5907 267 09/29 5909 1, 890 From Chavez Company's Accounting Records Cash Receipts Deposited Cash Date Debit Sept. 5 1, 116 12 2, 291 21 4, 312 25 2, 381 30 1, 749 11, 849 Cash Payments Cash Check No. Credit 5901 1, 847 5902 748 5903 410 5904 2, 023 5905 903 5906 1, 048 5907 267 5908 378 5909 1, 890 9, 514Cash Acct. H0. 181 Date Explanation Pll Debit Credit Balance Aug. 31 Balance 13,431 Sept. 38 Total receipts R12 11,349 33,283 33 Total payments D23 9,514 28,766 Additional Information {a} Check No. 5904 is correctly drawn for $2,062 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,023. {b} The NSF check shown in the statement was originally received from a customer, 5. 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,580 note for Chavez Company by the bank. The collection is not yet recorded. Required: 1. Prepare the September 30 bank reconciliation for this company. Bank statement balance _ Book balance m m: Deducl: Adjusted bank balance Adjusted book balance