Question: This project has been designed to provide students with more experience in working with basic functions of accounting using QuickBooks Premier Accountant Edition 2 0

This project has been designed to provide students with more experience in working with basic functions of accounting using QuickBooks Premier Accountant Edition 2018. Topics and tasks outlined in the exercises are derived from the same topics and tasks introduced and practiced in the CCI QuickBooks Premier 2018 Level 1 courseware.
1. Launch QuickBooks and restore the portable company file New Look Interiors Inc. base 2018(Portable).QBM. Save the file as New Look Interiors Inc. . Password: NewLook18(case sensitive).
2. Customize the Home page:
Remove the Statements and Statement Charges icons.
3. Add to these lists. Use the first name, last name protocol for names.
Customer: Frank Bellows, payment terms Net 15.
Vendor: Fabric Supply House, payment terms 1%10 Net 30.
Vendor: Gabby Hutchins, payment terms Net 30.
4. Turn on this preference: Automatically place decimal point.
5a. Add to these lists:
Sales Rep List: Gabby Hutchins, GH.
Terms: New term: 1%7 Net 15.
Items: New Item: Design Service, $80.00, tax code G, Service Sales account.
5b. Make these changes:
Add this main phone number for Frank Bellows: 866-111-5555.
Add Cost of Goods Sold type GL account named Soft Goods, sub-account of Costs of Goods Sold.
Make the following GL accounts sub-accounts of Soft Goods: Bedding & Linen, Draperies & Rugs.
6. Add the following individual who needs to be invoiced.
Mary Sullivan with payment terms of Net 15.
7. Enter an invoice using the default sales tax, receive the payment, and deposit the cheque for the following:
Frank Bellows buys 4 hours of Design Service on 03/05/2017. Use the default sales tax.
His cheque #4836 paying the invoice in full arrives on 3/10/2017 and the deposit to the Chequing Bank Account GL is on 03/11/2017.
8. Receive payment on two other invoices on 03/13/2017. One payment is from Ronald M. Carson, $2,141.72, cheque #3297; and the other is from Celine Cadman, $1,448.83, cheque #59346. Deposit these payments together on 03/14/2017.
9. Sell the following to walk-in customer Gene Roden: Design Service, 1.5 hours, using default sales tax, on 03/15/2017. He pays in full before he leaves with cheque #2376. Deposit the cheque on 03/16/2017.
10. The order for South West Realty, Inc. arrives. Invoice the delivery charge using item S 110 on 03/16/2017.
Use the Accounts Receivable Summary Aging report to check the balance for South West Realty, Inc. Open the invoice and receive their payment in full on 03/17/2017 using cheque #883264. Deposit the payment on 03/17/2017.
11. Frank Bellows wants to buy more Design Service. Invoice him for 2 additional hours on 03/19/2017. Before he pays, the designer explains he used only 1.5 hours. Issue a credit for .5 hours and apply it to the invoice.
12. The cheque from Ronald M. Carson for $2,141.72 comes back from the bank as an NSF. Record the bounced cheque on 03/19/2017 with a $25.00 bank fee and $30.00 customer fee.
13. A new fabrics supplier needs to be entered: Cotton Organics, with the payment terms 2%10 Net 30.
14. The February bill for Alberta Hydro for $120.00 before tax has arrived. The date is 03/19/2017. Find the January bill, duplicate it by creating a copy and update. Pay the bill on 03/22/2017 assigning the cheque #188.
15. Write cheque #189 to Telus for $100.00(before tax) for Telephone Expense, dated 03/23/2017.
16. Create a new GL account, credit card type, for Bank Credit Card (dismiss the message that follows). Then enter a purchase using the credit card from new vendor Tires Unlimited for $200(before tax), Automobile Expense, dated 03/24/2017.
17. Enter a debit card purchase for $125.00(before tax) for Automobile Expense to Tires Unlimited, dated 03/25/2017.
18. Write cheque #190 to new vendor Postal Service for $75(before tax) in Postage and Delivery. The tax code is G.
19. The bank statement ending 02/28/2017 needs to be reconciled. The beginning balance is 72,157.25. The ending balance is 84,777.88. The deposit on 02/27/2017 for 16,327.39 is in transit. Also in transit are the $7,500.00 transfer on 02/27/2017 and cheque #187. One bank service charge of $10.00 needs to be entered.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!