Knowing how to track real estate sales is what separates a brokerage that can explain its numbers from one that only finds out at month end. Tracking is not the same as reporting. A report tells you what closed last month; tracking tells you, every week, which enquiries became viewings, which viewings became offers and which offers are close to completion. This guide explains what to record on every deal, which handful of metrics deserve attention, how to run a short weekly review, and when a spreadsheet stops being enough. It is written for brokerage owners, sales managers and team leads who want a sales picture they can trust without adding admin to every agent's day.
What does it mean to track real estate sales?
Tracking real estate sales means recording every enquiry, viewing, offer and closed deal against the same agent, property and source, so that you can follow each sale from first contact to commission and measure where volume is gained or lost. The point is traceability. Any closed deal should lead back to the enquiry that started it, and any enquiry should show what happened next.
Most teams already record pieces of this. The listing sits in one place, the buyer's phone number in an agent's mobile, the offer in an email thread and the commission in an accounts file. Each piece is accurate on its own, but nobody can connect them. Tracking joins those pieces into one chain of events per transaction.
It helps to separate three layers:
- Activity: calls, messages, viewings and meetings logged by agents.
- Progress: the stage each deal has reached and how long it has been there.
- Outcome: closed value, commission earned, and the reason a deal was lost.
A brokerage that only measures outcomes sees problems a month too late. One that only measures activity rewards being busy. You need all three, linked together.
What to record on every deal
Good tracking depends on a short list of fields that are always filled in, rather than a long form that agents skip. If a field is not used in a weekly review or a report, consider removing it.
On the lead
- Source: where the enquiry came from, chosen from a fixed list rather than typed freely, so you can compare channels later.
- Date and time received, and the time of first response.
- Assigned agent, set at the moment of assignment, not after the deal closes.
- Requirement: buy or rent, budget range, area and property type.
On the deal
- Linked property and linked contact, so the deal is never an orphan record.
- Stage, using one agreed set of stages with written entry rules. Our guide to real estate deal stages sets out a model you can adapt.
- Expected value and expected close date, updated when they change.
- Viewings and offers, each logged with a date and outcome.
- Lost reason, from a fixed list, whenever a deal is closed as lost.
On completion
- Final transaction value and completion date.
- Commission, including how it is split between agents, team leads and the brokerage.
The lost reason is the field most teams neglect and the one that pays back fastest. Without it, you know you lost twenty deals last quarter but not whether the cause was price, financing, timing or slow follow-up.
The real estate sales metrics that matter
It is easy to build a dashboard with forty numbers and act on none of them. Start with a small set that answers three questions: are we getting enough opportunities, are we converting them, and is the money arriving?
| Metric | What it tells you | Review cadence |
|---|---|---|
| New enquiries by source | Whether lead volume is healthy and which channels supply it | Weekly |
| First response time | How quickly new enquiries are contacted | Weekly |
| Enquiry-to-viewing rate | Whether qualification and follow-up are working | Weekly |
| Viewing-to-offer rate | Whether the right properties are being shown to the right buyers | Weekly |
| Offer-to-close rate | How well negotiation and paperwork are handled | Monthly |
| Average days in each stage | Where deals slow down | Weekly |
| Weighted pipeline value | Likely revenue over the next 30 to 90 days | Weekly |
| Closed value and commission | Actual results against target | Monthly |
Conversion rates are more useful than raw counts because they point to a specific step. If enquiries are rising but the enquiry-to-viewing rate is falling, more marketing spend will not help; faster, better follow-up will. Our guide on how to follow up with real estate leads covers that step in detail.
Compare each metric with your own history rather than an industry figure. Markets, price points and sales versus rental mix vary so much that an outside benchmark rarely tells you whether your team is improving.
How to track real estate sales week by week
The most reliable way to track real estate sales is a fixed weekly routine with the same numbers reviewed in the same order. Consistency matters more than sophistication, because trends only appear when the same measure is checked the same way every week.
- Monday: check data quality. Look for deals with no stage, no expected value, no linked property or no activity in the last seven days. Ask agents to fix these before anything else is discussed, otherwise every later number is unreliable.
- Review the funnel. Compare last week's enquiries, viewings, offers and closings with the previous four weeks. Look for the step where the rate dropped.
- Walk the stuck deals. Sort the pipeline by days in current stage. For each deal past your threshold, agree one next action and a date. Close as lost anything that is not genuinely live.
- Update the forecast. Confirm expected close dates for deals in late stages, then read the weighted pipeline value for the next 30 days.
- Check individual agents. Look at each agent's activity and conversion, not to rank them publicly, but to spot who needs help with which step.
Keep the meeting short. Thirty minutes is usually enough when the data is already in one place. If the meeting is spent arguing about which spreadsheet is correct, that is a tracking problem, not a sales problem.
Tracking sales by agent, team and source
Once the basic chain from enquiry to commission is recorded, the same data can be cut three ways.
By agent
Agent-level tracking shows where each person is strong. One agent may book many viewings but convert few into offers; another may convert well but respond slowly to new enquiries. These patterns suggest specific coaching rather than a general push to work harder. Pair conversion numbers with activity so that a quiet month caused by a low lead allocation is not mistaken for poor performance.
By team or branch
For brokerages with several teams or offices, comparing stage conversion between teams often reveals a process difference worth copying, such as one team qualifying buyers before booking viewings.
By source
Source tracking links marketing spend to closed revenue, not just to enquiry volume. A channel that produces many enquiries but few viewings may cost more per closed deal than a smaller channel with serious buyers. This only works if the source is captured at the first enquiry and never overwritten.
Commission belongs in the same picture. When commission splits are recorded on the deal itself, agents can see their earnings building as deals progress, which tends to improve how carefully they keep records up to date. See commission tracking for how this can be organized.
Spreadsheet vs CRM for real estate sales tracking
A spreadsheet is a reasonable place to start. It is flexible, familiar and free. Many small teams track sales well in one for a time. The limits tend to appear as the team grows or as more than one person edits the file.
| Need | Spreadsheet | Real estate CRM |
|---|---|---|
| Link enquiry, deal, property and commission | Manual, by copying references between sheets | Records are linked by design |
| Time in stage | Requires manual date columns and formulas | Calculated from stage history |
| Activity history | Usually kept elsewhere | Logged on the lead or deal record |
| Several agents updating at once | Risk of overwrites and version conflicts | Each agent updates their own records |
| Access control | Whole-file sharing | Role-based visibility |
| Manager views and forecasts | Rebuilt by hand each period | Available from current data |
A practical sign that it is time to move is when preparing the weekly numbers takes longer than discussing them. Another is when a closed deal cannot be traced back to its original source without asking the agent.
If you do move, export your existing records to CSV first, clean the source and stage values into fixed lists, and import them so that historical conversion rates are not lost.
How Real CEO supports real estate sales tracking
Real CEO is a real estate CRM and sales operating system built around the chain described above. Leads, deals, properties and commissions are separate records that link to each other, so a closed deal can be followed back to its enquiry and source.
- Deal pipeline with configurable stages for sales and rental deals, with offers and viewings recorded on the deal.
- Viewing-to-offer-to-close funnel that shows where deals drop out.
- Pipeline intelligence that flags stuck, at-risk and high-value deals for the weekly review.
- Revenue forecast over 30, 60, 90 and 180 days, weighted by deal probability.
- Revenue dashboard showing performance by agent and by lead source.
- Commission records with splits and approvals on each deal.
- CSV and Excel export for teams that want to analyse the data further.
These tools are designed to support the routine, not replace it. The weekly review, clean source data and honest stage updates still come from the team. Explore real estate sales software and dashboards and analytics to see how the pieces fit, or revenue forecasting for the forecast view in more detail.
Common real estate sales tracking mistakes
- Logging the deal only when it closes. This hides the pipeline entirely and makes conversion rates impossible to calculate.
- Free-text sources and stages. "Website", "web" and "site enquiry" become three channels in a report. Use fixed lists.
- Never closing deals as lost. Dead deals left open inflate the pipeline and the forecast. Closing them with a reason is useful data, not an admission of failure.
- Tracking too many metrics. Choose the few that drive a decision and review them consistently.
- Separating commission from the deal. When commission lives in a different system, revenue reporting and sales reporting disagree.
- Using numbers only to rank agents. Tracking works best when agents see it as a tool that helps them close, not as surveillance.
Fixing these usually costs nothing except agreement on a few rules. The real estate sales pipeline guide is a useful companion when you write those rules down.
Frequently asked questions
How do you track real estate sales?
Record every enquiry, viewing, offer and closed deal against the same agent, property and source, using one agreed set of deal stages. Review the funnel, stuck deals and forecast on a fixed weekly routine so that problems show up before month end.
What should a real estate sales tracker include?
At minimum: lead source, date received, first response time, assigned agent, linked property and contact, deal stage, expected value, expected close date, viewings, offers, lost reason, final value and commission split.
Which metrics matter most for real estate sales?
New enquiries by source, first response time, enquiry-to-viewing rate, viewing-to-offer rate, offer-to-close rate, average days in each stage, weighted pipeline value, and closed value with commission.
Can I track real estate sales in a spreadsheet?
Yes, especially for a small team. A spreadsheet becomes hard to manage when several agents edit it at once, when you need time-in-stage or activity history, or when preparing weekly numbers takes longer than discussing them.
How often should a brokerage review sales numbers?
Weekly for leading indicators such as enquiries, response time, conversion rates, stuck deals and the near-term forecast, and monthly for closed value, commission and offer-to-close rates.
What is the difference between sales tracking and sales reporting?
Reporting summarises results after a period ends. Tracking follows each deal while it is still in progress, so a manager can act on a stalled deal or a falling conversion rate during the month.
Why record a lost reason on every deal?
Lost reasons show whether deals are lost to price, financing, timing, property fit or slow follow-up. Without them you know how many deals were lost but not what to change.
Does Real CEO forecast sales revenue?
Yes. Real CEO provides a revenue forecast over 30, 60, 90 and 180 days, weighted by each deal's probability, alongside pipeline flags for stuck, at-risk and high-value deals.