On March 31, Pina Colada Corporation showed a cash balance on their books of $13,800. The bank statement from the company's bank showed a month end balance of $17,483. On reviewing the bank statement, the following items were discovered: 1. A deposit made on March 29 for $4,450 did not appear on the bank statement. Cheques written in the month of March but that did not appear on the bank statement were as follows: 2. $4,530 315 Cheque #6341 Cheque #6342 Cheque #6346 Cheque #6347 Cheque #6348 44 1.065 865 3. 4. 5. The bank credited Pina Colada's account for $530 on March 19. This deposit did not belong to Pina Colada, but belonged to another company and was posted in error. The bank statement showed receipt of a wire transfer of $1,200 in payment of a note receivable, as well as $ 108 interest. According to the bank statement, $44 was deducted from Pina Colada's account for service charges. The bank cleared cheque #6281 for $1,030; however, the cheque was recorded in Pina Colada's records at $850. Research showed the bank was correct, and the cheque was recorded incorrectly in Pina Colada's books. The cheque was written in payment of rent. A cheque for $300 from one of Pina Colada's customers was rejected by the bank due to insufficient funds (NSF). 6. 7. Prepare a bank reconciliation to the correct cash balance at March 31. Pina Colada Corporation Bank Reconciliation $ $ $ $ A A > > . > Prepare journal entries required to adjust the cash account at March 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts.) Account Titles and Explanation Debit Credit (To record bank charges) (To correct error in recording cheque #6281) (To record collection of note receivable) (To record NSF cheque)