Using accounting software, identify and use the basic features, modules, and aids to produce reliable and accurate financial information.

Assignment # 3 – Working with Customers [5%]
This assignment relates to the following Course Learning Requirements:
CLR 1: Using accounting software, identify and use the basic features, modules, and aids to produce reliable and accurate financial information.
CLR 3: Using accounting software, record all transactions in the accounting cycle.
CLR 5: Using accounting software, produce and export management reports and financial statements.

Objective of this Assignment:
The objective of this assignment is to enter a customer list and record accounts receivable.
Assignment Scenario:
Beautiful Blooms Floral Company is a relatively new and growing business that is switching its bookkeeping to QuickBooks Online. As their bookkeeper, in this assignment, you will enter the required start-up information by following the steps in
• the Chapter 4 Reinforce Your Skills exercises and
• the Chapter 4 Apply Your Skills exercises.
Pre-Assignment Instructions:
1. To prepare you for this assignment, please read the content in Chapter 4 and follow the embedded learning activities (the Develop Your Skills exercises).

To follow along with the examples in the text before doing the assignment:
a. Use the QuickBooks Online sample company to follow along with the practice Develop Your Skills exercises in the textbook. See Module 3 for more information about the QuickBooks Online sample company.
b. Remember that the sample company will refresh after a couple of hours of inactivity, so it is best to complete all the practice exercises in one session. You do not need to submit these practice reports. All exercises using the sample company are ungraded.
Assignment Tasks:
1. Open the QuickBooks Online application software.
2. Use the chapter steps to complete the Chapter 4 Reinforce and Apply Your Skills exercises. Enter each transaction based on the information provided.
3. Follow the steps in the Apply Your Skills exercises to export each report to Excel. You will only be submitting reports from the Apply Your Skills exercises. You do NOT need to submit the reports saved from the Reinforce Your Skills exercises.
4. In order to submit your assignment into one excel workbook, you will need to cut and paste each report into ONE excel workbook.
5. Check to ensure that the asset and expense accounts have the correct debit balances.
6. Check to ensure that revenue and liabilities account have the correct credit balances.

Submissions:
You should be submitting ONE Excel file that contains one worksheet for each of the following reports (from the Apply Your Skills exercises):

1. Estimates and Progress Invoicing (from Apply Your Skills 4-1)
2. Unbilled Charges 1
3. Open Invoices
4. Unbilled Charges 2
5. Sales by Customer Summary (from Apply Your Skills 4-3)
6. Profit and Loss

Do NOT submit the reports from the Reinforce Your Skills exercises.

Save file as:
D4 Beautiful Blooms Floral Co Report Name – Student Name

Scoring Rubric – Assignment #3 [5%]

ITEM REQUIREMENTS MARK
Estimates and Progress Invoicing – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– All required information included
– All totals are correct /10
Unbilled Charges 1 – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– All required information included
– All totals are correct /5
Open Invoices – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– Correct report submitted
– The invoices include the correct information
– All required information is included
– All required columns are included /10
Unbilled Charges 2 – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– All required information included
– All totals are correct /5
Sales by Customer Summary – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– Report is a summary
– All customers included
– The correct number of customers included
– The correct balance is included /10
Profit and Loss – Heading is complete with company name, name of report and date (as applicable) centered at the top three lines
– All accounts with balances are listed with account numbers
– All expenses are in the debit column
– All revenues are in the credit column
– Total have a single line above and double line under /5
Format – Assignment submitted in Excel Format
– All reports included in ONE workbook
– All required reports included
– All reports are correct
– Consistent format through workbook /5
TOTAL /50