Real Estate Sales Forecast Template

Start with the Revenue Assumptions sheet. Enter your expected monthly deal count for each transaction type — residential buyer deals, seller listings, commercial, and any rental placements. Set an average sales price per category based on your market and your typical price point, then enter your commission rate. If you have referral splits, you can account for those here too. This takes about 15 minutes and once it's done, the rest of the workbook populates automatically.

Move to the Pipeline Tracker and log your current active deals. For each one, enter the client name, expected close month, projected sales price, and your close probability. The sheet handles the probability weighting — a $500,000 listing at 50% probability contributes $7,500 in expected commission to your forecast, not the full $15,000. Keep this updated weekly as deals progress or fall out, and your Monthly Forecast will stay accurate without any manual adjustments.

Check the Forecast vs Actual sheet each time a deal closes. Enter the real commission and the sheet shows you how you're tracking against your plan. Most agents find that looking at the variance monthly tells them something useful — whether it's that their pipeline is converting slower than expected, that they've been forecasting average sales prices too conservatively, or that a particular deal type is consistently underperforming. Use the Scenarios sheet before making a major decision, like hiring or increasing ad spend, to see what your financials look like under different deal volume assumptions.

Real estate income is lumpier than almost any other industry. A single month can swing from your worst to your best of the year depending on which deals are scheduled to close. Without a forecast built around your actual pipeline and deal conversion rates, it's nearly impossible to make confident decisions about marketing budgets, support staff, or personal draws. Most agents know their annual GCI goal but don't have a month-by-month plan — which means every slow month feels like a crisis instead of a predictable seasonal dip.

A good real estate sales forecast is built on three numbers: projected deal count, average sales price, and commission rate by deal type. Residential buyer deals and seller listings often have different commission rates, different close timelines, and different seasonal patterns. Commercial deals tend to be larger but less frequent. Rental placements are smaller but more predictable. Breaking these out separately gives you a much more accurate revenue picture than averaging everything together — and it tells you which deal type to prioritize when you want to grow.

The pipeline tracker is what separates a useful forecast from a wish list. When every active deal is logged with a close probability, your monthly revenue projection reflects reality rather than optimism. If your pipeline shows $60,000 in potential GCI but all the deals are at 25% probability, your effective expected revenue is $15,000 — and you need to know that before you commit to expenses. Agents who review their pipeline weekly and update their forecast monthly consistently make better decisions about when to hire, when to advertise, and when to conserve cash through a slow stretch.