How to Forecast Team GCI With Seasonality (With a Downloadable Model)

Why generic CRM forecasts are wrong

Follow Up Boss, kvCORE, and most other CRMs will show a forecast chart if you plug in an annual GCI target. Look under the hood, though, and almost all of them are doing the same thing: dividing your annual target by twelve and drawing a straight line through the year.

Real estate does not transact linearly. National existing-home-sales data shows a trough in December and January, a build through spring, a peak in June and July, and a soft-down into Q4. If your annual target is $480,000, the flat forecast says every month should book $40,000. In practice, June routinely books 30% above that, and December 50% below it. A team lead running a straight-line pacing model will start emergency coaching conversations in November for agents who are actually on track, and miss coaching conversations in April with agents who are quietly starting to fall behind.

We built the /team-kpi-software product page around exactly this problem — the seasonality-adjusted pacing chart on that page shows the naive-vs-seasonal contrast visually. The rest of this article walks through the same math so you can replicate it on your own.

The math, in plain English

The core idea is one you already understand intuitively: some months are hotter than others. The trick is representing that as numbers you can plug into a formula.

A seasonality index is a set of 12 monthly coefficients whose sum equals 12.00. A perfectly flat year has every coefficient equal to 1.00. A month that historically produces 30% above the annual monthly average gets a coefficient of 1.30. A month that produces 50% below gets 0.50. Once the 12 values sum to exactly 12.00, you can multiply them against any annual target and the totals still work out — nothing is inflated or deflated in aggregate.

The forecast for any given month is then just: (monthly index / 12) × annual target. In the downloadable model, June's National index is 1.36. Against a $480,000 annual target, that's (1.36 / 12) × $480,000 = $54,400. December's National index is 0.46 — (0.46 / 12) × $480,000 = $18,400. Both extremes together still sum, across all twelve months, to exactly $480,000.

That's the whole model. Everything else — regional variations, cumulative pacing, quota alerts — is bookkeeping on top of that single formula.

Walking through the model

The downloadable Excel model has four tabs.

1. Instructions — one-paragraph orientation and the note that the coefficients are illustrative starting points, not derived from ShowSmartly customer data.
2. Inputs — two cells. B4 is your annual GCI target (yellow, editable). B5 is a dropdown for region (National, Northeast, Midwest, South, West).
3. Seasonality Coefficients — the 12 monthly indices for each of the 5 regions. Every column sums to exactly 12.00, with a sum-check row at the bottom and a source note.
4. Forecast — the working tab. INDEX/MATCH formulas pull the correct region column based on Inputs!B5, compute monthly weights, apply them against Inputs!B4, and produce a side-by-side of the seasonality-adjusted forecast and the naive (flat) forecast, plus cumulative pacing and cumulative % of target.

With the default inputs — $480,000 annual target, National region — the forecast produces this shape: Jan $27,200 → Feb $29,600 → Mar $37,600 → Apr $45,200 → May $51,600 → Jun $54,400 → Jul $53,200 → Aug $49,600 → Sep $44,400 → Oct $39,200 → Nov $29,600 → Dec $18,400. Six months of the year, the seasonal forecast is more than 10% away from the naive flat $40,000. Those are the six months where a straight-line pacing chart lies to you.

To load the model with your own team's numbers, change Inputs!B4 and Inputs!B5. To make it truly team-specific, replace the coefficients on the Seasonality Coefficients tab with your team's own trailing-24-month history (indexed so the 12 monthly values sum to 12.00). That's the manual version of what our platform does automatically — see the homepage overview for the full picture.

From static spreadsheet to live dashboard

The spreadsheet is fine for setting an annual plan in January. It stops being useful in month three, when your actuals start diverging from the forecast and someone has to type the new numbers in.

ShowSmartly runs this same math live against your Follow Up Boss data. Every night, the platform pulls your team's closed-deal history, rebuilds the seasonality index from your own trailing 24 months (falling back to the regional profile if you're a new team without enough data), and updates the forecast against actuals. The pacing chart on the team dashboard is exactly this math — seasonality-adjusted target line, actuals overlay, cumulative pacing, and an automatic flag when any agent or the team overall crosses the intervention threshold covered in the 7 KPIs post.

GCI forecasting in real estate isn't a spreadsheet problem — it's a data-freshness problem. The math has been solved for a hundred years; the reason most teams still forecast wrong is that nobody has time to keep the spreadsheet current.