Attached is some information about DGA Groceries. Use this information to prepare a bank reconciliation for April 30, 2020. Bank of EdmontonDowntown Edmonton, Alberta, CanadaBank StatementPeriod: Apr 1 - 30, 2020 Client NameDCA Groceries Account Number7800-7802364 DescriptionDepositWithdrawalDateBalanceBalance Forward 1-Apr-20 15,032.00Cheque#7801010 200.001-Apr-20 14,832.00EFT 2,900.00 1-Apr-20 17,732.00Cheque Deposit 1,800.00 2-Apr-20 19,532.00Cheque Deposit 800.00 3-Apr-20 20,332.00Cheque#7801012 1,500.003-Apr-20 18,832.00Cheque#7801013 1,912.003-Apr-20 16,920.00Checque Deposit 13,200.00 3-Apr-20 30,120.00Cheque#7801014 110.006-Apr-20 30,010.00Cash Withdrawal 100.007-Apr-20 29,910.00Cash Deposit 1,275.00 8-Apr-20 31,185.00Cheque Deposit 10,000.00 9-Apr-20 41,185.00Cheque#7801015 2,500.0010-Apr-20 38,685.00Cheque#7801016 2,500.0010-Apr-20 36,185.00Cheque#7801017 16,300.0015-Apr-20 19,885.00Cheque#7801018 950.0018-Apr-20 18,935.00Cheque#7801019 10,000.0027-Apr-20 8,935.00Cheque Deposit 2,345.00 27-Apr-20 11,280.00Service Charge 40.0029-Apr-20 11,240.00Closing Balance 30-Apr-20 11,240.00Bank of CalgaryDowntown Calgary, Alberta, CanadaBank StatementPeriod: Apr 1 - 30, 2020 Client NameDCA Groceries Account Number4030-4037719 DescriptionDepositsWithdrawalsDateBalanceBalance Forward 1-Apr-20 42,004.00Cheque#403054 7,500.002-Apr-20 34,504.00E-transfer 8,725.002-Apr-20 25,779.00Cheque#403056 10,000.007-Apr-20 15,779.00E-transfer 8,725.0016-Apr-20 7,054.00Cheque#403059 775.0023-Apr-20 6,279.00EFT 7,500.00 23-Apr-20 13,779.00Cheque Deposit 10,000.00 23-Apr-20 23,779.00Cheque#403060 2,500.0023-Apr-20 21,279.00Cheque#403055 2,100.0027-Apr-20 19,179.00Cheque#403061 2,500.0028-Apr-20 18,779.00Service Charge 50.0029-Apr-20 18,729.00E-transfer 8,725.0030-Apr-20 10,004.00Closing Balance 30-Apr-20 10,004.00 Account: Cash GL No: 1000DateDescriptionPRDRCRBalance1-AprOpening Balance 50,111.00Dr1-AprEquipment Inv 12034Cheque#403054 7,500.00 42,611.00Dr1-AprRent for Apr - June, 2020 Cheque#7801012 1,500.00 41,111.00Dr2-AprCustomer Payment - Inv AR3213 13,200.00 54,311.00Dr2-AprDelivery Charges - Inv 2231Cheque#7801013 1,912.00 52,399.00Dr7-AprPetty Cash 100.00 52,299.00Dr#REF!Utility - Inv 1023 Cheque#403059 775.00 51,624.00Dr10-AprCheque#7801014 110.00 51,514.00Dr10-AprMaintenance Fees Inv M231Cheque#7801018 590.00 50,924.00Dr15-AprPayment - Inv102Cheque#7801017 16,300.00 34,624.00Dr15-AprSalary ExpenseApr 1 - 14, 2020 8,725.00 25,899.00Dr23-AprInv 7711 Cheque#403061 2,500.00 23,399.00Dr23-AprInv 7711Cheque#403060 2,500.00 20,899.00Dr23-AprProject 2211 7,500.00 28,399.00Dr24-AprAdvance Payment - ContractCheque#7801020 4,500.00 23,899.00Dr25-AprAdvertising Fees Inv 1191Cheque#403055 2,100.00 21,799.00Dr27-AprCustomer Payment - Inv AR3208 2,345.00 24,144.00Dr29-AprSalary ExpenseApr 15 - 28, 2020 8,725.00 15,419.00Dr29-AprCustomer Payment Inv AR3010, Cheque 5010 6,500.00 21,919.00Dr30-AprClosing Balance 21,919.00Dr Account: Petty CashGL No: 1010DescriptionOpening BalanceSetup Petty CashClosing BalanceDatePRDRCRBalance1-AprDr7-Apr100.00100.00Dr30-Apr100.00DrAccount: Advance Payments from CustomersGL No: 2600DescriptionOpening BalanceProject 2211DatePRDRCRBalance1-Apr23-Аpr30-Аpr7,500.007,500.00Cr|Closing Balance7,500.00CrAccount: Prepaid ExpensesDescriptionOpening BalanceRent for Apr - June, 2020Cheque#7801012Advance PaymentGL No: 1300DatePRDRCRBalance1-AprDr|1-Аpr1,500.001,500.00Dr24-Apr30-Аpr30-Аpr4,500.006,000.00DrRent Expense - Apr500.005,500.00DrClosing Balance5,500.00DrAccount: ExpensesGL No: 6000DateDescriptionPRDRCRBalanceOpening Balance|1-Аpr10-AprDrPurchase Office Supplies325.00325.00DrMaintenance Fees Inv10-Apr590.00915.00DrM231Salary ExpenseApr 1- 14, 2020Advertising Fees Inv 1191Rent Expense - AprClosing Balance15-Apr8,725.009,640.00Dr25-Apr30-Apr30-Apr2,100.0011,740.00Dr500.0012,240.00Dr12,240.00Dr Account: Accounts ReceivableGL No: 1100DescriptionOpening BalanceCustomer Payment - InvAR3213DatePRDRCRBalance1-Apr27,320.00Dr2-Apr13,200.0014,120.00Dr12-AprCustomer Invoice AR321116,500.0030,620.00Dr27-AprCustomer Payment - InvAR32082,345.0028,275.00DrCustomer Payment Inv29-Apr6,500.0021,775.00DrAR3010, Cheque 5010Closing Balance|30-Аpr28,275.00DrAccount: InventoryGL No: 1200PRCRDescriptionOpening BalanceDateDRBalance1-Apr5-Apr6-Apr22,000.00DrInventory PurchaseInventory Return17,500.0039,500.00Dr1,200.0038,300.00Dr30-AprCost of Goods Sold7,580.0030,720.00Dr30-AprClosing Balance30,720.00DrAccount: Accounts PayableGL No: 2100BalanceDescriptionOpening BalanceEquipment Inv 12034Delivery Charges - Inv2231Utility - Mar - Inv 1023Inventory Purchase - Inv 102Inventory Return - Inv 102DatePRDRCR1-Apr1-Apr17,450.00Cr7,500.003,450.00Cr2-Apr1,912.003,450.00Cr2-Аpr5-Apr6-Apr9-Аpr10-Apr775.0018,225.00Cr17,500.0035,725.00Cr1,200.0034,525.00CrUtility - Mar - Inv 1023Cr34,850.00775.0033,750.00Purchase Office Supplies325.00CrInv 771123-Apr2,500.0032,350.00CrCheque#403060Inv 7711Cheque#403061Closing Balance23-Аpr2,500.0029,850.00Cr30-Аpr29,850.00Cr

Bank Reconciliation statement as on 30/4/20 Particulars Amount Balance as per Bank statement…

Answered: Attached is some information about DGA…

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

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

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

Account: Accounts Receivable
GL No: 1100
Description
Opening Balance
Customer Payment - Inv
AR3213
Date
PR
DR
CR
Balance
1-Apr
27,320.00
Dr
2-Apr
13,200.00
14,120.00
Dr
12-Apr
Customer Invoice AR3211
16,500.00
30,620.00
Dr
27-Apr
Customer Payment - Inv
AR3208
2,345.00
28,275.00
Dr
Customer Payment Inv
29-Apr
6,500.00
21,775.00
Dr
AR3010, Cheque 5010
Closing Balance
|30-Аpr
28,275.00
Dr
Account: Inventory
GL No: 1200
PR
CR
Description
Opening Balance
Date
DR
Balance
1-Apr
5-Apr
6-Apr
22,000.00
Dr
Inventory Purchase
Inventory Return
17,500.00
39,500.00
Dr
1,200.00
38,300.00
Dr
30-Apr
Cost of Goods Sold
7,580.00
30,720.00
Dr
30-Apr
Closing Balance
30,720.00
Dr
Account: Accounts Payable
GL No: 2100
Balance
Description
Opening Balance
Equipment Inv 12034
Delivery Charges - Inv
2231
Utility - Mar - Inv 1023
Inventory Purchase - Inv 102
Inventory Return - Inv 102
Date
PR
DR
CR
1-Apr
1-Apr
17,450.00
Cr
7,500.00
3,450.00
Cr
2-Apr
1,912.00
3,450.00
Cr
2-Аpr
5-Apr
6-Apr
9-Аpr
10-Apr
775.00
18,225.00
Cr
17,500.00
35,725.00
Cr
1,200.00
34,525.00
Cr
Utility - Mar - Inv 1023
Cr
34,850.00
775.00
33,750.00
Purchase Office Supplies
325.00
Cr
Inv 7711
23-Apr
2,500.00
32,350.00
Cr
Cheque#403060
Inv 7711
Cheque#403061
Closing Balance
23-Аpr
2,500.00
29,850.00
Cr
30-Аpr
29,850.00
Cr

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 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.