Add the following items.
Item Type Inventory Part
Item Name Bluetooth Earpiece
Description Bluetooth Earpiece
Cost 6.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 29.00
Income Account 46000 – Merchandise Sales
Preferred Vendor Sofia Rafael Associates
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
Item Type Inventory Part
Item Name Smartphone Case
Description Smartphone Case
Cost 8.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 42.00
Income Account 46000 – Merchandise Sales
Preferred Vendor Sofia Rafael Associates
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
Item Type Inventory Part
Item Name Portable Speaker
Description Portable Speaker
Cost 30.00
COGS Account 50000 – Cost of Goods Sold
Sales Price 120.00
Income Account 46000 – Merchandise Sales
Preferred Vendor Sofia Rafael Associates
Asset Account 12100 – Inventory Asset
Tax Tax
Qty on Hand 0 as of 01/01/2024
From the Item List, enter the 9.75% sales tax rate as follows:
Double-click on State Tax in the Item List
Enter Tax Rate: 9.75%
Enter Tax Agency: California State Board of Equalization
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:
Uncheck Space between columns
Check Row height
Uncheck Include QuickBooks Export Guide worksheet with helpful advice
Select On printed report and screen