The same scene repeats every month in a lot of small businesses: someone opens five different tabs (Google Analytics, the sales spreadsheet, the Ads panel, WhatsApp Business, the bank), copies numbers by hand into a document, and ends up with a report only that one person understands. Or it just doesn’t happen at all, because “you can sort of tell how the month went” without writing it down.
Both scenarios are expensive. The first, in hours. The second, in decisions made by gut feeling that a number would have corrected in time. A good monthly report isn’t a live dashboard, and it isn’t an endless spreadsheet either — it’s a short summary, with one conclusion per block, built to decide something concrete before the next month begins.
A monthly report is not a dashboard
A dashboard shows numbers that change constantly: today’s visits, this week’s sales, pending messages. It’s for watching, not deciding — nobody sits down to analyze a dashboard, they glance at it between other tasks.
A monthly report has a different purpose: it’s a fixed point in time, with the information already interpreted rather than raw. The question it answers isn’t “how’s everything going right now?” but “what did we learn this month, and what are we changing next month?”. Mixing up the two formats is why a lot of businesses end up with either a giant spreadsheet nobody reads in full, or no report at all because “it’s already all in the dashboard.”
The 5 blocks a report can’t do without
1. Executive summary
Three or four lines, right at the top, that anyone can read without opening the rest of the document. What happened this month, in one sentence, and what’s going to be different next. If the report gets read by a partner, a family member involved in the business, or by you six months from now, this block alone should cover the essentials.
2. Key numbers
Between four and six metrics, never more. Pick the ones that genuinely move the business — sales, website visits, conversion rate, cost of acquisition, support tickets — and always put last month’s figure right next to the current one so the trend is visible at a glance. A number without a comparison says nothing: “340 visits” doesn’t mean the same thing if last month was 200 versus if it was 500.
Resist the urge to cram in fifteen metrics “just in case.” The more numbers you list, the less attention each one gets.
3. What worked
One or two positive findings, each with a hypothesis for why. It’s not enough to say “sales went up” — try to explain the reason: did it line up with a promotion, a change on the website, a date on the calendar? The cause isn’t always certain, but proposing a reasonable hypothesis is what turns a data point into a lesson.
4. What didn’t work
The block people are most tempted to skip, and the most useful one. One or two weak spots from the month, stated plainly, without softening or over-justifying them. If a campaign flopped, or a page got plenty of traffic but zero conversions, this is where you say so clearly — it’s what keeps you from repeating the same mistake two months in a row.
5. Action for next month
The block that justifies everything above it. Between one and three concrete actions, each with an owner (even if that’s you) and, ideally, a date. “Improve marketing” isn’t an action; “test a different subject line on the first week’s newsletter” is. A report without this block is just a data file, not a report.
How to automate pulling the data together
The real bottleneck isn’t writing the report — it’s gathering numbers from different sources every month. Three tiers, depending on the size of the business:
Basic tier — spreadsheets with connectors. Google Sheets has free add-ons that pull data straight from Google Analytics and Google Ads into a cell, no copy-pasting required. For sales or bookings, if you’re using a tool with CSV export or a native Google Sheets export, schedule that export for the 1st of every month instead of doing it by hand.
Intermediate tier — a dashboard that updates itself. Looker Studio (free, from Google) connects directly to Analytics, Ads, and spreadsheets, and produces charts that refresh on their own. It doesn’t replace the report’s conclusions, but it eliminates the “copy numbers by hand” step entirely — block 2 of the report can literally be a screenshot of that dashboard.
Advanced tier — automation between tools. Once your data sources go past three or four (sales, web, social, email, customer support), automation tools like Zapier or Make can move data automatically into a central spreadsheet every night, so the data is ready before the next month even starts. This tier only pays for the setup time once the number of sources justifies it — for a business tracking two or three key numbers, it’s unnecessary complexity.
How long it should take each month
With sources connected and a fixed template (same 5 blocks, same order, every month), filling in the report should take 30 to 60 minutes. If it’s taking you more than two hours, there are usually one of two causes: you’re gathering data by hand that could be automated, or the report is trying to cover too many areas of the business at once instead of sticking to the metrics that actually matter.
The fixed template matters more than it seems. Changing the format every month forces you to re-decide what to include each time, which adds friction and eats time. Set the structure once, save it as a template, and limit the changes to the numbers and the conclusions — not the shape of the document.
A report nobody reads isn’t worth writing
A perfectly written report nobody opens is worth exactly as much as no report at all. If you work with someone else in the business, set a fixed moment each month — the first three business days, for example — to read it together and decide on block 5 based on what it says, not on whatever feels right in the moment. The value of a monthly report isn’t how polished it looks; it’s whether it changes at least one decision before the following month is over.