From the Vendor Center, export to Excel the Vendor List
Add the following items. Click Next after entering each item.
Item Type Service
Item Name Rug Cleaning
Description Rug Cleaning
Account 47900 – Sales
Item Type Service
Item Name 3x5 Rug Cleaning
Subitem of Rug Cleaning
Description 3x5 Rug Cleaning
Rate 63.00
Account 47900 – Sales
Item Type Service
Item Name 5x7 Rug Cleaning
Subitem of Rug Cleaning
Description 5x7 Rug Cleaning
Rate 81.00
Account 47900 – Sales
Item Type Service
Item Name 8x10 Rug Cleaning
Subitem of Rug Cleaning
Description 8x10 Rug Cleaning
Rate 153.00
Account 47900 – Sales
Export to Excel or print the Item List as of January 1, 2023. (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