Module 7 (Chapter 7) Assignment Q 1 Ed 8 W V2 National Car Rentals Bank Reconciliation May 31, 2023 $7,055 Book balance $8,580 Bank statement balance Add: Deposit of May 31 in Transit 4,950 $12,005 Deduct: Outstanding cheques: #403 #420 $1,925 1,500 3,425 Adjusted bank balance $8,580 Adjusted book balance $8,580 The Cash account in the General Ledger appeared as follows on June 30. Cash PR Acct. No. 101 Balance Explanation Debit Credit Date 2023 May 31 June 30 June 30 Balance 34,215 CR14 CD18 $ 8,580 42,795 28,675 14,120 A list of deposits made and cheques written during June, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown on the next page. Deposits Made 5 June 10 15 20 27 $1,500 1,890 4,350 2,875 3,000 15,600 5,000 $34,215 30 30 Total June Cash Receipts Cheques Written No. 427 428 429 430 431 432 433 434 435 436 Total June Cash Disbursements $3,300 1,675 675 1,300 205 475 1,500 1,100 990 2,900 ? $14,120 The following is the June 30, 2023 bank statement: Bank Statement Cheques/Charges National Car Rentals Deposits/Credits June 2 5 June 2 5 10 #431 #428 #433 #430 #403 #429 #434 NSF #435 #427 SC $205 1,675 1,500 3,100 1,925 675 1,100 890 990 3,300 150 12 15 20 25 27 30 30 30 30 15 20 CM 22 27 June 30, 2023 Balance $7,055 $4,950 11,800 1,500 11,625 1,890 12,015 4,350 13,265 2,875 14,215 3,950 17,490 3,000 19,390 15,600 34,100 55 33,165 29,865 $29,715 30 INT 30 service charge Additional Information: The NSF cheque for $890 was that of customer Gwen Harp, deposited in June. Cheque #430 was to pay for office supplies but was incorrectly posted by the bookkeeper. The Credit Memo (CM) on June 22 was the collection of a notes receivable less a $50 collection fee. . Instructions: 1. Prepare the June 30th bank reconciliation on the data entry form provided. 2. Prepare the General Journal entries needed from the June 30th bank reconciliation on the data entry form provided