Sales Commission Tracking & Payouts

Effective-dated rates, a calculation anyone can trace, monthly reconciliation, clear statements, clean payroll handoffs, clawbacks and a fair dispute process, so every seller is paid the right commission on time.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Sales Commission Tracking & Payouts, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

210

Starter tasks

💼 Sales & Revenue

Sales Commission Tracking & Payouts

Calculating earned commission each period, reconciling it with closed deals, publishing statements to reps and resolving disputes quickly and transparently.

  1. Commission process map with named owners
  2. Signed plan acknowledgements for every rep
  3. Effective-dated rep and rate master table
  4. Commissionable deal definition mapped to system fields
  5. Commission calculation workbook build
  6. Commission calendar of cut-offs and pay dates
  7. Deal split and crediting rulebook
  8. Approval chain and separation of duties
  9. Twelve-month payout history reconstruction
  10. Commission FAQ page for reps
  11. Monthly commission close checklist
  12. Bookings reconciliation between CRM and billing
  13. Monthly commission statements to every rep
  14. Commission dispute and query log
  15. Payroll handoff and variance check
  16. Monthly commission accrual for the accounts
  17. Cancellations and clawback ledger
  18. Cash collection check before releasing commission
  19. Quarterly tier and accelerator true-up
  20. Draw and advance balance tracking
  21. Quarterly commission spot audit
  22. Reading your commission plan like the payroll team
  23. Tiered and capped commission formulas in spreadsheets
  24. Commission accounting under revenue standards
  25. How commission is taxed and withheld in payroll
  26. Commission software administration skills
  27. Explaining a commission statement in five minutes
  28. Recurring revenue commission maths
  29. Spreadsheet or commission software decision
  30. Cutting days from close to payout
  31. Pre-calculation data quality checks
  32. Manual adjustment and exception rule
  33. Calculation error log and root causes
  34. Securing commission files and pay data
  35. New plan year load and test
  36. Year-end true-up and final annual payout
  37. Parallel run before switching commission systems
  38. Audit or due diligence commission evidence pack
  39. Mid-period plan or territory change cutover
  40. Paying your first commissioned salesperson
  41. Final commission settlement when a rep leaves
  42. Ramp guarantees and draws for new hires
  43. Commission during a leave of absence
  44. Personal commission shadow tracker for reps
  45. Taking over commission admin mid-year
  46. Paying agents, resellers and contractor sellers
  47. Multi-currency commission conversion rules
  48. Capitalised commission amortisation schedule
  49. Payout curve analysis for the plan designers
  50. Commission law compliance review

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Commission process map with named owners

This is a team plan, best installed into a shared workspace so everyone with a role in it can see and own their tasks. Commission often gets paid through a chain of favours: a sales manager exports deals, someone in finance types numbers into a spreadsheet and payroll pays whatever arrives.

First tasks

  • List every person who touched last month's commission run and what they did
  • Draw the steps from closed deal to payslip on one page
  • Name an owner and a backup for each step
  • Walk the sales leader and finance lead through the map and record their agreement
  • Check the named owners on the process map are still in post @recurring(quarterly)

Signed plan acknowledgements for every rep

Before anyone can calculate commission with confidence, each rep needs a current plan document they have signed, with their own rate, quota and territory attached. Missing signatures turn every later dispute into an argument about what was promised, and in some places a signed written commission agreement is a legal requirement.

First tasks

  • Export the list of everyone paid commission in the last 12 months
  • Match each person to the plan version they signed and its date
  • Send the current plan for signature to anyone without one on file
  • File signed copies in a restricted folder named by rep and year
  • Confirm every active rep has signed the current year's plan @recurring(yearly)

Effective-dated rep and rate master table

Rates, quotas, managers and territories change mid-year, and a calculation that only knows today's values will pay March deals at July's rate. A master table where every row carries a start and end date lets the calculation look up the right rate for the date a deal closed, and leaves an audit trail of every change.

First tasks

  • Create the master table with start and end date columns for every value
  • Enter each rep's changes from the last 12 months from signed plans
  • Run a check for overlapping or missing date ranges per rep
  • Agree who approves new rows before they are added
  • Compare the table with HR's list of starters, leavers and movers @recurring(monthly:26)

Make it yours.

Install Sales Commission Tracking & Payouts, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.