1 of 4 (0 complete) The May 31 bank statement of Neighborhood Services Association (NSA) has just arrived from Scotiabank. To prepare the NSA bank reconciliation you gather the following data: E (Click the icon to view the additional data for the bank reconciliation.) Required 1. Prepare the bank reconciliation for NSA 2. Joumalize the May 31 transactions needed to update NSA's Cash account. Include an explanation for each entry Requirement 1. Prepare the bank reconciliation for NSA, and then continue with the book side of the reconciliation (Enter amounts to two decimal places. Leave unused cells blank.) Neighborhood Services Association Bank Reconciliation May 31 BANK Add: Less Choose from any list or enter any number in the input fields and then continue to the next question X i Data Table wing d ati kr so a. NSA's Cash account shows a balance of $6,565.48 on May 31. b. The May 31 bank balance is $8,257 25. C. The bank statement shows that NSA earned $16.38 of interest on its bank balance during May. This amount was added to NSA's bank balance. d. NSA pays utilities ($270) and insurance ($120) by EFT. The following NSA cheques did not clear the bank by May 31: th used e. soci Cheque No. Amount 7 237 $ 45.80 288 141.00 291 522.15 293 11.47 294 609.47 295 8.62 296 101.38 f. The bank statement includes a donation of $780, electronically deposited to the bank for NSA Ids a Print Done 237 $ 45.80 288 141.00 291 522.15 293 11.47 294 609.47 295 8.62 296 101.38 f. The bank statement includes a donation of S780, electronically deposited thithe bank for NSA g. The bank statement lists a $11.50 bank service charge. h. On May 31, the NSA treasurer deposited S16.15. which will appear on the June bank statement. i. The bank statement includes a $315 deposit that NSA did not make. The bank added $315 to NSA's account for another company's deposit. The bank statement includes two charges for returned cheques from donors. One is a 375 cheque received from a donor with the imprint "Unauthorized Signature. The other is a nonsufficient funds cheque in the amount of $66 85 received from a client