Workflow · Finance close · Opening soon
Real estate commission split
Bring in your closed sales export from Google Sheets. Match each sale to your split plans and agent names, then calculate the commission split.
Someone typed
“work out the commission on each closed sale and split it between the listing agent, buying agent and brokerage”
The agent read it as
Work out the commission on each closed sale in Closed sales using Commission split plans and Agents and Agents, and split it between the listing agent, buying agent and brokerage.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Closed sales
CSV export · 15 rows
File
Commission split plans
CSV export · 4 rows
File
Agents
CSV export · 8 rows
File
Agents
CSV export · 8 rows
Join
Bring in split percentages
15 of 15 paired
Join
Add listing agent name
15 of 15 paired
Join
Add buying agent name
15 of 15 paired
Step
Calculate commission split
Step 4
Result
Closed Sale Commissions
15 rows
Schedule
Runs when you say
Proposed
- FileClosed salesCSV export · 15 rows
- FileCommission split plansCSV export · 4 rows
- FileAgentsCSV export · 8 rows
- FileAgentsCSV export · 8 rows
- JoinBring in split percentages15 of 15 paired
- JoinAdd listing agent name15 of 15 paired
- JoinAdd buying agent name15 of 15 paired
- StepCalculate commission splitStep 4
- ResultClosed Sale Commissions15 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out, and the join paired 15 of 15 rows; the join paired 15 of 15 rows; the join paired 15 of 15 rows.
- Download Closed sales sample (15 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the 'Closed Sales' tab
- Download Commission split plans sample (4 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the 'Split Plans' tab
- Download Agents sample (8 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the 'Agents' tab
- Download Agents sample (8 rows)Google Sheets: File > Download > Comma-separated values (.csv) from the 'Agents' tab
What you get back
The result of that run, the rows to look at first.
Closed Sale CommissionsSample data15 rows
| Sale ID | Listing agent commission | Buying agent commission | Brokerage commission | Gross commission | Listing agent name | Buying agent name | Close date | Property address | Sale price | Gross commission rate |
|---|---|---|---|---|---|---|---|---|---|---|
| sal_1001 | 9,375 | 4,687.50 | 4,687.50 | 18,750 | Mara Ellison | Tessa Nguyen | 2026-09-16 | 18 Juniper Lane | 625,000 | 0 |
| sal_1002 | 12,150 | 6,075 | 6,075 | 24,300 | Caleb Voss | Jules Mercer | 2026-09-22 | 4412 Harbor View Dr | 810,000 | 0 |
| sal_1003 | 6,750 | 3,375 | 3,375 | 13,500 | Nina Hart | Priya Shah | 2026-09-29 | 77 Maple Crest Ct | 540,000 | 0 |
| sal_1004 | 11,700 | 8,775 | 8,775 | 29,250 | Owen Baird | Dante Ruiz | 2026-10-02 | 905 Southgate Rd | 975,000 | 0 |
| sal_1005 | 10,725 | 5,362.50 | 5,362.50 | 21,450 | Mara Ellison | Caleb Voss | 2026-10-07 | 1221 Winding Brook Way | 715,000 | 0 |
| sal_1006 | 7,020 | 3,510 | 3,510 | 14,040 | Tessa Nguyen | Nina Hart | 2026-10-11 | 304 Pine Hollow Ln | 468,000 | 0 |
| sal_1007 | 11,440 | 8,580 | 8,580 | 28,600 | Jules Mercer | Owen Baird | 2026-10-18 | 6409 Ashford Mill Cir | 880,000 | 0 |
| sal_1008 | 15,900 | 11,925 | 11,925 | 39,750 | Priya Shah | Mara Ellison | 2026-10-24 | 51 Brookridge Terrace | 1,325,000 | 0 |
| sal_1009 | 8,925 | 4,462.50 | 4,462.50 | 17,850 | Dante Ruiz | Caleb Voss | 2026-10-29 | 2104 Cedar Run Blvd | 595,000 | 0 |
| sal_1010 | 6,450 | 3,225 | 3,225 | 12,900 | Caleb Voss | Tessa Nguyen | 2026-11-01 | 9 Autumn Ridge Pl | 430,000 | 0 |
| sal_1011 | 13,680 | 4,560 | 4,560 | 22,800 | Nina Hart | Nina Hart | 2026-11-04 | 368 Fox Meadow Dr | 760,000 | 0 |
| sal_1012 | 7,150 | 3,575 | 3,575 | 14,300 | Owen Baird | Jules Mercer | 2026-11-05 | 14 River Point Ct | 520,000 | 0 |
How do you split real estate commission on each closed sale?
Export your closed sales from Google Sheets and bring the file into Mammoth. Add your split percentages, listing agent names, and buying agent names, then calculate the commission split for each sale. The result is a commission split by sale.
How it works
How to use the Closed Sale Commissions workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Closed Sale Commissions: questions
What export should I use for this workflow?
Use a spreadsheet export of your closed sales from Google Sheets. The file should include the sale records you want to calculate.
What happens to rows that do not match the split rules?
Rows that do not match stay out of the result until you add the missing agent names, split percentages, or other rules they need.
How do I change the rules later?
Edit the rule words in the workflow, such as the split percentages or the agent matching terms, then rerun the file.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template