Accounting Assignment #5 (5%)
Financial Office Management (FOM) OADM28823
Instructions
Access your Super Sports Company QBO Student Account (Super Sports Company – Your Name)
Make sure you have completed QBO Assignment #4 before starting this assignment
QuickBooks Supplier Transactions
1. Import the Supplier list from SLATE (“Import Supplier List”)
a. 6 total suppliers will be imported into your account
2. Create the following NEW SUPPLIERS:
i. Supplier Display Name: Sporting Goods Warehouse
Contact Name: Kim Derby
E-mail: SGW@example.ca
Phone: 647-555-9248
Address: 400 Main St. Whitby, ON
ii. Supplier Display Name: ProTeam Temporary Employees
e-mail: Proteam@example.ca
Phone: 416-555-4972
Address: 2058 Fargo Drive Watford, ON.
iii. Supplier Display Name: Agatha’s Advertising
e-mail: agatha@example.ca
Phone: 613-555-4821
Address: 2349 Fairview St. Kanata, ON.
3. Your boss has asked to make some purchases for the business. Super Sports Company has
accounts with several suppliers, and you have been told that you can pay those suppliers
back within 30 days.
NOTE: Assume Exclusive of Tax plus HST (unless otherwise stated).
i. You purchased some Office Supplies from your supplier Kameron Veluza sent
on October 24 (10/24/2024). The cost of the supplies was $875.
Category – Office Expenses.
ii. You called Sporting Goods Warehouse to order some much needed supplies
for Super Sports Company October 27 (10/27/2024). The cost was $1035.75.
Category – Supplies.
iii. You placed an advertisement in the local newspaper on October 29
(10/29/2024). Agatha’s Advertising told you over the phone to reference Bill
Number AA-005. The cost was $775.00. Category – Advertising.
Page 1|4
Accounting Assignment #5 (5%)
Financial Office Management (FOM) OADM28823
4. Your boss has asked to make more purchases for the business, but this time she has asked
that you pay immediately (with either the company Debit or Credit Card).
NOTE: Add tax (HST) to each transaction amount unless otherwise stated and TD Bank
Account (this account was added in Assignment #4) as the payment account.
i. Bought office supplies at Staples (Add new Payee) for $85.89 on November
5, 2024 (11/05/204). Track office supply purchases to Office Expenses.
Debit.
ii. You bought more advertising from Agatha’s Advertising on November 5,
2024 (11/05/2024) for $75.00. Category – Advertising (do not add the Bill
from before). Debit.
i. Your store needed more basketballs. You bought $150.00 worth of
basketballs from Luna’s Basketball on November 7, 2024 (11/07/2024). Your
purchase was made on a new Credit Card (make sure the payment account is
your new credit card. HINT – You will need to create a new credit card
account named “Super Sports VISA”.)
Category – Purchases
5. Your boss has told you that your supplies of Yoga Mats is low, so you need to order more.
You visited Yoga Mat Central on November 1, 2024 (11/01/2024) and purchased $225.25
worth of Yoga Mats. Yoga Mat Central has told you you will need to pay within 15 days and
to reference Bill number is 2089.
Category – Purchases.
6. You are planning an event and needed to pay a deposit for a gym rental. You paid Central
Community Centre Rentals $75.00 on your new Credit Card on November 7, 2024
(11/07/2024).
Hint: Make sure to check both the Payment account and Payment method!
Category – Rent or lease payments
7. PAY the following two (2) bills in full on November 30, 2024 (11/30/2024). (Total should be
$1243.28) from your TD Bank Account.
a) Yoga Mat Central
b) Kameron Veluza
Page 2|4
Accounting Assignment #5 (5%)
Financial Office Management (FOM) OADM28823
Additional Company Activities in QuickBooks
8. Create a Custom Invoice using the ‘Custom Form Styles’ list. Name this custom style
“Super Sports Invoice”
Design:
Template Style: Modern
Colour: #7889a1 (blue-grey)
Font: Courier
Content:
Add the Phone number, address
Change the message to customers:
Thank you for supporting Super Sports Company. Having a sporting day!
Make this the default invoice.
9. Create a new Expenses sub-account under the ‘Advertising’ Parent company called “Radio
Advertisements”.
10. Inactivate the following accounts:
a. Miscellaneous
b. Job Materials
11. Merge the accounts “Travel” and “Travel Meals” – your merged account should be named
“Travel” (note – the Travel Account is the detail type “Travel”).
12. Your customer Kevin Johnson now works for Duran Lawrence at ‘Sports for Seniors”. Merge
the two accounts (so that only the Duran Lawrence customer is active).
13. Your customer Duran Lawrence placed an order on December 1, 2024 (12/01/2024) for a
monthly yoga pass. He will pay within Net 30 days, + HST (Amounts are exclusive of Tax).
Note: The message on your invoice should be the one you created in Step 8!
14. You ordered Radio Advertisements from Agatha’s Advertising with the company’s new credit
card:
Date – 12/03/2024
Payment Account: Super Sports VISA
Payment Method – Credit Card
Category- Radio Advertisements (make sure to use the sub-account).
Amount: $175.00 + HST
Page 3|4
Accounting Assignment #5 (5%)
Financial Office Management (FOM) OADM28823
15. REPORTS (switch to Classic View if necessary):
i. Run an “Accounts Payable Aging Summary” (1 mark)
Run the Report for the “Custom Dates” as of 12/03/2024
Export the report to PDF → upload your file to SLATE
ii. Run a “Transaction List by Supplier” for all dates (3 marks)
Run the Report for the “Custom Dates” from 10/01/2024 to 12/03/2024
Group the Report by “Supplier”.
Export the report to PDF → upload your file to SLATE
iii. Go to the ‘Custom Form Styles Section’ and select your Default Invoice (Super
Sports Invoice”
Click on “Preview PDF”
Save your PDF → Upload your file to SLATE
Your final submission for assignment #5:
i. Accounts Payable Aging Summary Report
ii. Transaction List by Supplier Report
iii. Custom (default) Invoice
Page 4|4
