Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide a step by step solution Please note this is quickbook assignment 5. Add the following new customers in the Customer Centre: a .Add

Please provide a step by step solution

Please note this is quickbook assignment

5. Add the following new customers in the Customer Centre:

a.Add yourself as a customer (make sure to enter your last name first in the Customer Name text box). Make up fictitious address information and telephone numbers. Ship to name should be your name when copying the information from the "Invoice To" to the "Ship To". Set your terms as 2% 10 Net 30 and assign a credit limit of 15,000.00. Your preferred payment method is Cheque.

b.Add two more new customers using the following information: Note: If you do not have information for a specific field, leave it blank

Mr. Shawn Jenkins Ms. Jade Fleming 87 Dundas Street E.London, ON N5W 3E4 519-555-6523 redit Limit: 25,000 Credit Limit 1% 10 Net 30 2%

Ms. Jade Fleming 151 Highbury Avenue London, ON N9Y 3W7 519-555-3845 Terms: 2% 10 Net 30 Credit Limit: 25,000 Credit Limit: 15,000.

6. Add the following new vendors in the Vendor Centre. Vendor name is the same as the company name. Note: If you are not provided information for a specific field, leave it blank.

A. Allway Supply 3451 Exeter Road London, ON N5Y 2W6 Terms: 2% 10 Net 30 519-555-7496

b.AllRite Products 182 Jefferson Blvd Windsor, ON N8P 3A7 519-555-3488 Terms: 2% 10 Net 30

c.Fine Building 42 Talbot St. St. Thomas, ON N6Y 2A1 519-555-8452 Terms: 1% 10 Net 30

7. FORM - Receive Inventory with Bill (All Dates are for the year 2017)

Jan. 17Invoice 398745 from AllRite Products for: Standing Lamp (Standing Lamp - halogen) Qty 10 @ 114.75 each Track Light (Track light - 3 ft) Qty 12 @ 85.50 each Wall Sconce (Art Deco 9") Qty 12 @ 23.15 each.

Jan. 17 Invoice488 received from Allway Supply for: Exterior Door (Exterior Wood Door) Qty 5 @ 118.55 each Interior Door (Interior Wood Door) Qty 5 @ 67.88 each.

Jan. 17Invoice 89A31 received from C. U. Electric Supply for: Table Lamp (Table lamp - Tiffany) Qty 8 @ 85.95 each.

Jan. 17Invoice 355 received from Fine Building for: Cabinets - Light Pine (Light pine kitchen cabinet wall unit) Qty 10 @ 99.95 each.

Jan. 19Invoice 26 received from Andre's Mechanical for: Bathroom faucet (Tub faucet - waterfall) Qty 10 @ 269.95 each Kitchen faucet (Sink faucet with spray head) Qty 10 @ 119.95 each Shower Head (Rainfall) Qty 10 @ 29.95 each.

Jan. 19Returned 2 Exterior Wood Doors to Allway Supply on Debit Memo 45 @118.55.

Jan. 20Returned 2 Tiffany Table Lamps to C. U. Electric Supply on Debit Memo 46 @85.95.

Jan. 20Invoice 371 received from Fisher Supplies for: Brass Hinges (Standard brass hinge) Qty 50 @ 2.03 each Cabinet Pulls (Door pulls for kitchen cabinets) Qty 30 @ 1.02 each.

8. FORMS: Create Invoices, Refunds & Credits Enter the following sales invoices or issue the following credit memos to customers. Note: Accept the default sale price for all items unless otherwise noted.

Jan. 17 Invoice Shawn Jenkins for 1 Bathroom Faucet (Tub faucet - waterfall) and 1 hour of Direct Labour: Plumbing Labour @75.00 per hour

Jan. 17Invoice Jade Fleming for 5 Cabinets - Light Pine (Light Pine kitchen cabinet wall units) @159.95 each

Jan. 18Invoice Clinton Nielsen for 1 Standing Lamp - halogen and 1 Track Light - 3 Ft. Jan. 18 Invoice Jade Fleming for 10 Brass Hinges (Standard brass hinge), 5 Cabinet Pulls (Door pulls for kitchen cabinets), and 2 Doorknobs (Standard doorknobs).

Jan. 19Invoice your account for 2 Table Lamps - Tiffany, 1 - Standing Lamp - halogen, and 3 Track Lights - 3 ft.Jan. 19Jade Fleming returned 1 Light Pine kitchen cabinet wall unit @ 159.95. Make sure to apply the refund to the invoice recorded on Jan. 17.

Jan. 20Invoice your account for 2 Exterior Wood Doors Jan. 20 Clinton Nielsen returned the Halogen Standing Lamp he purchased on Jan. 18. Apply the refund to the Jan. 18 invoice..

9. Jade Fleming pays $865.08 to bring her account up to date on January 20. Make sure you record the proper discount due to the return based on the credit memo. The underpayment of $15.59 is the calculated discount. Make sure you know how this number is arrived at based on the NET sales for Jade Fleming, Apply the $15.59 as a discount. Record receipt of Jade's cheque no. 41 which was deposited into the Chequing account. Record the discount to the Sales Discounts account.

10. You pay your account in full on January 20. Apply the discount, which is on invoice no 24. Calculate the payment including the discount and record receipt of your cheque number 83.

11. Calculate the full amount owing to Allway Supply. Pay the amount owing on January 23. At the Pay Bills screen, after selecting Allway Supply in the list, click the Set Credits button to apply the debit memo for the returned goods on Jan. 19. Next, click the Discount tab in the Discount and Credits window and enter the amount you calculated as the discount available on the account. Make sure you select the Inventory on Hand (1120) account as the Discount Account.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts Financial Analysis

Authors: Gary Giroux

1st Edition

047146712X, 9780471467120

More Books

Students also viewed these Accounting questions

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago