Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 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 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 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 52,399 Dr 100 52.299 Dr 775 51,624 Dr 110 51,514 Dr 590 50,924 Dr Account: Clash Date Description 1-Apr Opening Balance Equipment Inv 12034 1-Apr Cheque#403054 Rent for Apr - June, 2020 1-Apr Cheque#7801012 Customer Payment - Inv 2-Apr AR3213 Delivery Charges - Inv 2-Apr 2231 Cheque#7801013 7-Apr Petty Cash Utility - Inv 1023 Cheque#403059 10-Apr Cheque#7801014 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 Cheque#403061 Inv 7711 23-Apr Cheque#403060 23-Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 25-Apr Advertising Fees Iny 1191 Cheque#403055 27-Apr Customer Payment - Inv AR3208 Salary Expense 29-Apr Apr 15 - 28, 2020 Customer Payment Inv 29-Apr AR3010, Cheque 5010 30-Apr Closing Balance 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 2,100 21.799 Dr 2,345 24,144 Dr 8,725 15,419 Dr 6,500 21,919 Dr 21,919 Dr PR DR CR De 13200 GL No: 1100 Balance 27,330 14,120 30.6.20 21.275 De Account: Accounts Receivable Date Description L-Apr Opening Balance Customer Payment - In 2. Apr AR3213 12-Apr Customer Invoice AR3211 27. Apr Customer Payment In JAR3208 29. Apr Customer Payment In AR 3010 Cheque 5010 30. Apr Closing Balance 16 500 De De 6500 21.775 Dr 28.275 De PR DR CR Account: Inventory Date Description L-Apr Opening Balance 5. Apr Inventory Purchase 6. Apr Inventory Return Cost of Goods Sold 30. Apr Closing Balung 17.500 GL No: 1200 Balance 22.000 39.500 38,300 30,720 30,720 DE De De De De 1.200 750 10-Apr PR DR CR GL No: 2100 Balance 17.450 3,450 1. Apr Cr 7.500 1,912 1,450 Cr CH 775 17.500 Account: Accounts Payable Date Description Opening Balance 1-Apr Equipment in 12034 Delivery Charger - Inv 2231 2. Apr Cheque7501013 2-Apr Utility - Mar - Iny 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 21-Apr Cheque 40060 iny 7711 21. Apr Cheque401061 Closing Balance 18.235 35.725 34.525 33,750 34.RSO 1.200 775 SS GOOGO Cr 2.500 32.150 C 2.500 29.850 CT 10- Apr 29.850 Cr PR DR CR Account: Petty Cash Date Description L-Apr Opening Balance Setup Petty Cash 30-Apr Closing Balance GL No: 1010 Balance 0 100 100 119 1. Apr 100 PR DR CR Account: Advance Payments from Customers Date Description PR 1 - Apr Opening Balance 23. Apr Project 2211 30.Apr Closing Balance GL No: 2600 Balance 0 7,500 7.500 7.500 C Cr PR DR CR GL No 1300 Balance 0 Dr Account: Prepaid Expenses Date Description 1-Apr Opening Balance 1- Apr Rent for Apr - Junc, 2020 Cheque7801012 24-Apr Advance Payment 30. Apr Rent Expense - Apr 1.500 1.500 De 4.500 6,000 5.500 De Dr 500 PR DR CR Account: Intentory Date Description 1-Apr Opening Balance 5-Apr Inventory Purchase 6-Apr Inventory Return Cost of Goods Sold 30-Apr Closing Balance 17.500 GL No: 1200 Balance 22.000 39.500 38,300 30,720 30.720 LLLLLL 1.300 7.50 Dr De Dr De Dr III 30-Apr PR DR CR GL No: 2100 Balance 12.450 3.450 7.500 OS 3 1.912 3,450 C Account: Accounts Payable Date Description 1-Apr Opening Balance L-Apr Equipment Inv 12034 2-Apr Delivery Charges - Inv 2231 Chequel7801013 2. Ape Utility. Mar. Inv 1023 S-Apr Inventory Purchase-In 107 6-Apr Inventory Return - In 160 Utility. Mar - Inv 1023 10-Apr Purchase Office Supplies 775 17.500 18.25 35,725 34.525 33,750 34,850 Jalalala Cr G CH Cr Cr - Apr 795 Ooooo 325 23 Apr Inw 52.350 Cr Cheque403060 Inv 7711 Choquei 40061 Closing Balance 23-Apr 30 Apr CH 29 RSD 29.850 Cr PR DR CR Account: Pelty Cash Date Description 1-Apr Opening Balance 7-Apr Setup Petty Cash 30. Apr Closing Balance GL No: 1010 Balance 0 100 100 100 Dr Dr Dr DR Account: Advance Payments from Customers Date Description PR Opening Balance 23-Apr Project 2211 30-Apr Closing Balance 1. Apr CR 0 7.500 GL No: 2600 Balance 0 7,500 Cr 7.500 CH PR DR CR GL. No: 1.300 Balance 0 Dr Account: Prepaid Expenses Date Description 1. Apr Opening Balance 1-Apr Rent for Apr, 2020 Chege 701012 |24-Apr Advance Payment 130-Apr Rent Expense Age Closing Balance 1.500 1.500 Dr 40 500 6,000 5.500 5.500 Dr Dr Dr 10-Apr GL. No: 6000 Balance PR DR CR 335 50 325 915 Dr Dr Dr Account: Expenses Date Description 1. Apr Opening Balance 10-Apr Purchase Office Supplies 10-Apr Maintenance Fees In M231 Salary Expense |15-Apr Apr 1. 14, 2020 25-Apr Advertising Fees Inv 1191 30-Apr Rent Expense. Apa 30-Apr Closing Balance 8.725 9.6-40 Dr 2100 SO 11.7.40 12.240 12.240 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 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 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 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 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 52,399 Dr 100 52.299 Dr 775 51,624 Dr 110 51,514 Dr 590 50,924 Dr Account: Clash Date Description 1-Apr Opening Balance Equipment Inv 12034 1-Apr Cheque#403054 Rent for Apr - June, 2020 1-Apr Cheque#7801012 Customer Payment - Inv 2-Apr AR3213 Delivery Charges - Inv 2-Apr 2231 Cheque#7801013 7-Apr Petty Cash Utility - Inv 1023 Cheque#403059 10-Apr Cheque#7801014 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 Cheque#403061 Inv 7711 23-Apr Cheque#403060 23-Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 25-Apr Advertising Fees Iny 1191 Cheque#403055 27-Apr Customer Payment - Inv AR3208 Salary Expense 29-Apr Apr 15 - 28, 2020 Customer Payment Inv 29-Apr AR3010, Cheque 5010 30-Apr Closing Balance 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 2,100 21.799 Dr 2,345 24,144 Dr 8,725 15,419 Dr 6,500 21,919 Dr 21,919 Dr PR DR CR De 13200 GL No: 1100 Balance 27,330 14,120 30.6.20 21.275 De Account: Accounts Receivable Date Description L-Apr Opening Balance Customer Payment - In 2. Apr AR3213 12-Apr Customer Invoice AR3211 27. Apr Customer Payment In JAR3208 29. Apr Customer Payment In AR 3010 Cheque 5010 30. Apr Closing Balance 16 500 De De 6500 21.775 Dr 28.275 De PR DR CR Account: Inventory Date Description L-Apr Opening Balance 5. Apr Inventory Purchase 6. Apr Inventory Return Cost of Goods Sold 30. Apr Closing Balung 17.500 GL No: 1200 Balance 22.000 39.500 38,300 30,720 30,720 DE De De De De 1.200 750 10-Apr PR DR CR GL No: 2100 Balance 17.450 3,450 1. Apr Cr 7.500 1,912 1,450 Cr CH 775 17.500 Account: Accounts Payable Date Description Opening Balance 1-Apr Equipment in 12034 Delivery Charger - Inv 2231 2. Apr Cheque7501013 2-Apr Utility - Mar - Iny 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 21-Apr Cheque 40060 iny 7711 21. Apr Cheque401061 Closing Balance 18.235 35.725 34.525 33,750 34.RSO 1.200 775 SS GOOGO Cr 2.500 32.150 C 2.500 29.850 CT 10- Apr 29.850 Cr PR DR CR Account: Petty Cash Date Description L-Apr Opening Balance Setup Petty Cash 30-Apr Closing Balance GL No: 1010 Balance 0 100 100 119 1. Apr 100 PR DR CR Account: Advance Payments from Customers Date Description PR 1 - Apr Opening Balance 23. Apr Project 2211 30.Apr Closing Balance GL No: 2600 Balance 0 7,500 7.500 7.500 C Cr PR DR CR GL No 1300 Balance 0 Dr Account: Prepaid Expenses Date Description 1-Apr Opening Balance 1- Apr Rent for Apr - Junc, 2020 Cheque7801012 24-Apr Advance Payment 30. Apr Rent Expense - Apr 1.500 1.500 De 4.500 6,000 5.500 De Dr 500 PR DR CR Account: Intentory Date Description 1-Apr Opening Balance 5-Apr Inventory Purchase 6-Apr Inventory Return Cost of Goods Sold 30-Apr Closing Balance 17.500 GL No: 1200 Balance 22.000 39.500 38,300 30,720 30.720 LLLLLL 1.300 7.50 Dr De Dr De Dr III 30-Apr PR DR CR GL No: 2100 Balance 12.450 3.450 7.500 OS 3 1.912 3,450 C Account: Accounts Payable Date Description 1-Apr Opening Balance L-Apr Equipment Inv 12034 2-Apr Delivery Charges - Inv 2231 Chequel7801013 2. Ape Utility. Mar. Inv 1023 S-Apr Inventory Purchase-In 107 6-Apr Inventory Return - In 160 Utility. Mar - Inv 1023 10-Apr Purchase Office Supplies 775 17.500 18.25 35,725 34.525 33,750 34,850 Jalalala Cr G CH Cr Cr - Apr 795 Ooooo 325 23 Apr Inw 52.350 Cr Cheque403060 Inv 7711 Choquei 40061 Closing Balance 23-Apr 30 Apr CH 29 RSD 29.850 Cr PR DR CR Account: Pelty Cash Date Description 1-Apr Opening Balance 7-Apr Setup Petty Cash 30. Apr Closing Balance GL No: 1010 Balance 0 100 100 100 Dr Dr Dr DR Account: Advance Payments from Customers Date Description PR Opening Balance 23-Apr Project 2211 30-Apr Closing Balance 1. Apr CR 0 7.500 GL No: 2600 Balance 0 7,500 Cr 7.500 CH PR DR CR GL. No: 1.300 Balance 0 Dr Account: Prepaid Expenses Date Description 1. Apr Opening Balance 1-Apr Rent for Apr, 2020 Chege 701012 |24-Apr Advance Payment 130-Apr Rent Expense Age Closing Balance 1.500 1.500 Dr 40 500 6,000 5.500 5.500 Dr Dr Dr 10-Apr GL. No: 6000 Balance PR DR CR 335 50 325 915 Dr Dr Dr Account: Expenses Date Description 1. Apr Opening Balance 10-Apr Purchase Office Supplies 10-Apr Maintenance Fees In M231 Salary Expense |15-Apr Apr 1. 14, 2020 25-Apr Advertising Fees Inv 1191 30-Apr Rent Expense. Apa 30-Apr Closing Balance 8.725 9.6-40 Dr 2100 SO 11.7.40 12.240 12.240 Dr Dr Dr

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen Braun, Wendy Tietz, Louis Beaubien

4th Canadian Edition

013544344X, 9780135443446

More Books

Students also viewed these Accounting questions

Question

When, if ever, are fixed costs differential?

Answered: 1 week ago

Question

dotear

Answered: 1 week ago

Question

Explain the importance of Human Resource Management

Answered: 1 week ago