Overview
After creating chargeable materials and equipment in QuickBooks Online, map your Items and Pricing items to the correct QuickBooks Online GL account.
Mapping your Items and Pricing 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 Items and Pricing items to the corresponding GL accounts in QuickBooks Online.
Note: In the QuickBooks Online integration, some fields and settings use the term Pricebook. These refer to the items in your Items and Pricing list.
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: Create classes in QuickBooks Online
After mapping your Items and Pricing 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.