Working with suppliers | Accounting homework help
Assignment # 4 – Working with Suppliers [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 2: Using accounting software, create a computerized accounting system for a new company.
CLR 3: Using accounting software, record all transactions in the accounting cycle.
Objective of this Assignment:
The objective of this assignment is to enter a suppliers list and record accounts payable.
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 5 Reinforce Your Skills exercises and
· the Chapter 5 Apply Your Skills exercises.
Pre-Assignment Instructions:
1. To prepare you for this assignment, please read the content in Chapter 5 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 5 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. Transaction List by Date June 2026 (from Apply Your Skills 5-2)
2. AP July 15
3. Supplier Balance Summary
4. Profit and Loss Detail
5. Balance Sheet
Do NOT submit the reports from the Reinforce Your Skills exercises.
Save file as:
D5 Beautiful Blooms Floral Co Report Name – Student Name
Scoring Rubric – Assignment #4 [5%]
ITEM
REQUIREMENTS
MARK
Transaction List by Date June 2026
– Heading is complete with company name, name of report and date centered at the top three lines
– All required journal entries are included (corrections are excluded)
– All expenses are in the debit column
– All revenues are in the credit column
– Both columns are totaled
– Totals are equal
– Totals have a single line above and double line under
/10
Accounts Payable July 15
– Heading is complete with company name, name of report and date centered at the top three lines
– Report is aged
– Report is a summary
– All vendors included
– The correct number of vendors included
– The correct balance is included
/5
Supplier Balance Summary
– Heading is complete with company name, name of report and date centered at the top three lines
– Correct report submitted
– All required information is included
– All account Descriptions are included
– All account balances are included and correct
/5
Profit and Loss Detail
– Heading is complete with company name, name of report and date 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
– Both columns are totaled
– Totals are equal
– Total have a single line above and double line under
/5
Balance Sheet
– Heading is complete with company name, name of report and date centered at the top three lines
– All accounts with balances are listed with account numbers
– All assets are in the debit column
– All liabilities and capital are in the credit column
– Both columns are totaled
– Totals are equal
– 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
/35