WB WorkbookBarn All workbooks

Free calculator · nothing to download

Commission Ladder

Type in the blue cells. Set THE HOUSE RULES once; every other tab reads them.

1 · THE REVENUE
2 · THE HARD COSTS (COGS)
3 · THE HOUSE RULES — SET THESE ONCE
4 · WHAT COMES OFF THE PAYOUT
5 · THE OLD WAY, FOR COMPARISON

1 · THE REVENUE

(A) TOTAL GROSS REVENUE

2 · THE HOUSE TAKE — OFF THE TOP

House fee

3 · THE HARD COSTS (COGS)

(B) TOTAL HARD COSTS

4 · THE PROFIT CHECK

Total net profit (A − fee − B)
ACTUAL NET MARGIN
Distance above the floor
Distance from the target
Price this job needed, to clear the floor
Price this job needed, to hit target
How far under the floor price it was signed

5 · THE COMMISSION CALCULATION

Commission tier earned
Gross commission (A × tier)
Less: booking draw already paid
Less: back-charges
(C) FINAL COMMISSION PAYOUT

WHAT THE FLOOR JUST DID

Had it cleared the floor, it would have paid
What pricing it thin cost the closer
Commission as a share of this job's net profit
What the company keeps after commission

AGAINST A FLAT PERCENTAGE

A flat % of revenue would have paid
What you would have kept, flat plan
The ladder keeps you ahead by
Same tier rate, paid on net profit instead

Job Log

One row per settled job. Margin, tier and commission compute themselves from THE HOUSE RULES.

SettledJob #ScopeGross revenueHard costs (COGS)House feeNet profitNet marginTier rateCommissionCompany keepsWhat happened
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Where that leaves you

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook

Keep it

Commission Ladder — the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $24.99What is inside →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: August 2026

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks