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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS