1. 2 3. On July 31, 2022. Keeds Company had a cash balance per books of $6.140.00. The statement from Dakota State Bank on that date showed a balance of $7,690,80. A comparison of the bank statement with the Cash account revealed the following facts. The bank service charge for July was $25.00 The bank collected $1,520.00 from a customer for Keeds Company through electronic funds transfer. The July 31 receipts of $1,193,30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31. Company check No. 2480 issued to L. Taylor, a creditor, for $384.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $348.00 Checks outstanding on July 31 totaled $1,860.10. On July 31. the bank statement showed an NSF charge of $575.00 for a check received by the company from W.Krueger, a customer, on account 4. 5. 6. (a) Your answer is correct Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.) KEEDS COMPANY Bank Reconciliation July 31, 2022 . Cash balance per bank statement 7690 80 Bank Reconciliation July 31, 2022 $ 7670. Cash balance per bank statement : Add : Deposits in transit 1193.30 08410 Less : Outstanding checks 1860.10 i Adjusted cash balance per bank . $ 7024 $ 6110 Cash balance per books Electronic funds transfer received : Add 1 1520 7600 Less Bank service charge NSF check Error in recording check No. 2480 5751 361 Adjusted cash balance per books $ 7024 Prepare the necessary adjusting entries at July 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date. Account Titles and Explanation Debit Credit July 31 (To record electronic funds transfer received by bank) 31. (To record NSF check) 31. (To correct error in recording check) 31 (To record bank service charge) e Textbook and Media List of Accounts