prepare bank reconciliation in excel

below down is some information about DGA groceries. use this information to prepare bank reconciliation for april 30, 2020

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.00 1,800.00 800.00 13,200.00 Description Balance Forward Cheque#7801010 EFT Cheque Deposit Cheque Deposit Cheque#7801012 Cheque#7801013 Checque Deposit Cheque#7801014 Cash Withdrawal E Cash Deposit 21 Cheque Deposit 2 Cheque#7801015 2 Cheque#7801016 24 Cheque#7801017 25 Cheque#7801018 26. Cheque#7801019 27 Cheque Deposit 28 Service Charge 23 Closing Balance Withdrawal Date 1-Apr-20 200.00 1-Apr-20 1-Apr-20 2-Apr-20 3-Apr-20 1,500.00 3-Apr-20 1,912.00 3-Apr-20 3-Apr-20 110.00 6-Apr-20 100.00 7-Apr-20 8-Apr-20 9-Apr-20 2,500.00 10-Apr-20 2,500.00 10-Apr-20 16,300.00 15-Apr-20 950.00 18-Apr-20 10,000.00 27-Apr-20 27-Apr-20 40.00 29-Apr-20 30-Apr-20 Balance 15,032.00 14,832.00 17,732.00 19,532.00 20,332.00 18,832.00 16,920.00 30,120.00 30,010.00 29,910.00 31,185.00 41,185.00 38,685.00 36,185.00 19,885.00 18,935.00 8,935.00 11,280.00 11,240.00 11,240.00 1,275.00 10,000.00 2,345.00 30 31 32 33 34 35 36 Bank of Calgary Downtown Calgary, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 4030-4037719 3 Deposits Withdrawals Description 0 Balance Forward 11 Cheque#403054 12. E-transfer 13 Cheque#403056 14 E-transfer 15 Cheque#403059 7,500.00 8,725.00 10,000.00 8,725.00 775.00 16 EFT 7,500.00 10,000.00 Date 1-Apr-20 2-Apr-20 2-Apr-20 7-Apr-20 16-Apr-20 23-Apr-20 23-Apr-20 23-Apr-20 23-Apr-20 27-Apr-20 28-Apr-20 29-Apr-20 30-Apr-20 30-Apr-20 17 Cheque Deposit 18 Cheque#403060 19 Cheque#403055 20 Cheque#403061 21 Service Charge 22 E-transfer 23 Closing Balance Balance 42,004.00 34,504.00 25,779.00 15,779.00 7,054.00 6,279.00 13,779.00 23,779.00 21,279.00 19,179.00 18,779.00 18,729.00 10,004.00 10,004.00 2,500.00 2,100.00 2,500.00 50.00 8,725.00 24 25 26 27 2 DR 1-Apr GL No: 1000 CR Balance 50,111.00 Dr 7,500.00 42,611.00 Dr 4 1,500.00 41,111.00 Dr 5 5 13,200.00 54,311.00 Dr 1,912.00 52,399.00 Dr Dr 100.00 52,299.00 775.00 51,624.00 Dr 110.00 51,514.00 Dr 590.00 50,924.00 Dr 1 Account: Cash Date Description PR Opening Balance Equipment Inv 12034 1-Apr Cheque#403054 Rent for Apr - June, 1-Apr 2020 Cheque#7801012 Customer Payment 2-Apr Inv AR3213 Delivery Charges - Inv 2-Apr 2231 Cheque#7801013 7-Apr Petty Cash Utility - Inv 1023 #REF! Cheque#403059 # 10-Apr Cheque#7801014 Maintenance Fees Inv 10-Apr M231 Cheque#7801018 Payment - Inv102 15-Apr Cheque#7801017 15-Apr Salary Expense Apr 1-14, 2020 Inv 7711 23-Apr Cheque#403061 Inv 7711 23-Apr Cheque#403060 23-Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 Advertising Fees Inv 25-Apr 1191 Cheque403055 Customer Payment- 27-Apr Iny AR3208 Salary Expense 29-Apr Apr 15 - 28, 2020 Customer Payment Inv 29-Apr AR 3010, Cheque 5010 30-Apr Closing Balance 11 12 16,300.00 34,624.00 Dr 8,725.00 25,899.00 Dr 14 2,500.00 23,399.00 Dr 15 2,500.00 Dr 14 20,899.00 28,399.00 7,500.00 Dr 4,500.00 23,899.00 17 Dr 2,100.00 21,799.00 Dr 19 2,345.00 24,144.00 Dr 8,725.00 15,419.00 Dr 21 6,500.00 21.919.00 Dr 22 22 21.919.00 Dr 25 24 G 2 PR DR 1 Account: Accounts Receivable Date Description 1-Apr Opening Balance Customer Payment - Inv 2-Apr AR3213 Customer Invoice AR3211 (27-Apr Customer Payment - Inv AR3208 29-Apr Customer Payment Inv AR3010 Cheque 5010 30-Ap Closing Balance GL No: 1100 CR Balance 27.320.00 Dr 13,200.00 14,120.00 Dr 30,620.00 Dr 2.345.00 28,275.00 Dr 1 12-Apr 16,500.00 . 6,500.00 21.775.00 Dr 28,275.00 Dr 1 3 11 PR DR 11 14 Account: Inventory Date Description 1-Apr Opening Balance 5-Aps Inventory Purchase Inventory Return 30-Apr Cost of Goods Sold Closing Balance 17,500.00 * 6-Apr GL No: 1200 CR Balance 22,000.00 Dr 39,500.00 Dr 1.200.00 38,300.00 Dr 7,580.00 30.720.00 Dr 30.720.00 Dr 30-Apr 12 18 11 81 PR DR * 1-Apr Ft 7.500.00 1.912.00 - Account: Accounts Payable Date Description Opening Balance 1-Apr Equipment Inv 12034 2-Apr Delivery Charges - Inu 2231 H 2-Apr Utility - Mar - Inv 1023 15-Apr Inventory Purchase-Inv 102 Inventory Return - Inv 102 Utility - Mar - Inv 1023 10-Apr Purchase Office Supplies 23-Apt Iny 7711 Cheque#403060 23-Api Inv 7711 Chegue403061 30-Ape Closing Balance GL No: 2100 CR Balance 17.450.00 Cr 3,450.00 Cr 3.450.00 Cr 775.00 18.225.00 Cr 17.500.00 35.725.00 Cr 34,525.00 Cr 33.750.00 Cr 325.00 34 850 00 Cr 32.350.00 Cr 26 6-Apr 9-Apr 1.200.00 775.00 25 98 2.500.00 11 2,500.00 29.850.00 29.850.00 CH 15 S ar 15 Account: Petty Cash Date Description 1-Apr Opening Balance 7-Api Setup Petty Cash 30-Apr Closing Balance PR DR GL No: 1010 Balance CR 10 100.00 100.00 100.00 81919 18 Dr Dr s! Arruntide GL No: 2600 Balance 1-Apr DR Account: Advance Payments from Customers Date Description PR Opening Balance 23-Apr Project 2211 30-Apr Closing Balance CR 03 40 7.500.00 45 7,500.00 7,500.00 Or Cr 05 49 50 PR 111-Apr DR - Account: Prepaid Expenses Date Description Opening Balance 1-Apr Rent for Apr - June, 2020 Cheque#7801012 * 24-Apr Advance Payment 30-Apr Rent Expense - Apr Closing Balance 1,500.00 GL No: 1300 CR Balance Dr 1500.00 6,000.00 Dr 500.00 5,500.00 DI 5,500.00 Dr 4,500.00 1 30-Apr 9999 59 6: PR 1-Apr DR CR 14 Account: Expenses Date Description Opening Balance 10-Apr Purchase Office Supplies 10-Api Taintenanceresino 15-Apr Salary Expense Apr 1-14, 2020 25-Apr Advertising Fees In 1191 30-Apr Rent Expense - Api 30-Apr Closing Balance 15 325.00 590.00 8.725.00 2,100.00 500.00 GL No: 6000 Balance Dr 325.00 Dr 915.00 Dr 9,640.00 Dr 11,740.00 Dr 12.240.00 Dr 12,240,001 Dr " 10 81 20 M 19