The bank reconciliation prepared by Winfield Construction on June 30, 2020, appeared as follows: Winfield Construction Bank Reconciliation June 10. 2020 $ 9,50 Book balance Bank statement balance Add: Deposit of June 30 in transit $10,140 1.460 $10,960 Deduct: Outstanding cheque #14 Adjusted bank balance 820 $10,140 Adjusted book balance $10,140 The Cash account in the General Ledger appeared as follows on July 31: Cash Explanation PR Debit Credit Acct. No. 101 Balance Date 2020 June 3e July 31 31 Balance CR3 CD6 4,936 10,140 15,876 12,015 3,061 A list of deposits made and cheques written during July, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below: Deposits Made July 8 11 $ 1,270 1,630 A list of deposits made and cheques written during July, taken from the Cash Receipts Journal and Cash Disbursements Journal shown below: July 8 11 $1,270 1,411 31 Total Duly Cash Receipts $ 4,936 No. Cheques written 52 53 54 Total July Cash Disbursements $1,751 942 368 $ 3,061 The following bank statement is available for July Bank Statement To: Winfield Construction Cheques/Charges Deposits/Credits NSF 252 #96 July 31, 2020 Bank of Montreal Balance 9,500 10,505 10,024 11,239 12,650 12.282 07/02 e7/88 07/11 455 1,751 415 07/02 07/08 07/11 07/24 07/31 1,460 1,270 1,630 1,411 #54 07/31 368 07/11 Not sufficient Funds NSE 112 12 1922 IN! Interest 07/ 1.111 07/11 PHT - Principal Payment SC - Service Charge In reviewing cheques returned by the bank, the bookkeeper noted that cheque #96 witten by Winburn Construction in the amount of $415 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 WINFIELD CONSTRUCTION Bank Reconciliation July 31, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: Deduct Deduct: 2. Prepare the necessary joumal entry to bring the General Ledger Cash account into agreement with the adpunted balance on the bank reconciliation View transaction list Journal entry worksheet A list of deposits made and cheques written during July, taken from the Cash Receipts Journal and Cash Disbursements Journal shown below: July 8 11 $1,270 1,411 31 Total Duly Cash Receipts $ 4,936 No. Cheques written 52 53 54 Total July Cash Disbursements $1,751 942 368 $ 3,061 The following bank statement is available for July Bank Statement To: Winfield Construction Cheques/Charges Deposits/Credits NSF 252 #96 July 31, 2020 Bank of Montreal Balance 9,500 10,505 10,024 11,239 12,650 12.282 07/02 e7/88 07/11 455 1,751 415 07/02 07/08 07/11 07/24 07/31 1,460 1,270 1,630 1,411 #54 07/31 368 07/11 Not sufficient Funds NSE 112 12 1922 IN! Interest 07/ 1.111 07/11 PHT - Principal Payment SC - Service Charge In reviewing cheques returned by the bank, the bookkeeper noted that cheque #96 witten by Winburn Construction in the amount of $415 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 WINFIELD CONSTRUCTION Bank Reconciliation July 31, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: Deduct Deduct: 2. Prepare the necessary joumal entry to bring the General Ledger Cash account into agreement with the adpunted balance on the bank reconciliation View transaction list Journal entry worksheet
