ACC303 module 3 project 2
For this module you are to complete the following assignment:
From the QuickBooks “Student Problems and Cases” book:

Question 4-1

Question 4-2

Question 4-3

Question 4-4

Question 4-5

Report Requirement 4-1 (export the report to Excel and submit it, do not “print” the report)

green Rectangle

Line

Previous

Next

Project 2

For this module you are to complete the following assignment:

From the QuickBooks “Student Problems and Cases” book:

Question 4-1

Question 4-2

Question 4-3

Question 4-4

Question 4-5

Report Requirement 4-1 (export the report to Excel and submit it, do not “print” the report)

• Question 4-1: Rock Castle Construction – Questions about customers, sales, and collections

a. Which customer has the largest outstanding account balance on the current date (12/15/2016)? Which one has the smallest balance excluding zero balances?

b. What is the total amount of invoices for the current fiscal year-to-date?

c. What is the total amount of open invoices for the current month to day (12/1/2016 to 12/15/2016)?

d. Which customer paid the largest amount using MasterCard this fiscal year-to-date?

• Question 4-2:

a. How many paychecks did Elizabeth Mason receive in November 2016?

b. Explain the difference between the nature of payroll checks and liability checks for payroll?

c. Which employee received the largest net paycheck every pay period in the current fiscal year?

• Question 4-4b:Rock Castle Construction – Print a list of vendor’s transactions and export thelist

a. Print a list of bills for the vendor Perry Windows & Doors for the current fiscal year to date using only four columns in the following order from left to right: Amount, Open Balance, Date, and Due Date. Sort the list by account balance, with the largest amount on top.

b. Export the list in part (a) to Excel using the Export Transactions menu item. After exporting to Excel, print a list of bills for Perry Windows & Doors with an invoice amount of $1,000 or

more. Except for the excluded bills, the columns and sorting should be the same as in Questions 4-4a. All headings should be in bold. The printout should include a description of the printout and the date.

• Question 4-5: Larry’s Landscaping & Garden Supply – Use drill down in cash receipts

Open the Customer Center: Received Payments list window. Drill down on Check No. 3250 dated 11/20/2016.

a. Who was the customer?

b. Were there any other sales to the customer in Question 4-5a that are currently unpaid? Explain.

c. What was the sales invoice number and date of the sale for the above collection?

d. What products or services were sold on the invoice?

e. Was a discount taken by the customer on this receipt?

•Question 4-6: Larry’s Landscaping & Garden Supply – Use drill down of employees

Open the Employees Center and use drill down to open the Edit Employee window for Shane Hamby.

a. What is his social security number?

b. What is his annual salary amount?

c. What is his filing status for federal taxes?

d. For the payment to Hamby on 6/16/2016, what was the amount of his total earnings and federal income tax withholding?

e. How much did Larry’s Landscaping & Garden Supply pay for his Federal unemployment for the pay period of 6/16/2016?

• Question 4-7: Larry’s Landscaping & Garden Supply – Use drill down of Chart of Accounts

a. Use drill down to determine the balance in the Bank of Anycity Loan account at 11/30/2016. What is the balance?

b. What were the total debits and credits for the 10/28/2016 transaction to that account?

• Report Requirement 4-1 (export the report to Excel and submit it, do not “print” thereport):

a. Print and hand in a standard profit and loss statement for Larry’s Landscaping & Garden Supply for this fiscal quarter to dsate (10/01/2016 to 12/15/2016) in two columns?

b. Print and hand in a standard profit and loss statement for Larry’s Landscaping & Garden Supply, by quarter for the last fiscal year. Each quarter and the total should be in separate columns

c. Which quarter was the most profitable for the company during the last fiscal year?

ACC303 module 3 project 2
For this module you are to complete the following assignment:
From the QuickBooks “Student Problems and Cases” book:

Question 4-1

Question 4-2

Question 4-3

Question 4-4

Question 4-5

Report Requirement 4-1 (export the report to Excel and submit it, do not “print” the report)

green Rectangle

Line

Previous

Next

Project 2

For this module you are to complete the following assignment:

From the QuickBooks “Student Problems and Cases” book:

Question 4-1

Question 4-2

Question 4-3

Question 4-4

Question 4-5

Report Requirement 4-1 (export the report to Excel and submit it, do not “print” the report)

• Question 4-1: Rock Castle Construction – Questions about customers, sales, and collections

a. Which customer has the largest outstanding account balance on the current date (12/15/2016)? Which one has the smallest balance excluding zero balances?

b. What is the total amount of invoices for the current fiscal year-to-date?

c. What is the total amount of open invoices for the current month to day (12/1/2016 to 12/15/2016)?

d. Which customer paid the largest amount using MasterCard this fiscal year-to-date?

• Question 4-2:

a. How many paychecks did Elizabeth Mason receive in November 2016?

b. Explain the difference between the nature of payroll checks and liability checks for payroll?

c. Which employee received the largest net paycheck every pay period in the current fiscal year?

• Question 4-4b:Rock Castle Construction – Print a list of vendor’s transactions and export thelist

a. Print a list of bills for the vendor Perry Windows & Doors for the current fiscal year to date using only four columns in the following order from left to right: Amount, Open Balance, Date, and Due Date. Sort the list by account balance, with the largest amount on top.

b. Export the list in part (a) to Excel using the Export Transactions menu item. After exporting to Excel, print a list of bills for Perry Windows & Doors with an invoice amount of $1,000 or

more. Except for the excluded bills, the columns and sorting should be the same as in Questions 4-4a. All headings should be in bold. The printout should include a description of the printout and the date.

• Question 4-5: Larry’s Landscaping & Garden Supply – Use drill down in cash receipts

Open the Customer Center: Received Payments list window. Drill down on Check No. 3250 dated 11/20/2016.

a. Who was the customer?

b. Were there any other sales to the customer in Question 4-5a that are currently unpaid? Explain.

c. What was the sales invoice number and date of the sale for the above collection?

d. What products or services were sold on the invoice?

e. Was a discount taken by the customer on this receipt?

•Question 4-6: Larry’s Landscaping & Garden Supply – Use drill down of employees

Open the Employees Center and use drill down to open the Edit Employee window for Shane Hamby.

a. What is his social security number?

b. What is his annual salary amount?

c. What is his filing status for federal taxes?

d. For the payment to Hamby on 6/16/2016, what was the amount of his total earnings and federal income tax withholding?

e. How much did Larry’s Landscaping & Garden Supply pay for his Federal unemployment for the pay period of 6/16/2016?

• Question 4-7: Larry’s Landscaping & Garden Supply – Use drill down of Chart of Accounts

a. Use drill down to determine the balance in the Bank of Anycity Loan account at 11/30/2016. What is the balance?

b. What were the total debits and credits for the 10/28/2016 transaction to that account?

• Report Requirement 4-1 (export the report to Excel and submit it, do not “print” thereport):

a. Print and hand in a standard profit and loss statement for Larry’s Landscaping & Garden Supply for this fiscal quarter to dsate (10/01/2016 to 12/15/2016) in two columns?

b. Print and hand in a standard profit and loss statement for Larry’s Landscaping & Garden Supply, by quarter for the last fiscal year. Each quarter and the total should be in separate columns

c. Which quarter was the most profitable for the company during the last fiscal year?