Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
use this information to prepare bank reconciliation as per 30/4/ 2020 We WHO BUN Ow WA ver OM | --- - Bank of Edmonton Downtown
use this information to prepare bank reconciliation as per 30/4/ 2020
We WHO BUN Ow WA ver OM | --- - 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 Cheque7801010 EFT Cheque Deposit Cheque Deposit Chequc#7801012 Cheque#7801013 Checque Deposit Cheque7801014 Cash Withdrawal Cash Deposit Cheque Deposit Cheque7801015 Cheque7801016 Cheque#7801017 Cheque#7801018 Cheque7801019 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-for-20 2,500.00 10-Apr-20 16,300.00 15-for-20 950.00 18 Apr 20 10,000.00 27-11-20 27 Ar 20 40.00 29-for-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 Description Deposits Withdrawals Date Balance forward 1-Apr-20 Cheque1403054 7,500.00 2 Apr 20 transfer 8,725.00 2 Apr 20 Cheque1403056 10,000.00 7 Apr 20 E transfer 8,725.00 16 Apr 20 Cheque #403059 775.00 23 Apr 20 EFT 7,500.00 23 Apr 20 Cheque Deposit 10,000.00 23 Apr 20 Cheque 403060 2,500.00 23 Apr 20 Cheque 403055 2,100.00 27 Apr 20 Chequet403061 2,500.00 28 Apr 20 Service Charge 50.00 29 Apr 20 Etranster 8,725.00 30 Apr 20 Closing Balance 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 GL No: 1000 CR 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 Dr 100.00 52.299.00 775.00 51,624.00 110.00 51,514.00 Dr Dr 590.00 50,924.00 Dr Account: Cash Date Description 1 Apr Opening Balance Equipment inv 12034 1-Apr Cheque 403054 1-Apr Rent for Apr - June 2020 Cheque 7801012 2-Apr Customer Payment Iny AR3213 Delivery Charges - in 2-Apr 2231 Cheque 7801013 7-Apr Petty Cash REF: Utility - Inv 1023 Cheque403059 10-Apr Cheque47801014 Maintenance Fees 10-Apr Inv M231 Cheque#7801018 15-Apr Payment - Inv102 Chequea7801017 15-Apr Salary Expense Apr 1-14, 2020 Inv 7711 23-Apr Cheque403061 inv 7711 23 Apr Cheque #403050 23 Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 Advertising Fees inv 25-Apr 1191 Cheque 403055 27-Apr Customer Payment iny AR3208 29 Apr Salary Expense Apr 15 - 28.2020 29Apr Customer Payment Inv AR300, 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 Dr 2,500.00 20,899.00 28,399.00 7,500.00 Dr 4,500.00 23,899.00 Dr 2.100.00 21,799.00 Dr 2.345.00 24,144.00 Dr Dr 6,500.00 8,725.00 15,419.00 21,919.00 23,919.00 Dr Dr PR DR CR Account: Petty Cash Date Description 1. At Opening Balance 2- Setup Petty Cash Closing Balance GL No: 1010 Balance Or 100.00 De 100.00 Or 100.00 30-Apr GL No: 2600 Balance DR CR Account: Advance Payments from Customers Date Description PR 1- Apr Opening Olance Prolece 2211 30-Apr Closine Balance 21 Apr 7,500.00 7,500.00 7,500.00 Or Cr GL No: 1300 Balance PR DR CR Ur Account: Prepaid Expenses Date Description 1.Ar Opening balance Rent for Apr - June, 2020 1.for cheque7801032 24. Aps Advance Payment 30-Apr Rent Expense-dor 30-Apr Closing Balance 1,500.00 Dr 4500.00 1,500.00 5,000.00 5,500.00 5,500.00 500.00 Dr Dr Dr Date GL No 6000 Balance PR DR CR 323.00 Dr DT 325.00 590.00 915.00 Dr R725.00 2.100.00 500 DO Anunt: Expenses Description 1-A Opening Balance 10-Apr Purchase Office Supplies Maintenance Fees in 10-Apr M231 Salary Expense 15. Apr Apr.14.2020 25-Apr Advertising Fees in 1291 30 Apr Rent Expense. At 30-Apr Closing Balance Account: Accounts Receivable Date Description 1-Apr Opening balance Customer Payment Iny 2- Apr AR2131 Customer invoice AR1211 27-Apr Customer Payntent-in AR9203 29-Apr Customer Payment in AR3010, Cheque 5000 30-Apr Closing Balance PR DR 9,640.00 Dr 11.740.00 Or 12,240.00 Dr 12,200.00 Dr GL Nos 1100 CR Balance 27,320.00 13,200.00 14,120.00 Dr 30,620.00 Dr 2,345.00 28,275.00 DE 15,500.00 6,500.00 Dr 21,775.00 28,275.00 De PR DR Account Inventory Date Description 1-Apr Opening Balance 5-A Inwentary Purchase 6-Apr Inventory Return 30-Apr Cost of Goods Sald 30-Apr Closing Balance 17,500.00 GL No: 1200 CR Balance 22,000.00 59,500.00 1,200.00 38,300.00 7,500.00 90,720.00 30,720.00 De Or De Dr We WHO BUN Ow WA ver OM | --- - 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 Cheque7801010 EFT Cheque Deposit Cheque Deposit Chequc#7801012 Cheque#7801013 Checque Deposit Cheque7801014 Cash Withdrawal Cash Deposit Cheque Deposit Cheque7801015 Cheque7801016 Cheque#7801017 Cheque#7801018 Cheque7801019 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-for-20 2,500.00 10-Apr-20 16,300.00 15-for-20 950.00 18 Apr 20 10,000.00 27-11-20 27 Ar 20 40.00 29-for-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 Description Deposits Withdrawals Date Balance forward 1-Apr-20 Cheque1403054 7,500.00 2 Apr 20 transfer 8,725.00 2 Apr 20 Cheque1403056 10,000.00 7 Apr 20 E transfer 8,725.00 16 Apr 20 Cheque #403059 775.00 23 Apr 20 EFT 7,500.00 23 Apr 20 Cheque Deposit 10,000.00 23 Apr 20 Cheque 403060 2,500.00 23 Apr 20 Cheque 403055 2,100.00 27 Apr 20 Chequet403061 2,500.00 28 Apr 20 Service Charge 50.00 29 Apr 20 Etranster 8,725.00 30 Apr 20 Closing Balance 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 GL No: 1000 CR 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 Dr 100.00 52.299.00 775.00 51,624.00 110.00 51,514.00 Dr Dr 590.00 50,924.00 Dr Account: Cash Date Description 1 Apr Opening Balance Equipment inv 12034 1-Apr Cheque 403054 1-Apr Rent for Apr - June 2020 Cheque 7801012 2-Apr Customer Payment Iny AR3213 Delivery Charges - in 2-Apr 2231 Cheque 7801013 7-Apr Petty Cash REF: Utility - Inv 1023 Cheque403059 10-Apr Cheque47801014 Maintenance Fees 10-Apr Inv M231 Cheque#7801018 15-Apr Payment - Inv102 Chequea7801017 15-Apr Salary Expense Apr 1-14, 2020 Inv 7711 23-Apr Cheque403061 inv 7711 23 Apr Cheque #403050 23 Apr Project 2211 Advance Payment 24-Apr Contract Cheque#7801020 Advertising Fees inv 25-Apr 1191 Cheque 403055 27-Apr Customer Payment iny AR3208 29 Apr Salary Expense Apr 15 - 28.2020 29Apr Customer Payment Inv AR300, 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 Dr 2,500.00 20,899.00 28,399.00 7,500.00 Dr 4,500.00 23,899.00 Dr 2.100.00 21,799.00 Dr 2.345.00 24,144.00 Dr Dr 6,500.00 8,725.00 15,419.00 21,919.00 23,919.00 Dr Dr PR DR CR Account: Petty Cash Date Description 1. At Opening Balance 2- Setup Petty Cash Closing Balance GL No: 1010 Balance Or 100.00 De 100.00 Or 100.00 30-Apr GL No: 2600 Balance DR CR Account: Advance Payments from Customers Date Description PR 1- Apr Opening Olance Prolece 2211 30-Apr Closine Balance 21 Apr 7,500.00 7,500.00 7,500.00 Or Cr GL No: 1300 Balance PR DR CR Ur Account: Prepaid Expenses Date Description 1.Ar Opening balance Rent for Apr - June, 2020 1.for cheque7801032 24. Aps Advance Payment 30-Apr Rent Expense-dor 30-Apr Closing Balance 1,500.00 Dr 4500.00 1,500.00 5,000.00 5,500.00 5,500.00 500.00 Dr Dr Dr Date GL No 6000 Balance PR DR CR 323.00 Dr DT 325.00 590.00 915.00 Dr R725.00 2.100.00 500 DO Anunt: Expenses Description 1-A Opening Balance 10-Apr Purchase Office Supplies Maintenance Fees in 10-Apr M231 Salary Expense 15. Apr Apr.14.2020 25-Apr Advertising Fees in 1291 30 Apr Rent Expense. At 30-Apr Closing Balance Account: Accounts Receivable Date Description 1-Apr Opening balance Customer Payment Iny 2- Apr AR2131 Customer invoice AR1211 27-Apr Customer Payntent-in AR9203 29-Apr Customer Payment in AR3010, Cheque 5000 30-Apr Closing Balance PR DR 9,640.00 Dr 11.740.00 Or 12,240.00 Dr 12,200.00 Dr GL Nos 1100 CR Balance 27,320.00 13,200.00 14,120.00 Dr 30,620.00 Dr 2,345.00 28,275.00 DE 15,500.00 6,500.00 Dr 21,775.00 28,275.00 De PR DR Account Inventory Date Description 1-Apr Opening Balance 5-A Inwentary Purchase 6-Apr Inventory Return 30-Apr Cost of Goods Sald 30-Apr Closing Balance 17,500.00 GL No: 1200 CR Balance 22,000.00 59,500.00 1,200.00 38,300.00 7,500.00 90,720.00 30,720.00 De Or De Dr
use this information to prepare bank reconciliation as per 30/4/ 2020
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b701ec4821_814669b701e650f5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b701f7282e_815669b701f1085d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b70200ef00_815669b701fa63f7.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b7020bd464_816669b70204f11a.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started