A commission ledger for the owner and the sales manager. Enter each sale — the rep, the job, the amount and the rate — and it works out the commission exactly, to the cent. Set a rep's usual rate once and it fills itself in. Each rep has a running owed and paid total, a commission can be marked paid, and the whole ledger exports to a spreadsheet for your accountant. Admins keep it; sales managers can read it under Accounting → Sales payouts; sales reps never see it.
Also called: commission tracking · commission sheet · sales commissions · rep commissions · what do I owe my reps
Worked out to the cent, the same way every time
Money is kept in whole cents and rates as exact percentages, and there is one rounding rule — half up to the cent, the way a person with a calculator expects. 8.5% of $41,237.50 is $3,505.19, on every screen and in every export.
Whether $3,505.1875 becomes .18 or .19 depends on which cell rendered it, and the rep notices before the accountant does.
Somebody's pay should be decided in one place, not by whichever screen happened to show it.
Owed and paid, per rep
Each rep carries a running owed and paid total. Mark a commission paid when it goes out; set a rep's usual rate once and new sales pick it up. A rate change applies to new sales only, so a commission already agreed never moves underneath anyone.
Changing a rep's rate in a spreadsheet quietly rewrites every row that formula touches, including the ones already paid.
An agreed number should stay agreed.
The reps never see it
Admins keep the ledger and sales managers can read it; sales reps cannot open it at all — the request is refused, not just the tab hidden. It sits under Sales payouts in Accounting, next to invoices and crew payouts.
A shared commission sheet is one forwarded link away from every rep comparing numbers.
Hiding a tab is decoration; refusing the request is a rule.
- 1Open Accounting → Sales payouts.
- 2Add a sale: pick the rep, the job and the customer, and enter the sale amount and the rate. A rep's usual rate fills in if you set one.
- 3The commission is worked out once, in whole cents — 8.5% of $41,237.50 is $3,505.19, every time.
- 4Each rep shows what is owed and what is paid; mark a commission paid when it goes out.
- 5A paid commission's numbers are frozen — to change them you mark it owed again first. Paid commissions can be voided, never deleted.
- 6Export the ledger to a spreadsheet for your accountant.
Commissions were living in a spreadsheet next to the software, where a formula can be overwritten, a row can be changed after it was paid, and the sheet is one share-link away from the whole sales team. This is somebody's pay, so the arithmetic is done once, in whole cents, with one rounding rule an accountant can reproduce. A rate change applies to new sales only — changing a rep's usual rate never reprices a sale already in the ledger — and a paid commission's numbers are frozen: to change them you mark it owed again first, and it can be voided but never deleted. The reps are kept out by the server, not just by a hidden tab.
- Commission tracking in a spreadsheet anyone can edit
- Rounding disagreements between the sheet and the accountant
- A paid commission's numbers changing by accident
