QuickBooks Assignment: Financial Reports and Analysis

This document presents a complete solution to a QuickBooks assignment, addressing various financial reporting requirements. The solution includes detailed reports such as the GST/HST return, deposit details, cheque details, and reconciliation summaries for Curly's Cabinets. It also covers the trial balance report for Darya's Dance Studio, the employee earnings summary report, payroll liabilities balance report, PD7A Summary Report, and the inventory valuation summary report, pending builds, and pending sales reports. The assignment demonstrates proficiency in generating financial statements, analyzing payroll data, and managing inventory using QuickBooks.

Running head: QUICK BOOKS
Quick Books
Name of the Student:
Name of the University:
Authors Note:

1
QUICK BOOKS
Contents
Chapter 8:.........................................................................................................................................2
Answer 1:.....................................................................................................................................2
Answer 2:.....................................................................................................................................3
Answer 3:.....................................................................................................................................4
Answer 4:.....................................................................................................................................4
Answer 5:.....................................................................................................................................5
Answer 6:.....................................................................................................................................6
Chapter 9 & 10:...............................................................................................................................7
Answer 1:.....................................................................................................................................7
Answer 2:.....................................................................................................................................9
Answer 3:...................................................................................................................................11
Chapter 11:.....................................................................................................................................13
Answer 1:...................................................................................................................................13
Answer 2:...................................................................................................................................14
Answer 3:...................................................................................................................................16
References:....................................................................................................................................19

2
QUICK BOOKS
Chapter 8:
Answer 1:
GST/ HST return report of Curly's
Reporting period is from August 1, 2019 to October 31, 2019
Line Particulars Amount
101 Sales and other revenue 107,026.34
103 GST/ HST collected / collectable 5,515.20
104 Adjustments -
105 Total GST / HST 5,515.20
106 Input tax credit 961.09
107 Adjustments -
108 Total input tax credit and adjustments 961.09
109 Net tax 4,554.11
110 Payments of instalments by the filer -
111 Rebates -
112 Total other credits -

3
QUICK BOOKS
113A Balance 4,554.11
205 GST/HST due on acquisition -
405 Other self-assessed GST/ HST -
113B Other debits total -
113C Balance 4,554.11
Answer 2:
Deposit details are provided in the table below:
Date Particulars Amount ($)
October 01, 2019 Cash received from cash sales 230.00
October 01, 2019 Cheque received from Doze
and deposited
3,000.00
October 01, 2019 Cheque received from Flatte
and deposited
2,000.00
October 01, 2019 Cheque received from Frame
and deposited
1,000.00
Total 6,230.00

4
QUICK BOOKS
Less: Withdrawn by owner
for personal use
200.00
Net deposit amount 6,030.00
Answer 3:
The cheque detailed report of Curly’s during the period from October 01, 2019 to October 31,
2019 is given below.
Date Account Amount ($)
31/10/2019 Bank charges 35.00
31/10/2019 Credit card fees 440.50
01/10/2019 Visa payables 451.00
Answer 4:
The missing cheque report is attached below:
Date Name Amount ($)
01/10/2019 451.00
04/10/2019 2918.00
13/10/2019 4290.00

5
QUICK BOOKS
15/10/2019 309.80
15/10/2019 39.68
20/10/2019 1489.80
23/10/2019 796.80
24/10/2019 135.80
30/10/2019 1364.00
31/10/2019 4554.18
31/10/2019 1060.25
Answer 5:
Previous reconciliation summary report as on October 31, 2019
Particulars Amount ($) Amount ($) Amount ($)
Balance at the
beginning
23,540.00
Transactions cleared (11,764.04)
Deposits and credits 23,855.60
Cleared balance 35,631.56

6
QUICK BOOKS
Transactions not cleared
Payment cheques (5,614.36)
Balance register as on
31/10/2019
30,017.20
Ending balance 30,017.20
Answer 6:
Previous reconciliation summary report as on October 31, 2019
Particulars Amount ($) Amount ($) Amount ($)
Balance at the
beginning
451.00
Transactions cleared 0.00
Cleared balance 0.00
Transactions not cleared
Payment cheques (451.00)
Balance register as on
31/10/2019
0.00
Ending balance 0.00

7
QUICK BOOKS
Chapter 9 & 10:
Answer 1:
Trial balance
Account Account
code
Debit ($) Credit
($)
Capital 3,20
0.00
91,715.
00
Revenue from lessons 4,10
0.00
3,800.
00
Sales discount 4,16
0.00
3
0.00
Revenue from interest 4,20
0.00
20
.00
Advertising and promotion 5,02
0.00
2,100
.00
Office and computer supplies
used
5,06
0.00
18
5.00

8
QUICK BOOKS
Music inventory expenses 5,08
0.00
4
5.00
Depreciation 5,10
0.00
1,000
.00
Maintenance expenses 5,12
0.00
22
0.00
Insurance expenses 5,14
0.00
3,250
.00
Interest expenses 5,16
0.00
42
0.00
Printing and stationery 5,18
0.00
56
0.00
Property tax expense 5,20
0.00
12
0.00
Purchase discount 5,22
0.00
95
.00
Hydro expenses 5,24
0.00
8
5.00
Telephone expenses 5,26 12

9
QUICK BOOKS
0.00 0.00
Vehicle expenses 5,28
0.00
24
0.00
Assets (Balancing figure) 87,255
.00
Total 95,630
.00
95,630.
00
Note: Drop down facility is provided in the attached excel sheet ("VitalSource Bookshelf Online",
2019).
Answer 2:
Employee earnings summary report
Name Salary Sick
Salar
y
Vacati
on
Hourl
y wage
Overti
me
Sick
hourl
y
Vacati
on
hourly
Commitm
ent
Advan
ce
Nichol
ai,
Digger
- - -
2,74
4.00
294
.00 56.00 -
- 10
0.00

10
QUICK BOOKS
Serge,
Draper - - -
1,68
0.00
325
.50
1
12.00
1,008
.00
- 20
0.00
Vijay,
Gardne
r
2,48
5.00
1
77.50
88
7.50 - - - -
1,044.00
-
Stone,
Kutter - - -
2,88
0.00
216
.00 -
960
.00
-
-
Mita,
Paynter - - -
2,16
0.00
108
.00 -
720
.00
-
-
Dee,
Zijner
3,19
5.00 -
35
5.00 - - - -
844.00
-
Total 5,68
0.00
1
77.50
1,24
2.50
9,46
4.00
943
.50
1
68.00
2,688
.00
1,888.00 30
0.00
Note: Drop down facility is provided in the attached excel sheet.
Employee Contact List Report
Name SIN Main Phone Address
Nicholai, Digger 931 216 660 [phone] 1049 Paradise Rd. Victoriam, BC.
Serge, Draper 406 629 420 [phone] 299 Vebesee Dr. Victoria, BC
Vijay, Gardner 420 161 420 [phone] 360 Tapolee Avenue, Victoria, BC

11
QUICK BOOKS
Stone, Kutter 583 444 858 [phone] 456 Marbles Court Victoria, BC.
Mita, Paynter 148 196 835 [phone] 18 Chatsusa Cr. Victoria, BC.
Dee, Zijner 129 632 774 [phone] 56 Wingent Pt. Victoria, BC.
Answer 3:
Part i:
Payroll liabilities balance report
Payroll liabilities Amount ($)
Federeal Income tax 4,828.76
CPP - employee 638.16
CPP - Company 638.16
III- Emplpyee 968.70
III- Company 1,687.41
Net vacation accrued (3,158.00)
CSB Plus 898.60
Medical - Employee 298.50