Download the spreadsheet (.xlsx)

Opens in Excel, and in Google Sheets (File, Import, or upload it to Drive and open it with Sheets). No sign-up. The file is yours after you download it.

What is in the sheet

Four tabs:

  • How to use. What to replace, and what not to overwrite.
  • Plan. The cap (0 if the plan has no cap), the brokerage's share of the split, a franchise fee percent, a per-file fee, and the company dollar already paid before the first row.
  • Deals. One row per deal. You type the label, the sale price and the commission rate. The row works out the gross, the franchise fee off the top, the company dollar the split would take, the company dollar actually taken up to the cap, the per-file fee, what the agent takes home, and the cap left for the next row.
  • Statement. The same deals as a short statement: gross, franchise fee, company dollar taken, per-file fee, agent net, and the cap left after each row, with totals for all 30 deal rows.

The example is one invented agent, a $20,000 cap, a 30 percent brokerage share, a 10 percent franchise fee and a $300 per-file fee. Four example deals follow, each an $800,000 sale at 2.5 percent. The fourth is the one that crosses the cap, so the company dollar taken stops at what was left. Copy the workbook for each agent. The opening company dollar has to be from that agent's cap year only.

How to use it

  1. Download the file and open it in Google Sheets or Excel.
  2. On Plan, replace the example cap, split, fees and company dollar already paid. Leave the labels in column A.
  3. On Deals, replace the example rows. The first 30 rows already have the formulas: type the label, the sale price and the rate on the next empty one. The cap remaining on each row reads every row above it.
  4. Read Statement before you pay the agent. The lines on a deal should add back to that deal's gross commission.

A referral fee is not a column. Take it off the gross before you type the sale, or lower the rate so the gross matches what is left after the referral. The commission split calculator does that order for one closing. A CDA template is the form the title company gets, not this sheet.

What a sheet will not do

Changing the split, the cap or a fee on Plan recalculates every deal row, including deals already paid. A paid deal should keep the split it was paid on. When a plan changes, save a copy and start the next deals in the new file.

Two people can edit the same cell. The sheet will not tell you who did, and it will not stop a sort from breaking the cap formulas. It does not email a statement, and it does not pay anyone. Those limits, and when a grid is still the right tool, are in Google Sheets or a brokerage back office.

When to move to Deskwork

Move when the cap has to survive more than one editor, when a plan change must not rewrite last quarter, or when an agent should see their own cap without asking. Bring the old rows across and check them before anything is filed. How to do that without retyping the past is in how to move from a commission spreadsheet to software.

An office you set up yourself is free. Request access if you would rather we set it up with you.

Questions

What is in the spreadsheet?

One example agent, four example deals, and a statement view. Each deal row works out the gross commission, a franchise fee off the top, the brokerage's split up to the cap, a per-file fee, what the agent takes home, and the company dollar left.

Will a paid deal keep its old split if the plan changes?

No. The split, the cap and the fees live in cells the deal rows read. Change one of those cells and every row recalculates, including deals already paid. For a new plan, start a new copy and leave the old file as it was.

Does the spreadsheet send anything to Deskwork?

No. It is a file you download. What you type in Google Sheets or Excel stays in that file. Deskwork does not receive it unless you later choose to import a workbook yourself.

When should an office move off the sheet?

When more than one person edits the cap, when a plan change must not rewrite a paid deal, or when each agent should see their own cap without someone reading a cell aloud. The sheet can stay as a copy until a real closing matches.

The sheet can stay until a closing matches.

Deskwork keeps each plan, each cap year and each statement, and a paid closing keeps the plan it was paid on.

Request access Sign up free