# How to build a monthly real estate market report for clients on Mac in 2026

> Build a monthly real estate market report for clients in less time. Learn the data setup, the error checks and the Mac tools that keep it accurate.

URL: https://www.lazur.app/for/realtors/problems/monthly-market-report-for-clients
Updated: 2026-11-08

A monthly real estate market report for clients is a short document that shows sales, prices and listings for one area. You can build it faster by setting up one master sheet, locking the formulas and having a second person check the numbers before anything goes out.

## Quick answer

- Set up one master sheet with a raw tab, a calculation tab and a report tab.
- Lock the calculation formulas so a typed number cannot overwrite them.
- Link charts to the table, then have a second person check totals and dates.
- Use Pages mail merge for personal copies, and test one copy first.
- Use AI for first drafts only. Check every market number against your own export.

## What building client market reports by hand costs you

- **Hours you do not get back.** NAR's 2026 Member Profile reports a median of 35 hours a week for Realtors in 2025, and 30 for sales agents. The profile does not break out report work. Assume the report takes a real share of that time, then measure it. Every hour spent rebuilding a file is an hour not spent with a buyer or seller.
- **Errors that reach the client.** Panko's audits of business spreadsheets found important errors in 83% to 91% of the audited files. A wrong median or a stale chart can reach a client before anyone checks it. Once a client catches one wrong number, they may check the rest. That risk costs more than the hour you saved by skipping the review.
- **Stress and time away from clients.** The only stress figure I could verify comes from Australia. A 2020/21 survey of more than 900 agents found 43% often stress about workload. It is not a US study, and it does not isolate report work. Treat it as context, not proof, but cut repeat admin work where you can.

## Why it happens

1. **Data lives in several places.** Each source has its own export, date format and idea of what counts as a sale. You copy from one source, then another, and the seams are where mistakes start. Hutly describes this pattern in its CMA article, though it cites no study for it.
2. **Spreadsheets grow by accident.** Panko's review cites research finding that spreadsheets were built informally and iteratively by people with little training. A file that started as one month's work becomes the monthly template, with patches added on top each time a client asks for something new.
3. **People are poor at checking their own work.** Panko found that people are good at avoiding mistakes while they work, but much weaker at finding errors afterward. In his inspection experiments, people caught about 60% of errors, and single inspectors caught between 34% and 69%. Your own review will miss things you wrote.
4. **Each client wants a slightly different report.** Clients ask for a new neighborhood, a new price band or a different chart. Each change tempts you to rebuild a section instead of changing one input. That is how a reusable template turns into a one-off file that nobody can audit.

## How to fix it

- **Keep one master sheet with a raw tab.** Build one file with a raw tab, a calculation tab and a report tab. Paste each month's export into the raw tab only, and write the export date in cell A1. Nothing on the calculation tab gets typed by hand. You can build this in Google Sheets in Chrome, Numbers or Excel without buying anything extra.
- **Protect the formulas.** In Google Sheets in Chrome, select the calculation range and open Data > Protect sheets and ranges. Add a note that says who may edit. Panko's review describes users overwriting formulas with numbers where cell protection was not in use, so this step closes that gap. Menu labels can change, so look under the Data menu if the wording differs.
- **Use a second reviewer and a checklist.** Ask one colleague to check the totals, the dates and the chart labels, not the layout. Use a short written checklist, so the review is the same each month. Panko recommends several inspectors and a walkthrough of each part of the file. Limit how much you ask them to check at once, so the review stays careful.
- **Link charts to the table, not to a pasted copy.** In Numbers for Mac, click the Chart button in the toolbar, then choose Add Chart Data and select the table cells. Apple says the chart updates when table data changes. In Google Sheets, use Insert > Chart, so the chart reads the live cells. A chart built on a pasted copy goes stale the next time you update the data.
- **Send personal copies with a test first.** Pages mail merge can fill a name, address and date from Contacts or a Numbers sheet. Run one test copy, read it on screen, then run the rest. Check the first and last names, the date, and the chart on every output. Send from Gmail, and schedule the send if your clients read email at a set time of day.

A monthly report does three jobs. It shows what the market did in one area, it shows what changed since last month, and it gives your client a reason to call. Most agents build it the same painful way each month. They open several sites, copy numbers into a file, and fix the chart last. That routine is where the hours go.

## Why a monthly market report eats so much time

No survey I could open measures how long one report takes, so there is no clean benchmark. The closest figure is NAR's 2026 Member Profile, as reported by HousingWire. Realtors reported a median of 35 hours a week in 2025. Sales agents reported a median of 30 hours. Brokers and managers who sell reported 40 to 45 hours. The profile does not split out report work, so you cannot tell how much of that time goes to reports. Your own timer will tell you more than any average.

- **35 hours** Median weekly hours for Realtors in 2025 (sales agents: 30). NAR does not break out report work. ([source](https://www.housingwire.com/articles/nar-2026-member-profile-experience/))
- **83% to 91%** Share of audited business spreadsheets with important errors, depending on the subset. Not real estate data. ([source](https://panko.com/ssr/Audits.html))
- **68%** Of AI-using respondents in an RPR survey of 225 NAR members, the share saving at least 1 hour a week. ([source](https://blog.narrpr.com/tips/real-estate-agents-use-ai/))
- **$52,830** Median pay for real estate sales agents, May 2025. 54% of agents are self-employed. ([source](https://www.bls.gov/ooh/sales/real-estate-brokers-and-sales-agents.htm))

Time your next report. Start the timer when you open the first data source. Stop it when the PDF is attached and sent. Write the total on a sticky note. Next month, track the same steps and see which one grew. That step is your first fix.

## Where the numbers live before they reach your report

Hutly, a vendor that sells CMA software, describes a pattern many agents recognize. Comps come from one system, listing history from another, and market trends from a third. Each lookup takes only minutes, but a handful of repeats add up. Hutly cites no study for this claim, so read it as a description, not a measurement. Your own log of steps is more useful.

| Data point | Where it usually lives | Common mistake |
| --- | --- | --- |
| Closed sales and sold prices | MLS search or your brokerage tool | Mixing list price with sold price |
| Active listings | MLS search, exported or saved as a screenshot | Counting pending or withdrawn homes |
| Days on market | MLS statistics or your own export | Changing the start date each month |
| Neighborhood trends | Public records or a third-party site | Comparing areas with different boundaries |

_Typical sources for a monthly report. Check your MLS license before you export or share raw data._

## How spreadsheet errors creep into client reports

Raymond Panko, a researcher at the University of Hawaii, reviewed audits of business spreadsheets. His review found important errors in 83% to 91% of the audited files, depending on the subset. Those are business spreadsheets, not real estate reports, so treat the figure as a warning, not a forecast for your file. The pattern still matters. Many spreadsheets were built informally, by people with little training, and then changed over time.

- Formulas overwritten with typed numbers. Panko cites a study where users typed over formulas in cells that were not protected.
- Ranges that stop one row short after you add a new sale.
- Date filters that start on a different day each month.
- Charts that still point at old cells after you move a column.
- A sold home counted twice after you paste a second export into the same tab.

Panko also reports that about 5% of audited spreadsheets had show-stopper errors, beyond serious ones. That share is small, but one wrong median price in a client report gets noticed. Check the sums before you check the design.

## Set up one master sheet you reuse every month

Build the sheet once, then stop rebuilding it. Give the file three tabs. Use one for raw exports, one for calculations and one for the report page. Paste each month's export into the raw tab, and write the export date in cell A1. Nothing on the calculation tab gets typed by hand. Rebuilding is where most repeat work hides, so this setup removes it. If Sheets is new to you, the [Google Sheets guide for realtors](https://www.lazur.app/for/realtors/google-sheets) covers the basics.

![Agent at a laptop preparing a monthly real estate market report for clients](https://images.lazur.app/content-images/problem/monthly-market-report-for-clients/monthly-real-estate-market-report-for-clients-1-12a5f1.jpg)

## Lock the formulas so a typed number cannot overwrite them

In Google Sheets in Chrome, select the calculation range. Then go to Data > Protect sheets and ranges. Add a description, then set who can edit. Protected cells still show their values, but only the people you allow can change them. Menu labels can shift between versions, so look under the Data menu if the wording differs. Panko's review links overwritten formulas to unprotected cells, so this step targets a known failure.

## Build the charts in Numbers or Google Sheets

In Numbers for Mac, select the table cells you want to chart. Click the Chart button in the toolbar, then choose Add Chart Data. Select the cells and click Done in the bottom bar. Apple says the chart updates automatically when table data changes. The data can come from several tables, including tables on other sheets. In Google Sheets, use Insert > Chart, and follow the [chart steps for Chrome](https://www.lazur.app/how-to/make-a-chart-in-google-sheets).

![Real estate agent reviewing a market report with clients at a table](https://images.lazur.app/content-images/problem/monthly-market-report-for-clients/monthly-real-estate-market-report-for-clients-2-c203af.jpg)

## Send personal copies with Pages mail merge

If every client gets the same report with a different name, Pages can fill those fields for you. Apple says merge fields can be populated from the Contacts app or a Numbers spreadsheet. The path is Document button in the sidebar > Document tab > Mail Merge > Add Merge Field. Apple says you can quickly and automatically create multiple custom documents. Run one test copy first, then check the name and date on the output.

## Excel for Mac users: check the data source first

If your data lives in Excel for Mac, Microsoft's Power Query table lists Text & CSV and Excel workbook as included for refresh and import on Mac. The Web connector appears in the Windows column, but no Web row appears for Mac. That does not prove Web is unsupported. Test any web source on a copy before you build a monthly routine around it. Importing a CSV you exported, where your license allows it, is the safer path.

## Check every number before the client sees it

Panko's inspection work found that people are good at avoiding mistakes while they work, but poor at finding them afterward. In his experiments, people caught about 60% of errors, and single inspectors caught between 34% and 69%. Panko recommends several inspectors and a walkthrough of each part of the file. Ask a colleague to check the sums, the dates and the chart labels, not the layout.

1. The date stamp matches the export date on the raw tab.
2. Every chart points at the current month, not last month.
3. Sold prices, list prices and active listings are labeled and never mixed.
4. A second person checked the totals and the sum of the parts.
5. Sources and the export date appear in a footnote on the last page.

## Where AI helps, and where to stay careful

RPR surveyed 225 real estate professionals who are NAR members. Of those, 82% said they use AI in their business. Of the AI users, 68% save at least 1 hour a week. The survey is not random, so treat it as a signal, not a census. NAR's 2025 Technology Survey tells a different story: 32% of REALTORS had not used AI in their business yet, and 46% reported no noticeable impact.

RPR also found that agents are more cautious when AI touches pricing, market interpretation and compliance-sensitive client guidance. A market report is exactly that kind of document. Let AI draft plain sentences, then check every number against your own export.

## Data rules, licenses and client privacy

Market data often comes with license terms. Your MLS license and your brokerage policy set how you may export, reuse and share listing data. I could not read the MLS policy text while researching this page, so confirm the rules with your broker before you email raw listing data. Lawyers, nurses, accountants and other regulated professionals follow their employer's rules for client data. Realtors should give client names, addresses and offer details the same care.

## Edge cases: thin markets and new neighborhoods

Some areas have only a few sales in a month. One sale can move an average a lot. Show the sales count next to every median. If the count is low, say so in one sentence, and show a longer time window as well. For a new subdivision, be clear that the data starts at the first closing. A short note beats a confident chart built on too little data.

## Common mistakes that waste next month too

- Rebuilding the template from scratch instead of copying last month's file.
- Sending the report before a second person checks the totals.
- Showing a seasonal trend without saying which season it covers.
- Forgetting to note a small sample, then reacting to a swing that is just noise.
- Writing commentary after the charts, so the story bends to fit numbers you already have.

## Where Lazur fits in this routine

Lazur is a voice assistant for the Mac. Hold ⌥ ⌘ to ask about anything on screen, and it answers out loud. Ask where something is, and it draws a circle and a label around it. Ask how to do something, and it guides you one click at a time, waiting for each click. It does not click for you, edit your files or operate other apps.

Use it for the parts that stall you. Hold fn to dictate your commentary at the cursor in any app. Ask it to draft a cover email, then edit and send it yourself in [Gmail](https://www.lazur.app/for/realtors/gmail). For public source gathering, research runs in Lazur's own Chrome tabs and returns a summary and report. Check every figure against your own export. A 3-day Pro trial starts when you first open the app, with no credit card, so you can test this on a real report.

## What to do this week

Start with the master sheet and the formula lock. Those two steps remove the most risk from the next report. Then add the second reviewer and the checklist. Mail merge and AI drafts come last, once the numbers are stable. Keep the timer running for the first two cycles so you can see where the time actually goes.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is Chart in this sheet?”: Lazur circles Insert in the menu bar, labels Chart, and leaves the click to you. (Points at it)
- “Where is Insert > Chart in this sheet?”: Lazur circles the menu and labels the item, then waits while you make the click.
- “Explain why this formula returns an error.”: Lazur reads the cell on screen and explains the error out loud, in plain words.
- “Dictate the market commentary at the cursor.”: Hold fn and speak. Clean, formatted text appears at the cursor in any app.
- “Draft a cover email for this monthly report.”: Lazur drafts the text. You edit it and send it from Gmail yourself.
- “Research recent sales context for this neighborhood.”: Research runs in Lazur's own Chrome tabs and returns a summary and report. Check every figure before you use it.

## A plan you can start this week

- **Day 1: Set the metrics and the template.** Write the handful of numbers your clients care about on one page. Define each one the way your MLS does, and write those definitions on the first tab. Build the empty master sheet with a raw tab, a calculation tab and a report tab. Lock the calculation tab before you add any data.
- **Day 2: Pull and paste the raw data.** Export last month's sales and listings from your MLS, if your license allows it. Paste them into the raw tab, and write the export date in cell A1. Do not type over anything on the calculation tab. Note where each number came from in a short source line.
- **Day 3: Build the charts and the commentary.** Link your Numbers or Google Sheets charts to the calculation tab. Dictate the commentary with fn, then read each sentence against the numbers. Flag thin samples in one line, and keep the story to what the data supports.
- **Day 4: Run the second check.** Hand the file to a colleague. Ask them to check totals, dates and chart labels only. Fix what they find, rerun the calculation tab, then check the changed cells again. Log how many problems the review found, so you can see the trend.
- **Day 5: Export, test and send.** Export the PDF from Google Sheets or Numbers. For personal copies, run Pages mail merge with one test copy first. Send from Gmail, or schedule the send for the time your clients usually read email. Record the total time, so you can compare it with your first timed report.

## FAQ

### How long does a monthly real estate market report take to build?

No study I could open measures it. NAR's 2026 Member Profile reports a median of 35 hours a week for all Realtor work, not for reports. Time one report yourself, from the first export to the sent PDF, and use that total as your baseline.

### Can I use MLS data in a report I send to clients?

Often, with limits. Your MLS license and brokerage policy set the rules for export, reuse and sharing. The policy text was not readable in my research, so confirm with your broker before you send raw listing data. Ask whether charts and summaries count differently from full exports.

### Should I use AI to write the market commentary?

Use it for a first draft of plain sentences. RPR found agents are more cautious when AI touches pricing and market interpretation. Read every claim against your export. You stay responsible for what the client reads.

### Google Sheets or Numbers for a monthly market report?

Use the tool your clients and team can open without friction. Google Sheets runs in Chrome and shares easily. Numbers charts update from table data, according to Apple. Many agents keep data in Sheets, then design the final page in Canva or Pages.

### Does Lazur see my client data?

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is not used to train AI models. Check your brokerage rules before you show client data to any tool.

### What part of the report can Lazur take off your hands?

Lazur points, explains, dictates and drafts text. When you ask how to do something, it guides you one click at a time. It does not click buttons or operate other apps for you, so the building and checking stay with you.

### Does Excel for Mac support web data for reports?

Microsoft's Power Query table lists Text & CSV and Excel workbook as included for Mac. It does not list the Web connector for Mac, though it lists Web for Windows. Test any web source on a copy before you depend on it.

## Sources

1. [NAR 2026 member profile shows Realtors more experienced](https://www.housingwire.com/articles/nar-2026-member-profile-experience/), HousingWire, checked 2026-11-08
2. [REALTORS Embrace AI, Digital Tools to Enhance Client Service, NAR Survey Finds](https://www.nar.realtor/press-releases/realtors-embrace-ai-digital-tools-to-enhance-client-service-nar-survey-finds), National Association of REALTORS, checked 2026-11-08
3. [82% of Real Estate Agents Use AI. The Real Gap Is Confidence](https://blog.narrpr.com/tips/real-estate-agents-use-ai/), Realtors Property Resource (RPR), checked 2026-11-08
4. [Audits of Operational Spreadsheets](https://panko.com/ssr/Audits.html), Raymond Panko, University of Hawaii, checked 2026-11-08
5. [Real Estate Brokers and Sales Agents: Occupational Outlook Handbook](https://www.bls.gov/ooh/sales/real-estate-brokers-and-sales-agents.htm), U.S. Bureau of Labor Statistics, checked 2026-11-08
6. [43% of agents admit to often stressing about workload](https://www.realestatebusiness.com.au/industry/23549-43-of-agents-admit-to-often-stressing-about-workload), Real Estate Business, checked 2026-11-08
7. [Why Preparing a CMA Still Takes Too Long](https://www.hutly.com/blog/why-preparing-a-cma-still-takes-too-long), Hutly, checked 2026-11-08
8. [Add column, bar, line, area, pie, donut, and radar charts in Numbers on Mac](https://support.apple.com/guide/numbers/add-column-bar-line-area-pie-donut-radar-tan727160fa/mac), Apple Support, checked 2026-11-08
9. [Add, change, or delete a merge field in Pages on Mac](https://support.apple.com/en-ca/guide/pages/tan1ef722d07/mac), Apple Support, checked 2026-11-08
10. [Power Query data sources in Excel versions](https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16), Microsoft Support, checked 2026-11-08