A renewal commission is a different question

A customer signs for three years. A rep earns a commission. Three years later the customer renews, and a rep earns another one.

Those two payments look identical on a payroll run. Whether they are the same thing for accounting purposes is a question your policy has to answer, and the answer changes the schedule, the carrying balance, and what happens on termination.

This article is about the systems consequences of that answer, not about which answer is right.

The two shapes

Renewal commissions are commensurate with the original. If a renewal earns roughly the same rate for roughly the same work, the argument that the original commission was buying the whole customer relationship gets weaker. Each commission relates to its own term.

Renewal commissions are not commensurate. If the renewal earns materially less, the original commission looks like it was acquiring something that extends past the initial term, and a longer benefit period follows.

That is the actual question, and it is one your accountants answer by looking at your commission plan. What the systems side has to do is make the answer applicable: distinguish the two kinds of commission, apply a different period to each, and keep both reconciling to the same contract.

What has to be distinguishable

Three things, none of which a payroll feed carries.

Which contract it relates to. A commission on a renewal of contract 4471 needs to point at contract 4471, not just at a period and a rep. Without that link there is no way to ask what the total capitalised cost of a customer relationship is.

Whether it is new or renewal. This is a property of the deal, known at the time, and almost never recorded on the commission record because nobody needed it there before.

What rate it earned relative to the original. The commensurate test needs both numbers. If the original commission's rate is not retrievable at renewal time, the test cannot be applied without going back through history.

Where the mechanics get awkward

Two schedules, one customer. An original commission on a 48 month benefit period and a renewal commission on its own period will overlap. Both are amortising at once, against the same customer, in the same months. That is fine and expected, and it means the balance for that relationship is the sum of two schedules rather than one.

Termination hits both. If the customer leaves during the overlap, both remaining balances are affected. A workbook that handles one schedule per customer will handle this incorrectly, usually silently.

Rate changes over time. Commission plans change annually. The rate that applied to the original deal in 2024 is not the rate on the renewal in 2027, and comparing them requires knowing what the plan said in each year. That is another piece of effective-dated data.

The structural requirement

Commissions attach to a contract, contracts belong to a relationship, and each commission carries its own period and its own schedule. The relationship-level balance is derived by summing, not maintained separately.

That structure answers all three of the awkward cases without special handling. Two schedules overlapping is just two records. A termination applies to every open schedule under that relationship. Rate history is a property of the plan, dated.

It also answers the question an auditor is most likely to ask, which is not about any of the above. It is: show me how you determined the benefit period for this commission, and show me it applied consistently to others like it. That is a query over structured data or it is an afternoon of reconstruction.

What to do first

Do not start with the schedule. Start with whether your commission records can even tell you which payments were renewals. If they cannot, no policy on renewal treatment is applicable, however carefully it is written, and that is the gap to close before anything else.