Old MathJax webview

Attached is some information about DGA Groceries. Prepare a bank reconciliation for April 30, 2020

GL No: 1100 2 PR DR CR Balance 27,320.00 3 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 Account: Inventory Date Description GL No: 1200 PR DR CR Balance D E F H 2 PR DR 3 1-Apr 1 Account: Inventory Date Description Opening Balance 5-Apr Inventory Purchase 6-Apr Inventory Return 30-Apr Cost of Goods Sold 30-Apr Closing Balance Dr 4 17,500.00 GL No: 1200 CR Balance 22,000.00 39,500.00 1,200.00 38,300.00 7,580.00 30,720.00 30,720.00 Dr 5 Dr 5 Dr Dr Account: Accounts Payable Date Description 1-Apr Opening Balance 1-Apr Equipment Inv 12034 PR DR CR GL No: 2100 Balance 17,450.00 3,450.00 Cr 7,500.00 cr Delivery Charges - Inv 2231 2-Apr chacuH7001012 Bank Statement Edmonton 1,912.00 3,450.00 Cr DEL + 2-Apr Delivery Charges - Inv 2231 Cheque#7801013 1,912.00 3,450.00 Cr 24 25 2-Apr 775.00 Cr 26 5-Apr 17,500.00 Cr 27 6-Apr 1,200.00 18,225.00 35,725.00 34,525.00 33,750.00 34,850.00 cr -8 775.00 Cr 9-Apr 10-Apr Utility - Mar - Inv 1023 Inventory Purchase - Inv 102 Inventory Return - Inv 102 Utility - Mar - Inv 1023 Purchase Office Supplies Inv 7711 Cheque#403060 Inv 7711 Cheque#403061 Closing Balance 9 325.00 Cr 23-Apr 2,500.00 32,350.00 Cr 0 23-Apr 2,500.00 29,850.00 Cr 30-Apr 29,850.00 Cr Account: Petty Cash GL No: 1010 E F G H GL No: 1010 35 PR DR CR Balance 34 Account: Petty Cash Date Description Opening Balance Setup Petty Cash 38 30-Apr Closing Balance 36 1-Apr 37 7-Apr Dr Dr 100.00 100.00 100.00 Dr 39 30 GL No: 2600 2 DR CR Balance Account: Advance Payments from Customers Date Description PR 1-Apr Opening Balance 23-Apr Project 2211 30-Apr Closing Balance 7,500.00 Cr 7,500.00 7,500.00 Cr E F G H GL No: 1300 Balance 52 PR DR CR 53 1-Apr Dr 51 Account: Prepaid Expenses Date Description 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 54 55 4,500.00 Dr 56 500.00 6,000.00 5,500.00 5,500.00 Dr 57 Dr 58 59 GL No: 6000 61 PR DR CR Balance 60 Account: Expenses Date Description 62 1-Apr Opening Balance Purchase Office Supplies Maintenance Fees Inv 10-Apr M231 Dr 63 10-Apr 325.00 325.00 Dr 590.00 915.00 Dr GL No: 6000 Balance PR DR CR Dr 325.00 325.00 Dr 590.00 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 915.00 Dr 8,725.00 9,640.00 Dr 2,100.00 Dr 500.00 11,740.00 12,240.00 12,240.00 Dr Dr GL No: 1100 2 PR DR CR Balance 27,320.00 3 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 Account: Inventory Date Description GL No: 1200 PR DR CR Balance D E F H 2 PR DR 3 1-Apr 1 Account: Inventory Date Description Opening Balance 5-Apr Inventory Purchase 6-Apr Inventory Return 30-Apr Cost of Goods Sold 30-Apr Closing Balance Dr 4 17,500.00 GL No: 1200 CR Balance 22,000.00 39,500.00 1,200.00 38,300.00 7,580.00 30,720.00 30,720.00 Dr 5 Dr 5 Dr Dr Account: Accounts Payable Date Description 1-Apr Opening Balance 1-Apr Equipment Inv 12034 PR DR CR GL No: 2100 Balance 17,450.00 3,450.00 Cr 7,500.00 cr Delivery Charges - Inv 2231 2-Apr chacuH7001012 Bank Statement Edmonton 1,912.00 3,450.00 Cr DEL + 2-Apr Delivery Charges - Inv 2231 Cheque#7801013 1,912.00 3,450.00 Cr 24 25 2-Apr 775.00 Cr 26 5-Apr 17,500.00 Cr 27 6-Apr 1,200.00 18,225.00 35,725.00 34,525.00 33,750.00 34,850.00 cr -8 775.00 Cr 9-Apr 10-Apr Utility - Mar - Inv 1023 Inventory Purchase - Inv 102 Inventory Return - Inv 102 Utility - Mar - Inv 1023 Purchase Office Supplies Inv 7711 Cheque#403060 Inv 7711 Cheque#403061 Closing Balance 9 325.00 Cr 23-Apr 2,500.00 32,350.00 Cr 0 23-Apr 2,500.00 29,850.00 Cr 30-Apr 29,850.00 Cr Account: Petty Cash GL No: 1010 E F G H GL No: 1010 35 PR DR CR Balance 34 Account: Petty Cash Date Description Opening Balance Setup Petty Cash 38 30-Apr Closing Balance 36 1-Apr 37 7-Apr Dr Dr 100.00 100.00 100.00 Dr 39 30 GL No: 2600 2 DR CR Balance Account: Advance Payments from Customers Date Description PR 1-Apr Opening Balance 23-Apr Project 2211 30-Apr Closing Balance 7,500.00 Cr 7,500.00 7,500.00 Cr E F G H GL No: 1300 Balance 52 PR DR CR 53 1-Apr Dr 51 Account: Prepaid Expenses Date Description 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 54 55 4,500.00 Dr 56 500.00 6,000.00 5,500.00 5,500.00 Dr 57 Dr 58 59 GL No: 6000 61 PR DR CR Balance 60 Account: Expenses Date Description 62 1-Apr Opening Balance Purchase Office Supplies Maintenance Fees Inv 10-Apr M231 Dr 63 10-Apr 325.00 325.00 Dr 590.00 915.00 Dr GL No: 6000 Balance PR DR CR Dr 325.00 325.00 Dr 590.00 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 915.00 Dr 8,725.00 9,640.00 Dr 2,100.00 Dr 500.00 11,740.00 12,240.00 12,240.00 Dr Dr