14 Deposit 15 Cheque, No. 2478 15 EFT, salaries 20 Deposit 25 Returned cheque-NSF, Giasson Developments 25 NSF fee 26 Cheque, No. 2479 27 Deposit 28 EFT, collection of note receivable and interest 30 Cheque, No. 2481 30 EFT, salaries 30 Bank service charges 5,24024,645 21,445 15,545 5,89021,435 21,035 21,027 19,677 3,500 23,177 4,979 28,156 26,901 21,001 20,996 3,200 5,900 400 8 1,350 1,255 5,900 5 The cash records per books for November showed the following Cash Receipts Cash Payments Date Number Amount 2475 3,576 4,300 1,100 3,200 1,350 5,900 1,277 1,255 1,810 5,900 $29,668 Date Nov. 3 7 12 20 27 30 Amount $2,329 1,890 5,240 5,908 3,500 856 $19,723 Nov. 1 2476 2477 2478 2479 15 EFT, salaries 2480 2481 2482 30 EFT, salaries 8 15 18 20 29 Additional information: 1. The EFT collection was not previously recorded. The collection of the note on November 28 was for $4,000, plus $979 interest. Interest was not previously accrued 2. EFT payments are recorded when they occur. 3. The bank did not make any errors. 4. Two errors were made by the company: one in recording a cheque and one in recording a cash receipt. The correction of any errors in the recording of cheques should be made to Accounts Payable. The correction of any errors in the recording of cash receipts should be made to Accounts Receivable Calculate the cash balance per books as at November 30, prior to reconciliation Cash balance per books Prepare the bank reconciliation at November 30. (List items that increaseace as per bank& books first.) PHAROAH LIMITED Bank Reconciliation November 30 Prepare any journal entries required from the reconciliation. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit Nov. 30 (To record EFT collections) 30 To record bank charges) 30 To record NSF cheque and fee) 30 To correct error in recording cheque No. 2476) 30 To correct error in Nov. 20 deposit)
