create a bank reconciliation for this company

Branch Address: BANK STATEMENT North Side of Diagon Alley London England Gringotts Wizarding Bank Banking Statement for the month ending 30 June 20x7 Account Owner: Chudley Cannons Inc. Date 1 June 20x7 4 June 20x7 10 June 20x7 11 June 20x7 14 June 20x7 17 June 20x7 18 June 20x7 25 June 20x7 29 June 20x7 30 June 20x7 30 June 20x7 Description Opening Balance Deposit Cheque No. 104 EFT Payment NSF Cheque No. 2748 Bank Fees EFT Receipt Cheque No. 106 EFT Receipt Interest Received Closing Balance Amounts deducted Amounts added from your account (S) to your account (5) Balance (5) 45,387 3,592 48,979 235 48.744 545 48,199 6,000 42,199 50 42,149 15,982 58.131 7,050 51,081 1.000 52.081 107 52,188 52,188 CASH BOOK CHUDLEY CANNONS INC. CASH ACCOUNT TRANSACTION LISTING FOR THE MONTH ENDED 30 JUNE 20X7 DEBIT CREDIT 3,592 DATE 01/06/X7 03/06/X7 03/06/X7 10/06/X7 12/06/X7 18/06/X7 19/06/X7 30/06/X7 30/06/X7 DESCRIPTION BROUGHT FORWARD DEPOSIT CHEQUE NO. 104 EFT PAYMENT CHEQUE NO. 105 EFT RECEPT CHEQUE NO. 106 DEPOSIT CARRIED FORWARD 235 545 910 BALANCE 45,387 48,979 48,744 48,199 47.289 63.271 56,266 58.486 58,486 15.982 7,005 2220 Note: Check #106 is for $7,050. It has been incorrectly entered into the general ledger