FormulaSurge

Services · Commission Calculator

Custom Sales Commission Calculator in Excel

Your exact plan, calculated from the sales export, with statements that show the working. Builds from $75 / £60, fixed in writing.

  • commission
  • sales
  • incentive
  • statements
  • tiers

Start here · Scoping Sprint

Know the exact price in 2 working days. $99, credited in full to your build.

Builds from $75, fixed in writing · Working draft in 5 days or your first payment back · Mutual NDA first if you want one

See a sample Sprint report →Who you'll work with: two partners, 10+ years on finance workbooks →

10+ years in ExcelNamed senior ownerFixed price, in writingDraft in 5 days or refundMutual NDA on request30-day warranty

Every month someone exports the sales, applies the commission plan by hand and sends statements. Then a rep disputes a number, and nobody can show how it was worked out. Tiered and cumulative plans make it worse.

We build a calculator that applies your exact plan from the sales export: tiers, accelerators, splits, caps, clawbacks and bonuses. Each rep gets a statement that shows the working, and we test it against a past pay period before you use it.

What we do

Your plan, calculated the same way every month.

Any plan structure

Flat rate, tiered or cumulative tiers, accelerators above quota, team splits, caps, draws and clawbacks.

From your sales data

CRM, invoicing or accounting exports loaded in one click, mapped to reps, products and periods.

Statements that show the working

One statement per rep, with each deal, the rate applied and the total, ready to send as PDF.

Tested before use

We run a past pay period through the calculator and reconcile it to what you actually paid.

Prices

What each price band includes.

The exact price is fixed in writing before any work starts. Bigger jobs start with the Scoping Sprint, credited in full.

Quick fix

$75 – $180

Your existing commission sheet fixed, or a flat-rate plan calculated.

  • Delivery: 1–5 working days
  • 1 review round
  • 30-day warranty

Standard

$180 – $500

Tiered plan with rep statements, tested against one past pay period.

  • Delivery: 10–15 working days
  • 2 review rounds
  • 30-day warranty

Complex

$500 – $2,000+

Accelerators, splits, clawbacks and bonuses, with PDF statements for every rep.

  • Delivery: 15–30 working days
  • 3 review rounds
  • 30-day warranty

Will it pay for itself? Work it out with the free Hours-Saved Calculator →

Deliverables

What you receive.

  • Commission calculator for your plan, in Excel or Google Sheets
  • One-click import of your sales export
  • Rep statements with the working shown
  • Reconciliation of one past pay period
  • Plan settings sheet, so next year's rates are a table edit
  • 30-day warranty against the Definition of Done

Tools

What we work in.

  • Excel tables
  • XLOOKUP / LET
  • Power Query
  • PivotTables
  • VBA PDF export
  • Google Sheets / Apps Script

Process

How it runs.

  1. Step 01

    Send the plan

    Send the commission plan document and one month of sales data (values can be masked). Mutual NDA first if you want one.

  2. Step 02

    Quote or Sprint

    A simple plan gets a free written quote within one working day; builds from $75 / £60. A complex plan starts with the Scoping Sprint ($99 / £79).

  3. Step 03

    Build, test, hand over

    Working draft within 5 working days of the first payment, tested against a past pay period before handover.

Frequently asked

Before you commission a commission calculator.

Our plan is complicated. Can Excel handle it?

Cumulative tiers, accelerators and splits are all formula work Excel handles well when the plan is set out as a table. If the plan has gaps or contradictions, we will point them out before building.

Can reps see only their own numbers?

Each rep gets their own PDF statement. If you need a shared live view with access control, Google Sheets with protected ranges is an option.

When should we buy commission software instead?

When you have many reps, frequent plan changes and need approvals and audit trails built in. For a small team, a well-built spreadsheet is usually cheaper and clearer.

Related: Sales operations · Excel automation · Excel VBA / macros

Start with a Scoping Sprint

End the monthly commission disputes.

Send the plan and a sample of sales data. We reply within one working day with a written quote or the Sprint price in your currency.

Replies within one working day, usually the same day

Calls 9am–7pm IST, Mon–Sat · How a project works

Service standards

Six rules on every Excel service project.

Project rules, not marketing copy. The same six on every dashboard build, audit, macro, model and clean-up.

15% OFF

15% off your first project

Start with the $99 Scoping Sprint - credited in full to your build.

View more

15% off the build fee of your first project. Mention it when you book; the Scoping Sprint is still credited in full.

The Scoping Sprint gives you a written diagnosis and a fixed price for your build in 2 working days.

Not ready yet? · Free

Free 10-minute Excel audit

Seven checks on your workbook, results in writing within one working day.