Quite a bit for this one, I'm so lost with bank reconciliation.

Someone please explain correct how to derive to solution, I'll give a thumbs up. I just need help!

The cash records and bank statement for the month of May for Copperfield Entertainment are shown below. Description DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer DC Debit card Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to checks number 469 and number 470, which are outstanding as of April 30, 2024 (prior month). b. The bank made the EFT on May 20 in error. The bank accidentally charged Copperfield for payment that should have been made on another account. Required: 1. Prepare a bank reconciliation for Copperfield's checking account on May 31, 2024. 2. Record the necessary cash adjustments. Complete this question by entering your answers in the tabs below. Prepare a bank reconciliation for Copperfield's checking account on May 31, 2024. (Amounts to be deducted should be indicated with a minus sign. Total entries to the same account together when entering in the bank reconciliation.) Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Total entries to the same account together when entering in the journal entry carousel.) Journal entry worksheet Record the amounts that increase cash. Note: Enter debits before credits. Record the necessary cash adjustments. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. Total entries to the same account together when entering in the journal entry carousel.) Journal entry worksheet Note: Enter debits before credits