Commission Calculator - Flat & Tiered Sales Models

Commission Calculator – Flat & Tiered Sales Models

In sales compensation, commission is variable performance-based pay earned by sales representatives, real estate agents, or account executives based on the dollar volume of goods or services they sell. A well-structured commission plan aligns sales incentives with business revenue growth. However, calculating payouts accurately requires understanding the specific plan design — whether it uses a single Flat Commission Rate or a progressive Tiered Commission Schedule. This calculator computes Commission Payouts () and Total Earnings () (Base Salary + Commission) across both Flat and Tiered calculation modes.

Key Sales Compensation Definitions

Total Sales Amount (S) is the total gross dollar value of closed deals or products sold during the commission period. Base Salary (B) is the fixed, guaranteed salary paid to a sales representative regardless of sales output. Commission Payout (C) is the variable incentive money earned directly from sales performance. Total Earnings (On-Target Earnings / OTE) is the complete gross pay earned during the period: Total Earnings = B + C.

Flat vs. Tiered Commission Structures

Flat commission applies a single fixed percentage across all eligible sales volume from the very first dollar:

Commission = S × (Commission Rate % / 100) qquad Total Earnings = B + Commission

Tiered (progressive bracket) commission divides sales into bracket spans (bands). As sales volume crosses specific threshold boundaries, higher percentage rates apply only to the sales dollars falling within that specific bracket:

Commission = sum_i=1^n ≤ft( Eligible Sales in Tier i × (Tier Rate_i % / 100) )

Worked Examples

Example 1: Flat Commission Mode (5% Flat Rate, 25,000 Sales,2,000 Base)

Commission = 25,000 × 0.05 =1{,}250.00. Total Earnings= 2{,}000 + 1{,}250 = \3,250.00.

Example 2: Tiered Commission Mode, Two Tiers Reached (25,000 Sales,2,000 Base)

Using the default tier structure (Tier 1: up to 10,000 @ 3%; Tier 2: up to50,000 @ 6%; Tier 3: unlimited @ 10%): Tier 1 commission = 10,000 × 0.03 =300.00. Remaining sales= 25{,}000 - 10{,}000 = 15{,}000. Tier 2 eligible sales= \min(15{,}000, 40{,}000) = 15{,}000; Tier 2 commission= 15{,}000 \times 0.06 = \900.00. Tier 3 is never reached. Total Commission = 300 + 900 =1{,}200.00. Total Earnings= 2{,}000 + 1{,}200 = \3,200.00.

Example 3: Tiered Commission Mode, All Three Tiers Reached (75,000 Sales,2,500 Base)

Tier 1 commission = 10,000 × 0.03 =300.00. Tier 2 span is50{,}000 - 10{,}000 = 40{,}000; Tier 2 commission= 40{,}000 \times 0.06 = \2,400.00. Remaining sales after Tiers 1–2: 75,000 - 10,000 - 40,000 = 25,000; Tier 3 (unlimited, above 50,000) commission= 25{,}000 \times 0.10 = \2,500.00. Total Commission = 300 + 2,400 + 2,500 =5{,}200.00. Total Earnings= 2{,}500 + 5{,}200 = \7,700.00 — this example shows the top 10% accelerator rate actually kicking in.

Why Tiered Commissions Produce Different Results

In Example 2, the 5% flat rate would have paid 1,250, while the tiered structure paid only1,200 on the exact same 25,000 sales volume — because under the tiered model, the first10,000 of sales was paid at a baseline rate of 3%. Tiered models are designed to control sales costs at lower volumes while offering powerful "accelerator" incentives (10%) when representatives crush high quotas, as Example 3 demonstrates once sales exceed $50,000.

Common Commission Payroll Mistakes

Applying higher tier rates retroactively to ALL sales is a common error — unless a compensation plan explicitly specifies a "retroactive tier jump," progressive tiers only apply their higher percentage rate to the incremental dollars within that tier band. Confusing gross revenue with gross margin is another: some plans pay commission on total sales revenue, while others pay commission on gross profit margin dollars (Sales − Product Cost). Ensure you enter the correct baseline amount for your specific plan.

Frequently Asked Questions

What is a tiered commission structure?

A tiered commission structure pays different percentage rates as sales volume crosses predefined threshold brackets. Rates typically increase at higher brackets (e.g. 3% on the first 10k, 6% on the next 40k) to reward high performers.

What is the difference between Base Salary, Commission, and Total Earnings?

Base salary is guaranteed fixed pay regardless of sales performance. Commission is variable performance-based pay directly tied to sales volume. Total Earnings (or On-Target Earnings / OTE) is the sum of base salary plus earned commissions.

Why does a 5% flat commission pay more than a 3%/6%/10% tiered commission on 25,000 of sales?

On 25,000 of sales, a 5% flat rate applies to every single dollar (1,250). In the tiered model, the first 10,000 is paid at a lower 3% rate (300), and only the remaining 15,000 is paid at 6% (900), totaling 1,200. Tiered models require reaching higher sales volumes (e.g. over 50,000) to unlock top 10% acceleration rates, as shown in the third worked example where75,000 in sales unlocks all three tiers.