Xero Commission Integration: How It Actually Works

Negative Space via Pexels

"Integrates with Xero" is on every commission tool's website. It means very different things depending on the vendor, and the difference is the number of hours your finance team spends hand-patching figures every month. The useful question isn't whether the tool talks to Xero's API or produces a file. It's whether finance has to rebuild anything: a generic spreadsheet they reshape and map by hand every month, or output in Xero's own format, one line per employee, that goes straight in.

This is what to actually expect, and what to interrogate a vendor on, if you run UK finance on Xero.

TL;DR

A Xero commission integration moves calculated commission from the commission tool into Xero in a payroll-ready form. In practice that's one of two postings: a manual journal, or an accounts-payable bill — Xero treats an approved bill as a journal under the hood, so it's the same data presented differently (Xero). A good integration maps commission to the correct expense and liability accounts, applies a tracking category so you can see spend by team or region, and reconciles cleanly against what's actually paid through payroll. Xero doesn't calculate commission and doesn't decide tax — your commission tool calculates, Xero records, and Xero Payroll (or your bureau) runs PAYE and NICs.

The question isn't API or file. It's whether finance has to rebuild anything before it goes into Xero.

What does a Xero commission integration actually do?

A Xero commission integration takes the commission your tool has calculated and gets it into Xero so finance doesn't re-key anything. Four different things are sold under the same word, and only one of them leaves the work with finance:

Manual journals and bills are both legitimate; Xero itself notes that an approved A/P invoice produces a resulting journal, so the two are "the same data presented in an easier way" for Xero users (Xero developer). The generic CSV is the one to be wary of: it's the manual bridge the integration was supposed to remove. A file already in Xero's format is a different thing, because nothing has to be retyped or remapped.

How does commission map to accounts and tracking in Xero?

Two configuration questions decide whether the integration is genuinely useful.

First, account mapping. Commission expense and the corresponding liability need to hit the right ledger accounts so your P&L and balance sheet are correct without a finance person reclassifying. Ask the vendor whether account codes are configurable per plan or hard-coded.

Second, tracking categories. Xero lets an organisation run up to two active tracking categories (Xero developer), and they're how you slice commission spend by team, region or cost centre without separate accounts for each. A strong integration applies the right tracking category automatically when it posts; a weak one posts a single undifferentiated lump you then split by hand.

Where does payroll fit — does Xero run PAYE on commission?

This is the most common confusion. The commission integration records the cost in Xero's accounting ledger; it doesn't pay anyone. The actual pay — and the PAYE and National Insurance on it — runs through your payroll, whether that's Xero Payroll or a separate bureau. Xero Payroll supports tracking categories so payroll expense can be split the same way (Xero Central).

Commission is earnings, taxed under PAYE and Class 1 NICs in the period it's paid, per HMRC's employer guide. So three systems each do one job: the commission tool calculates, Xero records the accounting, and payroll deducts tax. A good integration makes the handoffs clean; it doesn't collapse them into one. For the period-recognition side of the accounting, see our note on commission accounting under FRS 102, and for the non-cash incentive trap, P11D and commission reporting.

What to ask a vendor about their Xero integration

If you run on Xero, these five questions separate a real integration from a brochure claim:

• Does it post through Xero's API, or produce a file in Xero's own import format? Either can work. A generic CSV you have to reshape yourself can't.
• Are the expense and liability account codes configurable, and per plan?
• Does it apply a Xero tracking category automatically, and can I choose which?
• Does it reconcile against what payroll actually paid, or just post a number? (Our reconciliation guide is the test.)
• Does it handle the pensionable portion correctly, given commission is qualifying earnings? See commission and pension auto-enrolment.

Many US-built tools default to QuickBooks or NetSuite and bolt Xero on later. That's worth knowing before you sign: it usually shows up as a generic CSV rather than anything shaped for Xero. Our buyer's guide covers how to spot a US product wearing a UK skin.

Frequently Asked Questions

Does Xero calculate sales commission?

No. Xero is accounting (and, with Xero Payroll, payroll) software — it records and pays, but it doesn't calculate commission against your plan's tiers, splits, accelerators or clawbacks. That calculation is what dedicated commission software does; the integration then posts the result into Xero.

Should commission post to Xero as a journal or a bill?

Either works, and Xero treats an approved bill as a journal internally. A manual journal is simplest for a single periodic posting; a per-payee bill gives you payee-level detail inside Xero. Choose based on how much detail your finance team wants to see in Xero versus in the commission tool.

Can I track commission by team or region in Xero?

Yes — that's what Xero tracking categories are for, and an organisation can have up to two active at once. A good commission integration applies the tracking category automatically when it posts, so you get team or region splits on the P&L without manual reclassification.

Does the Xero integration handle PAYE and National Insurance?

No. The integration records the accounting entry; PAYE and Class 1 NICs are applied by payroll (Xero Payroll or your bureau) when the commission is actually paid. Commission is taxed as earnings in the period it's paid, so the timing of the payroll run matters more than the accounting posting.

What's the difference between a real integration and a CSV export?

An API integration posts journals or bills into Xero automatically. An import file is produced by the commission tool and imported by your payroll or finance admin. Both work if the output is in Xero's own format, grouped per employee, and every export is logged so nothing is paid twice or missed. The one that doesn't work is a generic CSV someone has to reshape by hand each month, because that reintroduces the manual, undocumented step software was meant to remove.

The bottom line

When a commission vendor says "integrates with Xero", make them show you exactly what lands in Xero: the journal, bill or import file, the account mapping, and how tracking is handled. That five-minute demo tells you whether finance gets a clean monthly import or a spreadsheet and a headache.

Commit exports approved commissions in Xero's own formats: a Xero UK Payroll import (additional earnings, one line per employee) or Accounts Payable bills. Every export is recorded in the audit trail, and a commission can't be exported twice. If Xero is your ledger, the true-cost comparison and our pricing are the practical next reads.