Sales Commission Tracker Template for Excel | Sales Tracker & Commission Calculator

Know exactly what every rep earned - commission calculates itself from each sale.

This sales commission tracker template for Excel is a sales tracker and commission calculator in one: log each sale and the tiered commission, quota attainment and payouts update automatically.

WHAT'S INCLUDED

• Settings: up to 10 sales reps with monthly quotas, 4 commission tiers (sale amount from / rate) and a product list• Sales Log: date, rep, client, product, units, unit price, discount, sale amount, commission rate, commission, status (Pending / Paid / Clawback) and month• Rep Summary: pick a month (or All) to see sales, quota, quota %, commission, paid, pending and number of deals per rep• Dashboard: total sales, total commission, commission pending, deals closed, average deal size and sales / commission by rep charts

BEST FOR

Small business owners, sales managers paying a team, and sales reps checking their own commission.

HOW IT WORKS

1. Set your reps, quotas and commission tiers.2. Log each sale - commission calculates automatically.3. Mark commission Paid when you pay it and review the Rep Summary each month.

FORMAT / DELIVERY

• 1 Excel workbook (.xlsx, no macros) - works in Microsoft Excel and Google Sheets• Sample data included so you can see how it works, then overwrite it• Instant digital download - no physical item• Commission rule: the rate of the highest tier the sale reaches applies to the whole sale

FAQ

What exactly do I get?

Sales commission tracker template for Excel: log sales, auto tiered commission, quota % per rep, paid vs pending payouts.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.