APETA Using Excel to Prepare a Bank Hornvillation PROBLEM On May 31, I Games Lad revered it from the Ean Co Savings Bank A chew on o of during the last week of May was returned with the hank statement as NSF The ms that had bens deposited pany had write and mailed out cheps that bad at yet cleared the bank Cheque #791, which was pay for advertising expenses, was To incorrectly recorded in the general ledger. During the month, one of 11ustomers paid their accmant using an electronic funds transfer. The cash 12 receipts for May 31 had been deposited in the night drop slet at the bank oo 13 the evening of May 31. These were not reflected on the back statement for 1a May The following amounts were derived from comparing the back statement and the accounting records for May tical fas indiced Use the SUM fin Prepare the bank conciliation for at May 31. Show and subtracted as negative Games Lad Bank Reconciliation As of May 31 15 16 17 Add Less 18 General ledger cash balance, May 31 $ 8,600 19 Bank statement balance, May 31 12,200 20 May 31 night bank deposit 1,650 21 Cheques mailed out not yet cleared the bank 4,235 Add: 22 NSF cheque 1,120 3 Bank service charges 55 Cheque #791 actual amount 230 Cheque #791 amount recorded in general ledger 3201 EFT from customer received by bank 2,100 BCover Page Q1 Q2 Q3 Q4 on Mode: Automatic Workbook Statistics Less: Service charge b. What cash should JB report on its statement of financial position as at Mavi What 147 Prepce the journal marie aary art of the bank t prepend is part Toad for EFT To admit for check error To adet for service charges) 8 Cover Page Q1 02 03 04 fe Automatic Workbook Statistics To adjust for NSF cheque lyi Mis Dubie Credi Ce Teedback to Minow