HubSpot to Xero: Commission CRM to Payroll in 6 Stages

Most buyers evaluating a commission CRM payroll integration ask one question first: "does it connect to our CRM?" It's the wrong question. The API connection is the easy part. What actually decides whether your month-end is calm or chaotic is the six stages between a deal flipping to closed-won in HubSpot and a commission line appearing on a Xero payslip — and the handoffs between those stages, where a number gets copied, judged, adjusted or quietly rounded by a human under time pressure.

TL;DR

Commission data travels through six stages: deal closes in HubSpot, the deal is qualified as commissionable, the plan logic runs, a manager approves, the payable amount lands in Xero payroll, and the calculation is archived as evidence. Spreadsheets don't fail at the maths — they fail at the handoffs between those stages, because each copy-paste is an unlogged decision nobody can reconstruct three months later. The two hard stages are qualification (what value is actually locked in, not the signing-day headline) and approval (someone checking the figure against the real contract before payroll runs). HMRC requires employers to report every payment through a Full Payment Submission on or before payday, and to keep PAYE records for at least three years after the end of the tax year they relate to. Design the flow around those two fixed points and the rest is plumbing.

What does a commission CRM payroll integration actually do?

A commission CRM payroll integration takes the deal data your sales team already creates — amount, close date, owner, product, stage — and turns it into a payroll-ready figure per person per pay period, without anyone re-keying it. HubSpot holds the sales truth. Xero holds the payroll truth. Neither is a commission engine: HubSpot doesn't model tiered rates, accelerators, splits or clawbacks across a quarter, and payroll software pays what you tell it to pay. The gap between the two is where almost every UK sales org still runs a spreadsheet.

The integration isn't the hard part. The hard part is deciding what a deal is worth before it reaches payroll.

What are the six stages between closed-won and net pay?

#	Stage	Where it lives	The failure mode
1	Deal closes	HubSpot	Closed-won used as a proxy for "earned", including deals that won't survive the opt-out window
2	Qualification	Commission system	Gross contract value paid on, instead of the value actually locked in
3	Calculation	Commission system	Tier boundaries, splits and ramp rules applied inconsistently per rep
4	Approval	Manager / finance	Nobody checks the number against the signed contract before payroll cut-off
5	Payroll	Xero	Figures re-keyed after cut-off; FPS sent with the wrong payment date
6	Archive	Audit trail	The workbook that produced the number is overwritten next month

Stages 1, 3 and 5 are mechanical. Stages 2, 4 and 6 are judgement, and they're the three most teams skip when a payroll deadline is four days away.

Why does "closed-won" not mean "commissionable"?

In practice, contract complexity spikes once a deal crosses roughly £100k. Below that, a closed-won amount is usually a clean number: fixed term, standard terms, paid annually. Above it, you get custom clauses, opt-out windows, phased go-lives, security-review delays and legal redlines — and that is exactly where commission errors hide. Comp logic that works fine on a £10k, 14-day SMB deal does not survive a £350k multi-threaded one.

So the qualification stage has to answer one question for every deal: how much of this is actually locked in today? A worked example. A rep closes a £120k three-year contract on 26 March at 8% commission. Paid on the gross signing-day figure, that's £9,600, and finance pushes it into the March payroll to avoid carrying it. The contract carries a 60-day opt-out on one of the three modules; in May the customer drops it, and the committed value is £96k. The rep has been paid £9,600 against an earned £7,680 — a £1,920 overpayment, plus employer National Insurance paid on money that was never earned, plus a clawback conversation that costs more in trust than £1,920 is worth.

Mechanically, this means your flow needs a holdback rule, not just a rate. Either commission on the protected portion now and the balance when the window closes, or pay in full at invoice. Both are defensible; what isn't defensible is deciding ad hoc, deal by deal, in the last 48 hours of the month. More on where the value should be measured in our guide to commission paid on gross margin, net revenue or invoice value.

Who should approve the number before it reaches payroll?

A sales manager's job isn't only helping reps close — it's shielding them from internal operational mistakes. That means sanity-checking the commission calculation against the real contract terms before payroll runs, because once a wrong number has been paid, the correction is what does the cultural damage, not the error.

The approval stage needs three things: a named approver per plan, a cut-off date that sits before payroll cut-off (not on it), and a view of the calculation that shows the inputs, not just the output. If your approver is signing off a single total per rep, they aren't approving anything — they're initialling. See commission approval workflows for how to structure sign-off without adding a week to close.

When does commission have to be reported to HMRC?

Commission is ordinary earnings: it goes through PAYE in the pay period it's paid. According to HMRC's guidance on running payroll, employers must send a Full Payment Submission to HMRC on or before their employees' payday, reporting pay and deductions — and the payment date reported is the date you pay the employee, not the date you ran payroll.

That single rule is why the commission cut-off has to sit upstream of the payroll cut-off, not alongside it. If your commission file lands on payroll day, the only ways out are paying a figure nobody has checked or paying late. HMRC's guidance on what payroll information to report does allow corrections — a later FPS with the right year-to-date figures, flagged with a late reporting reason — but a correction is an admission that stage 4 didn't happen.

What does the payslip itself have to show?

UK payslips must show gross pay, the deductions made, and net pay, per GOV.UK's payslip guidance; Acas adds that payslips can also carry the period the pay covers and the tax code, and that fixed deductions can sit in a standing statement. There's no legal requirement to itemise commission as its own line — but there's a strong operational one.

Reps don't lose faith because a number is occasionally wrong. They lose it when they can't see how it was built and a correction lands with no warning. A payslip that shows "Commission — November" as a distinct line, matched by a statement they can open showing which deals made it up, kills most disputes before they're raised. A single blended gross figure guarantees shadow accounting: reps rebuilding your numbers in their own spreadsheet because yours isn't legible.

How long do you need to keep the commission calculation?

HMRC requires employers to keep records of what they pay employees and the deductions made, and to keep them for three years from the end of the tax year they relate to — with a penalty of up to £3,000 where records aren't kept. The underlying duty sits in regulation 97 of the Income Tax (PAYE) Regulations 2003, which covers the documents relating to the calculation of PAYE income, not just the final totals.

For commission, "the calculation" is the interesting bit: the deal list, the qualification rule, the rate applied, the approver. A spreadsheet that gets copied forward each month and overwritten satisfies nobody — not HMRC, and not a rep disputing a figure from eight months ago. Many employers keep payroll records for six years rather than three, on the basis that a contract claim in England and Wales has a six-year limitation period; commission disputes are contract claims.

Re-keyed versus integrated: what actually changes?

	Manual export → spreadsheet → payroll	Integrated flow
Deal data	CSV pulled on a date nobody records	Snapshot with timestamp
Qualification	Judgement call, undocumented	Rule applied and visible to the rep
Plan logic	Formulas copied between tabs	Same engine for every rep
Approval	Email saying "looks fine"	Named approver against the calculation
Payroll entry	Re-typed per employee	Pay items pushed to Xero
Evidence	Last month's file, overwritten	Audit trail per period

The honest point: an integration doesn't make a bad plan good. If your scheme has ambiguous crediting rules, automating it just produces wrong answers faster. Fix the rules first — then remove the humans from the copying. Our HubSpot commission tracking guide covers which deal properties the calculation should key off, and the Xero commission integration guide covers the payroll end.

Frequently Asked Questions

Does HubSpot calculate sales commission natively?

HubSpot holds the deal data commission is calculated from — amount, close date, owner, line items — but it isn't a commission engine. Tiered rates, accelerators, splits across multiple reps, draw recovery and clawbacks across periods need logic that lives outside the CRM and reads from it.

Can Xero payroll work out commission?

Xero payroll pays commission correctly once you tell it the amount, handling PAYE, National Insurance and the FPS submission. It does not model your commission plan — the figure has to arrive as a calculated, approved pay item for the right pay run.

When does commission have to be reported to HMRC?

HMRC requires a Full Payment Submission on or before the employee's payday for every payment, including commission. The payment date reported must be the date the employee is actually paid, not the date payroll was processed.

Should commission appear as a separate line on the payslip?

UK law requires payslips to show gross pay, deductions and net pay rather than a specific commission line. Itemising commission separately isn't mandatory, but it materially reduces disputes, because reps can reconcile the payslip against the commission statement without rebuilding your numbers themselves.

How far back should commission calculations be kept?

PAYE records must be kept for at least three years after the end of the tax year they relate to. Because commission disputes are contract claims, many UK employers keep the full calculation — deals, rules, rates and approvals — for six years instead.

See the flow on your own numbers

Every stage above has a cost attached when it's done by hand: an overpayment on a deal that hadn't locked in, a dispute you can't answer because last month's file was overwritten, two days of finance time each period re-keying figures into payroll. Commit calculates commission from your HubSpot deals, pays it through Xero payroll and keeps the full audit trail behind every figure, and the 14-day free trial is self-serve — load your real plan and one real period, and see where your current process is making decisions nobody has recorded.