Add the following items.
Item Type Inventory Part
Item Name Basic Floral Kit
Description Basic Floral Kit
Cost 10.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 60.00
Income Account 46000 – Merchandise Sales
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
Item Type Inventory Part
Item Name Deluxe Floral Kit
Description Deluxe Floral Kit
Cost 20.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 100.00
Income Account 46000 – Merchandise Sales
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
Item Type Inventory Part
Item Name Roses (per dozen)
Description Roses (per dozen)
Cost 15.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 75.00
Income Account 46000 – Merchandise Sales
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
Item Type Service
Item Name Floral Design
Description Floral Design
Income Account 48600 – Service Sales
Item Type Service
Item Name Wedding Designs
Description Wedding Designs
Subitem of Floral Design
Rate 200.00
Income Account 48600 – Service Sales
Item Type Service
Item Name Funeral Designs
Description Funeral Designs
Subitem of Floral Design
Rate 100.00
Income Account 48600 – Service Sales
From the Item List, enter the 7.75% sales tax rate as follows:
1. Double-click on State Tax in the Item List
2. Enter Tax Rate: 9.75%
3. Enter Tax Agency: California State Board of Equalization
4. Click OK
Export to Excel or print the Item List as of January 1, 2024. (Use Report Center > List > Item Listing.) When exporting to Excel, remember to select Advanced Excel Options:
1. Uncheck Space between columns
2. Check Row height
3. Uncheck Include QuickBooks Export Guide worksheet with helpful advice
4. Select On printed report and screen