Tiered Fee Calculator
Use this custom tiered percentage fee calculator when percentage rates apply progressively to dollar brackets—not when unit prices change by quantity. It shows how much of the gross amount falls into each tier, rounds every fee line to the nearest cent, and reports the total fee, net amount, and blended effective rate. It can also work backward from the net amount you need to keep.
How progressive tiered fees work
A progressive fee schedule splits one gross amount into portions. Each portion uses the percentage assigned to its bracket. Crossing a threshold does not reprice the dollars already assigned to lower tiers.
For each active bracket, calculate amount in tier × fee rate, round that line to the nearest cent, and add the rounded lines. In compact form: Total fee = Σ(round(amount in tier × tier rate, 2)).
For a tier with lower and upper limits, amount in tier = max(0, min(gross amount, upper limit) − lower limit). For the final unlimited tier, use the gross amount in place of the upper limit. The calculator divides the total fee by the gross amount to show the blended fee rate.
Set cumulative dollar limits
If Tier 1 ends at $100 and Tier 2 ends at $500, the second tier contains the $400 between those boundaries.
Apply marginal percentage rates
Each percentage applies only to the dollars in that tier. Use 0% if the first bracket is fee-free.
Audit every fee line
The result identifies the amount, rate, and rounded deduction for each bracket before totaling the fee.
Worked example: a $1,000 payment across three fee tiers
Suppose the first $100 is charged at 3%, the portion from $100 to $500 at 2%, and the portion above $500 at 1%. Tier 2 contains $400—not another $500—because the limits are cumulative.
The three deductions are $3.00, $8.00, and $5.00. That produces a $16.00 total fee, a $984.00 net amount, and a 1.60% blended fee rate.
| Fee tier | Amount in tier | Rate | Fee |
|---|---|---|---|
| First $100 | $100.00 | 3% | $3.00 |
| Over $100 to $500 | $400.00 | 2% | $8.00 |
| Over $500 | $500.00 | 1% | $5.00 |
| Total | $1,000.00 | 1.60% blended | $16.00 |
How to calculate tiered fees in Excel or Google Sheets
You can reproduce the same progressive tiered fee formula in Excel or Google Sheets. Put the gross amount in B2. Enter the first two cumulative upper limits in B5:B6, then enter the three percentage rates in C5:C7. Format the rate cells as percentages and enter values such as 3%, 2%, and 1%.
For a three-tier schedule, use =ROUND(MIN($B$2,$B$5)*$C$5,2) + ROUND(MAX(0,MIN($B$2,$B$6)-$B$5)*$C$6,2) + ROUND(MAX(0,$B$2-$B$6)*$C$7,2). Each term isolates one bracket and rounds that bracket's fee to cents before the results are added.
With $1,000 in B2, limits of $100 and $500, and rates of 3%, 2%, and 1%, the spreadsheet returns $16.00. Test the formula at each exact boundary and just above it before adapting it to a live fee schedule. This formula is for progressive percentage fees on dollar amounts; it is not a per-unit volume pricing formula.
| Cell | Enter | Meaning |
|---|---|---|
B2 | $1,000.00 | Gross amount |
B5 | $100.00 | Tier 1 cumulative upper limit |
C5 | 3% | Tier 1 fee rate |
B6 | $500.00 | Tier 2 cumulative upper limit |
C6 | 2% | Tier 2 fee rate |
C7 | 1% | Final unlimited-tier fee rate |
Reverse a tiered fee to protect a target net amount
When you know the amount you need to keep, use the reverse result instead of guessing a gross-up percentage. The calculator finds the smallest cent-level charge that reaches your target after applying the same progressive brackets and rounding rules. If your gross-up also includes fixed, per-item, or fee-tax costs, use the Reverse Fee Calculator instead.
With the default 3%, 2%, and 1% schedule, keeping exactly $1,000.00 requires a charge of $1,016.16. The $16.16 total fee leaves a $1,000.00 net amount.
This is useful for progressive commissions, agency fees, and other contract-based service fees where the agreement allows the fee to be passed through. Confirm the applicable contract and local rules before adding a fee to an invoice.
Percentage fee tiers are different from per-unit pricing tiers
This calculator applies percentage rates to dollar ranges. It is designed for commissions, deductions, and management or service fees where the result is subtracted from a gross amount.
If your schedule prices API calls, seats, credits, wholesale quantities, or other units at different dollar rates, use the Tiered Pricing Calculator. That tool accepts a price per unit, included usage, and a base fee, and compares graduated pricing with volume pricing.
A whole-amount percentage band is different again: one selected percentage may apply to the entire gross amount. Do not enter that rule here because this calculator always uses marginal brackets.
Progressive tiers and whole-amount bands produce different fees
The same thresholds and percentages can produce a different result when a schedule applies the selected band to the whole amount. On a $1,000 gross amount, the default progressive schedule charges $16.00 because every bracket keeps its own rate. A whole-amount band at the selected 1% rate would charge $10.00.
Check the agreement for words such as “portion,” “amount over,” or “marginal” before choosing the progressive method. If one known percentage applies to the entire amount, use the Percentage Fee Calculator.
| Rule | Calculation on $1,000 | Fee |
|---|---|---|
| Progressive tiers | $100 × 3% + $400 × 2% + $500 × 1% | $16.00 |
| Whole-amount band | $1,000 × 1% | $10.00 |
Boundary checks: at a threshold and just above it
Boundary checks make a graduated fee calculation easier to audit. Under the default schedule, exactly $500.00 fills the first two tiers. At $500.01, one cent enters the final 1% tier, but its $0.0001 raw fee rounds to $0.00. At $500.50, the final tier's half-cent raw fee rounds up to $0.01.
A 0% first tier works as a free allowance: the dollars inside it appear in the breakdown but add no fee. The final tier has no upper limit, so every dollar above the last entered boundary continues to use its rate.
| Gross amount | Amount in final tier | Rounded final-tier fee | Total fee |
|---|---|---|---|
$500.00 | $0.00 | $0.00 | $11.00 |
$500.01 | $0.01 | $0.00 | $11.00 |
$500.50 | $0.50 | $0.01 | $11.01 |
Cent rounding, limits, and calculator scope
Each active tier is calculated separately and rounded half up to the nearest cent. The rounded fee lines are then added. This may differ by a cent from applying an unrounded blended rate and rounding only the final total.
You can create 2 to 5 tiers. Each percentage can range from 0% to 99.99%, and each gross amount or boundary can be up to $1,000,000.00. The final tier has no upper boundary.
This tool does not supply or verify a provider's rates. Fixed fees, minimums, maximums, tax, refunds, currency conversion, provider-specific exceptions, and whole-amount fee bands are not included. For a percentage plus fixed charge, use the general fee calculator.
Results are estimates, not financial, investment, tax, or legal advice. Confirm the rates and terms that apply to you. Read our calculation review method or report a calculation difference.