Scenario: On April 31st, 2022, your lemonade stand has a Cash balance of $800. Over the course of the month, they wrote $10,000 in checks, but $200 of those checks haven’t been processed by your local bank. In addition, $170 out of their $20,000 in cash receipts still needs to be deposited in the local bank.
However, on their bank statement, it shows a Cash Balance of $850 and includes the following items not yet recorded by the company: a note receivable collected by the bank for $200, interest earned on that note of $20, and a bank service fee of $50. In addition, the bank accidentally charged your lemonade stand $50 for a service fee that was meant to be on another customer’s account. Lastly, one of your lemonade stand's customer’s checks for $100 returned back with non-sufficient funds.
Prepare the bank reconciliation to correct the ending Cash Balance on April 31st, 2022.