Commission Payroll Reporting: From CRM to Payslip

What is commission payroll reporting?

Commission payroll reporting is the hand-off between the commission calculation and the payroll run: one approved line per employee, per period and per pay element, with the gross commission, every adjustment, clawback and draw, and the net amount payroll should pay. Payroll then withholds tax and social contributions on it as supplemental pay, and finance books the expense and any capitalised cost. A good report reconciles to the commission statements, the payroll register and the general ledger without anyone retyping a number.

This guide is for finance, payroll and RevOps teams in the US, the UK and Europe who need commission to arrive in payroll correctly every month. It follows commission from the CRM to the payslip, lists the fields a payroll-ready report must contain, explains cut-offs and accrual timing, covers the tax treatment in the US and the UK with notes on the EU and the Nordics, shows how ASC 340-40 and IFRS 15 change the accounting, and ends with reconciliation checks, common errors and worked examples in Python. Tax and employment rules change and vary by state and country, so treat this as general guidance and check with your payroll provider, accountant or employment counsel.

Key findings

• 22% is the US federal optional flat rate for withholding on supplemental wages such as commission, up to $1 million a year per employee. Above $1 million, a mandatory 37% applies (EY, 2026 rates).
• $341 is how much more a US employer pays in payroll tax on the same $10,000 commission when it is paid in January instead of December, for a rep who has already earned $180,000 that year. Our worked model, based on the 2026 Social Security wage base of $184,500.
• 15% employer National Insurance applies to UK commission above the £5,000 a year secondary threshold in 2026-27, so a £10,000 commission paid to a salaried rep costs the employer another £1,500.
• £461.54 a week is added to UK holiday pay for a rep who averages £2,000 a month in commission, because the four weeks of EU-derived statutory leave must be paid at normal pay including commission.
• $333.33 a month is what a $12,000 commission on a three-year contract costs in the P&L under IFRS 15 and ASC 340-40, even though payroll pays it all at once. Only contracts amortised over one year or less can be expensed straight away.

How does commission flow from the CRM to payroll?

Commission moves through six stages: the period's data is captured, commission is calculated, each rep's statement is reviewed, the statement is approved, approved amounts are exported to payroll, and payroll pays and reports them. Payroll should only ever receive approved amounts, and every number it receives should trace back to a statement and from there to the deals behind it.

1. Period data: Won deals, invoices or subscription changes for the period are pulled from the CRM, the billing system or the accounting system, with the owner, amount and the date that decides the period.
2. Calculation: The commission plan is applied: rates, tiers, accelerators, splits, caps, plus corrections for earlier periods whose data changed.
3. Statement review: Each rep sees a statement with every deal, rate and adjustment, and flags anything missing while the period can still be fixed.
4. Approval: A manager, then finance, signs off the amount. After the first signature, the number is frozen.
5. Payroll export: Approved amounts are sent to the payroll system as a file or through an integration, one line per employee and pay element.
6. Payroll run and accounting: Payroll calculates withholding and employer contributions, pays the rep, files with the tax authority and posts the journal, which finance reconciles against the commission accrual.

Three rules keep this flow clean. First, payroll pays what was approved and nothing else: no manual top-ups in the payroll system that never appear on a statement. Second, a paid period is never edited; a later change is a correction in the next period. Third, the export is generated, not typed, so the totals in the commission system, the payroll file and the ledger can be compared line by line. The commission statement template shows what each rep's statement should contain before it reaches this stage.

What must a payroll-ready commission report contain?

At minimum: who is paid (employee ID as payroll knows it), for which period, which pay element or wage code, the gross commission, adjustments and corrections, clawbacks, draw recovery or top-up, the net amount payable, the currency and the cost centre. Add an approval reference and the pay date so every line can be audited later.

Payroll does not need the deals. It needs enough to pay the right person the right amount under the right pay code, and enough references to answer an auditor. The table lists the fields and why each one matters.

Keep the commission report in the currency the employee is paid in. If commission is earned on deals in another currency, convert at the rate the plan specifies and show the converted amount, not the deal currency, on the payroll line.

Sample payroll commission report

The sample below is one month's report for four reps, as finance would send it to payroll. Names, IDs and amounts are invented for the example. The total row is the control total payroll checks the import against.

Each row tells a story payroll can check. Alex had a September deal upsized after it was paid (a +$450 correction) and an August deal cancelled within the clawback window (−$900). Priya repays $1,000 of a recoverable draw. Tom's correction is negative because a deal was credited to a colleague after review. Sara is ramping on a $2,000 guaranteed draw, so her $1,250 is topped up by $750.

Sample payout breakdown for one rep

Behind each net amount sits a breakdown the rep sees on their statement. For Alex, the $7,750 that goes to payroll is built up like this:

If your payroll system needs separate pay elements, for example because a SPIFF is a bonus rather than commission for pension purposes, split the lines by wage code in the export rather than sending one combined number.

What is the difference between the commission period and the payment period?

The commission period is when the commission was earned; the payment period is when it is paid. They are almost never the same. Most companies pay commission for a month in the following month's payroll, after statements are reviewed and approved, and finance accrues the expense in the month it was earned.

Four dates decide the timing, and all four belong in the written commission plan:

• The earning event: what makes commission earned. Closed-won in the CRM, invoiced, or paid by the customer. The later the event, the fewer clawbacks you need.
• The period cut-off: the last moment a deal can count for the period, usually the end of the last day in a stated time zone.
• The approval deadline: when statements must be signed off to make the next payroll.
• The payroll cut-off: when the payroll provider must receive the file. In many payroll services this is several working days before pay day.

Two timing choices cause most trouble. Paying on bookings but clawing back on cancellation creates a stream of negative adjustments; paying on customer payment avoids them but delays commission and may conflict with how the plan was sold to reps. And paying quarterly commission once a quarter makes payroll simple but creates large, lumpy payments that are taxed and averaged differently from monthly ones. Decide deliberately and write it down. Our guide to payout frequency compares the options.

How do accruals work at month end?

Commission is an expense of the month it was earned, even when it is paid a month later. At month end, finance books an accrual: debit commission expense, credit accrued commission (a liability), plus the employer payroll taxes that will fall due on it. When payroll pays, the liability is cleared. The accrual should come from the commission system's period total, not from an estimate, which is one more reason to calculate commission continuously through the month rather than once at the end.

In the sample report, October's net commission of $25,350 is accrued at 31 October. If all four reps are below the Social Security wage base, the employer's share of FICA on it is $1,939.28 at 7.65%, which is accrued as well. The accrual is reversed when the November payroll posts.

How is commission taxed in payroll?

For employees, commission is wages. In the US it is a supplemental wage, which lets employers withhold federal income tax at a flat 22% instead of using the W-4 tables. In the UK it is ordinary earnings that go through PAYE with income tax and Class 1 National Insurance. In most EU and Nordic countries it is taxed as ordinary salary. Commission paid to independent agents or contractors is not wages and is not run through payroll at all.

United States: supplemental wage withholding

US federal rules treat commission as a supplemental wage: Treasury Regulation 31.3402(g)-1 lists commissions as an example and says wages that vary by payroll period are not regular wages. An employer can withhold federal income tax on them in one of two ways:

• Optional flat rate method: withhold a flat percentage, 22% for 2026, on supplemental wages up to $1 million in the year. It can be used only if the commission is paid separately from regular wages or is shown separately, and income tax was withheld from the employee's regular wages this year or last year.
• Aggregate method: add the commission to the regular wages for the pay period and withhold on the total as if it were one payment, using the employee's Form W-4 and the normal withholding tables. This often withholds more on a large commission, because the whole amount is treated as if it were earned every pay period.

Once an employee's supplemental wages from one employer pass $1 million in a calendar year, the excess must be withheld at 37%, whatever the employee's W-4 says (EY, 2026). Withholding is not the final tax: the rep's actual liability is settled on their tax return, so a high flat rate does not mean higher tax overall.

Commission is also subject to FICA. For 2026 the Social Security tax is 6.2% each for employee and employer on wages up to $184,500, and Medicare is 1.45% each with no cap (Social Security Administration). Most states with an income tax publish their own supplemental rate or method, so check each state where reps work. Some states also have specific rules for commission: California requires commission plans to be in writing and to set out how commission is computed and paid, with a signed copy to the employee (Labor Code section 2751).

Worked example, using the flat method on Alex's $7,750 commission paid separately from salary, before any state tax:

Why payment timing changes the employer's cost

Because Social Security stops at the annual wage base, when commission is paid matters for high earners. Take a rep who has earned $180,000 by December and is owed $10,000 in commission. Paid in the December payroll, only $4,500 of it is below the $184,500 wage base, so the employer pays $279 in Social Security and $145 in Medicare: $424. Paid in the January payroll, the wage base resets and the employer pays the full 7.65%: $765. The same commission costs the employer $341 more for being paid one month later. This is our worked model, not survey data, and it ignores state taxes and any employer benefits tied to pay.

The point is not to move commission between years to save tax: the plan decides when commission is earned and due, and late payment can breach state wage-payment rules. The point is that the payroll report needs the commission period and the pay date as separate fields, so finance can accrue the right employer tax and explain why the same commission costs different amounts.

United Kingdom: PAYE, National Insurance and holiday pay

In the UK, commission paid to an employee is earnings: the Income Tax (Earnings and Pensions) Act 2003 defines earnings as "any salary, wages or fee" and anything else that is an emolument of the employment (section 62). It is added to pay for the period and goes through PAYE, with income tax and Class 1 National Insurance deducted, just as HMRC describes for cash bonuses (GOV.UK). Employers who run payroll themselves must report payments and deductions to HMRC on or before each pay day (GOV.UK).

For 2026-27, employer Class 1 National Insurance is 15% on earnings above the secondary threshold of £5,000 a year (£417 a month), and the employee main rate is 8% between £12,570 and £50,270 a year (GOV.UK rates and thresholds). For a salaried rep whose base pay already exceeds the threshold, every pound of commission costs the employer another 15p: £1,162.50 on a £7,750 commission.

UK holiday pay is where commission reporting most often goes wrong. Following British Gas v Lock, the Court of Appeal held in 2016 that holiday pay must include results-based commission for the four weeks of EU-derived leave (Brodies). Government guidance on the 2024 reforms says normal pay for those four weeks must include "payments, including commission payments, intrinsically linked to the performance of tasks", while the remaining 1.6 weeks can be paid at basic pay. For variable pay, employers average over the last 52 weeks in which the worker was paid, looking back no more than 104 weeks (GOV.UK guidance).

In practice, this means your payroll report must keep commission history by pay week or month for at least a year, and flag the commission wage code as holiday-pay relevant in the payroll system. A rep who averages £2,000 a month in commission adds about £461.54 a week to holiday pay for the four weeks (£2,000 × 12 ÷ 52). The glossary entry on holiday pay on commission covers the principle across countries.

EU and the Nordics: commission as ordinary salary

Across the EU, commission paid to employees is generally taxed as ordinary salary through the employer's payroll, and holiday pay must reflect normal pay including commission, following the Court of Justice's ruling of 22 May 2014 in Lock (case C-539/12), which held that commission linked to the work must be included in holiday pay (Court of Justice press release). How the averaging works, which social contributions apply and who pays them differ by country. In Denmark, for example, commission is A-income: the employer withholds 8% labour market contribution (AM-bidrag) and then A-skat, and holiday pay on commission follows special rules in the Danish Holiday Act. Our guide to tax on commission in Denmark walks through it. For any other country, ask your payroll provider which pay element commission should use, because that setting decides tax, pension and holiday pay together.

Commission to independent agents and contractors

Commission paid to a self-employed agent, reseller or contractor is a business payment, not wages. It is paid against an invoice or a self-billing statement through accounts payable, not payroll, with no PAYE or withholding in most cases, although US businesses may have information-reporting duties and VAT can apply in Europe. Keep these people out of the payroll report entirely, and be careful that the relationship really is independent: misclassifying an employee as a contractor is expensive in every jurisdiction covered here.

How should finance account for commission under ASC 340-40 and IFRS 15?

Commission that is paid because a specific customer contract was won is an incremental cost of obtaining that contract. Under IFRS 15 and the matching US guidance in ASC 340-40, it must be capitalised as an asset if the company expects to recover it, and then amortised over the period the related goods or services are delivered. A practical expedient lets you expense it immediately if that amortisation period would be one year or less.

The rules come from paragraphs 91 to 94 and 99 of IFRS 15, which mirror ASC 340-40-25-1 to 25-4 in US GAAP (PwC Viewpoint, TRG paper):

• Capitalise costs you would not have incurred without the contract, with a sales commission as the standard's own example (IFRS 15.91-92).
• Expense costs you would have incurred anyway, such as base salaries or a discretionary bonus based on overall profitability (IFRS 15.93).
• Practical expedient: expense immediately if the amortisation period of the asset would be one year or less (IFRS 15.94).
• Amortise on a systematic basis consistent with the transfer of the goods or services the asset relates to (IFRS 15.99), which can include anticipated renewals when the renewal commission is not commensurate with the initial one.

A Transition Resource Group staff paper adds two points that matter for payroll reporting. Payroll taxes and pension costs that arise because a commission was paid appear to be capitalisable along with the commission. And a renewal commission is capitalised when the renewal happens, not when the first contract is signed (PwC Viewpoint). These were staff views for discussion, so agree the policy with your auditor.

Worked example: amortising a commission on a three-year contract

A rep earns $12,000 in commission on a three-year subscription signed on 1 January, with the service delivered evenly. The commission is capitalised and amortised straight-line at $4,000 a year, or $333.33 a month. If your policy also capitalises the employer's 7.65% FICA on it ($918), the asset is $12,918 and the monthly charge $358.83.

What this means for the commission report: payroll pays the full $12,000 in the month after the deal closes, but the P&L shows only $333.33 of it that month. Finance therefore needs commission data at deal or contract level, with contract start date, term and the commission attributed to each contract, not only one total per rep. A clawback reverses the unamortised part of the asset. The glossary explains capitalising commission under IFRS 15 and commission amortisation in more detail.

How do you reconcile commission with payroll?

Reconcile three totals every period: the approved commission in the commission system, the commission lines in the payroll register, and the commission accounts in the general ledger. They should agree per employee and in total. Any difference has to be explained before the next period closes, or it compounds.

What makes an audit trail good enough?

An auditor, a tax inspector or a rep in a dispute should be able to go from any payslip line back to the deals and rules that produced it, and see who approved it and when. That requires a frozen copy of each statement as approved, the plan version that applied, every adjustment with a reason and an author, the approval history, and the payroll file as sent. A spreadsheet that is overwritten every month cannot provide this. If you are moving away from one, the commission software implementation guide covers how to check a past paid period before you switch.

How should corrections, clawbacks and draws appear in payroll?

As their own lines, in the period they are processed, never by editing a period that was already paid. A correction or clawback adjusts the current period's net amount; a recoverable draw is repaid from future commission; a negative balance is carried forward until it is recovered or written off under the plan.

• Corrections: when the data behind a paid period changes, recalculate that period, take the difference and put it on the current statement. The old statement and the old payroll line stay as they were. See correction and true-up.
• Clawbacks: show them separately from corrections, with the deal and the rule that triggered them. Rules on deducting money from wages vary by country and US state, and often need written consent in the plan. Our clawback guide covers the plan wording.
• Draws: a recoverable draw is an advance that later commission repays; a non-recoverable (guaranteed) draw tops commission up to a floor and is never repaid. The report should show the draw balance outstanding. See commission draw.
• Overpayments: when commission was simply paid wrong, treat recovery as its own process with the rep's agreement. Our guide to commission overpayment covers the options.

A negative net amount should never be sent to payroll as a negative payment unless your payroll provider and local law allow it. Carry it forward on the rep's balance instead and recover it from the next positive period, as the plan specifies.

Worked examples in Python

The three examples below use Python's decimal module, because floating-point arithmetic produces rounding errors in money. Round once, at the end of each line. You can run them as they are with Python 3.

1. Build the payroll file from approved statements and check the control total

from decimal import Decimal as D
import csv, sys

statements = [  # one row per approved statement (USD)
    {"payroll_id": "E1042", "period": "2026-10", "wage_code": "COMM-01",
     "gross": D("8200"), "corrections": D("450"), "clawbacks": D("-900"), "draw": D("0")},
    {"payroll_id": "E1057", "period": "2026-10", "wage_code": "COMM-01",
     "gross": D("5600"), "corrections": D("0"), "clawbacks": D("0"), "draw": D("-1000")},
    {"payroll_id": "E1063", "period": "2026-10", "wage_code": "COMM-01",
     "gross": D("11300"), "corrections": D("-300"), "clawbacks": D("0"), "draw": D("0")},
    {"payroll_id": "E1071", "period": "2026-10", "wage_code": "COMM-01",
     "gross": D("1250"), "corrections": D("0"), "clawbacks": D("0"), "draw": D("750")},
]

rows, carried = [], {}
for s in statements:
    net = s["gross"] + s["corrections"] + s["clawbacks"] + s["draw"]
    if net < 0:                      # never send a negative payment
        carried[s["payroll_id"]] = net
        continue
    rows.append([s["payroll_id"], s["wage_code"], s["period"], f"{net:.2f}"])

control_total = sum(D(r[3]) for r in rows)
assert control_total == D("25350.00"), control_total
csv.writer(sys.stdout).writerows(rows)
print("Control total:", control_total, "Carried forward:", carried)

The script prints four lines and a control total of 25350.00, the same total as the sample report. Payroll compares that number with the total of the import before running payroll.

2. US withholding and employer FICA on a commission payment

from decimal import Decimal as D, ROUND_HALF_UP

def cents(x):
    return x.quantize(D("0.01"), rounding=ROUND_HALF_UP)

SS_RATE, MED_RATE, FLAT_RATE = D("0.062"), D("0.0145"), D("0.22")
WAGE_BASE_2026 = D("184500")

def us_commission(commission, wages_ytd):
    ss_taxable = min(commission, max(WAGE_BASE_2026 - wages_ytd, D("0")))
    ss, med = cents(ss_taxable * SS_RATE), cents(commission * MED_RATE)
    federal = cents(commission * FLAT_RATE)  # optional flat method, under $1M
    return {"federal_withheld": federal, "employee_ss": ss, "employee_medicare": med,
            "net_before_state": commission - federal - ss - med,
            "employer_fica": ss + med}

print(us_commission(D("7750"), D("40000")))    # employer FICA 592.88
print(us_commission(D("10000"), D("180000")))  # employer FICA 424.00
print(us_commission(D("10000"), D("0")))       # employer FICA 765.00

The second and third calls reproduce the timing example: $424.00 in December against $765.00 in January for the same $10,000. Additional Medicare tax for very high earners and state taxes are left out to keep the example short.

3. Amortisation schedule for capitalised commission

from decimal import Decimal as D, ROUND_HALF_UP

def schedule(commission, months):
    monthly = (commission / months).quantize(D("0.01"), rounding=ROUND_HALF_UP)
    rows, remaining = [], commission
    for m in range(1, months + 1):
        charge = remaining if m == months else monthly  # last month absorbs rounding
        remaining -= charge
        rows.append((m, charge, remaining))
    return rows

rows = schedule(D("12000"), 36)
print(*rows[0])                          # 1 333.33 11666.67
print(*rows[-1])                         # 36 333.45 0.00
print(sum(r[1] for r in rows))           # 12000.00

The last month absorbs the rounding difference, so the schedule always adds up to the amount capitalised. A clawback in month 10 would remove the remaining balance at that point from the asset.

What are the most common commission payroll reporting errors?

Most errors come from manual steps between the commission calculation and payroll: retyped numbers, matching by name, late approvals and edits to paid periods. The table lists the ones payroll and finance teams see most, with a fix for each.

Year end adds its own list: true-ups, December deals and accruals across the year boundary. The year-end commission checklist covers them.

Should you send commission to payroll as a file or through an integration?

Both work if the data is right. A file import is universal and gives payroll a clear control point; a direct integration removes a manual step but needs the employee matching to be reliable. What matters more is that the file or the push is generated from approved statements, not typed.

How does Prowi handle commission payroll reporting?

In Prowi, a statement that completes its approval chain is credited to the rep's balance account, a ledger of what the company owes them, kept per currency. An administrator then starts a payout run on the Payouts page. For Zenegy, Prowi pushes each payout directly to the employee as a salary supplement line. For any other payroll system, including Danløn, Visma Dataløn, Lessorløn and Visma Enterprise, the run produces a payroll file from a one-line template the company defines, which can include the payroll ID, the amount, the wage code, the currency, the date and per-person fields such as a wage type.

The amounts come from commission Prowi calculates live from deals in HubSpot, Pipedrive or Salesforce. Each statement shows the deals behind it and the formula with every value filled in, and reps follow their statement in the mobile app as the period runs. An adjustment can carry its own wage code, so it lands on its own payroll line. When a deal changes after its period was paid, Prowi never rewrites the paid statement: it recalculates that period and puts the difference as a correction on the rep's current statement, so it reaches payroll with the next payout. Every payout run is kept in a run history with the people paid and the outcome for each, and a file run can be downloaded again. See the Zenegy integration for the direct push.

Want to see how approved commission reaches your payroll file? Book a demo.

FAQ

Is commission taxed differently from salary?

Not in the final tax bill: commission is income like salary. What differs in the US is withholding, because commission is a supplemental wage and can be withheld at a flat 22% federal rate. In the UK and most of Europe it is simply added to pay for the period and taxed through payroll in the normal way.

What should a commission report for payroll include?

Employee payroll ID, commission period, pay date, wage code, gross commission, corrections, clawbacks, draw recovery or top-up, net payable, currency, cost centre and an approval reference, with a control total for the file.

Should commission be paid in the same month it is earned?

Usually not. Most companies pay a month's commission in the following month's payroll, after statements are reviewed and approved, and accrue the expense in the month it was earned. Whatever you choose, write the cut-off, approval deadline and pay date into the plan.

Does commission count towards holiday pay?

In the UK, yes for the four weeks of statutory leave derived from EU law, averaged over the last 52 paid weeks. Across the EU, holiday pay must reflect normal pay including commission, with national rules on how. In the US there is no federal holiday pay requirement, so it depends on state law and your policy.

Do we have to capitalise sales commission?

Under IFRS 15 and ASC 340-40, commission that is incremental to winning a contract is capitalised and amortised if you expect to recover it, unless the amortisation period would be one year or less. Private companies under other frameworks may differ, so confirm with your auditor.

How do we reconcile commission with payroll?

Compare the total of approved statements, the payroll file and the ledger every period, per employee and in total, and explain each difference before the next close. Keep the approved statements and the file as sent.

Sources

• Cornell Law School LII: 26 CFR 31.3402(g)-1, supplemental wage payments
• EY Tax News: 2026 federal and state supplemental withholding rates (9 January 2026)
• Social Security Administration: Contribution and benefit base
• California Labor Code section 2751
• legislation.gov.uk: Employment Rights Act 1996, section 27
• legislation.gov.uk: Income Tax (Earnings and Pensions) Act 2003, section 62
• GOV.UK: Rates and thresholds for employers 2026 to 2027
• GOV.UK: Expenses and benefits: bonuses and PAYE and payroll for employers
• GOV.UK: Holiday pay and entitlement reforms from 1 January 2024
• Brodies: Holiday pay must include results-based commission (British Gas v Lock, 2016)
• Court of Justice of the EU: Press release on case C-539/12 Lock (22 May 2014)
• IFRS Foundation: IFRS 15 Revenue from Contracts with Customers, paragraphs 91-94 and 99
• PwC Viewpoint: TRG paper on incremental costs of obtaining a contract (ASC 340-40)