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 Description Deposit Withdrawal Date Balance Balance Forward 1-Apr-20 15,032.00 Cheque#7801010 200.00 1-Apr-20 14,832.00 EFT 2,900.00 1-Apr-20 17,732.00 Cheque Deposit 1,800.00 2-Apr-20 19,532.00 Cheque Deposit 800.00 3-Apr-20 20,332.00 Cheque#7801012 1,500.00 3-Apr-20 18,832.00 Cheque#7801013 1,912.00 3-Apr-20 16,920.00 Checque Deposit 13,200.00 3-Apr-20 30,120.00 Cheque#7801014 110.00 6-Apr-20 30,010.00 Cash Withdrawal 100.00 7-Apr-20 29,910.00 Cash Deposit 1,275.00 8-Apr-20 31,185.00 Cheque Deposit 10,000.00 9-Apr-20 41,185.00 Cheque#7801015 2,500.00 10-Apr-20 38,685.00 Cheque#7801016 2,500.00 10-Apr-20 36,185.00 Cheque#7801017 16,300.00 15-Apr-20 19,885.00 Cheque#7801018 950.00 18-Apr-20 18,935.00 Cheque#7801019 10,000.00 27-Apr-20 8,935.00 Cheque Deposit 2,345.00 27-Apr-20 11,280.00 Service Charge 40.00 29-Apr-20 11,240.00 Closing Balance 30-Apr-20 11,240.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 Balance Forward 1-Apr-20 42,004.00 Cheque#403054 7,500.00 2-Apr-20 34,504.00 E-transfer 8,725.00 2-Apr-20 25,779.00 Cheque#403056 10,000.00 7-Apr-20 15,779.00 E-transfer 8,725.00 16-Apr-20 7,054.00 Cheque#403059 775.00 23-Apr-20 6,279.00 EFT 7,500.00 23-Apr-20 13,779.00 Cheque Deposit 10,000.00 23-Apr-20 23,779.00 Cheque#403060 2,500.00 23-Apr-20 21,279.00 Cheque#403055 2,100.00 27-Apr-20 19,179.00 Cheque#403061 2,500.00 28-Apr-20 18,779.00 Service Charge 50.00 29-Apr-20 18,729.00 E-transfer 8,725.00 30-Apr-20 10,004.00 Closing Balance 30-Apr-20 10,004.00 Account: Cash GL No: 1000 Date Description PR DR CR Balance 1-Apr Opening Balance 50,111.00 Dr 1-Apr Equipment Inv 12034 Cheque#403054 7,500.00 42,611.00 Dr 1-Apr Rent for Apr - June, 2020 Cheque#7801012 1,500.00 41,111.00 Dr 2-Apr Customer Payment - Inv AR3213 13,200.00 54,311.00 Dr 2-Apr Delivery Charges - Inv 2231 Cheque#7801013 1,912.00 52,399.00 Dr 7-Apr Petty Cash 100.00 52,299.00 Dr #REF! Utility - Inv 1023 Cheque#403059 775.00 51,624.00 Dr 10-Apr Cheque#7801014 110.00 51,514.00 Dr 10-Apr Maintenance Fees Inv M231 Cheque#7801018 590.00 50,924.00 Dr 15-Apr Payment - Inv102 Cheque#7801017 16,300.00 34,624.00 Dr 15-Apr Salary Expense Apr 1 - 14, 2020 8,725.00 25,899.00 Dr 23-Apr Inv 7711 Cheque#403061 2,500.00 23,399.00 Dr 23-Apr Inv 7711 Cheque#403060 2,500.00 20,899.00 Dr 23-Apr Project 2211 7,500.00 28,399.00 Dr 24-Apr Advance Payment - Contract Cheque#7801020 4,500.00 23,899.00 Dr 25-Apr Advertising Fees Inv 1191 Cheque#403055 2,100.00 21,799.00 Dr 27-Apr Customer Payment - Inv AR3208 2,345.00 24,144.00 Dr 29-Apr Salary Expense Apr 15 - 28, 2020 8,725.00 15,419.00 Dr 29-Apr Customer Payment Inv AR3010, Cheque 5010 6,500.00 21,919.00 Dr 30-Apr Closing Balance 21,919.00 Dr kindly solve it step by step including journal entries , bank balance and legders. It would be very helpful. Thank you:)
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 Description Deposit Withdrawal Date Balance Balance Forward 1-Apr-20 15,032.00 Cheque#7801010 200.00 1-Apr-20 14,832.00 EFT 2,900.00 1-Apr-20 17,732.00 Cheque Deposit 1,800.00 2-Apr-20 19,532.00 Cheque Deposit 800.00 3-Apr-20 20,332.00 Cheque#7801012 1,500.00 3-Apr-20 18,832.00 Cheque#7801013 1,912.00 3-Apr-20 16,920.00 Checque Deposit 13,200.00 3-Apr-20 30,120.00 Cheque#7801014 110.00 6-Apr-20 30,010.00 Cash Withdrawal 100.00 7-Apr-20 29,910.00 Cash Deposit 1,275.00 8-Apr-20 31,185.00 Cheque Deposit 10,000.00 9-Apr-20 41,185.00 Cheque#7801015 2,500.00 10-Apr-20 38,685.00 Cheque#7801016 2,500.00 10-Apr-20 36,185.00 Cheque#7801017 16,300.00 15-Apr-20 19,885.00 Cheque#7801018 950.00 18-Apr-20 18,935.00 Cheque#7801019 10,000.00 27-Apr-20 8,935.00 Cheque Deposit 2,345.00 27-Apr-20 11,280.00 Service Charge 40.00 29-Apr-20 11,240.00 Closing Balance 30-Apr-20 11,240.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 Balance Forward 1-Apr-20 42,004.00 Cheque#403054 7,500.00 2-Apr-20 34,504.00 E-transfer 8,725.00 2-Apr-20 25,779.00 Cheque#403056 10,000.00 7-Apr-20 15,779.00 E-transfer 8,725.00 16-Apr-20 7,054.00 Cheque#403059 775.00 23-Apr-20 6,279.00 EFT 7,500.00 23-Apr-20 13,779.00 Cheque Deposit 10,000.00 23-Apr-20 23,779.00 Cheque#403060 2,500.00 23-Apr-20 21,279.00 Cheque#403055 2,100.00 27-Apr-20 19,179.00 Cheque#403061 2,500.00 28-Apr-20 18,779.00 Service Charge 50.00 29-Apr-20 18,729.00 E-transfer 8,725.00 30-Apr-20 10,004.00 Closing Balance 30-Apr-20 10,004.00 Account: Cash GL No: 1000 Date Description PR DR CR Balance 1-Apr Opening Balance 50,111.00 Dr 1-Apr Equipment Inv 12034 Cheque#403054 7,500.00 42,611.00 Dr 1-Apr Rent for Apr - June, 2020 Cheque#7801012 1,500.00 41,111.00 Dr 2-Apr Customer Payment - Inv AR3213 13,200.00 54,311.00 Dr 2-Apr Delivery Charges - Inv 2231 Cheque#7801013 1,912.00 52,399.00 Dr 7-Apr Petty Cash 100.00 52,299.00 Dr #REF! Utility - Inv 1023 Cheque#403059 775.00 51,624.00 Dr 10-Apr Cheque#7801014 110.00 51,514.00 Dr 10-Apr Maintenance Fees Inv M231 Cheque#7801018 590.00 50,924.00 Dr 15-Apr Payment - Inv102 Cheque#7801017 16,300.00 34,624.00 Dr 15-Apr Salary Expense Apr 1 - 14, 2020 8,725.00 25,899.00 Dr 23-Apr Inv 7711 Cheque#403061 2,500.00 23,399.00 Dr 23-Apr Inv 7711 Cheque#403060 2,500.00 20,899.00 Dr 23-Apr Project 2211 7,500.00 28,399.00 Dr 24-Apr Advance Payment - Contract Cheque#7801020 4,500.00 23,899.00 Dr 25-Apr Advertising Fees Inv 1191 Cheque#403055 2,100.00 21,799.00 Dr 27-Apr Customer Payment - Inv AR3208 2,345.00 24,144.00 Dr 29-Apr Salary Expense Apr 15 - 28, 2020 8,725.00 15,419.00 Dr 29-Apr Customer Payment Inv AR3010, Cheque 5010 6,500.00 21,919.00 Dr 30-Apr Closing Balance 21,919.00 Dr kindly solve it step by step including journal entries , bank balance and legders. It would be very helpful. Thank you:)
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter6: Cash And Receivables
Section: Chapter Questions
Problem 1E: Computing; the Cash Balance Listed below are ten items that may be found on a balance sheet....
Related questions
Question
100%
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 | |||
Description | Deposit | Withdrawal | Date | Balance |
Balance Forward | 1-Apr-20 | 15,032.00 | ||
Cheque#7801010 | 200.00 | 1-Apr-20 | 14,832.00 | |
EFT | 2,900.00 | 1-Apr-20 | 17,732.00 | |
Cheque Deposit | 1,800.00 | 2-Apr-20 | 19,532.00 | |
Cheque Deposit | 800.00 | 3-Apr-20 | 20,332.00 | |
Cheque#7801012 | 1,500.00 | 3-Apr-20 | 18,832.00 | |
Cheque#7801013 | 1,912.00 | 3-Apr-20 | 16,920.00 | |
Checque Deposit | 13,200.00 | 3-Apr-20 | 30,120.00 | |
Cheque#7801014 | 110.00 | 6-Apr-20 | 30,010.00 | |
Cash Withdrawal | 100.00 | 7-Apr-20 | 29,910.00 | |
Cash Deposit | 1,275.00 | 8-Apr-20 | 31,185.00 | |
Cheque Deposit | 10,000.00 | 9-Apr-20 | 41,185.00 | |
Cheque#7801015 | 2,500.00 | 10-Apr-20 | 38,685.00 | |
Cheque#7801016 | 2,500.00 | 10-Apr-20 | 36,185.00 | |
Cheque#7801017 | 16,300.00 | 15-Apr-20 | 19,885.00 | |
Cheque#7801018 | 950.00 | 18-Apr-20 | 18,935.00 | |
Cheque#7801019 | 10,000.00 | 27-Apr-20 | 8,935.00 | |
Cheque Deposit | 2,345.00 | 27-Apr-20 | 11,280.00 | |
Service Charge | 40.00 | 29-Apr-20 | 11,240.00 | |
Closing Balance | 30-Apr-20 | 11,240.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 |
Balance Forward | 1-Apr-20 | 42,004.00 | ||
Cheque#403054 | 7,500.00 | 2-Apr-20 | 34,504.00 | |
E-transfer | 8,725.00 | 2-Apr-20 | 25,779.00 | |
Cheque#403056 | 10,000.00 | 7-Apr-20 | 15,779.00 | |
E-transfer | 8,725.00 | 16-Apr-20 | 7,054.00 | |
Cheque#403059 | 775.00 | 23-Apr-20 | 6,279.00 | |
EFT | 7,500.00 | 23-Apr-20 | 13,779.00 | |
Cheque Deposit | 10,000.00 | 23-Apr-20 | 23,779.00 | |
Cheque#403060 | 2,500.00 | 23-Apr-20 | 21,279.00 | |
Cheque#403055 | 2,100.00 | 27-Apr-20 | 19,179.00 | |
Cheque#403061 | 2,500.00 | 28-Apr-20 | 18,779.00 | |
Service Charge | 50.00 | 29-Apr-20 | 18,729.00 | |
E-transfer | 8,725.00 | 30-Apr-20 | 10,004.00 | |
Closing Balance | 30-Apr-20 | 10,004.00 |
Account: Cash | GL No: 1000 | |||||
Date | Description | PR | DR | CR | Balance | |
1-Apr | Opening Balance | 50,111.00 | Dr | |||
1-Apr | Equipment Inv 12034 Cheque#403054 |
7,500.00 | 42,611.00 | Dr | ||
1-Apr | Rent for Apr - June, 2020 Cheque#7801012 | 1,500.00 | 41,111.00 | Dr | ||
2-Apr | Customer Payment - Inv AR3213 | 13,200.00 | 54,311.00 | Dr | ||
2-Apr | Delivery Charges - Inv 2231 Cheque#7801013 |
1,912.00 | 52,399.00 | Dr | ||
7-Apr | Petty Cash | 100.00 | 52,299.00 | Dr | ||
#REF! | Utility - Inv 1023 Cheque#403059 | 775.00 | 51,624.00 | Dr | ||
10-Apr | Cheque#7801014 | 110.00 | 51,514.00 | Dr | ||
10-Apr | Maintenance Fees Inv M231 Cheque#7801018 |
590.00 | 50,924.00 | Dr | ||
15-Apr | Payment - Inv102 Cheque#7801017 |
16,300.00 | 34,624.00 | Dr | ||
15-Apr | Salary Expense Apr 1 - 14, 2020 |
8,725.00 | 25,899.00 | Dr | ||
23-Apr | Inv 7711 Cheque#403061 |
2,500.00 | 23,399.00 | Dr | ||
23-Apr | Inv 7711 Cheque#403060 |
2,500.00 | 20,899.00 | Dr | ||
23-Apr | Project 2211 | 7,500.00 | 28,399.00 | Dr | ||
24-Apr | Advance Payment - Contract Cheque#7801020 |
4,500.00 | 23,899.00 | Dr | ||
25-Apr | Advertising Fees Inv 1191 Cheque#403055 |
2,100.00 | 21,799.00 | Dr | ||
27-Apr | Customer Payment - Inv AR3208 | 2,345.00 | 24,144.00 | Dr | ||
29-Apr | Salary Expense Apr 15 - 28, 2020 |
8,725.00 | 15,419.00 | Dr | ||
29-Apr | Customer Payment Inv AR3010, Cheque 5010 | 6,500.00 | 21,919.00 | Dr | ||
30-Apr | Closing Balance | 21,919.00 | Dr |
kindly solve it step by step including
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,