Commission dashboards

Commission dashboards
that show each rep how the number was built.

We design and build commission dashboards and commission reporting for sales reps, sales managers and finance. Sales reps see quota attainment, earnings and what the next deal pays. Managers see the team. Finance sees expense, accruals and payout status. We build in your ICM platform or BI tool, from over a decade inside ICM systems.

Why commission reporting fails the people it pays.

Most commission disputes start with a sales rep who can't see how a number was calculated. The math is usually right. The rep just can't see it.

01

A total with no deal data behind it

A commission statement that shows $14,200 for the month and nothing else invites a dispute. The sales rep wants to see which deals were credited, at what commission rates, with which split credit, and whether an accelerator applied. Without deal-level lines, every question goes to the comp admin, who answers it by hand.

02

Payouts changed with no explanation

A deal gets re-credited after a territory fix, or a clawback hits when a customer cancels in month four. The rep's earnings drop and the dashboard shows only the new total. A good commission dashboard shows that the payout changed, which plan rule applied and the effective dates, so reps understand the adjustment before they open a ticket.

03

One report for every audience

Reps, sales managers and finance ask different questions, and a single report built for the comp admin answers none of them well. Reps need their own attainment and pay. Managers need team performance and the distribution under it. Finance needs commission expense, accruals and payout status by pay cycle.

04

Earned, approved and paid look the same

Many organizations show one commission amount per rep. The rep can't tell whether a commission is earned but waiting on invoice, approved for the next payroll or already paid. The payment trigger creates that gap. The dashboard has to show where each amount sits, and when it will be paid.

05

Commission payouts that lag the deal

If the dashboard refreshes only after period close, sales reps keep shadow spreadsheets to track earnings in between. Those spreadsheets become the version they trust, and every difference turns into a dispute. Daily refresh, or real time visibility for short cycles, keeps the official number the one reps use.

06

Data accuracy problems put in front of the field

A dashboard shows every data error to the person most likely to notice it. Missing splits, wrong territory assignments and stale quotas show up first in a rep's view. Fix data accuracy before launch, or the dashboard becomes the place reps go to find mistakes.

How we build a commission dashboard.

We design from the questions each role asks and build on the calculation your ICM platform already runs. The dashboard reads the results and never recalculates them.

Step 01

The questions each role asks

We sit with sales reps, sales managers, sales ops, the comp admin and finance. We collect the questions behind last quarter's disputes and the ones people ask every month-end. Each role gets a short list, and each question on it maps to a view, a metric or a drill-down.

Step 02

Metrics and definitions

We define each metric once: attainment, earned, approved, paid, accrued, clawback exposure and draw balance. Each definition names its source, payment trigger and effective-date logic. This is where we write down that a deal closes in the CRM but earns nothing until it invoices.

Step 03

Commission tracking from deal data to payout

We connect each payout line to the deal, the credit rule and the commission rate that produced it. Splits, accelerator tiers and adjustments carry reason codes showing the rules applied. That trail lets a rep trace a number in two minutes instead of filing a dispute.

Step 04

Commission tracking software or a BI tool

Most commission tracking software has native rep dashboards and commission statements, and we use them where they fit. Manager and finance views often need CRM or ERP data the ICM platform can't see, so those may sit in your BI tool. Managers get performance insights on the team, so sales management can make informed decisions about coaching and deal focus from the same numbers. We document which view lives where and why.

Step 05

Testing against real statements

Before launch we check every dashboard against closed periods. Totals must tie to payroll, and deal lines must tie to the commission statement. Then a few reps and managers use it for a pay cycle, and we fix whatever confuses them.

Step 06

Launch and upkeep

We train admins on how the dashboards are built and how to change them when the plan changes. Reps get a short guide to reading their view. When next year's commission structure adds a measure or changes commission rates, the build notes tell your team what to update.

What you get, and who it is for.

Each engagement ends with dashboards people use, statements that tie to payroll, and notes your admins can maintain.

What you get

Rep dashboards with attainment, earnings, payout status and what the next deal pays

Manager dashboards with team attainment, distribution and earnings by rep

Finance views of commission expense, accruals and payouts by pay cycle

Commission statements with deal-level lines, rates, splits and adjustments

A metric dictionary with sources, payment triggers and effective dates

Build notes so admins can update dashboards when the plan changes

Who it is for

Comp admins answering the same commission questions every month-end

Sales leaders who want managers coaching to sales goals from attainment data

Finance teams reconciling commission accruals to payroll by hand

Companies whose reps keep shadow spreadsheets to track earnings

Teams live on commission tracking software with no useful rep view

RevOps teams rolling out a new plan and expecting a wave of questions

Related revenue analytics and data services.

Dashboards show what the plan paid. These pages cover the analysis above them and the data underneath.

Revenue analytics

Revenue analytics

The hub for analytics over comp and pipeline data, and the two services next to this one.

Revenue analytics consulting

Quota attainment analysis

Sales forecasting

Data and systems

Clean data under the dashboard

A dashboard can't be more accurate than the credits and payouts it reads.

Commission data quality

CRM and ERP integrations

ICM implementation

Further reading

Background

Where commission numbers go wrong, and how calculation gets automated.

Common commission errors

Automating sales commission calculations

Sales commission calculator

Commission dashboard questions.

What is a commission dashboard?

A commission dashboard is a view of what salespeople, a team or the company have earned in variable pay, and why. A sales rep's dashboard shows quota attainment, earnings by deal, payout status and what the next deal pays at the current rate. Manager and finance versions roll the same data up by team, period and pay cycle.

What are commission statements?

A commission statement is the formal record of what a rep earned for a period. It lists credited deals, commission rates, splits, accelerators, adjustments, clawbacks and draw recovery, then the amount paid. The dashboard is the running view during the period. The statement is the record at close.

Can you provide an example of a commission statement?

Take an AE with an 8% base rate and an accelerator to 11% above quota. The statement lists six closed deals and credits $310,000 of new ARR against a $300,000 quarterly quota. It pays 8% on the first $300,000 and 11% on the last $10,000. A $1,200 clawback for a customer who canceled comes off, for $23,900 paid. Each line shows the deal, the rule and the amount.

What is commission reporting?

Commission reporting covers every report built on commission data: rep statements, manager rollups, accrual and expense reports for finance, and audit reports showing which rules applied. Good commission reporting lets anyone trace a payout back to the deal and the plan rule that produced it.

How do you prepare a sales commission report?

Start from the audience. For a sales commission report going to finance, pull credited transactions and payout lines for the period from your ICM system. Group them by rep, plan and pay cycle, then reconcile the total commission to payroll and the accrual. For reps, show the same lines deal by deal. Never rebuild the calculation inside the report.

How do you keep track of sales commissions?

Use the ICM platform as the system of record for calculations and give reps a dashboard on top of it. Track earned, approved and paid separately, because payment triggers put time between them. A spreadsheet works for a few reps on one flat rate plan. It stops working once you have splits, accelerators or clawbacks.

What is the best software for tracking sales commissions?

The one that handles your plan rules and that your admins can maintain. Plan complexity, data volume, CRM and ERP integrations, and how much you want sales reps to see all matter when you choose sales compensation software. We work on 13 platforms and don't rank them. We can help you test your real plan against the shortlist before you sign.

Can a commission dashboard calculate commissions?

It shouldn't. The ICM platform should calculate commissions and keep the audit trail. The dashboard reads the results. When a dashboard recalculates, it eventually disagrees with the commission statement, and sales reps stop knowing which number to believe.

What are the benefits of a commission dashboard?

Fewer disputes, less admin time at month-end and faster approval, because managers see what they are signing off. Sales reps can track earnings against target without a shadow spreadsheet. Managers can see sales performance across the team, and finance sees commission expense and payouts by period without asking for an export.

What should a sales dashboard look like?

It should answer the viewer's top questions on one screen without a filter. For a rep that means where they stand against quota, what they've earned, what's pending and what the next deal pays. Add a drill-down to deal data for the detail. Leave out metrics nobody acts on.

What are the three types of dashboards?

Operational, analytical and strategic is the usual split. In comp terms, rep and admin views are operational. Plan health and attainment distribution views are analytical. The finance and executive view of commission expense against revenue is strategic. Each needs a different refresh rate and level of detail.

How quickly should a commission dashboard update after a deal closes?

Daily is enough for most plans. Reps mostly need to see that a closed deal was credited, and what it's worth, before the next one closes. Real-time updates matter more for short sales cycles and SPIFs, where reps act on the number within days. Faster refresh doesn't help if the payment trigger is invoice and the invoice lands weeks later.

Do commission dashboards reduce disputes?

They reduce disputes that come from not seeing the math, which in many organizations is most of them. When a rep can see the deal, the credit, the rate and the rule applied, they check it themselves. The disputes that remain are usually about plan rules or data errors, and those need fixing at the source.

What are the emerging trends in commission dashboards?

Earnings estimators that show sales reps what a pipeline deal would pay, discount modeling that shows how a pricing change moves the commission amount, AI assistants that answer plan questions in plain language, and comp visibility for CSMs, SEs and other roles outside the core sales team. Each one depends on clean deal data and plan rules documented well enough to explain.

Tell us what your reps keep asking.
We will tell you what it takes to answer it.

Bring a recent commission statement, a few disputes from last quarter and a list of the systems your data comes from. We'll show you what each role should see.

Start a conversation