How to Reconcile Bonus or Commission Calculations to Your Books

Bonus and commission entries are among the most common sources of payroll errors and overstated costs I see in small business books. The calculations happen in a spreadsheet or an operations system, someone posts a journal entry, and nobody checks whether the number actually matches what was earned.

When the reconciliation step is skipped, you end up with liabilities on your balance sheet that nobody can explain, bonus expenses that do not match what employees were actually paid, and payroll remittances that are off. These errors compound over time and are painful to unwind during a year-end review or an audit.

Why This Is Harder Than It Looks

The challenge with bonuses and commissions is that they live in multiple places at once. The commission calculation might happen in your CRM or your operations software. The payment runs through payroll. The accrual sits on your balance sheet. And the expense lands in your income statement.

Each of those touchpoints involves a different person or system, and they do not automatically stay in sync. If the commission rate changes mid-period, or a deal is reversed after it was already credited, or payroll is processed before the final numbers are confirmed, the entries stop agreeing with the source data. Nobody notices until there is a discrepancy at year-end that requires several hours of forensic work to trace.

The Reconciliation Framework

A reliable commission and bonus reconciliation has four checkpoints.

Checkpoint one: tie the calculation to the source transaction. Every commission or bonus earned should trace back to a specific revenue transaction, a closed deal, a completed milestone, or a defined performance result. If the source transaction is in your CRM or operations software, export it. The dollar amount sitting in your commission payable account needs to connect to a specific observable event, not just a formula output.

Checkpoint two: confirm the rate or formula has not changed without a matching update in the books. Commission structures change. Rate tiers get updated, deal categories get reclassified, and special arrangements get made. Every time a rate changes, the accrual methodology needs to reflect it. Pull the commission agreement or the most recent compensation memo and confirm it matches what is being calculated.

Checkpoint three: reconcile the accrual balance to the amounts actually paid through payroll. Your commission payable account is a liability. Every time you pay out commissions through payroll, that balance should decrease. At the end of each period, the remaining balance should represent only the amount earned but not yet paid. Pull the payroll detail for the period and confirm the remaining liability balance makes sense.

Checkpoint four: verify the payroll tax treatment is consistent. Bonuses and commissions are employment income. They attract CPP, EI, and income tax deductions. If the payroll provider does not know that a payment is a bonus, it may be taxed differently, which can result in under-deductions that create employee tax surprises at filing time. Confirm with your payroll provider how each payment type is coded.

An Illustrative Example

A small distribution company paid quarterly commissions based on gross sales. Their operations team calculated commissions in a spreadsheet and emailed the totals to their bookkeeper, who posted the journal entry. The problem was that the spreadsheet was updated occasionally after the email was sent, when deals were revised or credits were issued, but the books were never corrected to match the final version.

Over four quarters, the commission liability on the balance sheet was overstated by about $8,000 because credits applied after the initial posting were never reversed. The overstatement did not affect cash, because the payroll amounts were correct, but it produced inflated commission expense in the income statement and a mystery liability that made the year-end balance sheet harder to close cleanly. Two hours of reconciliation work at each quarter-end would have prevented a full day of cleanup at year-end.

What to Do About It

1. Establish a source document requirement. No commission or bonus entry gets posted without a supporting report or calculation that can be tied to source transactions.
2. Build a monthly or quarterly reconciliation into your close checklist. The commission payable balance should be explained line by line at each close: who earned what, when it was earned, and when it was or will be paid.
3. Create a communication workflow between whoever calculates commissions and whoever does the bookkeeping. If numbers change after the initial calculation, there needs to be a defined process for issuing a corrected figure and ensuring the books reflect it.
4. At year-end, confirm the commission payable balance agrees to amounts that are actually owed and unpaid. Any balance that cannot be explained by a specific unpaid obligation should be reversed.
5. Ask your payroll provider to confirm how bonus and commission payments are coded in the payroll system so the tax treatment matches CRA requirements.

Commission and bonus reconciliation is unglamorous work, but getting it wrong creates real errors in your financial statements and real surprises in payroll. If your books have accumulated unexplained liabilities or your year-end keeps surfacing commission discrepancies, this is worth fixing at the process level. Book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.