Skip down to the research record

Commission accrual: 3 mistakes before quarter-end close

Quota Forecast Editorial Team · Published · 11 min read

Commission accrual mistakes include booking the full amount too early, accruing after earning stops, and carrying liabilities for commission not yet earned.

Key takeaways

  • Confirm the earning trigger against the plan document.
  • Check that the schedule stops when earning stops.
  • Reconcile earned commission, payments, and the remaining liability.

It looks like a simple lookup, but the figure depends on the accrual logic behind it, and that logic is where errors can hide. A figure that is too high overstates what the company owes. A figure that keeps growing after the plan has stopped earning it is wrong in a different way, and neither problem is visible in a total alone.

As the revenue leader, your job is to give finance a figure you can explain line by line. That means knowing the trigger, the monthly amount, the stop point, and the balance for each rep, not only the total.

This post walks through three accrual mistakes, using worked examples from Performio's guide to accrued commission errors. Treat the examples as a test for your own process. They show the arithmetic and the logic, but they do not replace your plan document, which decides what is earned and when.

This post stays with the mechanics: the trigger, the schedule, the stop point, and the reconciliation.

How to read the examples

Check each example in Performio's guide against the applicable plan. The first starts with a rep who closes a $120,000 annual deal with a 10% commission, which is a $12,000 commission. The second describes a $12,000 annual commission accrued monthly at $1,000 and looks at the point where the rep has earned $3,000. The third reaches six months and says $6,000 has been earned and paid.

In the first, $120,000 is the deal and $12,000 is the commission on it. The $1,000 is the amount the plan earns each month. In the second, $3,000 is the amount earned at the point where accrual stops. In the third, $6,000 is earned and paid after six months, and a further $6,000 is an obligation the guide says has not been earned yet.

Use your plan to decide which amounts apply. Confirm the earned amount and remaining liability for the period you are reviewing.

Booking the full commission when the deal closes

Under a plan that earns commission monthly, booking the full commission at deal close records a liability before the plan has earned it. In Performio's first illustration, the plan pays commission monthly as revenue is recognized, meaning $1,000 should be earned and accrued each month. That is the pattern the plan describes. At $1,000 a month, the accrual reaches $3,000 after three months, the same earned point the second illustration uses.

The wrong logic looks different. If the accrual assumes the full commission is earned at deal close, the system records a $12,000 commission liability immediately, even though only $1,000 has actually been earned under the plan. The gap between the recorded liability and the amount earned is liability the plan has not yet earned, and it sits on the books from the moment of close. An overstated accrual means the books show a larger obligation than the plan supports, which is why the trigger is the first thing to check.

The deal is the visible event, which makes it tempting to treat as the trigger. A deal closes, and the full commission is a clean number to enter. That is why the accrual trigger needs a deliberate check rather than an assumption.

The fix starts with a question: which event creates the liability? Ask the person who builds the accrual to name that event in writing. If the answer is "the deal closed," go back to the plan document and check whether it says commission is earned at close or as revenue is recognized. The plan's wording decides the trigger. The size of the deal does not.

Then check the monthly figure. The $1,000 in the illustration follows from the plan's monthly timing. A schedule that spreads the annual amount evenly across the year is not the same thing as one that follows the plan's timing, so confirm which one you have. For related process checks, see commission automation figures to test.

Accruing after the earned amount stops growing

Once a rep has earned $3,000 in Performio's second illustration, no additional commission should be earned or accrued from that point. The illustration is a rep earning a $12,000 annual commission, accrued monthly at $1,000. After three months, the rep has earned $3,000, and the guide says that amount should be paid and retained.

If the schedule shows more than $3,000 for that rep after three months, the difference above the earned amount is the kind of accrual the illustration says should not exist. Find the entry that created it before the number goes out.

Confirm why earning stops before applying that point to your schedule. The stop condition belongs to your plan document. Before you build an accrual schedule, find the plan language that ends earning, and confirm that the schedule stops adding the monthly amount once that language applies. If you cannot find that language, take the question to the person who owns the plan rather than writing an assumption into the accrual.

A schedule that keeps running past the stop point keeps adding to the liability while the earned amount stays where it is. The two numbers then drift apart. A reconciliation that puts the earned amount next to the accrued balance is a direct way to see that drift before the close.

This is also where a correct monthly figure can mislead. A monthly amount that looks right on its own says nothing about whether the schedule still applies. Check the accrued balance against the earned figure each period, not only once at the start of the schedule.

Carrying a liability for commission not yet earned

In Performio's third illustration, the books still reflect an obligation for commission that has not been earned yet. The guide puts it this way: after six months, $6,000 has been legitimately earned and paid, but the books still reflect an additional $6,000 obligation that hasn't been earned yet.

The two halves of that picture need separate treatment. The first $6,000 has been earned and paid under the plan. The second $6,000 is an amount the illustration describes as not yet earned, so it should not be read as earned money. A single combined balance hides that difference, which is why the split matters.

A reconciliation catches this kind of error. For each rep, put three figures side by side: the amount earned to date, the amount paid, and the balance still on the books. In the illustration, earned and paid after six months is $6,000, so a balance that still carries another $6,000 of obligation stands out when the figures sit together. Run the comparison before the close, not after finance asks why the number moved. Use the related sales dashboard reconciliation checks when reviewing the reported total.

If the balance does not tie out, do not adjust the balance until it matches the total. Work backward from the earned and paid figures, find where the extra amount came from, and fix that source. Forcing a match leaves the cause in place.

Keep the reconciliation simple. A few columns for each rep can show earned, paid, and accrued side by side, and a reviewer can read them without rebuilding the model. The goal is to make a mismatch visible, not to produce a perfect report.

Today, choose one rep and bring the plan document and accrual schedule to the review below; record any mismatch before changing the balance.

Related guides: Quarter-end bookings: 9 billing and reporting limits · Unsigned quote review: 5 checks for quarter-end records · Accepted quote review: 6 checks at quarter close.

Questions to ask the accrual owner

Before the number goes to finance, ask the accrual owner four questions: what event earns the commission, what amount is earned each period, where earning stops, and how the balance ties to what has been earned and paid.

  1. What is the trigger? The trigger is the event the plan says earns commission. Ask for the event by name and the plan language that says so. In the first illustration, the plan's wording is that commission is paid monthly as revenue is recognized.
  2. What is earned each period? The amount follows the plan's earning schedule. Ask for the amount for each period and how it was derived. In the illustration, that amount is $1,000 a month.
  3. Where does earning stop? Earning stops where the applicable plan says it ends. Ask which plan language ends earning and what the schedule does at that point. In the second illustration, that point is the $3,000 the rep has earned.
  4. Does the balance tie out? Compare the remaining liability with earned commission minus payments. Ask for earned, paid, and accrued figures for each rep. In the third illustration, that comparison is what shows the extra $6,000 still on the books.

A good answer to each question points to plan language, not to habit or a spreadsheet formula. If the answer is that the schedule has always been built a certain way, that does not show it was checked against the plan.

The accrual owner can explain the schedule, but the plan's own terms are what confirm the trigger and the stop point. Bring the plan document to the review as well, and have it open when the questions are asked.

Illustrative example: check the monthly accrual

Suppose a plan earns $1,000 each month. After 3 months, earned commission is $3,000. If payments are $3,000, the remaining liability is $0. Compare that result with the balance on the books, then trace any difference to the earning entries or payments before making a correction.

Check the stop point and remaining balance

Next, take the second illustration. The schedule should show $3,000 earned after three months, and that amount should be paid and retained. If it keeps adding $1,000 past that point, check whether the plan language supports the extra accrual before anything else changes.

Last, take the third illustration's six-month point. Earned and paid should show $6,000, matching the illustration. With $6,000 earned and $6,000 paid, the remaining liability is $0; investigate any remaining balance.

If all three checks pass for one rep, run the same checks across the team. If one fails, find out whether the cause is the trigger, the stop point, or the reconciliation before you change anything. Write down what you found for each check, so the review has a record and the fix stays tied to the actual error.

Once the three checks pass for every rep, the schedule you send finance can be checked against each rep's own plan-derived amounts.

Apply the checks to your plan

The examples do not cover every plan, so treat them as checks rather than rules. Confirm the stop condition and the terms governing any remaining liability before applying the examples. Your plan may have different triggers, different pay timing, or different ending conditions, and it is that plan the accrual has to follow.

When an illustration and your plan disagree, the plan controls the accrual. Write down the difference, ask the plan owner to confirm it, and record the answer for the close.

Send finance a schedule for each rep

Send finance a schedule for each rep, not a single commission total. A single total hides the mistakes described above. If finance sees one number, it cannot tell whether the deal-close trigger was used, whether earning stopped where the plan says it should, or whether earned and paid amounts match the balance. A schedule for each rep makes each of those visible.

A workable layout has one row for each rep and columns for the trigger, the amount for each period, the stop point, earned to date, paid to date, and the accrued balance. Each column answers one of the questions above, so the reviewer can follow the logic without a walkthrough.

Include a short note with the schedule that names the plan document and version the accrual was built from. If the plan changed during the quarter, the note should say when and how the change was communicated. That lets the person reviewing the number trace it back without a meeting.

Expect questions, and answer them with the plan language and the schedule rather than from memory. Before the meeting, sort likely questions into two groups: those the plan answers and those the schedule answers. Where a figure is an estimate, label it as one, so nobody mistakes it for a booked amount.

Mid-quarter plan changes: check the notice rule that applies

Under North Carolina's G.S. 95-25.13, employers are to notify employees in writing at least one pay period before any changes in promised wages.

That rule belongs to North Carolina. Ask counsel whether a commission plan change counts as a change in promised wages. If your team works in other states, check each state's rule separately.

A plan change late in the quarter can raise a timing question for the accrual. The schedule should show which plan version applied to each period, so a reviewer can see the change without reconstructing it. Agree the change date and the notice date with finance before the change takes effect, so the accrual and the notice record use the same dates.

Keep a dated record of each change: what changed, the date it was communicated to employees, and the pay period in which it took effect. That record is what you check when someone asks about notice, and it saves the team from rebuilding events from email.

Sources