prepare 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 Cheque7801014 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 Bank of Calgary Downtown Calgary, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 4030-4037719 Deposits Description Balance Forward Chequet403054 E-transfer Cheque#403056 E-transfer Cheque #403059 EFT Cheque Deposit Cheque#403060 Cheque#403055 Cheque#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 Bank Statement Edmonton Bank Statement Calgary Cash Ledger Other_ledger PR DR CR GL. No: 1000 Balance 50.111 Dr 42.611 Dr 7,500 1.500 41,111 Dr 13.200 54.311 Dr 1.912 $2,399 Dr 100 52.299 Dr 775 51.624 Dr Account: Cash Date Description 1-Apr Opening Balance 1-Apr Equipment Inv 12034 Cheque 403054 Rent for Apr - June, 2020 1-Apr Cheque7801012 2-Apr Customer Payment - Inv AR3213 Delivery Charges - Inv 2-Apr 2231 Cheque 7801013 7- Apr Petty Cash Utility - Inv 1023 Cheque403059 10-Apr Cheque7801014 Maintenance Fees Inv 10-Apr M231 Cheque#7801018 Payment - Inv102 15-Apr Cheque 7801017 Salary Expense 15-Apr Apr 1-14, 2020 Inv 7711 23-Apr Cheque403061 Inv 7711 23-Apr Cheque 403060 23 Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 110 51.514 Dr 590 50,924 Dr 16,300 34,624 Dr 8,725 25,899 Dr 2.500 23,399 Dr 2.500 20.899 Dr 7.500 28.399 Dr 4,500 23,899 Dr 25-Apr Advertising Fees Iny 1191 Chequei403055 2.100 21.799 Dr 27-Apr 2.345 24,144 Dr 29-Apr 8.725 15.419 Dr Customer Payment - Inv AR3208 Salary Expense Apr 15. 28, 2020 Customer Payment Iny AR3010, Cheque 5010 Closing Balance 29. Apr 6,500 21,919 Dr 30-Apr 21.919 Dr Cash Ledger Other ledger DR CR GI. No: 1100 Balance 27.320 De Bank Statement Edmonton Bank Statement Calgary Account: Accounts Receivable Date Description PR 1-Apr Opening Balance Customer Payment In -Apr AR3213 12. Apr Customer Invoice AR3211 Customer Payment In ARBON 29-Apr Customer Paynient In AR1010 Cheque 5010 30-Apr Closing Balance Dr DE 16.500 30,620 21,275 27- 2.145 De De 21.775 2.275 De PR DR CR Account: In entory Date Description Opening Balance 5-Apr Investy Purchase 6Apr Investy Return Cost of Goods Sold Closing Balance 17.500 GL Ne: 1200 Balance 22.000 39.500 38.300 30,720 30,720 1.200 7.50 De De DE De DE 10.A 10.A PR DR CR GL No: 2100 Balance 17450 3450 7.500 1,912 2. Apr 775 17.500 Account: Accounts Payable Date Description 1.Apr Opening Balance Apr Equipment Inv 12014 Delivery Charges - In 3231 2- Apr Cheque701013 Utility - Mariny 1023 5-Apr Inventory Purchase. In 102 Ape Inventory Return 102 Apr Utility - Mar - Iny 1023 10.Apr Purchase Office Supplies my 7711 Cheque403000 In 7711 21 Apr Cheque 403061 30-Apr Closing Balance 1.200 16.325 35,725 34 35 33,750 3450 775 135 23-Apr 2.500 32.350 2.500 29.50 20.50 PR GL No: 1010 Balance DR CR Account: Pelty Cash Date Description 1.Apr Opening Balm 7.Apr Setup Pelly Cash Closing Balance 100 De Dr De 100 100 10.A GL. Nec 2600 Balance DR Account: Advance Payments from Customers Date Description PR 1.Apr Opening Halance 23. Apr Project 2211 10-Apr Closing Balance CR 0 7.500 7.500 7.500 C Cr PR DR CR GL Ne: 1300 Balance De MADE Account: Prepaid Expenses Date Description Opening Balm Rent for Apr - June 2020 1-Apr Cheque 7801012 24 Apr Advance Payment 10-Apr Rest Expense: A 1.500 1.500 De 4.500 6.000 5.500 De DE SOO PR DR CR T Account: Inventory Date Description 1-Apr Opening Balance 5-Apr Inventory Purchase 6-Apr Inventory Return 30-Apr Cost of Goods Sold 30-Apr Closing Balance 17.500 GL No: 1200 Balance 22.000 39,500 38,00 30,720 30,720 1,200 7.580 Dr Dr Dr Dr Dr PR DR CR 1.A GL No: 2100 Balance 12,450 3.450 Cr Cr 7.500 1.912 3,450 Cr 2.A 775 17.500 Account: Accounts Payable Date Description Opening Balance 1-Apr Equipment Inv 12014 Delivery Charges. Inv 2231 2-Apr Chequel 7501013 Utility - Mar - Iny 1023 13-Apr Inventory Purchase-Inv 102 16-Apr Inventory Return. In 102 9.Apr Utility-Mar-Inv 1023 Purchase Office Supplies In 7711 23-Apr Chequ40105 in 7711 23-Apr Chequel:403061 30 Apr Closing Balance 1.200 775 18.225 35,725 34,525 33,750 34,850 OS5Salou Cr Cr Cr C Cr 10 Apr 2.500 32,350 Cr 2.500 29,850 Cr 29,850 Cr PR DR CR 1.A Account: Petty Cash Date Description Opening Balance 7-Apr Setup Poly Cash Closing Balance GL No: 1010 Balance 0 100 100 I 100 Dr Dr Dr 30-Apr PR DR CR Account: Advance Payments from Customers Date Description 1-Apr Opening Balance 23. Apr Project 2211 30-Apr Closing Balance 0 7.500 GL No: 2600 Balance 0 7,500 7.500 Cr Cr PR DR CR GL No: 1.300 Balance 0 Dr Account: Pripaid Expenses Date Description 1-Apr Opening Balance 1-Apr Rent for Apr - June, 2020 Cheque 7801012 24. Apr Advance Payment 30-Apr Rent - Apr 30-Apr Closing Balance 1.500 De 4.500 1.500 6,000 5.500 5.500 Dr Dr Dr TTT 500 PR DR CR GL No: 6000 Balance O 325 915 325 $90 DE Dr Dr Account: Expenses Date Description 1-Apr Opening Balance 10.Apr Purchase Office Supplies 10.Apr Maintenance Fees Inv M231 15-Apr Salary Expense Apr 1.14.2020 Advertising Fees In 1191 Rent Expense - Ape 30-Apr Closing Balance 8.725 9,640 Dr 25-Apr - Aps 2,100 500 11,740 12.240 12.240 Dr Dr Dr Prepare Bank Reconciliation in Excel