Skip to main content

Connecting QuickBooks: Setting Up Expense Mapping

How to create an Expense account in QuickBooks Online and map it in Easy Truck Shop's QuickBooks integration.

Written by Vladimir

Expense accounts must exist in your QuickBooks Chart of Accounts before they can be mapped to Easy Truck Shop during account mapping or sync. This article covers both halves: creating the account in QuickBooks, then pointing Easy Truck Shop at it.

Part 1: Create the expense account in QuickBooks

Learn more from the official QuickBooks guide: Chart of accounts in QuickBooks Online

  1. From the left navigation menu, click Accounting.

  2. Select Chart of Accounts.

  3. Click New.

  4. Set the Account Type to Expenses.

  5. Choose the appropriate Detail Type.

  6. Enter an Account Name.

  7. (Optional) Add a description or account number.

  8. Click Save and Close.

Once created, return to Easy Truck Shop and map the new account, or re-sync your QuickBooks data if needed so it's available for use.

Creating a new Expenses account in the QuickBooks Online Chart of Accounts

Part 2: Where expense accounts are mapped in Easy Truck Shop

Expense mapping is now in two places, and which one you need depends on what you are mapping.

This table shows where each kind of purchase-order cost is mapped.

What you are mapping

Where to set it

Parts on a purchase order

Settings → Integrations → QuickBooks → Expense Mapping → Ordered Parts

Everything that is not a part — freight, taxes, fees, office supplies

Settings → Part Settings → Expense Products

The Expense Mapping screen

Go to Settings → Integrations → QuickBooks and scroll to Expense Mapping. It holds a single account, Ordered Parts, which every part on every purchase order posts to.

In the picture below: 1 = the Ordered Parts account. 2 = the note saying fees added when receiving orders are mapped through Expense Products, with a link straight to that page.

The Expense Mapping section of the QuickBooks integration settings, showing a single Ordered Parts account and a note linking to Expense Products

If you remember a longer list of fee types on this screen, that is why it is shorter now. Each fee type became an expense product with its own QuickBooks account, and your existing mappings were carried across — nothing was lost.

Mapping everything else: Expense Products

Go to Settings → Part Settings → Expense Products. Each row is a non-part cost you can put on a purchase order, mapped to the QuickBooks account it should post to.

In the picture below: 1 = the Expense Products tab. 2 = the Add Expense Product button. 3 = the QuickBooks account each expense product posts to.

The Expense Products page under Settings, Part Settings, listing expense products with the QuickBooks account each one is mapped to

Click any row to change its account. The change applies to purchase orders you receive from then on — bills already in QuickBooks keep the account they were sent with.

Common questions about expense mapping

  • My new QuickBooks account does not appear in Easy Truck Shop. Re-sync your QuickBooks data, then reopen the page. The account picker reads your live chart of accounts.

  • Can I map to a Cost of Goods Sold account instead of an Expense account? Yes. The picker shows the account type beside each result — Expense, Other Expense and Cost of Goods Sold can all be used.

  • Where did the old fee-type mappings go? They are expense products now, at Settings → Part Settings → Expense Products, each keeping the account it already had.


Related Articles

Did this answer your question?