Skip to content

Account Mappings (QuickBooks)

Account Mappings control how each VMX category — sales-tax codes, payment tenders, departments, consignment sections, gift-card types — maps to a QuickBooks income or expense account.

The Account Mappings editor is set up per-store by VMX. If you don't see an Account Mappings section on the Admin → Configuration → Accounting tab, your store's accounting is managed a different way — contact help@vmxllc.com.

Common error: "Unmapped account for Line X"

If the nightly daily-sales push fails with this error, it means VMX tried to send a transaction line whose category doesn't have a QB account assigned yet. Common causes:

  • A new department added in VMX without a matching QB income account
  • A new tender type (gift card type, payment method) without a QB account
  • A tax category that isn't mapped
  • A consignment section missing its QB accounts (consignment cost-of-goods and consignment liability)

How to fix it

  1. Go to Admin → Configuration → Accounting tab.
  2. Scroll past the Books Closed Before field — you'll see the Account Mappings section.
  3. Find the unmapped category (the error message names the line; you can also type a keyword in the Filter mappings... box to narrow the list — e.g. type BIRD to see only bird-related mappings).
  4. Click the pencil icon on the row to open the Edit Mapping window and set its Output Account, Department, Priority, etc.
  5. Click Save.
  6. Contact VMX (help@vmxllc.com) to re-push the failed day to QuickBooks. Once we've re-pushed, the error clears.

Adding something new? Map it before its first sale

The most common cause of the "Unmapped account" failure is not a broken mapping — it's something new being used for the first time without a mapping ever having existed:

  • a new department (or sub-department) makes its first sale or receives its first purchase order
  • a new tender type is added at the register and takes its first payment
  • a new payment method goes live on your website (a new processor, or online payments turned on for the first time)
  • a new store location opens

Each of these needs a QuickBooks account mapping before the first transaction touches it — otherwise the daily journal entry fails on the first day it appears, and keeps failing every day until it's mapped. When you're about to add a department, tender, or payment method, set up its mapping at the same time (or email help@vmxllc.com and we'll wire it up with you). A minute of setup beforehand saves a stretch of failed journal entries afterward.

Editor reference

The Account Mappings editor shows your store's mappings grouped by type (sales_income, cogs, inventory, etc.). Click a group to expand it.

  • View — click any group header to expand the rows under it
  • Filter — type in the Filter mappings... box to instantly narrow down
  • Edit — click the pencil icon on a row to change its Output Account, Department, Priority, etc.
  • Add — click the green Add Mapping button to create a new mapping
  • Delete — click the trash icon (asks for confirmation before deleting)

Accounting Self-Serve panel (advanced)

Below the Account Mappings section on the same Admin → Configuration → Accounting tab is the Accounting Self-Serve (config-driven) panel — an advanced tool for taking direct, versioned control of your accounting setup (account mappings, line granularity, QuickBooks classes, and posting strategy), with validation and replay checks on every save and instant rollback. See Accounting Self-Serve (config-driven accounting).

Note: if the account-mappings layer in the Accounting Self-Serve panel shows the green config-driven badge, that saved value takes precedence — the rows in the Account Mappings table no longer drive the nightly journal entry until that layer is cleared back to code fallback. If you're unsure which tool is live for your store, contact help@vmxllc.com.