Overview
After creating a QuickBooks Desktop backup file, map your pricebook items to GL accounts. Mapping your pricebook items to GL accounts is important for generating financial reports that show accurate financial performance of the business. These articles provide instructions on how to map your pricebook items to the corresponding GL accounts in QuickBooks Desktop.
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: Map pricebook items to a QuickBooks sub-account
After mapping your pricebook items to a QuickBooks GL accounts, you can map pricebook items to QuickBooks sub-account, if applicable. For more, see QBD Onboarding Step 4: Map pricebook items to a QuickBooks sub-account.
If you are not using QuickBooks sub-account, you can skip setting up payment types for QuickBooks. For more, see QBD Onboarding Step 5: Set up payment types for QuickBooks.