realtor-team-ops

v1.0.0 MIT real-estate updated 2026-09-27

Rank your team's agents by production and see what each split plan really costs — feed an agent deals CSV (agent, deals closed, total volume, avg commission %) plus a split config and get per-agent GCI, split-adjusted brokerage net and agent net, and a ranking table. Use when reviewing team performance, comparing comp plans, or onboarding a new agent.

$ skillbank install realtor-team-ops@1.0.0
# pins exactly 1.0.0 · README + changelog included

Realtor Team Ops

Overview

A team productivity calculator that speaks comp plans. You keep one CSV of agent production (deals closed, total volume, average commission %) and one JSON split config supporting three plan types: fixed split (70/30), graduated split with a cap (80/20 with an $18,000 cap), and 100% with a flat desk fee. The script computes each agent's GCI, applies their plan, and prints a ranking table with split-adjusted brokerage net and agent net, plus team totals. All data stays local — nothing is uploaded.

Installation

1. Copy the realtor-team-ops/ directory anywhere convenient. 2. Make the script executable (Unix):


   chmod +x scripts/productivity.py

No pip install needed — standard library only.

Configuration

Two files. The deals CSV must have exactly these columns (order does not matter):

| Column | Format | |----------------------|-------------------------------| | agent | Agent's name. | | deals_closed | Whole number. | | total_volume | Sales volume in dollars. | | avg_commission_pct | e.g. 2.5 for 2.5%. |

The split config is JSON:


{
  "default": {"type": "split", "brokerage_pct": 30},
  "agents": {
    "Alice Morgan": {"type": "split", "brokerage_pct": 30},
    "Bob Chen": {"type": "cap", "agent_split_pct": 80, "cap": 18000},
    "Carol Diaz": {"type": "desk", "fee": 1200}
  }
}

| Plan | Fields | Brokerage net | |--------|----------------------------------------------------|-----------------------------------| | split | brokerage_pct | GCI × brokerage % | | cap | agent_split_pct, cap | min(cap, GCI × (100 − agent %) / 100) | | desk | fee | Flat fee per period |

Agents not named in agents fall back to default. See references/split-structures.md for how each plan works in practice.

Inputs

productivity.py <deals.csv> --config <splits.json>

Returns, on stdout: a ranking table by GCI with per-agent deals, volume, commission %, GCI, plan, brokerage net, agent net, and a team totals row. Missing or invalid input produces a clear Error: message on stderr and exit code 2 — never a raw traceback.

Worked example

Four sample agents on three different plans:


cat > deals.csv <<'EOF'
agent,deals_closed,total_volume,avg_commission_pct
Alice Morgan,12,4200000,2.5
Bob Chen,8,2900000,2.5
Carol Diaz,15,5100000,2.4
Dave Ortiz,5,1650000,2.75
EOF

cat > splits.json <<'EOF'
{
  "default": {"type": "split", "brokerage_pct": 30},
  "agents": {
    "Alice Morgan": {"type": "split", "brokerage_pct": 30},
    "Bob Chen": {"type": "cap", "agent_split_pct": 80, "cap": 18000},
    "Carol Diaz": {"type": "desk", "fee": 1200},
    "Dave Ortiz": {"type": "split", "brokerage_pct": 40}
  }
}
EOF

./scripts/productivity.py deals.csv --config splits.json

Output:


Team productivity ranking (by GCI)
Agent         Deals        Volume   Comm%           GCI  Plan                Brokerage net      Agent net
---------------------------------------------------------------------------------------------------------
Carol Diaz       15  $5,100,000.00   2.40%   $122,400.00  100% + $1,200.00 desk      $1,200.00    $121,200.00
Alice Morgan     12  $4,200,000.00   2.50%   $105,000.00  70/30 split            $31,500.00     $73,500.00
Bob Chen          8  $2,900,000.00   2.50%    $72,500.00  80% w/ $18,000.00 cap     $14,500.00     $58,000.00
Dave Ortiz        5  $1,650,000.00   2.75%    $45,375.00  60/40 split            $18,150.00     $27,225.00
---------------------------------------------------------------------------------------------------------
TOTAL            40  $13,850,000.00           $345,275.00                         $65,350.00    $279,925.00

Carol is your top producer on GCI — but on a desk plan she contributes the least to the brokerage. That tension is the point of the table: GCI measures production, the split-adjusted column measures what the brokerage actually keeps.

Version history

Changelog

1.0.0 — 2026-09-27

  • Initial public release.
  • scripts/productivity.py: agent deals CSV + split config JSON → GCI ranking table with split-adjusted brokerage net and agent net (supports fixed split, split-with-cap, and 100%-plus-desk-fee plans).
  • references/split-structures.md: 70/30, 80/20 with cap, and 100% with desk fee explained, plus guidance on picking between them.
  • Zero dependencies; tested with 4 sample agents on three plan types plus bad-input cases (bad number, missing default plan, missing config).

← back to catalog