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:)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

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 journal entries , bank balance and legders. It would be very helpful. Thank you:)

Account: Petty Cash
GL No: 1010
Description
Opening Balance
Setup Petty Cash
Closing Balance
Date
PR
DR
CR
Balance
1-Apr
Dr
7-Apr
100.00
100.00
Dr
30-Apr
100.00
Dr
Account: Advance Payments from Customers
GL No: 2600
Description
Opening Balance
Project 2211
Date
PR
DR
CR
Balance
1-Apr
23-Аpr
30-Аpr
7,500.00
7,500.00
Cr
|Closing Balance
7,500.00
Cr
Account: Prepaid Expenses
Description
Opening Balance
Rent for Apr - June, 2020
Cheque#7801012
Advance Payment
GL No: 1300
Date
PR
DR
CR
Balance
1-Apr
Dr
|1-Аpr
1,500.00
1,500.00
Dr
24-Apr
30-Аpr
30-Аpr
4,500.00
6,000.00
Dr
Rent Expense - Apr
500.00
5,500.00
Dr
Closing Balance
5,500.00
Dr
Account: Expenses
GL No: 6000
Date
Description
PR
DR
CR
Balance
Opening Balance
|1-Аpr
10-Apr
Dr
Purchase Office Supplies
325.00
325.00
Dr
Maintenance Fees Inv
10-Apr
590.00
915.00
Dr
M231
Salary Expense
Apr 1- 14, 2020
Advertising Fees Inv 1191
Rent Expense - Apr
Closing Balance
15-Apr
8,725.00
9,640.00
Dr
25-Apr
30-Apr
30-Apr
2,100.00
11,740.00
Dr
500.00
12,240.00
Dr
12,240.00
Dr

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.