Commission Sheet Template: Sales Commission Calculator in Excel with Tiers & Accelerators

Sales Commission Calculator is a complete commission spreadsheet for sales teams, agents and partners. Set up each rep once with a plan, annual quota, manager and draw, then log deals as they close. The workbook works out credit, quota attainment, tiers, accelerators and caps, and each month gives a payable figure and a commission statement that shows every deal behind it, so a rep can check the number without asking.

Plans can be flat, tiered or retroactive, measured over a month, quarter or year, and paid on revenue or margin. Each plan has up to 6 tiers that start at a % of quota. In a tiered commission plan each rate applies only to the sales inside its band; in a retroactive plan the top tier reached applies to all sales in the period. Give tiers above 100% a higher rate for an accelerator, and limit payouts with a credit cap or a maximum commission per period. Quota can be phased by month for seasonal businesses.

Every month follows the same steps. Commission is calculated on period-to-date credit, then the amount already earned in the period is taken off, so crossing a tier pays in the month it happens. The Commission Run tab shows this line by line for every rep. Deal types can credit at different rates, for example 50% on renewals. Commission can be earned on the deal date or when the customer pays, and split deals share credit between two reps.

Real payroll cases are covered. When a deal is cancelled or refunded inside your clawback window, commission is taken back at the rate earned in the deal's month, including partial refunds. Recoverable draws guarantee a minimum payment and carry any shortfall forward until it is earned back. Manager overrides pay a % of team credit, and SPIFFs, bonuses and corrections go on the Adjustments tab.

The What-If Calculator tests any plan before you roll it out, showing the commission band by band, the same sales under flat, tiered and retroactive structures, and a payout curve. Rep Summary shows the year to date per rep with payable by month, and the Dashboard shows credit, earned, payable, cost of sales, a leaderboard and a watch list. For agents and partners who bill you, the Commission Invoice gives a ready commission invoice format in Excel. Capacity covers 40 reps, 10 plans, 2,000 deals and 300 adjustments for one fiscal year. Calculated cells are locked and sheet protection has no password. Sample data from a fictional company is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.