M5-12 (Algo) Preparing a Bank Reconciliation [LO 5-4] Use the following bank statement and T-account to prepare the May 31 bank reconciliation. BANK STATEMENT 7:40 Date May 1 Checks Deposits Other Balance $ 460 May 4 #2 $ 75 $ 115 500 May 12 #4 165 NSF check $ 115 220 May 28 #5 85 135 May 30 #6 80 460 515 May 31 #8 120 Service charge 70 325 Cash (A) Debit Credit nt May 1 460 May 3 115 75 May 3 #2 75 May 4 #3 165 May 8 #4 85 ences May 11 #5 80 May 21 #6 May 29 460 90 May 29 #7 May 30 280 120 May 30 #8 May 31 625 Bank Statement Ending Balance per Bank Statement Additions: Deductions: Bank Reconciliation May 311 Company's Books Ending Balance per Cash Account Additions: 0 0 Deductions: 0 0 Up-to-Date Cash Balance $ 0 Up-to-Date Cash Balance $ 0 0 0