Overview
After creating a QuickBooks Desktop backup file, map your Items and Pricing items to GL accounts. Mapping your Items and Pricing 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 Items and Pricing 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 Items and Pricing items to a QuickBooks general ledger account
Go to the navigation bar and click Items and Pricing.
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 Items and Pricing items using the Items and Pricing Excel Template
Export your Items and Pricing list (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 Items and Pricing items to a QuickBooks sub-account
After mapping your Items and Pricing items to a QuickBooks GL accounts, you can map Items and Pricing items to QuickBooks sub-account, if applicable. For more, see QBD Onboarding Step 4: Map Items and Pricing 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.