Before You Begin

You will continue to use your student trial account for Beautiful Blooms Floral Co., creating a special project for the 2026 Fall/Winter Expo that Melanie's company will be participating in. In this project you will use almost every task you have learned throughout this course, from adding customers to running financial reports and payroll.

REMEMBER THESE POINTS

Things to remember for the entirety of the project, unless stated otherwise:

The date format is dd/MM/yyyy. All Customer (Sales) transaction amounts are exclusive of tax, with HST ON added (Invoice, Sales Receipt, Estimate, etc.). All Supplier (Expense) transaction amounts are inclusive of tax, with HST ON included (Expense, Cheque, Bill, Purchase Order, etc.). If not provided, leave Terms as Net 15 for bills. For payments and sales receipts, Deposit to: Undeposited Funds, unless otherwise instructed.

The project MUST be added to every transaction properly to track to the project, for example: Record sales transactions to the Project as the customer. Connect all Expense form line items to the project, but don't make them billable.

NOTE!

Always click Switch to Classic View when it is an option on any report before running and exporting. You will not be reminded to do so throughout this project chapter. If you are asked to run a report for all dates and the option to select All Dates is missing, make sure you have switched to the classic view.

Project Setup

Before you begin with all the tasks, you must first set up the project and other list items. This project is created within your current Beautiful Blooms Floral Co. student trial account. Feel free to review the section on Projects earlier in the textbook prior to starting.

1. From the Projects centre, use the New Project button to set up the Expo project:

• Name: 2026 Fall/Winter Expo
• Customer: Beautiful Blooms
• Notes: 2026 Expo - Nov to Dec

1. Add these accounts to the Chart of Accounts:

Name	Account Type	Detail Type
Event Workshops	Income	Other Primary Income
DIY Products	Income	Sales of Product Income
Holiday Plants and Products	Income	Sales of Product Income
Equipment Rental	Cost of Goods Sold	Equipment rental - COS
Merchant Service Fees	Cost of Goods Sold	Other costs of service - COS
Holiday Plants and Supplies	Cost of Goods Sold	Supplies and materials - COS
DIY Kits	Cost of Goods Sold	Supplies and materials - COS

1. Open the Products and Services list and add two new categories: Christmas and DIY Products
2. Add the custom non-inventory items and services by importing the CH11 Products and Services - Expo.xlsx file from your Chapter 11 folder.

Don't forget to match the Tax on Sales mapping. If in the review section the QTY column is showing red around the 0 values, simply click each. This will turn them black before you click Import. You should have five items successfully imported. Click X to close if the form does not close after confirmation and select Yes.

1. In the Products and Services list, bulk select all the items you just added as non-inventory (except Expo DIY Workshops) and from the Assign Category menu, choose Christmas. Categorize the workshop to DIY Products.
2. Add these inventory items.

For all items, Initial quantity on hand: 0. As of date: 01/09/2026. Tax on sales and purchases: HST ON. Inventory Asset Account: Inventory Asset.

Name	Sales Description	Rate	IncomeAccount	Purchase Cost	Expense Account	Category
Poinsettia Plant	Poinsettia Plant	35	Holiday Plants and Products	25	HolidayPlants and Supplies	Christmas
Christmas Cactus	Christmas Cactus	25	Holiday Plants and Products	17.75	HolidayPlants and Supplies	Christmas
Wreath - Evergreen	Wreath - Evergreen	35	Holiday Plants and Products	25	HolidayPlants and Supplies	Christmas
Wreath - Dried	Wreath - Dried	30	Holiday Plants and Products	21	HolidayPlants and Supplies	Christmas
Christmas Vase	Christmas Vase	15	Holiday Plants and Products	10	Decor and Cards - COGS	Christmas
Flower Press Kit (Kids)	Flower Press Kit (Kids)	27	DIY Products	19.25	DIY Kits	DIY Products
DIY Take Home Wreath Kit	DIY Take Home Wreath Kit	35	DIY Products	25	DIY Kits	DIY Products

Prepare Your DeliverablesSet 1QG

To complete this segment of the project, prepare these deliverables, exporting each to Excel and keeping in mind the Quick Grader file format requirement:

• Chart of Accounts, saved as: CH11 Chart of Accounts
• Products and Services list, saved as: CH11 Products and Services
• Balance Sheet for All Dates, saved as: CH11 Balance Sheet - Start
• Profit and Loss for All Dates, saved as: CH11 Profit and Loss - Start

CHECK FIGURE To ensure you are starting with the correct figures, run your Trial Balance report (All Dates) and verify that your figures match these (a negative number means the amount is contra to what it would be; DR vs CR):

Account	Balance
TD Operating Account	$10,638.25
TD Savings	$1,504.50
Undeposited Funds	$1,678.05
Accounts Receivable (A/R)	$3,813.75
Accounts Payable (A/P)	$537.03
TD VISA	$1,300.27
GST/HST Payable	$-821.24