Free Commission Sheet Template | Excel & Google Sheets
Download Free Template
Free Commission Sheet Template (Excel & Google Sheets)
TL;DR: This free commission sheet template is a ready-to-use commission tracking spreadsheet for sales teams of up to 30 reps. Log deals as they close and it calculates every payout automatically, in Excel or Google Sheets. No formula building, no commission software required.
Key takeaways
- A pre-built commission tracking spreadsheet that calculates payouts automatically as you log deals.
- Three tabs: rep setup, monthly totals, and a deal log. Green cells are inputs, blue cells are outputs.
- Works in both Excel and Google Sheets, across SaaS, manufacturing, logistics, distribution, and more.
- Best for teams up to 30 reps that want accuracy and payout transparency without buying a commission system yet.
- Free to download, customize, and reuse.
Download the free commission sheet template →
Most sales teams do not lose time on commissions because the math is hard. They lose it because the math is scattered across five spreadsheets, three inboxes, and one rep's memory. Every month Finance rebuilds the same formulas, Sales Ops chases deal data, and at least one rep disputes a payout.
A commission tracking spreadsheet fixes the immediate problem: one place to log deals, one set of formulas that does not break, and clear numbers everyone can see. This template gives you that on day one, so you can stop maintaining commission math and start trusting it.
It will not replace a full commission system forever, and that is the point. Use it to run clean, accurate payouts now, then recognize the exact moment you have outgrown it (covered below).
How to Use the Template
- Go to the Home tab and add each rep’s name and monthly quota.
(This is a one-time setup unless your team changes. Feel free to remove reps from here if they leave) - Go to Monthly Totals tab and enter month and base salary for that month
- Log deals as they close in the Deals tab with product/service and commission rate.
- Commission amounts calculate instantly-no formulas to build or repair.
For clean monthly reporting:
Save a copy at the start of every month, delete old deals, and continue using the existing rep list and salary structure. This prevents version confusion and keeps historical copies preserved.
What is a commission sheet template?
A commission sheet template is a pre-formatted commission tracking spreadsheet that calculates sales commissions automatically as deals are logged. Instead of writing formulas, you enter rep details, deal values, and commission rates, and the sheet returns the payout for every deal plus the monthly total per rep.
This one is built for sales teams, not generic accounting. It ships with the tabs, formulas, and color coding already in place, in both Excel and Google Sheets. Think of it as a sales commission tracker you can use in five minutes, not a blank spreadsheet you have to engineer.
Why do sales teams use a free commission tracking spreadsheet?
Manual tracking across multiple files creates three predictable costs: errors that trigger disputes, slow month-end close while Finance reconciles numbers, and reps who stop trusting their pay. Lost trust is the expensive one. A rep who doubts their commission sells less and asks more.
This template removes those costs by handling every formula automatically and giving reps a clear view of how each payout was calculated. You get structure and accuracy without rebuilding a tracker every month, and without paying for software before you need it. Most teams reach for a commission tracking spreadsheet first because it is the fastest way to make payouts accurate and visible, and this one removes the setup work entirely.
What is inside the commission tracker template?
The template is organized into three working tabs, each with one job.
Color coding keeps it simple, with no formula editing required.
Enter data in the green cells. Everything else updates in real time.
How do you use the commission tracking template?
- Set up reps once. On the Home tab, add each rep's name and monthly quota. Update it only when your team changes, and remove reps who leave.
- Add the month. On the Monthly Totals tab, enter the month and base salary for each rep.
- Log deals as they close. On the Deals tab, record the product or service, deal value, and commission rate.
- Read the payout. Commission amounts calculate instantly. There are no formulas to build or repair.
For clean monthly reporting, save a fresh copy at the start of each month, delete the old deals, and keep the existing rep list and salary structure. This preserves historical copies and prevents version confusion.
Who is this free commission template best for?
This commission tracking spreadsheet is a strong fit for:
- Sales teams with up to 30 reps
- Startups and SMBs moving off manual commission calculations
- Finance and RevOps leaders who need clear, documented payouts
- Teams testing a compensation structure before automating it
It works across industries, including SaaS, real estate, insurance, manufacturing, logistics, and distribution.
It is not built for teams with commission splits, clawbacks, accelerators, multi-currency payouts, or more than roughly 30 reps. Past that point, the spreadsheet becomes the risk, not the fix.
When should you move beyond a commission spreadsheet?
A spreadsheet works until your comp plan gets complicated or your headcount grows. The signals are predictable.
When you cross those lines, the spreadsheet stops saving time and starts creating audit and trust risk. That is where a dedicated commission system replaces the manual work entirely. Visdum automates commission calculations, payout visibility, approvals, and ASC 606 amortization for Finance, RevOps, and Sales teams, so the numbers stay accurate and defensible without anyone maintaining a sheet. See how Visdum compares to manual tracking, or book a demo.
How do you get the most from this template?
- Clear the sample data first. The download includes sample data so you can see how everything works. Once the flow is clear, delete the contents of all green fields.
- Follow the tab order. Rep name and quota on Home, then month and base salary on Monthly Totals, then deals on the Deals tab as they close.
- Spell names consistently. Use the exact same rep name across every tab, or the totals will not link correctly.
- Do not rename tabs or edit blue cells. Output cells hold the formulas. Leave them untouched for accurate calculations.
FAQs
Is the commission sheet template free?
Yes. It is completely free to download, customize, and reuse.
Does it work in Excel and Google Sheets?
Yes. The template is compatible with both.
How many reps can the commission tracker support?
It is built for sales teams of up to 30 reps.
Do I need to edit any formulas?
No. Green cells are inputs, blue cells are outputs, and all formulas are pre-built. Do not disturb the output cells.
How do I start a new month?
Save a fresh copy, delete the old deals, and keep rep details and salaries as they are to start clean.
When should I switch from a spreadsheet to commission software?
When you add splits, clawbacks, accelerators, or multi-currency payouts, grow past ~30 reps, or month-end close starts slipping. At that point, automation removes the manual work and the audit risk.
Get a Demo Customized to Your Sales Comp Plans
