7 Exercise 7-11 Preparation of bank reconciliation LOG 10 The bank reconciliation prepared by Winfield Construction on June 30, 2020. appeared as follows: Winfield Construction Bank Reconciliati June 30, 2020 Hank statement balance $8.760 Book balance $9,25 Add Deposit of Tue 10 in transit $10,000 Deduct Outstanding cheque 14 20 Mjusted banke balance 59,260 Adjusted book balance 5*,260 1,200 The Cash account in the General Ledger appeared as follows on July 31: Cash Acct. No. 101 Explanation Debit Credit Balance 2020 June 30 Balance 9.260 July 111 4.672 13,932 11 CD 2,905 11,023 A list of deposits made and checues written during July, taken from the Cash Receipts Journal and Cash Disbursements Journalis shown below Deposits Made July $ 1.100 Check my wort 7 A list of deposits made and cheques written during July taken from the Cash Receipts Journal and Cash Distursements Journal, shown below Tepsis Made 10 Tuly $1,190 1.550 1,330 20 31 Total July Cash Receipts 54,672 11,663 Chequest 33 54 Total july Cash Dishes 352 12.00 July 2010 Bank of Montreal The following bank statement is available for July Bank Statement To wintind Construction Ches/Charpes Deposit/Credits NS 07/02 4:31 07/03 1,300 -52 07/08 1,641 02/05 1,190 7751 351 07/11 1,150 1.19 7/31 352 02/11 5 - Service Principal Sist sufficient Fund 56 5.700 9.00 10.255 11.594 11,242 TNT Teteret FAW Check my work 7 in reviewing cheques returned by the bank the bookkeeper noted that cheque #96 written by Winburn Construction in the amount of $391 was charged against Winfield's account in error by the bank. The NSF cheque was regarding a customer account. Jim Anderson Required: 1. Prepare a bank reconciliation at July 31 10 po WINFIELD CONSTRUCTION Bank Reconciliation July 31, 2020 Bank Statement Company's Books Bank sement Add Book baie Add: . Deduct Deduct Adultico Adjusted book 7 2. Prepare the necessary joumal entry to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation 10 View transactions Journal entry worksheet Record the entry to bring the General Ledger Cash account to agreement with the adjusted balance on the bank reconciliation time before cred General Journal Debit Date 31 Credit Record and Clear entry View general Journal