Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The course I'm taking this summer is Accounting with QuickBooks class. The book name is Computer Accounting with QuickBooks 2015 Seventeenth Edition by Donna Kay.

The course I'm taking this summer is Accounting with QuickBooks class. The book name is Computer Accounting with QuickBooks 2015 Seventeenth Edition by Donna Kay. The project that I am trying to complete is Chaper 7, Project 7. It is due July 22, 2017 at 10.59 EST. If you can, Please just upload all the report sheets so I can just transfer my answer for the report sheets into my assignment. Thank you for all your help.

Here are the questions they want me to complete in Quickbooks:

Project 7 Larry's Landiscaping

To complete the project, download the Chapter 7 Go Digtal Reports Excel template at www.My-QuickBooks.com. Follow the instructions provided in the Excel template.

Complete the following for Larry's Landscaping

1. Use either your QuickBooks Company file (.QBW file) or backup file (.QBB file) that you completed for Project 6. (If you have issues with your Quickbooks file, contact your instructor.) Update the Company Name to Include: YourName Project 7.

2. Download the Chapter 7 Go Digital Reports Excel template. Save the Excel file using the file name YourLastName FirstName CH7 REPORTS.

3. Complete the following instructions to ensure that your accounts are in the proper order in the Chart of Accounts. Open the Chart of Accounts window. Click Account > Re-sort List. When asked Are you sure you want to return this list to its original order?, Click OK.

Using your saved Excel template for Chapter 7, export to Excel the Trial Balance report for Larry's Landscaping for the fiscal quarter October 1 to December 31, 2019.

4. Enter the following adjusted entries for Larry's Landscaping.

Date Entry Number Account to Debit Account to Credit Amount
12/31/2019 A108 6700 Depreciation (Expense) 1520 Accumulated Depreciation-Truck $575.00
12/31/2019 A109 6900 Insurance (Expense) Prepaid Insurance $100.00

.

5. Export to Excel the Adjusting Journal Entries report for December 31, 2019. (Select: Report Center > Accountant & Taxes > Adjusting Journal Entries.)

6. Export to Excel the Adjusted Trial Balance for Larry's Landscaping at December 31, 2019. Highlight the adjustments and any adjusted trial balance account balance that changed as a result of adjustments.

7. Export to Excel the Profit and Loss Standard report for the fiscal quarter October 1 to December 31, 2019.

8. Export to Excel the Profit and Loss Detail report for the fical quarter October 1 to December 31, 2019.

9. Export to Excel the Balance Sheet Standard report as of December 31, 2019.

10. Export to Excel the Balance Sheet Standard report with a vertical analysis showing each account as a percentage of total assets as of December 31, 2019. Highlight the asset that represents the largest percentage of total assets.

11. Export to Excel the General Ledger report using only the accounts in use for December 15 through December 31, 2019.

12. Mark the reports completed on the 7 REPORTS sheet. Save your Excel file.

13. Save a .QBB backup of your work.

Down below is the assignment questions.

1. Using the Trail Balance for Larry's Landscaping that you prepaired in Step 3 using instructions on page 7.35, enter the following information.

A. Input the amount for Checking from the Trail Balance that you prepared using the instructions on page 7.35. (Round your answer to 2 decimal places.)

Account Amount Debit/Credit?
Checking

B. Input the amount for 1200 Account Receivable from the Trail Balance that you prepared using the instructions on page 7.35. (Round your answer to 2 decimal places.)

Account Amount Debit/Credit?
1200 Account Receivable

C. Input the amount for 2400 Bank Loan from the Trail Balance that you prepared using the instructions on page 7.35. (Round your answer to 2 decimal places.)

Account Amount Debit/Credit?
2400 Bank Loan

D. Input the amount for 4100 Landscaping Services: 4000 Design Services form the Trial Balance that you prepared using the instructions on page 7.35. Round your answer to 2 decimal places.)

Account Amount Debit/Credit?
4100 Landscaping Services: 4000 Design Services

E. Input the amount for 5000 Cost of Goods sold from the Trial Balance that you prepared using the instructions on page 7.35. (Round your answer to 2 decimal places.)

Account Amount Debit/Credit?
5000 Cost of Goods Sold

F. Input the amount for Total Debits form the Trial Balance that you prepared using the instructions on page 7.35. (Round your answer to 2 decimal places.)

Account Amount
Total Debits

2. Using the Adjusting Journal Entries that you prepared in Step 5 for Larry's Landscaping using instructions on text page 7.35, Input the following key amounts. (Round your answers to 2 decimal places.)

Account Amount Debit/Credit?
12/31/2019 6700 Depreciation Expense
12/31/2019 1520 Accumulated Depreciation-Truck
12/31/2019 6900 Insurance Expense
12/31.2019 Prepaid Insurance
Total Debits N/A
Total Credits N/A

3. Using the Adjusted Trail Balance for Larry's Landscaping that you prepared in Step 6 using instructions on page 7.35, enter the following information.

A. Input the following information for the following accounts from the Adjusted Trail Balance for Larry's Landscaping. Round your answers to 2 decimal places. If there is no effect for an item in a particular column, leave the balance cell blank and do not select Debit or Credit.

Item Unadjusted Balance Amount Debit/Credit? Adjustments Debit/Credit? Adjusted Balance Debit/Credit?
Prepaid Insurance
1500 Truck: 1520 Accumulated Depreciation
6700 Depreciation
6900 Insurance
Total Debits from Adjusted Trail Balance
Total Credit from Adjusted Trail Balance

Using the Profit & Loss Statement (Standard) for Larry's Landscaping that you prepared in Step 7 on page 7.35, input key information as directed below.

A. Input the amount for Total 4100 Landscaping Services. (Round your answer to 2 decimal places.)

Amount
Total Landscaping Services

B. Input the amount for Total Income. (Round your answers to 2 decimal places.)

Amount
Total Income

C. Input the amount for Total COGS. (Round your answer to 2 decimal places.)

Amount
Total COGS

D. Input the amount for Gross Profit. (Round your answer to 2 decimal places.)

Amount
Gross Profit

E. Input the amount for Total Expense. (Round your answer to 2 decimal places.)

Amount
Total Expense

F. Input the amount for Net Ordinary Income. (Round your answer to 2 decimal places.)

Amount
Net Ordinary Income

G. Input the amount for Net Income. (Round your answer to 2 decimal places.)

Amount
Net Income

5. Using the Balance Sheet (Standard) for Larry's Landscaping that you prepared in Step 9 on page 7.36, input key information as directed below.

A. Input the balance for the following items appearing on the Balance Sheet Standard. (Round your answers to 2 decimal places.)

Item Amount
Checking
Total Current Assets
Total Fixed Assets
Total Assets
Total Accounts Payable
Total Credit Cards
Total Current Liabilities
Total Liabilities
Total Equity

6. Using the Balance Sheet Vertical Analysis report that you prepared in Step 10 using instructions on page 7.36, enter the following key information.

A. Enter the amount and percentage for Checking on the Balance Sheet Vertical Analysis report. (Round your answer dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Checking %

B. Enter the amount and percentage for 1200 Account Receivable on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Current Assets %

C. Enter the amount and percentage for Total Current Assets on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Current Assets %

D, Enter the amount and percentage for Total Fixed Assets on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Assets %

E. Enter the amount and percentage for Total Assets on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Anount Percentage
Total Assets %

F. Enter the amount and percentage for 2000 Accounts Payable on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
2000 Accounts Payable %

G. Enter the amount and percentage for Total Long Term Liabilities on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Long Term Liabilities %

H. Enter the amount and percentage for Total Liabilities on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Liabilities %

I. Enter the amount and percentage for Total Equities on the Balance Sheet Vertical Analysis report. (Round your dollar amount to 2 decimal places and percentage answer to 1 decimal place.)

Item Amount Percentage
Total Equity %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions