Insights / Automation

Automating sales commissions without a spreadsheet

6 minute read · Dellajax

Commission spreadsheets tend to grow one exception at a time until only one person understands them. That is a risk for finance and a source of distrust for sales. Automating commissions starts with writing the plan down precisely.

Define the plan in plain rules

  • Basis: revenue, gross profit, or margin after specific costs
  • Timing: paid when invoiced, or only when the customer pays ("paid on paid")
  • Rates: flat, tiered, or different for new versus existing customers
  • Splits: how credit is shared between reps or teams
  • Adjustments: clawbacks for bad debt, chargebacks for shared costs, draws and guarantees

If a rule can't be written as a sentence, it will break in automation. Resolve it with sales leadership first.

Model it where the data lives

Revenue, cost and payment data already sit in your ERP. Calculate commissions there, or in a tool that reads directly from it, instead of exporting to a spreadsheet:

  1. Tag each transaction with the rep and the plan.
  2. Calculate commission per transaction using the plan rules.
  3. Apply adjustments as separate, labeled lines so reps can see them.
  4. Accrue the expense in the right period.

Statements reps can check

A good statement shows every transaction, the basis, the rate and each adjustment. When reps can trace each number, disputes drop and finance stops spending the first week of the month answering questions.

Tip: run the automated calculation alongside the spreadsheet for two cycles and reconcile every difference before switching over.

Want this done for you?

We build these processes inside your ERP, usually NetSuite. Start with a free 30-minute teardown.