How Solo Realtors Track Listings, Showings, and Commissions in One System

Running 10 to 30 active deals as a solo realtor means you are the agent, the admin, and the analyst — all at once. Most CRM tools built for real estate are designed for teams and priced accordingly. The broker-provided spreadsheet from 2019 covers the basics but breaks the moment you need to answer a question like: “What am I likely to earn this month based on what’s actually in my pipeline right now?”

This guide covers what a solo realtor’s tracking system needs to handle, where conventional tools fall short, and how to get meaningful pipeline visibility without paying $99/month.

The Five Layers of a Working Realtor Pipeline

A solo real estate practice has five distinct information domains that need to be tracked simultaneously. Mixing them into one view creates noise; ignoring any of them creates blind spots.

Active Listings Pipeline: Every deal needs a consistent status — Active, Under Contract, Pending, Closed — along with the property address, client name, listing price, expected close date, and your commission rate. When you have 14 active deals, this is the daily reference point. It tells you what’s moving and what’s stalled.

Showings Log: Each showing needs a date, buyer name, property, time, and outcome. This isn’t just scheduling; it’s evidence. When a buyer later claims they never saw the property, or a seller asks why there haven’t been viewings, you need a timestamped record, not a memory.

Offer and Counter Tracker: Multi-offer situations are where tracking discipline pays off directly. Recording every offer received, every counter made, and the final accepted price protects you legally and helps you analyze patterns across deals.

Commission Forecast: This is the data most solo realtors are missing entirely. Knowing what you have in your pipeline is not the same as knowing what you will earn this month. A deal at 40% close probability contributes differently to your forecast than one at 90%.

Lead Source ROI: After six months of data, you can answer: which source — referral, Zillow, open house, social — generates the most closed deals? Which produces the highest average commission? This is how you allocate your next marketing dollar intelligently instead of by habit.

The Commission Forecasting Problem

Most realtors estimate monthly income the same way: they look at their pipeline, make rough mental adjustments for deals that seem shaky, and arrive at a number they aren’t confident in. The actual math — probability-weighting each deal against its commission potential and summing the projections — rarely gets done because it’s tedious to do in a spreadsheet.

The result is that income surprises happen in both directions. A slow month comes as a shock because two deals you expected to close slipped. A strong month gets partly wasted because you didn’t anticipate the cash flow and had already committed expenses.

Commission Forecast with Close-Probability Weighting is the exclusive feature in the Real Estate Agent Pipeline OS. Set a close probability on each active deal, and the Commission Forecast tab calculates projected monthly income in real time, without any formula maintenance. It’s the only real estate tracker on Etsy that does this as an interactive calculation rather than a static row in a spreadsheet.

What a Good Tracking System Looks Like in Practice

The Real Estate Agent Pipeline OS is a single HTML file — six tabs, no subscription, no login, no internet required after download:

• Overview — summary stats for your full pipeline
• Pipeline — every active deal with status, close date, and commission rate
• Showings — per-property calendar with outcome notes
• Offer Tracker — full negotiation history per deal
• Commission Forecast — probability-weighted income projection for the month
• Lead Source ROI — closed deal and commission analysis by acquisition channel

Your client names, property addresses, and financial figures never leave your device. The Export Backup button downloads a private JSON file; Load Backup restores it on any computer.

One-time purchase at $24. No subscription.

Get the Real Estate Agent Pipeline OS on Etsy →