Quotaline Commissions

Quotaline Commissions calculates sales commission payouts and commission statements for a sales team from its comp plan. Give it the plan terms and the sales, or attach a deals export from your CRM or spreadsheet, and it works out what each rep earned, deal by deal, to the cent.

It handles the plan structures that cause commission disputes: flat rates, tiered commission with marginal (stepped) or retroactive tiers, quota attainment with accelerators and decelerators, commission caps, recoverable and non-recoverable draws against commission with the balance carried forward, split deals (60/40 or across several reps), SPIFFs and bonuses, clawbacks for refunded or cancelled deals inside a clawback window, commission on gross margin, and OTE with target variable pay. When a plan does not say whether tiers are retroactive, both results are shown side by side so you can check the signed plan before payroll.

Typical tasks:

• How much commission do I get on 72k if I earn 5% up to 50k and 8% above?
• How much commission did each rep earn this month? (upload the deals CSV or Excel file; columns such as rep, deal, amount, margin, close date and status are matched automatically)
• Recoverable draw against commission: what is payable now and what carries forward?
• Compare two comp plans at 50% to 200% of quota and see where one overtakes the other.

Each statement lists each deal with the tier and rate applied, the draw recovered, clawbacks and the amount payable now. Download a commission statement PDF (one section per rep, with signature lines) and an Excel workbook with the team summary, each deal line and the tier breakdown. The widget shows rep cards with quota attainment bars and a marginal vs retroactive toggle.

Limitations: it follows the plan terms you enter and does not read comp plan documents. It does not compute payroll taxes, withholding or take-home pay. Up to 5,000 deal rows and 200 reps per run; CSV and .xlsx files only (no PDF or scanned files). Download links expire after about an hour. Results are informational; your signed compensation plan governs.