Overview
After creating chargeable materials and equipment in QuickBooks Online, map your pricebook items to the correct QuickBooks Online GL account.
Mapping your pricebook items to the proper GL accounts is important to gain accurate financial performance of your business. Follow the steps outlined in these workflows to map your pricebook items to the corresponding GL accounts in QuickBooks Online.
Who uses this feature
Administrators, office employees, managers, accountants, and bookkeepers
Applies to all business types
Applies to all trades
Feature configuration
Account configuration is required to use this feature. Please contact Technical Support for details.
Map pricebook items to a QuickBooks general ledger account
Go to the navigation bar and click Pricebook.
In the side menu, select the Services, Equipment, or Material for the item you want to map. The item table opens.
In the General Ledger Account field, add the income account associated with the item. You should enter only the name of the QuickBooks income account. You do not need to include the account number.
When you're done, click Save.
Map multiple Pricebook items using the Pricebook Excel Template
Export your pricebook (Settings > Import / Export Data).
Open the exported file in a spreadsheet application.
Enter the sub-account name in the Account column. Enter the name in this format: Parent Account Name:Sub-account Name. For example, if map a service item to a Sales sub-account called HVAC, enter Sales:HVAC in the account field.
When you’re done, save the spreadsheet file and import it back into (Settings > Import / Export Data).
Next step: Create classes in QuickBooks Online
After mapping your pricebook items to QuickBooks GL accounts, create classes in QuickBooks Online to categorize your transactions within your income accounts. For more, see QBO Onboarding Step 7: Create classes in QuickBooks Online.