Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hiiii please i need answer in details , thankyou . Create a Visa credit card account for both Jon and Alice. 2 . Record the

Hiiii please i need answer in details , thankyou .
Create a Visa credit card account for both Jon and Alice.
2. Record the following credit cards transactions for Jon:a. Office Supplies at Office Supplies Depot on the first of the month for $24+ tax.b. Fuel at Fuel Stop on the 5th of this month for $68+ tax.c. Supplies at Home Depot on the 10th of this month for $348+ tax.d. Disposal Fees from Waste Unlimited on the 15th of this month for $97+ tax.e. Meals and Entertainment from Sandwich Lunch Co. on the 17th of this month for $23.88+ tax.3. Jon returned Supplies to Home Depot for $27.00+ tax. Record the credit card credit.4. Enter a bill from Insurance Experts for liability insurance. Amount is $1200. This is not a taxable expense. Enter the transaction on the 20th of this month.5. Karen from Insurance Experts realized the quote was overstated, so she issued a credit for $200. Apply the credit against the bill and pay the bill to Insurance Experts.6. Green Tree Landscapes has rented some space to setup a landscape yard as they are growing quickly. They will pay rent of $2000 a month + tax to their new landlord, Brookstone Rentals. Add the new supplier and enter the expense for rent on the 28th of this month.7. To automate this transaction, make this a recurring entry in QuickBooks on the first day of every month from the TCU Chequing account. The lease is indefinite so there will be no end date to the transactionEnable inventory tracking.Create the following products using the following setup:a. Sales Account: Salesb. Inventory Account: Inventory Assetc. Purchasing Account: Cost of Goods SoldName: Turf Edger Sales Description: Turf Edger Sales Price: $99.95 Tax: Taxable Purchase Price: 38.87 Reorder Point: 5 Initial Quantity on Hand: 0Name: Gas Hedge Trimmer Sales Description: Gas Hedge Trimmer Sales Price: $149.99 Tax: Taxable Purchase Price: $86.88 Reorder Point: 5 Initial Quantity on Hand: 0Name: Hand Garden Trowel Sales Description: Hand Garden Trowel Sales Price: $19.95 Tax: Taxable Purchase Price: $7.67 Reorder Point: 5 Initial Quantity on Hand: 0Name: Pruner Lopper Sales Description: Pruner Lopper Sales Price: $78.50 Tax: Taxable Purchase Price: $40.09 Reorder Point: 5 Initial Quantity on Hand: 0Name: Evergreen Fertilizer Sales Description: 30 KG Evergreen Fertilizer Sales Price: $39.95 Tax: Taxable Purchase Price: $11.48 Reorder Point: 5 Initial Quantity on Hand: 03. Create a Purchase order for Johnson Supplies for the 1st of the month. Order the following supplies (NOTE: You may have to enable Purchase Orders prior to this exercise): Turf Edger: 10 Evergreen Fertilizer: 30 Bags4. Create a Purchase Order for a new supplier:Hanson Garden Supplies 723 Speers Road Oakville, ON L6L 2X5Order the following items:1.15 Pruner Lopper2.20 Hand Garden Trowel3.10 Gas Hedge Trimmer5. Jon wants to see whats on purchase orders as of today.Create and submit the Open Purchase Order report as PDF document.6. Receive against the PO for Johnson Supplies. Receive it in full on the 10th of this month. Use the bill form to receive the purchase order.7. Receive against the PO for Hanson Garden Supplies. You received all the Pruner Loppers and Hand Garden Trowels. You only received 7 Gas Hedge Trimmers.8. Pay the bills for Johnson Supplies and Hanson Garden Supplies in full on the last day of this month.9. Alice notices customers are buying several garden tools at one time. She has the idea to bundle several tools together as a Garden Tool Starter Kit.Create the Garden Tool Starter Kit with the following items and quantities:a.1 Hand Garden Trowelb. 1 Pruner Lopperc. 1 Turf Edger Sales Description: Garden Tool Starter Kit10. Create an invoice for Kelly Buss on the 25th of this month. Sell the Garden Tool Starter Kit.11. Receive the payment from Kelly Buss on the 30th of this month and deposit the amount directly to the TCU chequing account. She paid with cheque #1481.12. There was a heavy rainstorm at the Green Tree Landscape yard and the roof on the inventory shed was leaking. As a result, 3 Gas Hedge Trimmers were damaged. They cannot be sold and will need to be disposed of.Jane has asked you to write off the inventory as of the last day of this month. Make the inventory adjustment to account for the damaged goods. Jane asked you to use an Inventory Write-Off expense account (Tip: you may have to use the Chart of Accounts to create a new account)13. Alice and Jon want to know the value of the inventory. Create and print the Inventory Valuation Detail report for them.14. Alice wants to count the inventory each month. Shed like a list of inventory parts as of today. Create the appropriate report for her and submit as PDF document.After two busy months of business, Jon and Alice need to review their business. Submit a copy of each report as PDF document.1. Create a Balance sheet as of the last day of this month.2. Create a Profit & Loss report from the first day of last month to the last day of this month.3. Create an Accounts Receivable Aging Summary.4. Create an Accounts Payable Aging Summary.5. Create a Sales by Customer Detail report.6. Jon is going to the bank to inquire about a loan. He wants a more sophisticated set of reports. Print the appropriate reports for Jon. (Tip: Dont print the usual reports.)7. Alice loves using MS Excel to do analysis. She asks for the Profit & Loss in excel format. Create the report in Excel and email it to your instructor.8. Jane wants to see the Profit & Loss report in .pdf format. Create the report in.pdf format for Jane.9. Jane also wants to receive weekly reports mailed to her every Monday morning. Setup a group of reports listed above (Exercises 15) and schedules them to be sent to your instructor every week.Jon and Alice have a good grasp on their business. Now they want to refine their accounting work in QuickBooks.1. Customize the invoice with following features:a. Add a logo placed in the top left corner.b. Use the Friendly Style.c. Name it Sales Invoice Template.d. Choose Helvetica font.e. Relabel the Invoice Sales Invoice.f. Remove all header information except for Company Name and Address.g. In the body of the invoice include the following:i. Description (you may have to relabel this field)ii. ii. Quantityiii. Rateiv. Amountv. Taxvi. Add a message in customer message that reads: Thank you for your business!vii. Save the template.2. To remind customers of outstanding invoices, send a reminder email to all customers with outstanding balances.3. Create a GST Summary report for Jon and Alice to review.4. File Sales Taxes for the period from your start date to today.5. Pay your Sales Taxes for the filed period.NOTE: You may have to receive a sales tax refund

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_2

Step: 3

blur-text-image_3

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

Cost Management Accounting And Control

Authors: Don R. Hansen, Maryanne Mowen

2nd Edition

0538864451, 978-0538864459

More Books

Students also viewed these Accounting questions