This Test: 55 pts p The August 31 bank statement of Neighborhood Services Association (NSA) has just arrived from Scotiabank. To prepare the NSA bank reconciliation, you gather the following data: (Click the icon to view the additional data for the bank reconciliation.) Required i Data Table - X 1. Prepare the bank reconciliation for NSA. 2. Journalize the August 31 transactions needed to update NSA's Cash account. Include an explanation for each entry. a. NSA's Cash account shows a balance of $2, 166.70 on August 31. Requirement 1. Prepare the bank reconciliation for NSA, and then continue with the book side of the reconciliation. (Enter amounts to b. The August 31 bank balance is $4,023.05. C. The bank statement shows that NSA earned $26.34 of interest on its bank balance Neighborhood Services Association during August. This amount was added to NSA's bank balance. Bank Reconciliation d. NSA pays utilities ($220) and insurance ($120) by EFT. e. The following NSA cheques did not clear the bank by August 31: August 31 Cheque No. Amount BANK: 237 $ 45.80 288 146.00 Add 291 598.65 293 11.27 294 609.55 Less: 295 296 106.79 f. The bank statement includes a donation of $790, electronically deposited to the bank for NSA. BOOKS g. The bank statement lists a $9.80 bank service charge. h. On August 31, the NSA treasurer deposited $15.55, which will appear on the September bank statement. Add: i. The bank statement includes a $395 deposit that NSA did not make. The bank added $395 to NSA's account for another company's deposit. j. The bank statement includes two charges for returned cheques from donors. One is a $390 cheque received from a donor with the imprint "Unauthorized Signature." The Choose from any list or enter any number in the input fields and then continue to the next question. other is a nonsufficient funds cheque in the amount of $126.15 received from a client. Print Done