Company’s Bank statement shows a cash balance of $31,000, which is different from the one reported on the trial balance. Please prepare a bank conciliation using the following information.
a. Outstanding checks of $6,500
b. A note from a customer for the amount of $1,500 is cleared at the bank, but forgot to be recorded on the book.
c. A check collected from the customer in the amount of $300 was bounced
d. Earned interest of $55
e. Bank service charge for the return check was $25
f. A check cleared for $570 was recorded as $750 on the book