Key takeaways
- A monthly pack should lead with decisions, not data: one headline page, then pipeline, production, lead response, marketing, agents, finance, market and risk.
- Pending sales are the best early signal of next quarter's income; nationally they parallel closed sales over the following two months[1].
- Fewer than half of REALTORS use a CRM[2], so the first job is often making sure the data exists at all.
- Fix definitions once (what counts as a lead, an appointment, a pending) and never change them mid-year.
What a monthly pack is for
Most brokerage reports are a stack of exports: closings from the transaction system, leads from the CRM, a profit and loss statement from the bookkeeper. Each is accurate. Together they rarely answer the questions an owner actually has at the end of a month: are we on track, where is the problem, and what do we do about it before next month?
A good reporting pack is short, the same every month and built around decisions. It should take an owner ten minutes to read and a manager about ninety minutes to prepare. The structure below works for a single office of fifteen agents and scales to a multi-office firm by adding a column per office.
Who reads it and what they need from it
| Reader | Decisions they make | Pages they read first |
|---|---|---|
| Owner or broker of record | Budget, hiring, marketing spend, compliance priorities | Headline, finance, risk |
| Office or sales manager | Coaching, lead routing, recruiting, agent accountability | Pipeline, lead response, agents |
| Team leaders | Lead distribution, team splits, staffing | Pipeline, lead response, marketing |
| Marketing lead | Channel spend, campaign changes | Marketing, lead response |
If a page does not help any of these readers make a decision, drop it. Long packs do not get read, and an unread pack is worse than none because it creates the feeling that the business is being managed.
The pack, page by page
Headline page
Five numbers against target and last year: closed sides, gross commission income, company dollar, new pendings and appointments set. Add three sentences: what went well, what went wrong, and the one decision needed this month.
Pipeline
Pending deals by expected close month, active listings, signed buyer agreements, and deals that fell through this month with the reason. This page predicts the next few months of income.
Production
Closed sides and volume by agent and by team, year to date against the plan. Show the median agent as well as the top producers, because averages hide a long tail.
Lead response
New leads by source, median time to first contact, share of calls answered live, and appointments set per hundred leads. Responsiveness matters to clients: 77% of agent-using sellers rate an agent's initial responsiveness as very or extremely important[3].
Marketing
Spend by channel, cost per appointment and cost per closing over a trailing twelve months. Monthly cost per closing swings too much to act on alone.
Agents and recruiting
Headcount, joins, departures, agents below minimum production, and agents approaching their cap. Departures need a reason code, not a blank.
Finance
Company dollar against budget, fixed costs, cash position and receivables from pending deals. Separate one-off costs so the trend is readable.
Market context
Three or four local figures beside the national ones: inventory, months of supply, days on market, median price. National context helps explain your numbers; it does not excuse them.
Risk and compliance
Open complaints, files missing documents, expired licenses or training, wire-fraud incidents or near misses, and any advertising issues. Keep this page even when it is empty.
Where the data comes from
A pack is only as good as the systems it pulls from. Most agents already use the MLS and e-signature tools, and many use showing and pricing tools, but CRM use lags far behind: only 46% of REALTORS use one[2][4][5][6]. That gap is why lead-response and appointment figures are often the weakest part of a brokerage report.
If agents work leads outside the brokerage CRM, start by requiring a few fields for every lead (source, date, first-contact time and stage) rather than full adoption. A partial, consistent record is more useful than a complete one that half the office ignores.
Leading and lagging numbers
Closed sides and commission income are lagging numbers: they tell you what happened. Appointments and pendings are leading numbers: they tell you what is about to happen. NAR notes that monthly pending sales activity parallels closed existing-home sales in the following two months[1], and the same pattern holds inside a brokerage. In September 2026, national pending sales fell 7.3% from the month before and 11.3% from a year earlier[7], an early warning for closings later in the year.
Put leading numbers on the headline page. An owner who sees only closings learns about a problem two months after it could have been fixed.
Example: one month's headline page
Example (fictional brokerage, 18 agents). The headline page for October might read like this:
- Closed sides: 21 against a target of 24 (last October: 23).
- Gross commission income (Example): 188,000 dollars against a 214,000 dollar target.
- New pendings: 17, down from 22 in September; three deals fell through on financing.
- Appointments set: 64, up from 58, with median first response on portal leads at 11 minutes.
- What went well: listing appointments up after the September open house campaign.
- What went wrong: weekend calls to the main line went to voicemail on two Saturdays.
- Decision needed: approve weekend phone coverage before the spring market.
Every figure in that Example is fictional, but the shape is the point: five numbers, three sentences and one decision.
Definitions that keep the numbers honest
- Lead: a person who contacted the brokerage or an agent about buying, selling or renting, with at least a name and a way to reach them. Agent-to-agent calls are not leads.
- Appointment: a scheduled meeting or call with a clear purpose, such as a buyer consultation, listing appointment or first showing.
- Pending: an accepted contract with signatures from all parties, counted in the month it was accepted.
- Fall-through: a pending that terminated, counted in the month it ended, with one reason code.
- Time to first contact: minutes from lead creation to the first two-way conversation, not the first automated message.
Write these definitions on the last page of the pack. When a number moves, the first question should be about the business, not about whether someone counted differently.
A ninety-minute monthly routine
- Day one of the month: export closings, pendings and fall-throughs from the transaction system.
- Day one: export leads, appointments and response times from the CRM and phone system.
- Day two: update the finance page with the bookkeeper's figures.
- Day two: add local market figures and the latest national releases.
- Day three: write the three headline sentences and the decision, then send the pack before the management meeting.
Making the pack easy to read
Format matters more than most managers expect. A pack that looks different every month forces readers to search for the numbers they care about, and they soon stop looking.
- Keep every page in the same order and the same layout each month.
- Show each figure next to its target and the same month last year, never on its own.
- Use one simple chart per page at most, and label the axis in plain words.
- Mark anything that needs a decision in the headline sentences rather than with color coding alone.
- Put agent-level detail in an appendix so the main pages stay short.
Send the pack as one document before the meeting, then use the meeting to discuss the decision on the headline page rather than to read the numbers aloud.
Common mistakes
- Reporting only top producers, which hides how the median agent is doing.
- Changing a definition mid-year and comparing the new number with the old one.
- Leaving fall-throughs out of the pipeline page; nationally, 47% of sellers had at least one offer fall through in Zillow's latest survey[8].
- Treating national inventory as your own; national supply was 4.8 months in September 2026[9], but your market may be far tighter or looser.
- Adding pages every month and never removing any.
To set targets for the pack, use benchmarking your brokerage against industry data, and for the market page, the housing market indicators agents should watch.
Frequently asked questions
What should a monthly brokerage report include?
A headline page with five key numbers and one decision, then pipeline, production, lead response, marketing, agents and recruiting, finance, market context, and risk and compliance.
Which numbers predict future closings?
Appointments set and new pendings. Pending sales usually turn into closings over the next two months, so a drop in pendings is an early warning.
How long should a monthly report be?
Short enough to read in about ten minutes. One page per section is plenty, and any page that does not support a decision should be removed.
What if agents do not log leads in the CRM?
Start by requiring a handful of fields for every lead, such as source, date, first-contact time and stage. Consistent partial data beats complete data that only some agents enter.
References
National Association of REALTORS® (2026). Pending Home Sales Decreased 7.3% in September (opens in a new tab) ↑
National Association of REALTORS® (2026). REALTORS® Adopt Technology to Save Time and Improve the Client Experience, NAR Report Finds (2026 REALTORS® Technology Report) (opens in a new tab) ↑
Zillow Research (2026). Sellers: Results from the Zillow Consumer Housing Trends Report 2026 (opens in a new tab) ↑
National Association of REALTORS® (2026). REALTORS® Adopt Technology to Save Time and Improve the Client Experience, NAR Report Finds (2026 REALTORS® Technology Report) (opens in a new tab) ↑
National Association of REALTORS® (2026). REALTORS® Adopt Technology to Save Time and Improve the Client Experience, NAR Report Finds (2026 REALTORS® Technology Report) (opens in a new tab) ↑
National Association of REALTORS® (2026). REALTORS® Adopt Technology to Save Time and Improve the Client Experience, NAR Report Finds (2026 REALTORS® Technology Report) (opens in a new tab) ↑
National Association of REALTORS® (2026). Pending Home Sales Decreased 7.3% in September (opens in a new tab) ↑
Zillow Research (2026). Sellers: Results from the Zillow Consumer Housing Trends Report 2026 (opens in a new tab) ↑
National Association of REALTORS® (2026). Existing-Home Sales Increased 1.5% in September, According to NAR Report (opens in a new tab) ↑