Which KPIs to include in a monthly client report: a bookkeeper's shortlist
A monthly client report lives or dies on its first page. If the owner opens it and sees twenty numbers, they close it. If they see five numbers they recognise and understand, they read on. Choosing those few KPIs is one of the most useful decisions a bookkeeper makes about a client's reporting.
This post is a practical shortlist: which key performance indicators tend to earn a place in a small business monthly report, how to pick the right handful for each client, and how to present them so they lead into your commentary rather than replacing it.
Start with the client's questions, not the chart of accounts
Every accounting system can produce dozens of ratios. That is not the problem to solve. The useful question is: what does this owner actually worry about at the end of a month? Usually it is some mix of these:
- Did we sell more or less than last month, and than this time last year?
- Are we actually making money on what we sell?
- How much cash do we have, and is it going up or down?
- Who owes us money, and who do we owe?
- Are costs creeping up anywhere?
If each KPI on the first page answers one of those questions, the page makes sense to the owner without a glossary. If a number does not map to a question they care about, it probably belongs in an appendix, or nowhere.
A shortlist that works for most small businesses
These are the KPIs that come up again and again for small service and product businesses. Not every client needs all of them, but most monthly packs can be built from this list.
- Revenue for the month, with the change against last month and the same month last year. The year-on-year comparison matters for seasonal businesses, where month-on-month swings can mislead.
- Gross profit and gross margin %. For anyone selling products or billable time, this shows whether the core work is profitable before overheads. A falling margin is often the earliest warning sign in a set of accounts.
- Net profit for the month and year to date. The bottom line owners expect to see, ideally next to the year-to-date figure so one unusual month does not dominate the story.
- Closing cash balance and the change from last month. Owners check their bank app constantly, so this is the number they will use to sanity-check everything else.
- Accounts receivable, ideally with how much is overdue. For businesses that invoice, this often explains why cash and profit do not match.
- Accounts payable, for clients where supplier timing matters.
- Operating expenses against last month or budget, with the one or two lines that moved most called out.
Five to seven of these is usually plenty. Beyond that, the first page becomes a dashboard rather than a summary, and the owner stops looking for the story.
Tailor the set to the type of business
The shortlist is a starting point. A few adjustments based on the business model keep the report relevant:
- Retail and e-commerce: gross margin and stock value deserve a spot, since stock ties up cash and margin drives profit.
- Agencies and consultancies: receivables and overdue invoices usually matter more than stock, and revenue concentration (how much comes from the largest client) can be worth a line in the commentary.
- Trades and project businesses: lumpy revenue makes year-to-date figures and cash more useful than any single month.
- Hospitality: gross margin and wage costs as a share of revenue are often the numbers the owner already watches.
Only include a KPI if the underlying data is reliable in the books. A margin figure built on messy cost-of-sales coding does more harm than good. If the data is not clean yet, fix the coding first, then add the KPI.
Present KPIs so they lead into your commentary
A KPI on its own is just a number. What makes it useful is comparison and context. A few presentation habits help:
- Always show a comparison. Last month, same month last year, or budget. A bare figure invites the question "is that good?"
- Use the same layout every month. Consistency lets owners spot changes at a glance and builds the habit of opening the report.
- Use plain labels. "Money customers owe you" may land better than "Accounts receivable" for some clients. You can keep the technical term in brackets.
- Add a simple trend. A small chart of the last six or twelve months of revenue and cash often says more than any single month's figure.
- Follow with a few sentences of commentary. The KPIs show what happened; your commentary explains why and what to watch next month.
That last point is where the bookkeeper adds the most value. If revenue is up but cash is down, the KPI page shows the tension, and your note explains it, for example that a large customer invoice is still unpaid. We wrote more about that specific conversation in how to explain profit vs cash flow to clients.
Review the KPI set once in a while
A KPI set is not permanent. As a client grows, takes on a loan, hires staff or starts holding stock, different numbers start to matter. A quick review once or twice a year, ideally in a conversation with the owner, keeps the first page relevant. Ask them which numbers they actually look at and which they skip. Their answer is usually more useful than any template.
It also helps to agree the KPI set before the numbers come out. Then the report is not a surprise, and a bad month is easier to discuss because everyone already agreed what "good" looks like.
Make the numbers trustworthy first
None of this works if the underlying books are not closed properly. Bank reconciliations, accruals, and a quick check for miscoded transactions all come before the KPI page. If you want a routine for that, our month-end close checklist for bookkeepers covers the steps we would run before building any client report.
Once the books are closed, picking a short, consistent set of KPIs and pairing it with your own commentary turns a monthly export into something owners actually read. The numbers become the start of a conversation, which is where a good bookkeeper earns their fee.
Where ClosePack fits
ClosePack is in its founding pilot: it turns a QuickBooks Online or Xero export into a branded monthly client PDF with KPIs, trends and draft commentary you edit and own. It is early and deliberately narrow. If that sounds useful, have a look at the sample pack or request a founding spot.
Request a founding spotSee the Harbor Bike Co sampleRelated reading
- How long should a monthly client report pack take?
- How to get clients to answer uncategorized transaction questions before month-end
- How to write monthly commentary clients actually read
- How to price and package a monthly client report as a premium service
- What to do when last month's numbers change after you've sent the client report
- How to explain the balance sheet to small business clients (without losing them)
- Who builds the pack vs who owns the client debrief?
- Default QBO/Xero PDF vs branded client pack: what clients actually read
- Keeping your voice: why commentary should stay bookkeeper-owned
- A month-end close checklist for bookkeepers, before the client report goes out
- How to explain profit vs cash flow to your bookkeeping clients
- How to write the month-end email that goes with your client's report
- How to build a budget vs actual report your small business clients will use