Skip to main content
GL mapping is the core of the accounting integration, and the part worth spending setup time on. You do it once, and Vori reuses it for every daily entry and every invoice after that. It works the same way whether you’re connected to QuickBooks Online, QuickBooks Desktop, or Xero. Vori pulls your chart of accounts directly from your accounting system and lets you map those accounts to your Vori data. You’re creating the relationship between what something is called in Vori and the account it belongs to in your books, so you never type an account number from memory.
The store, bookkeeper, or accountant knows these relationships. Vori’s job is to show them where to make each one. If you’re not sure where a line should map, ask whoever closes your books.
Vori refreshes your chart of accounts nightly, so new and renamed accounts are ready to map the next day. You can also refresh on demand from Integrations → Accounting Sync. Mappings are managed under Accounting → GL Account Mapping. There are three types to configure: general accounts, department accounts, and segments. Each has its own tab: General Accounts, Department Accounts, and Banner Settings.

​
General accounts

Store-level items that don’t belong to any single department, grouped by type: These mappings feed the daily sales journal entry.

​
Department accounts

Every parent department in your store can be mapped to up to four account types: A few important notes:
  • All four are optional. A store that only wants revenue-level detail maps Sales. If you want live department margin tracking and perpetual inventory, map all four.
  • COGS and Inventory go together. Because they’re two sides of the same movement, Vori needs both mapped to post either one. Mapping both is what lets your accounting system show department margin without extra work at period end.
  • Returns is for shopper refunds only. It posts each department’s POS refund total on the daily sales journal entry and in the daily export. Vendor bills, vendor credits, and returns to a vendor don’t use it. If a department has refunds and no Returns account, the daily entry stops and lists that department as unmapped.
  • Multiple Vori departments can share one account. Many stores have departments that are more granular than their accounting structure. Map those Vori departments to the same account and their activity rolls up together.
Department accounts drive both the daily journal entry and the invoice bills, so purchases and sales settle against the same accounts.
Department Accounts grid showing the Sales Code and Returns Code columns

​
Segments

If you run several stores out of one accounting company, Vori tags every line it posts with that store’s segment value, so you can filter reports by store. That includes each line of an invoice bill and each line of the daily journal entry. Assign these under Accounting → GL Account Mapping. What the segment is called depends on your system: A segment value must match one that already exists in your accounting system, or the line posts untagged. Single-store operators generally don’t need this.

​
Set the class for QuickBooks Desktop

Vori reads your class list from QuickBooks Desktop along with your chart of accounts. To tag a store’s bills and daily entries with a class:
  1. Go to Accounting → GL Account Mapping and open the Banner Settings tab.
  2. On the Segment 1 card, Maps to reads Class in QuickBooks Desktop. In Export column header, type a name, such as Class, then click outside the box to save. The store rows unlock once this has a value.
  3. In each store’s row, open the dropdown and choose the store’s class.
Segment 1 card with Export column header set to Class and a store's class dropdown open
Vori saves the class as soon as you choose it. Invoices you approve after that carry the class on every bill line. Bills that already posted keep their original lines, so set their class in QuickBooks Desktop.
Don’t see your class in the dropdown? Add it in QuickBooks Desktop. Vori picks it up with the nightly chart of accounts refresh, or refresh on demand from Integrations.
If a store’s segment value matches nothing in your accounting system, the entry still posts, but that store’s lines are untagged. Vori flags the mismatch in GL Account Mapping so you can fix it.