Attached is some information about DGA Groceries. Use this information to prepare a 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 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.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 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 Cheque#403054 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.00 10,000.00 Withdrawals Date 1-Apr-20 7,500.00 2-Apr-20 8,725.00 2-Apr-20 10,000.00 7-Apr-20 8,725.00 16-Apr-20 775.00 23-Apr-20 23-Apr-20 23-Apr-20 2,500.00 23-Apr-20 2,100.00 27-Apr-20 2,500.00 28-Apr-20 50.00 29-Apr-20 8,725.00 30-Apr-20 30-Apr-20 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 PR DR CR GL No: 1000 Balance 50,111.00 Dr 7,500.00 42,611.00 Dr 1,500.00 41,111.00 Dr 13,200.00 54,311.00 Dr 1,912.00 52,399.00 Dr 100.00 52,299.00 Dr 775.00 51,624.00 Dr 110.00 | 51,514.00 Dr 590.00 50,924.00 Dr Account: Cash Date Description 1-Apr 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 10-Apr Inv M231 Cheque#7801018 Payment - Inv102 15-Apr Cheque#7801017 Salary Expense 15-Apr 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 Cheque#403055 Customer Payment- 27-Apr Inv AR3208 29-Apr Salary Expense Apr 15 - 28, 2020 29-Apr Customer Payment Inv AR3010, Cheque 30-Apr Closing Balance 16,300.00 34,624.00 Dr 8,725.00 25,899.00 Dr 2,500.00 23,399.00 Dr 2,500.00 20,899.00 Dr 7,500.00 28,399.00 Dr 4,500.00 23,899.00 Dr 2,100.00 21,799.00 Dr 2,345.00 24,144.00 Dr 8,725.00 15,419.00 Dr 6,500.00 Dr 21,919.00 21,919.00 Dr PR DR CR GL No: 1100 Balance 27,320.00 Dr 13,200.00 14,120.00 Dr Account: Accounts Receivable Date Description 1-Apr Opening Balance Customer Payment - Inv 2-Apr AR3213 12-Apr Customer Invoice AR3211 Customer Payment - Inv 27-Apr AR3208 Customer Payment Inv 29-Apr AR3010, Cheque 5010 30-Apr Closing Balance 16,500.00 30,620.00 Dr 2,345.00 28,275.00 Dr 6,500.00 21,775.00 Dr 28,275.00 Dr PR DR CR 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 GL No: 1200 Balance 22,000.00 39,500.00 1,200.00 38,300.00 7,580.00 30,720.00 30,720.00 Dr Dr 17,500.00 99999 PR DR CR | GL No: 2100 Balance 17,450.00 3,450.00 Cr Cr 7,500.00 1,912.00 Cr 775.00 17,500.00 Account: Accounts Payable Date Description 1-Apr Opening Balance 1-Apr Equipment Inv 12034 Delivery Charges - Inv 2-Apr 2231 2-Apr Utility - Mar - Inv 1023 5-Apr Inventory Purchase - Inv 102 6-Apr Inventory Return - Inv 102 9-Apr Utility - Mar - Inv 1023 10-Apr Purchase Office Supplies Inv 7711 23-Apr Cheque#403060 Inv 7711 23-Apr Cheque#403061 30-Apr Closing Balance 3,450.00 18,225.00 35,725.00 34,525.00 33,750.00 34,850.00 1,200.00 775.00 88888 Cr Cr Cr Cr Cr 325.00 2,500.00 32,350.00 Cr 2,500.00 29,850.00 Cr 29,850.00 Cr GL No: 1010 Balance PR DR CR Account: Petty Cash Date Description 1-Apr Opening Balance 7-Apr Setup Petty Cash 30-Apr Closing Balance Dr Dr 100.00 100.00 100.00 Dr GL No: 2600 Balance DR CR Account: Advance Payments from Customers Date Description PR 1-Apr Opening Balance Project 2211 30-Apr Closing Balance 23-Apr 7,500.00 7,500.00 7,500.00 Cr Cr GL No: 1300 Balance PR DR CR Dr Account: Prepaid Expenses Date Description 1-Apr Opening Balance Rent for Apr - June, 2020 1-Apr Cheque#7801012 24-Apr Advance Payment 30-Apr Rent Expense - Apr 30-Apr Closing Balance 1,500.00 1,500.00 Dr 4,500.00 Dr 500.00 6,000.00 5,500.00 5,500.00 Dr Dr GL No: 6000 Balance PR DR CR Dr Dr 325.00 325.00 590.00 915.00 Dr Account: Expenses Date Description 1-Apr Opening Balance 10-Apr Purchase Office Supplies Maintenance Fees Inv 10-Apr M231 Salary Expense 15-Apr Apr 1 - 14, 2020 25-Apr Advertising Fees Inv 1191 30-Apr Rent Expense - Apr 30-Apr Closing Balance 8,725.00 9,640.00 Dr 2,100.00 500.00 11,740.00 12,240.00 12,240.00 Dr Dr Dr 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 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.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 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 Cheque#403054 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.00 10,000.00 Withdrawals Date 1-Apr-20 7,500.00 2-Apr-20 8,725.00 2-Apr-20 10,000.00 7-Apr-20 8,725.00 16-Apr-20 775.00 23-Apr-20 23-Apr-20 23-Apr-20 2,500.00 23-Apr-20 2,100.00 27-Apr-20 2,500.00 28-Apr-20 50.00 29-Apr-20 8,725.00 30-Apr-20 30-Apr-20 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 PR DR CR GL No: 1000 Balance 50,111.00 Dr 7,500.00 42,611.00 Dr 1,500.00 41,111.00 Dr 13,200.00 54,311.00 Dr 1,912.00 52,399.00 Dr 100.00 52,299.00 Dr 775.00 51,624.00 Dr 110.00 | 51,514.00 Dr 590.00 50,924.00 Dr Account: Cash Date Description 1-Apr 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 10-Apr Inv M231 Cheque#7801018 Payment - Inv102 15-Apr Cheque#7801017 Salary Expense 15-Apr 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 Cheque#403055 Customer Payment- 27-Apr Inv AR3208 29-Apr Salary Expense Apr 15 - 28, 2020 29-Apr Customer Payment Inv AR3010, Cheque 30-Apr Closing Balance 16,300.00 34,624.00 Dr 8,725.00 25,899.00 Dr 2,500.00 23,399.00 Dr 2,500.00 20,899.00 Dr 7,500.00 28,399.00 Dr 4,500.00 23,899.00 Dr 2,100.00 21,799.00 Dr 2,345.00 24,144.00 Dr 8,725.00 15,419.00 Dr 6,500.00 Dr 21,919.00 21,919.00 Dr PR DR CR GL No: 1100 Balance 27,320.00 Dr 13,200.00 14,120.00 Dr Account: Accounts Receivable Date Description 1-Apr Opening Balance Customer Payment - Inv 2-Apr AR3213 12-Apr Customer Invoice AR3211 Customer Payment - Inv 27-Apr AR3208 Customer Payment Inv 29-Apr AR3010, Cheque 5010 30-Apr Closing Balance 16,500.00 30,620.00 Dr 2,345.00 28,275.00 Dr 6,500.00 21,775.00 Dr 28,275.00 Dr PR DR CR 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 GL No: 1200 Balance 22,000.00 39,500.00 1,200.00 38,300.00 7,580.00 30,720.00 30,720.00 Dr Dr 17,500.00 99999 PR DR CR | GL No: 2100 Balance 17,450.00 3,450.00 Cr Cr 7,500.00 1,912.00 Cr 775.00 17,500.00 Account: Accounts Payable Date Description 1-Apr Opening Balance 1-Apr Equipment Inv 12034 Delivery Charges - Inv 2-Apr 2231 2-Apr Utility - Mar - Inv 1023 5-Apr Inventory Purchase - Inv 102 6-Apr Inventory Return - Inv 102 9-Apr Utility - Mar - Inv 1023 10-Apr Purchase Office Supplies Inv 7711 23-Apr Cheque#403060 Inv 7711 23-Apr Cheque#403061 30-Apr Closing Balance 3,450.00 18,225.00 35,725.00 34,525.00 33,750.00 34,850.00 1,200.00 775.00 88888 Cr Cr Cr Cr Cr 325.00 2,500.00 32,350.00 Cr 2,500.00 29,850.00 Cr 29,850.00 Cr GL No: 1010 Balance PR DR CR Account: Petty Cash Date Description 1-Apr Opening Balance 7-Apr Setup Petty Cash 30-Apr Closing Balance Dr Dr 100.00 100.00 100.00 Dr GL No: 2600 Balance DR CR Account: Advance Payments from Customers Date Description PR 1-Apr Opening Balance Project 2211 30-Apr Closing Balance 23-Apr 7,500.00 7,500.00 7,500.00 Cr Cr GL No: 1300 Balance PR DR CR Dr Account: Prepaid Expenses Date Description 1-Apr Opening Balance Rent for Apr - June, 2020 1-Apr Cheque#7801012 24-Apr Advance Payment 30-Apr Rent Expense - Apr 30-Apr Closing Balance 1,500.00 1,500.00 Dr 4,500.00 Dr 500.00 6,000.00 5,500.00 5,500.00 Dr Dr GL No: 6000 Balance PR DR CR Dr Dr 325.00 325.00 590.00 915.00 Dr Account: Expenses Date Description 1-Apr Opening Balance 10-Apr Purchase Office Supplies Maintenance Fees Inv 10-Apr M231 Salary Expense 15-Apr Apr 1 - 14, 2020 25-Apr Advertising Fees Inv 1191 30-Apr Rent Expense - Apr 30-Apr Closing Balance 8,725.00 9,640.00 Dr 2,100.00 500.00 11,740.00 12,240.00 12,240.00 Dr Dr Dr