On July 31, 2022, Shamrock Company had a cash balance per books of $6,320. The statement from Dakota State Bankon that date showed a balance of $7,870,80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $21. 2. The bank collected $1,700.00 for Shamrock Company through electronic funds transfer. 3. The July 31 receipts of $1,377.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. 4. Company check No. 2480 issued to L. Taylor, a creditor, for $374 that cleared the bank in July was incorrectly entered in the cash payments record on July 10 for $347. 5. Checks outstanding on July 31 totaled $2.031.10. 6. On July 31, the bank statement showed an NSF charge of $755.00 for a check received by the company from W. Krueger. a customer, on account. Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank \& books first) SHAM Butstanding checks Adjusted cash balance per bank Bank service charge Deposits in transit Cash balance per bank statement NSF check Error in recording check No. 2480 5 Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank \& books first) 5 5 I 5