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 · $24.99

See what is inside 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: October 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