Sales Commission Ledger
Log sales commissions with status, totals, and a 12-month chart.
Overview
The Sales Commission Ledger is the place where every commission you earn gets logged, tracked through its approval cycle, and reconciled against the payout that eventually hits your account. For independent reps, agency partners, and salaried reps with variable compensation, the gap between closing a deal and being paid the commission is full of failure points: incorrect rates, deals that are credited to the wrong rep, payouts delayed by clawback policies, and disputes over recognition timing. A ledger turns that ambiguity into evidence.
Each entry records the deal name, the customer, the close date, the deal amount, the commission rate, the calculated commission, the payment status (Pending, Approved, or Paid), and notes. The dashboard summarises total deals, total deal value, total commission earned, the breakdown by status, and a 12-month chart that shows trend over time.
How it works
You add a commission by entering the deal name, customer, close date, deal amount, and commission rate. The ledger calculates the commission automatically, then waits while you move the status from Pending to Approved (once your finance team signs off) and finally to Paid (when the payout lands). You can edit any entry as the deal evolves or as adjustments are made.
The dashboard at the top of the page totals everything in scope and groups by status, so you always know how much commission has been earned but not yet paid. The 12-month bar chart compares months side-by-side so you can spot seasonality, momentum, and quarter-end spikes.
Examples
- Independent contractor. Track ten deals across three months, see that two are stuck in Pending, and follow up with the customer's account team for sign-off.
- Partner channel. Log every customer-paid invoice that triggers a partner commission and reconcile the quarterly payout against the ledger total.
- Variable compensation rep. Compare commission earned against your annual target by status to see how much is at risk in the Pending bucket.
- Dispute defense. When finance questions a payout, point them to the ledger entry with the deal amount, rate, and close date that justifies it.
FAQ
How is the commission calculated?
Deal amount multiplied by the commission rate. Tiered structures should be entered as the effective rate for that deal.
What does Approved mean?
The deal has been recognised by your company and the commission is locked in, but the payout has not landed yet.
How are clawbacks handled?
Edit the original entry to reflect the adjustment, or add a negative entry with a note referencing the original deal.
Can I track team commissions?
The ledger is personal; for team rollups, run a separate ledger per rep.
Does the 12-month chart reset annually?
The chart is a rolling 12-month view, so it always shows the most recent year of activity.