Commission accounting covers how companies capitalize the incremental cost of winning a contract under ASC 340-40, amortize it over the benefit term, and post the resulting journal entries. The difficulty is keeping the CRM, the waterfall and the ledger in agreement each time a deal changes.
Most growing companies run commission accounting out of a single workbook. One tab holds new bookings, another holds amendments, a third carries the amortization waterfall, and underneath it sits a macro nobody has opened since the analyst who wrote it moved to another role. Each month someone exports deals from the CRM, pastes them in, and hopes the totals agree with the general ledger.
The trouble starts when something changes. A contract gets amended mid-term, a rep leaves and a clawback applies, or a renewal extends the benefit period. Each change forces a recalculation that ends with a journal entry someone keys in by hand, and the file and the ERP get updated at separate times, often by two people.
Over a few months, those two records drift. The next month-end close opens from two versions of the same number, and its first days go to chasing a difference nobody can explain quickly. Nominal gives the recalculation, the posting and the tie-out to an accounting agent that finishes the work and shows how it got there.
Why Commission Accounting Breaks At Month-End
The accounting itself is well defined. The breakage comes from how many systems the answer depends on, and from how often the inputs move after a deal is booked.
The Waterfall Lives Outside The System Of Record
Under ASC 340-40, the incremental cost of obtaining a contract, which for most companies means sales commissions, is capitalized and amortized over the expected term of benefit. That window often includes anticipated renewals, so a single payout can spread across several years. When the amortization period is a year or less, companies can elect a practical expedient and expense the cost as incurred.
Tracking the release of that cost means maintaining a waterfall: every capitalized payout, its start date, its benefit term, the monthly charge it produces, and the remaining asset. The ledger usually holds one or two summary balances. Everything underneath them lives in the spreadsheet, which is why one analyst tends to become the only person who can explain the number.
Every deal change ripples forward
Commission plans rarely stay still for a full quarter. An upsell adds a new capitalized cost with its own term. A cancellation may bring a clawback, which reduces the asset and can require an impairment review of what remains. Territory changes move payouts between reps after the original entry already posted.
Each of those events revises the schedule from that month forward, and some reach back into prior months too. Someone has to find the affected rows, recalculate the remaining amortization, compare the new totals with what already sits in the general ledger, and book the adjustment.
Journal Entries a Single Payout Generates
A capitalized payout produces at least three kinds of postings over its life, and each one depends on the state left by the month before.
Across a full sales team with frequent amendments, the posting count grows faster than the headcount that maintains it.
Recommended read: How to Scale Finance Operations Without Adding Headcount: Data-Driven Insights from 50 Million Transactions
Where the Workbook and the ERP Drift Apart
The drift has a predictable cause. The spreadsheet gets updated when the analyst processes the deal file, and the journal entry gets posted when someone finds time to key it in, often days later and sometimes in a different amount after a late correction.
By the time the next period opens, the prepaid commission balance in the ERP no longer ties to the waterfall. The difference is usually small, which is exactly why it survives. It gets carried forward, explained with a note, and investigated properly only when an auditor asks for the rollforward.
The underlying task is holding two records in step while both keep moving, then documenting why they tie. Accountants recognize that shape from every tie-out they have ever prepared.
If this is one of several schedules your team rebuilds by hand each month, the Automate Reconciliation, Consolidation & Close one-sheet covers how agents take on that work. Nominal connects at the data layer, so it works with the ERP already in place.
How an Accounting Agent Carries the Commission Schedule to Sign-Off
Nominal performs this work from the deal file through to a tied-out schedule and a prepared entry awaiting approval. Before anything goes live, Deployed Finance Engineers encode the company's own commission policy, including capitalization rules, benefit terms and clawback treatment, from its written procedure.
The team supplies the accounting judgment, and the engineers turn it into standing instructions.
Reading the Deal File and the Ledger Together
The monthly run begins with the CRM export and the current capitalized balance from the ledger. New and changed deals are matched against the prior month's records, much as transaction matching pairs bank lines with book activity, so an amendment or a revised rep split becomes a change to process.
Recalculating Amortization From the Prior State
For every affected contract, the agent starts from where the schedule stood at the end of last period, applies the change, and recalculates the remaining charge for each future month. Where the change reverses a payout already booked, the capitalized asset and the expense still to be released come down together.
Changes that fall outside the written policy, such as a clawback on a contract already fully amortized, go to a reviewer with the proposed treatment and its calculation attached. Everything else in the run keeps moving.
Updating the Worksheet and the ERP at the Same Time
Once a reviewer approves the recalculation, the agent updates the waterfall in the worksheet and posts the adjusting journal entry to the ERP in the same step. Both records change together, so the next cycle opens from one number instead of two.
Keeping a Changelog an Auditor Can Follow
Every run leaves a changelog showing which deal moved, what the prior amortization looked like, what the new calculation produced, who approved it, and when it posted. Audit trails are expected of any accounting software, and this one covers the recalculation itself, on a schedule that previously existed only inside the workbook.
The approach mirrors how agentic reconciliation carries balance sheet accounts to sign-off, with a tied-out workpaper, a prepared entry, and the evidence attached to both.
Helpful resource: Balance Sheet Account Reconciliation: Why Your Workpaper and Your Ledger Stop Agreeing
What to Ask Before Replacing the Commission Workbook
Whether the answer is Nominal or another close management option, a few questions separate tools that finish commission work from tools that only track it.
- Can it recalculate the amortization after a mid-term amendment without someone rebuilding rows?
- Does it update the worksheet and the ledger together, or leave the posting to a person with a keyboard?
- What happens to a clawback that the written policy does not cover?
- Can an auditor trace one expense line back to the deal that created it?
- Who encodes your capitalization policy, and how long until the first period runs?
From One Analyst's File to a Close the Team Can Defend
Commission accounting keeps getting harder as plans add accelerators, multi-year terms and more frequent amendments. Teams that move the recalculation, the posting and the tie-out to an accounting agent get the analyst's time back for reviewing plan changes before they take effect and for the judgment calls that need a person.
Each month then ends with a waterfall that ties to the ERP, a posted entry a reviewer approved, and a changelog that explains every movement. That is the artifact the next close opens from, and the one an auditor can follow from the ledger back to the original deal.
See your own commission schedule carried to sign-off. Book a demo and bring the workbook your team rebuilds by hand. Nominal's finance engineers can show how your written policy becomes an agent that does the recalculation and tie-out each month.
About the writer
