0% found this document useful (0 votes)
33 views4 pages

QBO 2019 Practice Set Checklist Key

Uploaded by

ber
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
33 views4 pages

QBO 2019 Practice Set Checklist Key

Uploaded by

ber
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

QUICKBOOKS ONLINE PLUS:

A COMPLETE COURSE 2019


PRACTICE SET: CHECKLIST KEY
YOUR NAME’S SHAPE UP CENTER

The following documents and reports should be printed and attached to the students’
checklists or emailed to the professor. Document totals are provided next to the
document name in the checklist.

Student Printouts

1. Prod-Svc List PS
2. Cust List PS
3. Vend List PS
4. Acct List PS
5. Trial Bal PS, $147,523.04
6. Profit and Loss PS, $3,020.04
7. Bal Sheet PS, $143,563.04
8. Inv 1008 L Chin PS, $334.64
9. Inv 1009 L Diamond PS, $850.00
10. Inv 1010 E Brown PS, $758.58
11. PO 1001 Unique Accessories PS, $125.00
12. PO 1002 Tee-Shirt World PS, $150.00
13. Journal 01-01-19 PS, $112,186.22
14. Prod-Svc Sum 01-01-19 PS, $1,884.81
15. Inv Val Sum 01-01-19 PS, $5,090.00
16. Cust Bal Sum 01-01-19 PS, $8,588.26
17. Vend Bal Sum 01-01-19 PS, $3,625.00
18. SR 1011 M Salazar PS, $557.99
19. SR 1012 M Walsh PS, $749.19
20. PO 1003 Fitness Supplies PS, 40.00
21. PO 1004 Visor City PS, $150.00
22. Inv 1013 J Ludwig PS, $998.79
23. CM 1014 E Brown PS, $22.04
24. Journal 01-05-19 PS, $2,693.01
25. Prod-Svc Sum 01-05-19 PS, $2,252.89
26. Inv Val Sum 01-05-19 PS, $5,135.00
Copyright ©2020 Pearson Education, Inc.
QUICKBOOKS ONLINE PLUS: A Complete Course 2019 IM PS-

27. Cust Bal Sum 01-05-19 PS, $9,565.01


28. Vend Bal Sum 01-05-19 PS, $3,775.00
29. RR 1015 M Salazar PS, $33.06
30. SR 1016 G Jong PS, $820.83
31. Rcv Pmt E Brown PS, $721.37
32. Rcv Pmt J Ludwig PS, $978.82
33. Dep Sum 01-10-19 PS, $3,795.14
34. Journal 01-10-19 PS, $6,813.99
35. Prod-Svc Sum 01-10-19 PS, $774.96
36. Inv Val Sum 01-10-19 PS, $5,303.00
37. Cust Bal Sum 01-10-19 PS, $7,829.68
38. Vend Bal Sum 01-10-19 PS, $4,065.00
39. Open PO List by Vendor PS, $25.00 (Unique Accessories)
40. SR 1017 G Jong PS, $103.56
41. Unpaid Bills 01-15-19 PS, $4,600.00
42. Inv 1018 A Raza PS, $295.77
43. Ck 1 Unique Accessories PS, $83.30
44. Bill Pmt List 01-15-19 PS, Checking: -$83.30, Visa: $147.00
45. Journal 01-15-19 PS, $4,271.63
46. Prod-Svc Sum 01-15-19 PS, $366.85
47. Inv Val Sum 01-15-19, $5,211.00
48. Cust Bal Sum 01-15-19 PS, $8,125.45
49. Vend Bal Sum 01-15-19 PS, $4,365.00
50. Ck 2 Santa Monica Rentals PS, $1,500.00
51. SR 1019 M Larson PS, $561.14
52. Inv 1020 J Ludwig PS, $45.00
53. Ck 3 Office Supply World PS, $392.00
54. Inv 1021 O Ericson PS, $150.00
55. Journal 01-20-06 PS, $2,693.14
56. Prod-Svc Sum 01-20-19 PS, $749.99
57. Inv Val Sum 01-20-19 PS, $5,191.00
58. Cust Bal Sum 01-20-19 PS, $8,320.45
59. Vend Bal Sum 01-20-19 PS, $3,940.00
60. Inv 1020 J Ludwig Void PS, $0.00
61. SR 1022 Cash Customer PS, $125.00
62. Inv 1023 M Walsh PS, $785.25
63. Rcv Pmt L Diamond PS, $850.00
64. Rcv Pmt L Chin PS, $200.00
65. Rcv Pmt A Raza PS, $789.85
66. Dep Sum 01-25-19 PS, $2,629.55
67. Journal 1-25-19 PS, $5,512.15
68. Prod-Svc Sum 01-25-19 PS, $906.97
69. Inv Val Sum 01-25-19 PS, $5,181.00
70. Cust Bal Sum 01-25-19 PS, $7,214.93
71. Vend Bal Sum 01-25-19 PS, $3,815.00
72. SR 1024 A Raza PS, $526.94
73. Ck 4 Westside Prop Rent PS, $1,600.00

Copyright ©2020 Pearson Education, Inc.


QUICKBOOKS ONLINE PLUS: A Complete Course 2019 IM PS-

74. Ck 5-7 PS:


CA Electric, $325.00
CA Gas, $150.00
CA Water, $185.00
75. Sales Tax Liability PS, $145.84
76. Ck 8 Owner PS, $1,200.00
77. Dep Sum 01-30-19 PS, $526.94
78. Bank Rec 01-30-19 PS, Register Balance $93,904.49
79. Ck 9 Visa PS, $344.50
80. Visa Rec 01-30-19 PS, Register Balance $344.50
81. Inv 1025 L Chin PS, $40.00
82. Cust Bal Sum 01-31-19 PS, $7,454.93
83. Prod-Svc Sum 01-31-19 PS, $7,415.68
84. Sales by Location Sum 01-31-19 PS, $7,415.68
Santa Monica, $3,318.20
Westwood, $4,097.48
85. Sales by Class Sum 01-31-19 PS, $7,415.68
Boutique, $1,435.48
Gym, $5,979.96
Not Specified $0.24
86. Purch by Prod-Svc Detail 01-31-19 PS, Shows 5 Products: Shorts, Tee Shirt,
Towel, Visor, Wrist Band
87. Inv Val Sum 01-31-19 PS, $4,964.00
88. Bill Pmt List 01-31-19 PS, Checking: -$475.30; Visa: $269.50
89. Vend Bal Sum 01-31-19 PS, $3,815.00
90. Trans List by Vend 01-31-19 PS
91. Ck Detail 01-31-19 PS
92. Trial Bal 01-31-19 PS, $158,680.00
93. Profit and Loss 01-31-19 PS, $2,411.82
94. Bal Sheet 01-31-19 PS, $150,412.21
95. Journal 01-31-19 PS, $150,497.22

Forms Not Printed

There are a significant number of transactions that are recorded but not printed in
QuickBooks Online. Screenshots were taken for these transactions and are included in
this folder for your review.

1. Exp Workout Clothing Co PS, $150.00


2. Transfer to Petty Cash PS, $100.00
3. Rec Pmt CM E Brown PS, $22.04
4. Delayed Charge A Raza PS, $272.92
5. Bill Visor City PS, $150.00
6. Bill Fitness Supplies PS, $40.00
7. Bill Unique Accessories PS, $100.00
8. CC Credit Workout Clothing Co, $75.00
9. Exp Office Supply World PS, $9.71
10. Bill Tee-Shirt World, $150.00
Copyright ©2020 Pearson Education, Inc.
QUICKBOOKS ONLINE PLUS: A Complete Course 2019 IM PS-

11. Bill 4601 Deluxe Advertising PS, $125.00


12. Bill 948 Office Supply World PS, $425.00
13. Vend Cr Unique Accessories PS, $15.00
14. Bill Visor City, $147.00
15. Bill Pmt Visor City PS, $147.00
16. Bill Unique Accessories PS, $98.30
17. Bill Pmt Unique Accessories, $83.30
18. Vend Cr Office Supply World, $25.00
19. Bill 948 Office Supply World, $417.00
20. Bill Pmt Office Supply World, PS, $392.00
21. Bill 4601 Deluxe Advertising PS, $122.50
22. Bill Pmt Deluxe Advertising PS, $122.50
23. Qty Adjust Shorts PS, -5
24. Adjust Inv Start Value PS, Weights 2 $240.00
25. Pmt Rct L Chin Revised, $200.00

Copyright ©2020 Pearson Education, Inc.

Common questions

Powered by AI

An efficient payment collection strategy could involve structured follow-ups, implementing early payment discounts, and maintaining a detailed aging analysis of receivables to prioritize collections . Automating invoicing and reminders to customers could streamline the collection process. Establishing clear payment terms and leveraging technology for online payment options can also enhance customer compliance and expedite cash inflow .

The inventory valuation shows slight fluctuations with $5,090.00 on January 1st, increasing to $5,191.00 by January 20th, and slightly decreasing to $4,964.00 by January 31st . The overall minor changes suggest effective inventory management, maintaining consistent levels while adapting to production or sales needs. This indicates a balance between order fulfilment and overstock minimization, essential for optimal inventory management .

Discrepancies among summaries, such as the differences in inventory valuation and vendor balances, could affect reporting accuracy by skewing understanding of financial health . Variances in amounts reported in customer balances and invoice payments might indicate internal recording inaccuracies or timing differences between transaction occurrences and entries. This could lead to mismatches in periodic financial reviews, affecting decision-making accuracy about performance and strategic directions .

The vendor balance summary shows an increase from $3,625.00 on January 1st to $3,815.00 on January 31st . This rising trend suggests accumulating payables, perhaps due to increased procurement activities without proportionate bill payments. Strategic actions could involve negotiating extended payment terms, consolidation of vendors for better terms, or optimizing cash flow management to settle outstanding payables timely, reducing potential interest or penalties .

The frequency of journal entries, e.g., on January 1, 5, 10, 15, 20, 25 , reflects detailed recording practices and indicates an attempt at comprehensive financial reporting. However, the existence of unprinted forms and delayed charges suggests gaps that could impact the completeness and reliability of financial reports. Ensuring all entries are accurately captured and classified supports better financial oversight and assures stakeholders of the data's reliability .

The fluctuations in profit and loss, from $3,020.04 at the start to $2,411.82 at the end , suggest a decline possibly due to increased expenses or reduced revenues. This signals a need for managerial considerations on cost optimization and revenue enhancement strategies. The business may consider revising budget allocations or exploring new revenue streams to buffer profits, which is necessary for sustained operational viability and strategic planning .

Improving internal controls could include implementing more robust transaction verification procedures, ensuring all transactions like voided invoices and adjusted quantities are accurately tracked and reconciled promptly . Regular audits and cross-departmental reviews would enhance transparency. Additionally, integrating a comprehensive, system-assisted tracking mechanism for real-time data check and validation could reduce discrepancies, enhancing financial integrity .

The net change in the customer balance summary from January 1st ($8,588.26) to January 31st ($7,454.93) shows a reduction of $1,133.33. This decrease could be attributed to various factors such as payments received from customers, possibly indicated by the recorded receipts like 'Rcv Pmt L Diamond PS, $850.00' and others . Additionally, adjustments like voided invoices could have impacted the total customer balances .

The check payments in January, such as 'Ck 1 Unique Accessories PS, $83.30', 'Ck 2 Santa Monica Rentals PS, $1,500.00', and others, totaling substantial sums, imply strategic cash outflows to manage and sustain operations . This cash flow management reflects an active approach to maintaining supplier relationships and fulfilling obligations. Despite these payouts, maintaining increasing balances on profit and loss accounts suggests strong revenue collection supporting outflows .

The sales by class summary for January 31st indicates priorities towards the gym class, which totals $5,979.96 compared to $1,435.48 in the boutique . This significant difference prioritizes gym-related activities, reflecting potentially higher demand or profitability derived from gym services compared to the boutique. Strategic resource allocation and marketing efforts may hence be oriented more towards gym services for optimization and growth .

You might also like