How to Track Your Sales Commissions (Without Getting Shorted)

If you sell for a living, you already know the feeling: a commission check lands, the number looks a little light, and you have no solid way to prove it. You think that roof job should've paid more. You think there was a second draw on the kitchen remodel. But “I think” doesn't win that conversation with your manager or your office.

The reps who consistently get paid right aren't the ones with the best memory. They're the ones who track every deal, every rate, and every payment as it happens — so when a number looks off, they've got receipts. Here's how to actually do that, whether you want to keep it simple with a spreadsheet or hand the whole thing off to software.

Why tracking commissions is harder than it should be

Commission math looks easy on paper: contract value times your rate. In real life it falls apart fast.

You close deals all week, so no single job has your full attention. Payments trickle in — a deposit here, a progress draw there, a final check weeks later — and it's easy to lose track of which jobs are fully paid and which still owe you. Splits, overrides, and tiered rates make the math different on every deal. And most of the tools out there are built for sales managers who want to watch a whole team, not for you, the individual rep who just wants to know what you're owed.

So the job that falls through the cracks isn't selling. It's keeping score.

What you actually need to track

You don't need to track everything — you need to track the handful of things that decide your paycheck. For every deal, capture:

• The job — client name or address, and what it was (roof, remodel, solar, whatever you sell).
• Contract value — the total price the customer signed for.
• Your commission rate — the percentage you earn on it.
• Your split, if you share the deal with anyone.
• What you've been paid so far — every deposit, draw, and final payment as it lands.
• The date — so you can spot a payment that's gone quiet.

From those, two numbers matter most: your commission owed(contract × rate × split) and what's still outstanding(owed minus paid). If you always know those two, you'll never get quietly shorted again.

Method 1: The commission tracking spreadsheet

The simplest way to start is a spreadsheet, and it costs you nothing. One row per job, columns for the fields above, and a couple of formulas that do the math for you.

You can build one yourself, or skip the setup and use our free commission tracker template — it's an Excel and Google Sheets file that already has the formulas in. You type in the contract value, your rate, and what you've been paid, and it works out your commission, what's still owed, and whether each job is Paid, Partially paid, or still Open. There's a running total at the top so you can see, at a glance, how much money is still out there with your name on it.

A spreadsheet is honestly enough when you're doing a handful of deals a month. It's yours, it's free, and it's a huge step up from tracking commissions in your head or on the back of a work order.

Method 2: Software that tracks commissions for you

The spreadsheet starts to strain once your volume climbs. More jobs, more partial payments, more pay periods to reconcile — and the formulas you set up in January quietly break, or you forget to log a payment, and you're back to guessing. That's the point where dedicated software to track commissions earns its keep.

A tool like SaleTrakk does the same core job — logging deals, recording payments, and showing what you're owed — except automatically, and it can't “break.” You log a job in a few seconds, record payments as they come in, and it keeps your commission owed and outstanding balance current in real time — on your phone, in the field, the moment a deal closes. It's built for the individual rep tracking their own pay, not for a manager watching a team, so there's nothing to fight through.

The honest trade-off: a spreadsheet is free but manual, and it leans on you to keep it tidy. Software costs a little (SaleTrakk is $9.99/month) but removes the busywork and the risk of a formula quietly going wrong on the deal that mattered.

The best way to track commissions: start simple, upgrade when it hurts

Here's the straight answer. If you're doing a few deals a month, start with the spreadsheet — it's free and it works. The important thing is that you start now, because the money you can't prove you're owed is money you quietly lose.

When tracking by hand starts eating real time, or you catch yourself unsure whether a job's been paid, that's your signal to move to software. Not before. Don't overbuy a tool for volume you don't have yet — but don't keep wrestling a spreadsheet that's clearly outgrown you either.

Three mistakes that cost reps money

1. Tracking in your head.Memory is the first thing to go when you're busy closing. If it's not written down, it didn't happen — and you can't dispute a short check you didn't see coming.
2. Only logging the sale, not the payments. The sale is when you earn it. The payments are when you actually get it. Track both, or you'll never notice the draw that never showed up.
3. No date on anything.Without dates, you can't tell a slow payment from a missing one. A commission that's 60 days late looks identical to one that's just late — unless you wrote down when it should have come.

Bottom line

Getting paid right isn't about working harder or remembering more. It's about keeping a simple, honest record of what you sold, what you're owed, and what's actually landed — so the moment a number looks off, you can point to exactly why.