Excercise 5-7 Bank Reconciliation LO 3

a. the october 31 cash balance in the general ledger is $844

b. the october 31 balance shown on the bank statement is $373

c. checks issued but not returned with the bank statement were No. 462 for $13 and No. 483 for $50

d. a deposit made late on October 31 for $450 is included in the general ledger balance but not in the bank statement balance

e. returned with the bank statement was a notice that a customers check for $75 that was deposited on october 25 had been returned because the customers account was overdrawn

f. during a review of the checks that were returned with the bank statement, it was noted that the amount of check No. 471 was $65 but that in the companys records supporting the general ledger balance, the check had been erroneously recorded as a payment of an account payable in the amount of $56.

Prepare a bank reconciliation as of October 31 from the above information???(answer is in table form with two columns one heading bank statement balance and other book balance)