End-of-Year Commission Reconciliation: UK Tax Year Checklist

The UK tax year ends on 5 April. For most of the business, that date passes without drama. For anyone responsible for sales commission, it's the deadline that determines whether you start the new year clean — or spend the first quarter untangling problems from the last.

Commission reconciliation at year end isn't optional. It's the process that ensures every rep was paid correctly, every PAYE deduction was accurate, every employer NIC contribution was properly calculated, and your records will survive an HMRC enquiry. Get it right, and April is a fresh start. Get it wrong, and you're carrying forward errors that compound.

This article is your step-by-step checklist. Whether you're in finance, sales ops, or sales leadership, here's exactly what needs to happen — and when.

How to Conduct a Commission Audit at Year End

A commission audit at UK tax year end verifies that every pound paid to reps matches your deal data, your payroll records, and HMRC requirements. The process follows a fixed sequence: compile all commission payments, reconcile them to CRM deal data, cross-check against payroll and NIC records, resolve disputes, and prepare documentation for the new tax year. Most organisations need 3-4 weeks to complete this properly—which means starting by mid-March, not early April.

Why the UK Tax Year End Matters for Commission

The 5 April deadline triggers several critical HMRC obligations that directly affect commission payments. Missing or mishandling any of these creates compliance risk and administrative burden that extends well into the new tax year.

P60s and Payroll Reporting

Every employer must provide P60s to employees by 31 May, showing total pay and deductions for the tax year. Commission forms part of total taxable pay, and if your commission records don't reconcile with payroll, the P60 will be wrong — and employees will find out when their tax position doesn't match their records.

According to HMRC guidance on Real Time Information (RTI) submissions, employers must submit payroll data throughout the year. The year-end process is your opportunity to catch any discrepancies before HMRC does. An RTI correction after year end is possible but creates administrative burden and potential enquiry triggers.

Employer NIC Final Calculations

Employer National Insurance Contributions on commission are calculated at 15% (as of April 2025) and must be verified during year-end reconciliation. Per HMRC's April 2025 policy changes published in the National Insurance rates and thresholds guidance, the secondary threshold dropped to £5,000, making errors proportionally more expensive. Your reconciliation must verify that NIC was calculated on the correct earnings bands and at the correct rates throughout the year.

These changes mean that employer NIC on commission is now a larger cost item — and errors carry more financial impact. If any commission was processed outside normal payroll (which it shouldn't be, but sometimes is), it needs to be brought into the RTI record.

Pension Auto-Enrolment

Commission that forms part of qualifying earnings is subject to pension auto-enrolment contributions under The Pensions Regulator automatic enrolment requirements. If your commission payments and PAYE compliance haven't been correctly included in pension calculations, you may have under-contributed — creating a compliance issue with The Pensions Regulator.

Accruals and Financial Close

If your company's financial year doesn't align with the tax year (many UK companies use a calendar year or other period), the 5 April reconciliation still matters. Commission accruals need to be accurate for both tax reporting and management accounts. Unreconciled commission creates uncertainty in your cost base that ripples through financial statements. For organisations using Xero or similar platforms, commission reconciliation and payroll integration ensures your financial close is clean.

The Step-by-Step Checklist

Work through this checklist in order. Each step builds on the previous one.

Step 1: Compile the Master Commission Record (By 10 March)

Pull together a complete record of every commission payment made during the tax year (6 April 2025 to 5 April 2026). This should include:

• Rep name and payroll reference — every payment must tie to a payroll record
• Payment date — the actual date the commission was paid, not the date it was earned
• Gross commission amount — before any deductions
• Associated deals — which deals generated each commission payment
• Plan terms applied — which commission plan and rate tier was used
• Any adjustments — clawbacks, corrections, manual overrides

If you're working from spreadsheets, this step alone can take days. If you have commission software, it should be a single export.

Common mistake: Forgetting about off-cycle payments. If any commission was paid outside the normal monthly payroll run — a manual payment, an advance, a one-off bonus — it needs to be in the master record.

Step 2: Reconcile Commission to Deal Data (By 15 March)

For every commission payment, verify that:

• The deal exists in your CRM and has been closed/won
• The deal value matches the value used for commission calculation
• The deal was attributed to the correct rep (particularly important for split deals or territory changes)
• The deal close date falls within the commission period it was paid for
• Any deal amendments (upsells, downsells, cancellations) have been reflected in commission

This is where most calculation errors surface. Deals that changed value after commission was calculated, reps who moved territories mid-quarter, or deals that were attributed to the wrong rep.

Worked example: A rep closed a £60,000 deal in January, earning 8% commission (£4,800). In February, the customer downgraded to a £45,000 contract. If the commission was already paid on £60,000, there should be a £1,200 clawback in the records. Verify that it's there.

Step 3: Check for Outstanding Disputes (By 20 March)

Review all open commission disputes and aim to resolve them before year end. For each dispute:

• Document the dispute and the rep's claimed amount
• Investigate and determine the correct outcome
• Process any payments or adjustments needed
• Confirm resolution with the rep in writing

Disputes that carry over into the new tax year create complications. If a dispute results in an additional payment, it will be taxed in the year it's paid — which may not match the year it was earned. While this is legally correct per HMRC guidance, it can create confusion for reps reviewing their P60s.

If a dispute genuinely cannot be resolved before 5 April, document it clearly: what's disputed, what amount is at stake, what the expected resolution timeline is, and how it will be handled for tax purposes.

Step 4: Reconcile Commission to Payroll Records (By 25 March)

This is the critical step. Every pound of commission on your master record must match your payroll records exactly. Compare:

• Total commission per rep on your commission records vs total commission per rep on payroll
• Payment dates — commission should have been processed through payroll in the period it was paid
• Tax codes — verify that commission was processed under each rep's correct tax code (watch for reps who joined or left mid-year)
• NI category letters — confirm the correct NI category was applied

Any discrepancy between commission records and payroll needs to be investigated and resolved. Common causes include:

• Commission processed in the wrong pay period
• Manual payments made outside payroll
• Rounding differences between commission calculations and payroll systems
• Mid-year tax code changes not reflected in commission processing

For organisations using Xero for payroll, this commission payroll reconciliation process should involve exporting payroll journals and matching them line-by-line to your commission records.

Step 5: Verify Employer NIC Calculations (By 28 March)

For each rep, verify that employer NIC has been correctly calculated on their commission earnings. This means checking:

• Commission was included in the NIC calculation (not accidentally excluded)
• The correct NIC rate was applied (15% from April 2025, per HMRC policy updates)
• The secondary threshold (£5,000 per year from April 2025) was correctly applied
• Any NIC reliefs (e.g., Employment Allowance) were correctly allocated

Worked example: A rep earned £40,000 base salary plus £25,000 in commission during the 2025/26 tax year. Total earnings: £65,000. Employer NIC at 15% on earnings above the £5,000 secondary threshold: (£65,000 - £5,000) x 15% = £9,000. Verify this matches the actual NIC charged through payroll.

If your commission was processed through payroll correctly each month, the NIC should be accurate. But if any commission was paid late, processed as a lump sum, or handled outside normal payroll, the NIC calculation may be wrong.

Step 6: Review Accruals (By 31 March)

Check for commission that has been earned but not yet paid as of 5 April:

• Deals closed in March that won't be paid until April — the commission accrual needs to be recorded as a liability in the 2025/26 accounts
• Deals in dispute where the outcome may result in additional payment
• Multi-period deals where commission is earned over time

Document the accrual amount and the expected payment date. This information will be needed for both management accounts and, if applicable, statutory accounts.

Step 7: Prepare for the New Tax Year (By 5 April)

Before the new year starts, ensure you're ready:

• Update commission plans — if any rates, tiers, or terms are changing for 2026/27, ensure these are documented and communicated before 6 April
• Apply new tax year rates — confirm that payroll is set up with the correct 2026/27 NIC rates, thresholds, and tax bands per HMRC published thresholds
• Carry forward any open items — disputes, accruals, or corrections that span the year boundary need to be clearly documented
• Reset tracking — if you use spreadsheets, create the new year's workbook and verify all formulas. If you use commission software, confirm the new period is configured correctly
• Communicate to reps — send a clear summary to each rep showing their total commission for the year, any outstanding items, and what to expect in the new year

Timing: What to Do Before vs After 5 April

Before 5 April

Everything in Steps 1-7 above. The goal is to close the year with a clean, reconciled commission record that matches payroll.

If you discover errors before 5 April, you can usually correct them through an additional payroll run in the current tax year. This is far easier than correcting them after the year closes.

6 April to 19 April: Final RTI Submission

Your final RTI submission for the tax year is due by 19 April, according to HMRC RTI guidance. This is your last opportunity to correct any payroll data for the year. If your reconciliation revealed discrepancies, ensure the corrections are included in this submission.

By 31 May: P60 Distribution

P60s must be distributed to all employees by 31 May per HMRC regulations. Review commission-related figures on P60s before distribution. If a rep received £65,000 in total pay but their P60 shows £62,000, they'll notice — and the investigation will be more painful than catching it during reconciliation.

By 5 July: P11D Deadline

If any commission-related benefits in kind need to be reported (uncommon, but possible with certain commission structures involving non-cash elements), P11Ds are due by 5 July according to HMRC filing deadlines.

Common Year-End Mistakes

Having walked through this process with dozens of sales organisations, these are the mistakes we see most frequently.

Forgetting about leavers. Reps who left mid-year are often overlooked in year-end reconciliation. Their commission records may be incomplete, their final payments may not have been properly reconciled, and their tax position may be complicated by the interaction between their earnings with you and their subsequent employment. Verify that every leaver's commission record is complete and matches payroll.

Not reconciling clawbacks. Commission clawbacks — recoveries for deals that churned or were amended — are frequently miscategorised or missed entirely. A clawback reduces the rep's taxable commission for the year. If it wasn't processed through payroll correctly, the rep may have overpaid tax.

Treating the reconciliation as a finance-only exercise. Year-end reconciliation requires input from sales ops (deal data, plan terms), finance (payroll records, NIC calculations), and ideally sales leadership (dispute resolution, plan changes). Treating it as a pure finance task almost guarantees that commission-specific nuances will be missed.

Leaving it too late. Starting reconciliation in the last week of March is starting too late. The process reliably takes 3-4 weeks for a team of 20+ reps, longer if you're working from spreadsheets. Begin in early March.

Not documenting the process. If HMRC enquires about your commission payments, they'll want to see that you have a systematic process for calculating, paying, and reconciling commission. The reconciliation itself is evidence of that process. Document what you checked, what you found, and what you corrected.

Preparing Commission Plans for the New Tax Year

Year-end reconciliation is also the natural moment to review and update commission plan design for UK sales teams for the coming year. Consider:

Rate and Threshold Changes

If employer NIC costs have increased (as they did significantly in April 2025 per HMRC policy changes), does this change the economics of your commission plan? Many companies absorbed the additional NIC cost, but some adjusted OTE or commission rates to partially offset it. Whatever you decide, document the rationale.

Plan Simplification

If your reconciliation revealed frequent calculation errors or disputes, the plan itself may be too complex. Year end is the time to simplify: reduce the number of tiers, clarify deal categorisation rules, or standardise commission periods. Simple plans are easier to calculate, easier to verify, and generate fewer disputes.

Communication

Any changes to commission plans for the new tax year should be communicated in writing before 6 April. Reps need to understand their new terms before they start earning under them. Ambiguity at the start of the year creates disputes throughout it.

Finance Alignment

Share your commission plan for the new year with finance before finalising it. They need to model the expected cost, set up budgets, and ensure payroll can handle the calculation requirements. A plan that sales ops can't calculate or payroll can't process is a plan that will generate errors — and you'll be reconciling those errors at this time next year.

A Note on Tools

If this checklist feels like a lot of manual work, it's because it is — when you're working from spreadsheets. The reconciliation process described here is designed to catch errors that wouldn't exist with proper commission management software.

Automated commission tools calculate in real time, reconcile to CRM data continuously, and integrate with payroll systems. The year-end process becomes a verification step rather than a reconstruction exercise. That's the difference between spending four weeks on reconciliation and spending four hours.

But regardless of your tooling, the checklist itself doesn't change. The questions are the same whether you're answering them from a spreadsheet or a dashboard. What matters is that you ask them.

Frequently Asked Questions

What happens if I miss the 5 April commission reconciliation deadline?

You can still reconcile after 5 April, but corrections become harder. Any commission adjustments made after the tax year closes must be processed in the new tax year (2026/27), which means they'll be taxed in a different year than they were earned. Your P60s for 2025/26 will be finalised without those corrections, and you'll need to file RTI amendments if payroll data was wrong. HMRC doesn't penalise late reconciliation directly, but incorrect RTI submissions or P60s can trigger compliance enquiries.

Can I carry disputed commission into the new tax year?

Yes, but document it carefully. If a dispute can't be resolved before 5 April, record the disputed amount, the rep's claim, and the expected resolution date. When you eventually pay the disputed commission, it will be taxed in the year it's paid (not the year it was earned), which is HMRC-compliant but may confuse the rep when reviewing their records. Communicate this clearly to avoid further disputes.

How do I handle commission clawbacks that span the tax year?

If a deal churns in April 2026 but the commission was paid in February 2026, the clawback must be processed in 2026/27 (the year the recovery happens). The rep's 2025/26 P60 will show the original gross commission. The clawback reduces their taxable pay in 2026/27, which may result in a tax refund if they've already been taxed on the full amount. This is correct per HMRC rules but requires clear communication to the rep and accurate payroll coding.

What's the penalty for incorrect employer NIC on commission?

If HMRC identifies that you've under-reported or under-paid employer NIC, they can charge the shortfall plus interest and, in cases of carelessness or deliberate error, penalties of up to 100% of the unpaid amount. Regular reconciliation is your defence: if you can demonstrate a systematic process and promptly correct errors when found, HMRC is far more lenient. The 2025/26 NIC threshold drop to £5,000 means even small commission errors now trigger NIC liability.

Do I need to reconcile commission if we use automated commission software?

Yes, but the process is faster. Automated tools reduce calculation errors and provide real-time CRM-to-payroll reconciliation, but you still need to verify that deal data is accurate, disputes are resolved, and payroll integration worked correctly. The year-end reconciliation becomes a verification checkpoint rather than a full reconstruction. Most organisations using commission software complete the process in days rather than weeks.

Sources and Further Reading

• HMRC: Real Time Information (RTI) — official guidance on payroll reporting requirements and RTI submission deadlines
• HMRC: National Insurance rates and thresholds 2025/26 — current NIC rates, secondary thresholds, and employer obligations
• The Pensions Regulator: Automatic enrolment duties — guidance on pension contributions and qualifying earnings
• HMRC: P60 End of Year Certificate — requirements and deadlines for P60 distribution

---

This article provides general guidance on UK tax year-end commission processes. It does not constitute tax advice. For specific PAYE, NIC, or pension queries, consult a qualified tax adviser or HMRC directly. Tax rates and thresholds referenced are for the 2025/26 and 2026/27 tax years and may change.