Configure accounting data mapping
Mapping tells Zenoti which record in the accounting provider receives each kind of posting: which location a center posts to, which account a payment type settles into, which account an item type is booked to, which tax rate a Zenoti tax group corresponds to, and which supplier a Zenoti vendor is. The mapping lives in five panels of the Accounting accordion. Complete them before enabling the posting jobs.
On this page
- Before you begin
- Mapping overview
- Map centers to locations
- Map custom fields
- Map payment types
- Map item types to accounts
- Map tax rates
- Map suppliers
- Choose how customers are posted
- Failure path (mapping)
- Related articles
Before you begin
Permission: You need organization administrator access to configure accounting data mapping.
- The provider must be chosen, saved, and authorized, and the master data pulled at least once from Manual Sync. Mapping drop-downs list only records Zenoti has already pulled from the provider. See Connect an accounting provider.
- Every target record must already exist in the provider. Zenoti does not create accounts, tax rates, locations, or suppliers.
Mapping overview
| Panel | Zenoti side | Provider side | Needed before |
|---|---|---|---|
| Locations | Center | Location, tracking category, department, or class, depending on the provider | Any posting when multi-location posting is on |
| Fields | Custom field | Provider custom field | Posting custom values on documents |
| Payments Mapping | Payment type | Payment method and payment account, with optional department, class, and custom fields | Post Payments, Post Sales & Refunds |
| Payments Mapping (Item Mapping grid) | Item type | Chart of account, plus inventory and expense accounts for stock items | Post Sales & Refunds, inventory jobs |
| Tax Rates Mapping | Tax group | Tax rate | Any posting that carries tax |
| Supplier Mapping | Vendor | Supplier | Post Inventory Orders |
If a mapped record is later deleted in the provider, the row is highlighted and its tooltip asks you to update the highlighted field. Posting for that row fails until you re-map it.
Map centers to locations
- Navigate to Configuration > Integrations > Integration settings, expand Accounting, and open Locations.
- The grid lists every center with Center Code, Center Name, Mapped Location, Mapped Location in (the provider), and Active.
- For each center, choose the provider location. Turn on Active for centers that should post.
- Select Save. Zenoti confirms with
Centers mapping saved succcessfully.
Multi Location is a switch in Configuration. Turning it on requires this mapping; turning it off deletes the existing location mapping, and Zenoti asks you to confirm before it does.
Map custom fields
- Open Fields.
- The grid lists the provider's custom fields with their internal and display names, header, order, and an active switch.
- Turn on the fields Zenoti should populate and set their order.
- Select Save.
Map payment types
Open Payments Mapping.
Create a Payment Header first if the provider needs one: enter it (
Enter The New Payment Header) and select Add. The header groups the payment rows that follow.For each row, complete the fields.
Field What to enter Department / Class Optional dimensions on the posting, where the provider supports them. Mapped Account in The provider whose account you are choosing. Chart of Account (required) The bank, clearing, or undeposited-funds account that receives this payment type. Custom Field 1 to Custom Field 5 Optional custom values the provider expects. Zenoti's payment types are listed by Payment Type and Description; for each, choose the Mapped Payment Method in the provider and the payment account. Card payments can be grouped by card brand, and digital payment fees, card surcharge tax, and custom payment deposits have their own rows.
Select Save.
Map card processors that settle in batches to a clearing account rather than straight to the bank so the bank feed can be reconciled against the processor payout.
Map item types to accounts
The Item Mapping grid sits in the Payments Mapping panel below the payment rows.
- For each Zenoti Item Type and Item Name (services, products, memberships, packages, gift cards, prepaid cards, classes, and the default items you named in Configuration), choose the Mapped Item Type and the income account under Chart of Account.
- For stock items, also choose the Inventory Account and the Expense Account (cost of goods sold).
- Select Save. Zenoti confirms with
Successfully Updated the items mapping.
Posting stops with Please correct the mapping of accounts in itemtype mapping when a row is missing an account.
Map tax rates
- Open Tax Rates Mapping.
- Each row pairs a Tax Group (Zenoti) with the provider's Tax Rates. Select Add for a new row, then choose the tax group and the matching rate.
- Select Save.
Zenoti tax groups must be mapped before any posting job that carries tax runs. For Xero organizations in VAT regions, see Configure Xero VAT mapping.
Map suppliers
Needed only when inventory documents are posted.
- Open Supplier Mapping.
- Select Add, choose the vendor under Vendors (Zenoti), and choose the matching provider supplier under Suppliers.
- Select Save.
Create the supplier in the provider first; the drop-down lists only suppliers pulled by the vendors row in Manual Sync.
Choose how customers are posted
Customer posting is the Customer option in Configuration, not a mapping grid. You choose Invoice Guest, so that the provider holds a customer record per guest, or Default, a single default customer you name. Pick one model before the first posting run; switching later means the provider holds two generations of customer records.
Failure path (mapping)
| Symptom | Cause | Resolution |
|---|---|---|
| Drop-downs are empty | Master data has not been pulled since the provider was authorized. | Run Get on the relevant rows in Manual Sync, then reopen the panel. |
| A row is highlighted with a tooltip that the record was deleted from the provider | The mapped account, class, department, location, tax rate, or payment account no longer exists in the provider. | Choose a live record and select Save. |
This item has been deleted in Zenoti. Please update or remove this mapping. |
The Zenoti item in the item-type grid was deleted. | Re-point or remove the row. |
Please enable multi-locations and map the locations to post Invoices |
Posting requires locations but Multi Location is off or the mapping is incomplete. | Turn on Multi Location in Configuration and complete Locations. |
Cannot turn on multi location when posting as journal entry for Codat |
Journal posting and multi-location are mutually exclusive on Codat connections. | Choose one model in Configuration. |
Change of mapping will reset all the existing mappings. Do you want to continue? |
You changed the mapping type. | Continue only if you intend to redo every row. |
Please correct the mapping of accounts in itemtype mapping |
An item type has no account. | Complete the item-type grid. |