prepare bank reconciliation statement

its only what i have for the question so kindly provide me with the solution , that is , the bank reconciliation statement

Bank of Edmonton Downtown Edmonton, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 7800-7802364 Deposit 2,900 1,800 800 13,200 Description Balance Forward Cheque#7801010 EFT Cheque Deposit Cheque Deposit Cheque#7801012 Cheque#7801013 Checque Deposit Cheque#7801014 Cash Withdrawal Cash Deposit Cheque Deposit Cheque#7801015 Cheque#7801016 Cheque#7801017 Cheque#7801018 Cheque#7801019 Cheque Deposit Service Charge Closing Balance Withdrawal Date 1-Apr-20 200 1-Apr-20 1-Apr-20 2-Apr-20 3-Apr-20 1,500 3-Apr-20 1,912 3-Apr-20 3-Apr-20 110 6-Apr-20 100 7-Apr-20 8-Apr-20 9-Apr-20 2,500 10-Apr-20 2,500 10-Apr-20 16,300 15-Apr-20 950 18-Apr-20 10,000 27-Apr-20 27-Apr-20 40 29-Apr-20 30-Apr-20 Balance 15,032 14,832 17,732 19,532 20,332 18,832 16,920 30,120 30,010 29,910 31,185 41,185 38,685 36,185 19,885 18,935 8,935 11,280 11,240 11,240 1,275 10,000 2,345 Cass Led One_ Bank Smet Emoto Bank Statement Calgary skalgary Dario Calgary, Alberta Canada Rank Pred: Apri Crew Asher 19 Description Wildwash the tainar | 13 Che Apr 30 E 6.728 Apr 30 Chaq 10.000 p3 E- 8.725 16.30 Cheque 775 22 ET Cheque 100 30 Chow 2200 220 Chaw 2.100 Chequr 3500 20 Service Charge 30 30 E- 8.750430 Clui 10-30 To 117 2 IN 11 Bank States Bank Bem Cay Cash Ledger Oy LIC Description PR DR CR GL NO: Balu EN HAR 7.300 las -Apr 10 2 TA 30 De Cosa Rest for Apt.Jun. Khe801013 Payment- JARU Pedivery Charge 101 Patty Call y los 103 3050 Choo01014 Maneler M231 00018 P100 Che Salary 775 313 TAPE 10 D 15. 15 72 AP h01 1 PRP 3.A 9.500 22 AP he Argo w 1191 (055 Plus 21 2 IN AR Salary 11.10 Cowo ARCSID alla 2 2:39 Done Bank_Reconciliation_Project_B... Other_jade KL1 DR CR Bank Statement Etment Market Calgary Account As Merchable Date Description PR HAP BA Camel 13.A CA1311 TAN CPA D 16.00 PRIR PR GL12 Ba DR CR De Loti Intery Date Description 1-App Inventory Retur 10 Co MAP LA 1700 30 50 D D PR OR CR 75 0 13 725 ACHIA Paya Date Thescripti LAN pelos clovery Chain Cheque AN M. SALE Inmery Purchase-In 102 any Retur. 100 AP - M11 10.A acceps 11 3.A Chapa 11 Ap ch 10.A TATA 725 lal GL180 PR DK CR 414H TV | Date Descripti LA Distance TA 30.A Close Balance GL Recent Advance Payments from Custers Date Description PR DW CK 7500 3. Aps GL300 PR DK Prepaid Espen Date Descripti 144 ans Resowe 1.A CO? BAR AP RALE 30-AP . PROVO ala ANAT GI PR DR CR Rese Date ther 1.A 10 Pedes 10 AP Mac 15A Salary 4. 235 sa WS 1111 Gala PR DK CH D 3 Re: Accents Rechable Dale Description BA b-Ape La ARBEID 12. Ape KARITI 07. Apr Comment OP ART Cheque 10 NOAP CSI G De 21 D D GL 120 PR DR CR Accountinery Date Description 1-AP SAN May WA Le Retur 10.A Code 1.500 D D De TRINIAI GEN PR DR CR 9.50 1991 6 Acc: Acroyable Dale Descripti HAR Bale LAD 1304 Delivery pupe GOOD DA - Mabove LAN Apr www.10 M. 10.A Pechowice Supplies PHP Che le 11 3.A 10.A Chile 12 795 TATTI 1991 C 22 G KG PR DR CR Act: Pelty Cash Dals 1.A TAN 10 M GEN DR Account Advance Payment from me Date Theeriyin PH LA 3. 10AM CR . . G PR DR CH AC: Pripad praes Dals Dewrition LA Rew Aphew, CO 1.A che 26 AM dance AN Mest p-AN 10AM Bu i 49 BAAT GL Acties Date Description PR DR B . 10A 10 90 5 De 19. TH 25 Pachowe Supe Mac MM Salary Expo AH Foi Holy ute tama De HHHHH 2100 500 D De 001 Bank of Edmonton Downtown Edmonton, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 7800-7802364 Deposit 2,900 1,800 800 13,200 Description Balance Forward Cheque#7801010 EFT Cheque Deposit Cheque Deposit Cheque#7801012 Cheque#7801013 Checque Deposit Cheque#7801014 Cash Withdrawal Cash Deposit Cheque Deposit Cheque#7801015 Cheque#7801016 Cheque#7801017 Cheque#7801018 Cheque#7801019 Cheque Deposit Service Charge Closing Balance Withdrawal Date 1-Apr-20 200 1-Apr-20 1-Apr-20 2-Apr-20 3-Apr-20 1,500 3-Apr-20 1,912 3-Apr-20 3-Apr-20 110 6-Apr-20 100 7-Apr-20 8-Apr-20 9-Apr-20 2,500 10-Apr-20 2,500 10-Apr-20 16,300 15-Apr-20 950 18-Apr-20 10,000 27-Apr-20 27-Apr-20 40 29-Apr-20 30-Apr-20 Balance 15,032 14,832 17,732 19,532 20,332 18,832 16,920 30,120 30,010 29,910 31,185 41,185 38,685 36,185 19,885 18,935 8,935 11,280 11,240 11,240 1,275 10,000 2,345 2:56 Done Bank_Reconciliation_Project_B... Bank Statement Edmonton Bank Statement Calgary Cash Ledger Bank of Calgary Downtown Calgary, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DXCA Groceries Account Number 4030-4037719 Deposits Description Balance Forward Cheque403054 E-transfer Cheque/403056 E-transfer Chequei403059 EFT Cheque Deposit Chequei403060 Cheque 403055 Chequel:403061 Service Charge E-transfer Closing Balance 7,500 10,000 Withdrawals Date 1-Apr-20 7.500 2-Apr-20 8,725 2-Apr-20 10,000 7-Apr-20 8.725 16-Apr-20 775 23-Apr-20 23-Apr-20 23-Apr-20 2.500 23-Apr-20 2,100 27-Apr-20 2.500 28-Apr-20 50 29-Apr-20 8,725 30-Apr-20 30-Apr-20 Balance 42,004 34.504 25.779 15.779 7,054 6,279 13.779 23,779 21,279 19,179 18,779 18,729 10,004 10,004 2:56 Done Bank_Reconciliation_Project_B... Cash Ledger CR Other ledger GL Nes 1000 Balance 50.111 Di 42,61 De 7.500 1.500 41 Dr 11 DT 1912 DI 100 32.99 Dr SLASH Dr DI 110 $1,514 30.934 Dr Bank Statement Edmonton Bank Statement Calgary Account Cush Date Description PR DR 1-Apr Opinie Balance 1-Apr Fquipement Im 13034 Cheques 401054 1-Apr Renfe Ape Sune, 2030 Cheque 01012 Customer Payment In 2-Apr JAR21 11. Delivery Charges. In AP 2331 Cheque 0101 7. Apr Petty Cat Liity. Inv 103 Chaque 109 10.A Chaquel7801014 Maintenance Fees In 10-A M2 ChRO1018 19 Apr Payment 102 Chau1017 Salary Expense 15. Apr Apr 14, 2030 23-Apr Ch.403061 TIN 1 20-Apr Choque 403060 23.A These 2211 7.500 Advance Payment Colt Ch701030 Advertising Fees lov 1191 [25-Ape Cheque403055 27-Apr Customer ayment -In AR1208 19. Salary Expense Apr 15.2.2020 29. Ape Customer Payment Inv AR 3010. Choque 5010 10.A Closing Balance 34 34 Di 735 25. De Inv 2500 2399 Dr 2.500 2009 Dr 28.399 Dr 300 2399 De 2.100 21.799 DE 34.14 De 15.419 DE 21,919 Dr 21.91 Dr 2:39 Done Bank_Reconciliation_Project_B... Other_jade KL1 DR CR Bank Statement Etment Market Calgary Account As Merchable Date Description PR HAP BA Camel 13.A CA1311 TAN CPA D 16.00 PRIR PR GL12 Ba DR CR De Loti Intery Date Description 1-App Inventory Retur 10 Co MAP LA 1700 30 50 D D PR OR CR 75 0 13 725 ACHIA Paya Date Thescripti LAN pelos clovery Chain Cheque AN M. SALE Inmery Purchase-In 102 any Retur. 100 AP - M11 10.A acceps 11 3.A Chapa 11 Ap ch 10.A TATA 725 lal GL180 PR DK CR 414H TV | Date Descripti LA Distance TA 30.A Close Balance GL Recent Advance Payments from Custers Date Description PR DW CK 7500 3. Aps GL300 PR DK Prepaid Espen Date Descripti 144 ans Resowe 1.A CO? BAR AP RALE 30-AP . PROVO ala ANAT GI PR DR CR Rese Date ther 1.A 10 Pedes 10 AP Mac 15A Salary 4. 235 sa WS 1111 Gala PR DK CH D 3 Re: Accents Rechable Dale Description BA b-Ape La ARBEID 12. Ape KARITI 07. Apr Comment OP ART Cheque 10 NOAP CSI G De 21 D D GL 120 PR DR CR Accountinery Date Description 1-AP SAN May WA Le Retur 10.A Code 1.500 D D De TRINIAI GEN PR DR CR 9.50 1991 6 Acc: Acroyable Dale Descripti HAR Bale LAD 1304 Delivery pupe GOOD DA - Mabove LAN Apr www.10 M. 10.A Pechowice Supplies PHP Che le 11 3.A 10.A Chile 12 795 TATTI 1991 C 22 G KG PR DR CR Act: Pelty Cash Dals 1.A TAN 10 M GEN DR Account Advance Payment from me Date Theeriyin PH LA 3. 10AM CR . . G PR DR CH AC: Pripad praes Dals Dewrition LA Rew Aphew, CO 1.A che 26 AM dance AN Mest p-AN 10AM Bu i 49 BAAT GL Acties Date Description PR DR B . 10A 10 90 5 De 19. TH 25 Pachowe Supe Mac MM Salary Expo AH Foi Holy ute tama De HHHHH 2100 500 D De 001