Homework Help is Here – Start Your Trial Now!
Business
Accounting
Attached is some information about DGA Groceries. Use this information to prepare a bank reconciliation for April 30, 2020.

Attached is some information about DGA Groceries. Use this information to prepare a bank reconciliation for April 30, 2020.

Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter4: Operating Activities: Sales And Cash Receipts
Section: Chapter Questions
Problem 3.6C
See similar textbooks
icon
Related questions
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
Transcribed Image Text: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
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Bank reconciliation statement
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.
Similar questions
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS