● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Sales Commission Tracker by Rep
Hero image of the Sales Commission Tracker by Rep, showing the full workbook at a glance
BOOKKEEPING & BUSINESS FINANCE

Sales Commission Tracker by Rep

Working out commission by hand at month end always ends the same way: a rep questions a figure, a sale goes missing, and an evening disappears into old messages. This sales commission tracker spreadsheet settles it in advance, by logging each sale once and letting the sheet do every calculation from there.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Commission nobody has to argue about

Commission disputes rarely start with bad intent. They start with a number worked out by hand, weeks after the sale, from notes nobody kept properly. This tracker removes the guesswork. You log each sale once with its date, rep, client, deal and amount, and the tracker finds that rep's rate, works out the commission, and keeps every total current from that moment on.

Rates live on their own tab: each rep's base rate, bonus threshold and bonus rate, with the rule stated plainly that a sale at or above the threshold earns the bonus rate on the whole sale. The Rep Dashboard shows every rep at a glance, with deals, total sales, total commission, average sale and each rep's share of sales. The Monthly Summary compares months straight from the log, with no separate report to build.

When payday comes, the Payout Schedule shows what each rep has earned, what you have already paid and what is still due, and its status flips to Paid in full when nothing is left. Sales Goals tracks a monthly goal per rep with actual sales, the percentage reached and the amount left. Change a rate later and every commission in the log updates to match, with no past sales to edit one by one.

Inside the workbook: 8 tabs

What you receive

  • BLANK Excel workbook, clean and ready for your own numbers
  • EXAMPLE Excel workbook filled with realistic sample data, so you can explore before you start
  • Google Sheets access link that makes your own copy in one click
  • Quick Start Guide that walks through setup in Excel and in Google Sheets
  • Files delivered individually, ready to download and use straight away

Good to know

  • Runs in Microsoft Excel and in free Google Sheets, with the same formulas in both
  • Works on your computer, tablet and phone
  • Your currency is set once on the Start Here tab
  • Works for a single rep or a whole sales team
  • Questions after purchase? Message us through Etsy and we will help you out

Questions about this template

The things buyers ask us most.

Does the bonus rate apply to the whole sale, or only part of it?

The whole sale. If a rep's bonus threshold is $5,000 and a sale comes in at $5,600, the bonus rate is used for the full $5,600, not just the part above the threshold. That rule is written on the Commission Rates tab, so every rep can see exactly how their pay is worked out.

What happens if I change a rate later?

Every commission in the log updates to match the new rate automatically. You do not need to edit past sales one by one or rebuild the totals. The Rep Dashboard, Payout Schedule and Monthly Summary all read from the same log, so the whole workbook agrees with itself after the change.

Can I use this for a single rep or a whole team?

Both. The dashboard, payout and goal tabs each carry a row per rep, so one rep is simple and a growing team still fits. The Quick Start Guide explains how to add a rep by copying a row and changing the name, and the Settings tab holds your team list.

What if a sale is refunded or cancelled?

Change its status on the Commission Log, or remove the row altogether. Either way, the rep totals, the amount still due on the Payout Schedule and the Monthly Summary update with it, so nobody gets paid commission on money the business did not keep. No other tabs need touching.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Receipt and Mileage Expense Tracker Excel Spreadsheet

Receipts and business mileage in one workbook, with one combined total for tax time.

$7.50 $3.00
View on Etsy
Small Business Bookkeeping Spreadsheet

Log income and expenses in minutes and see your real net profit on one clear dashboard.

$6.99 $2.80
View on Etsy
Small Business Subscription Tracker

Every recurring cost, renewal date and annual total in one simple tracker.

$2.99 $1.20
View on Etsy
View on Etsy · $3.00