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.

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.