Refentra
English
Go to tools

Marginal and whole-sales commission

Enter your sales, increasing thresholds and rates. Marginal slices differ from applying the reached tier to all sales; boundary activates new tier.

  • Runs in your browser
  • No upload
  • Check before download

Enter your sales, increasing thresholds and rates. Marginal slices differ from applying the reached tier to all sales; boundary activates new tier.

Calculations run locally and inputs are not saved automatically. Download an input backup before closing the tab. Input data, formulas and filenames are never sent. Only with your optional consent, Refentra sends aggregate counts of actions and outcomes, without input content.

What are the limits?

Maximum amount 1 trillion units; total 100 trillion cents. Up to 100 rows, 50 people, 20 tiers, 100 depreciation years, 1,200 schedule periods, 61 cash flows. IRR range −99% to 1,000% per interval, numerical candidates only. Rates: up to eight decimals. Backup: 1 MiB. CSV formula-leading text gets an apostrophe. Use decimal points, no thousands separators.

Amounts use two decimals in your stated unit. Exact decimal inputs; cent rounding half away from zero. Table sums balance. Largest fractional remainders receive shared cents; equal remainders use row order. No tax, fees, legal entitlement or current prices are inferred.

Non-monetary values are shown with up to ten significant digits. CAGR, fractional-year inflation and IRR use numerical approximations; IRR candidates are not a symbolic proof. CSV keeps the numeric values before display rounding.

Policy totals use exact fractions before rounding. Final pay or commission is rounded once. Base pay is rounded from all base hours; the premium reconciles final pay minus base. Displayed row cent portions balance these totals and remain between their exact floor and ceiling. Redundant same-rate thresholds cannot change totals. This is a calculation convention, not a legal payroll rule.

Own tiers (increasing lower thresholds)
1
2

C = Σ S_j × r_j; C = S × r_(max j)

Calculate with your own assumptions

  1. Enter the inputs

    Name your rule, then enter the sales and thresholds that increase from 0. Choose marginal to apply each rate only within its band, or whole to apply the rate of the band that was reached to all sales. Enter decimals with a point and without thousands separators.

  2. Check a worked example

    Sales 1500, rates 5% from 0 and 10% from 1000: marginal commission=1000×0.05+500×0.10=100. Whole mode pays 1500×0.10=150, which is a different rule.

  3. Interpret and save the result

    Check the selected mode before you interpret the commission. The marginal row portions add up to the rounded total, and redundant bands with the same rate don't change it. Export the CSV together with the policy name.

Method, errors and limits

Can I reopen editable inputs from the CSV?

The CSV is a report of the results, not a backup of your inputs. Download the separate JSON input backup before you close the page, then import it into this same tool to edit your assumptions again. Import accepts files up to 1 MiB and checks that the file belongs to this tool. Inputs are not saved automatically.

Which input mistakes should I check?

Thresholds start at 0 and keep increasing, with at most 20 tiers. Rates are percentages from 0 to 1000, so enter 5 for 5%. Switching from marginal to whole can cause a jump at a threshold; that is how the selected rule works.

What are this model’s limits?

A custom calculation policy, not a validated compensation contract. The tool doesn't assume clawbacks, quotas, taxes, minimum guarantees or any lookup of sales data.