At a small accounting firm that produces monthly management accounts for twenty-five clients, the routine goes like this. Once a client's books are closed, someone exports the profit and loss, balance sheet and aged debtors from Xero or QuickBooks Online, pastes them into an Excel template, fixes the formulas that broke because a new account appeared, refreshes the charts, writes a page of commentary, turns it into a PDF and emails it. Each pack takes several hours. Many land in the middle of the following month, by which point the client has already made the decisions the pack was meant to inform.
Management accounts are one of the most valuable things a firm can offer a growing business, and one of the best routes into advisory work. The production process gets in the way of both. When the mechanical parts take most of the time, there's little left for the analysis and conversation that clients actually value.
This article covers what to standardize before automating, and what an automated pack process does from a closed ledger to a reviewed report.
Where the time goes
Break the pack down and the hours fall into a few buckets: extracting and pasting data, fixing the template when the chart of accounts changes, calculating KPIs and variances, rebuilding charts, writing commentary, and formatting and sending. Only the commentary and the review of the numbers really need an accountant's judgment, and even the commentary is often spent describing movements that could be described automatically, leaving little time to explain what they mean.
Timing matters as much as effort. A pack delivered on the twentieth of the month describes a period that ended three weeks earlier. The sooner the pack arrives, the more useful it is, which means the production process shouldn't be the bottleneck.
Standardize before you automate
Design a standard pack
Agree a standard structure that suits most clients, with room for client-specific additions: a summary page, profit and loss against budget and prior year, cash position and forecast, aged debtors and creditors, and a handful of KPIs. For clients in particular industries, add the measures that matter to them, such as gross margin by job for contractors or revenue per clinician for a practice.
Map accounts consistently
Reports break when every client's chart of accounts is structured differently. Map each client's accounts to a standard set of reporting lines, so the template doesn't care whether "subcontractors" is account 5100 or 5150. Keep the mapping updated when new accounts are created.
Tie the pack to the close
A pack built on books that aren't reconciled will need redoing. Set a close calendar for each client, with the pack produced only after the close is marked complete.
Load budgets and targets
Variance commentary needs something to compare against. Make sure budgets or targets are loaded for each client, in the ledger or in your reporting tool.
Write commentary standards
Decide what good commentary looks like at your firm. For example: every variance above a set threshold gets a sentence explaining the cause if it's known, or a question to the client if it isn't, and the summary page ends with two or three points the client should act on. Standards make commentary consistent across the team and give automated drafting something concrete to follow.
What the automated version does
- Triggers on close. When a client's month is marked closed, the pack process starts.
- Pulls and maps the figures. The system pulls the trial balance and supporting reports from Xero or QuickBooks Online through their APIs and maps them to the standard reporting lines.
- Calculates. It calculates totals, KPIs, variances against budget and prior periods, and the cash forecast, and builds the charts and tables.
- Drafts commentary. For each variance above the threshold, an AI model drafts a sentence or two, using the transaction detail to identify the cause where the data shows it. For example, wages above budget because two new employees appear in payroll from the middle of the month. Where the data doesn't explain the movement, it writes a question for the client instead of guessing.
- Flags for review. Unusual items, such as a large one-off expense, a sharp change in debtor days or a negative balance where there shouldn't be one, are highlighted for the accountant.
- Accountant reviews. The accountant checks the numbers, edits the commentary, adds the advice that only they can give, and approves the pack.
- Delivers and schedules. The pack goes to the client as a PDF or a live dashboard, and a short review meeting is offered or booked automatically.
Reporting tools such as Fathom, Syft and Spotlight Reporting handle much of the figure-building, and some firms already use one. The extra value usually comes from tying the pack to the close, drafting commentary from transaction detail, and flagging the items that need a conversation. Our automatic client reports system adds those around the tools you use. The accounting and tax page shows how reporting fits with bookkeeping, onboarding and deadline tracking.
Keeping commentary honest
Drafted commentary is useful only if it's grounded in the figures. The rule should be simple: the draft can describe what the data shows and point to the transactions behind it, and it must ask a question whenever the cause isn't in the data. "Revenue fell 8% against budget, mainly in the second half of the month; was there a pause in a major contract?" is a good draft. "Revenue fell due to seasonal softness in demand" is a guess dressed as an explanation, unless the data supports it.
The accountant's review then focuses on what matters: is the explanation right, is it material, and what should the client do about it?
A worked example
Consider a firm producing packs for a mix of contractors, clinics and retailers. It agrees a standard pack with a summary page, profit and loss against budget and last year, cash and a thirteen-week forecast, aged debtors and creditors, and three to five KPIs chosen per industry. Each client's accounts are mapped to standard reporting lines. When a contractor client's month is closed, the pack builds itself within minutes. The drafted commentary notes that subcontractor costs ran above budget, tied to two specific invoices for a single large job, and asks whether that job's final invoice has gone out, because revenue for it doesn't appear yet. The accountant confirms with the client that the invoice was delayed, rewrites the sentence to explain it, adds a note about the cash effect, and sends the pack early in the month. The review meeting that follows is about the delayed invoice and the client's plans for next quarter.
What to watch out for
- Packs on unclean books. If the close isn't really complete, the automation will produce a confident-looking pack with wrong numbers. Keep the close sign-off as a real gate.
- Mapping drift. New accounts created during the month can fall outside the mapping and quietly disappear from the pack. Have the system flag unmapped accounts every time.
- Materiality. Set variance thresholds per client, as a percentage and an amount, so commentary focuses on what matters for a business of that size.
- Client confidentiality. Financial data is sensitive. Know where your reporting and AI tools process and store client data, and keep it within systems you control or trust.
- Losing the conversation. A faster pack is a means to a better conversation with the client. If the meeting stops happening, the client gets a report and less advice.
How to tell whether it's working
Measure the working days from month end to pack delivery for each client, and the hours spent per pack, before and after. Track how much the accountant changes the drafted commentary, since heavy rewriting means the standards or the transaction detail need work. Count unmapped accounts flagged each month to see whether the mapping is holding. The most useful measure is harder to count but easy to notice: whether review meetings spend their time on decisions or on establishing what the numbers are.
Where to start this week
Pick five clients who already get monthly packs and time how long each pack takes, step by step. Then agree a standard structure, map those five clients' accounts to standard reporting lines, and write your commentary standards on a page. Produce next month's packs for those clients from the standard template and compare the time taken.
Once the template, mappings and standards hold up for those five, automating the figures and drafting the commentary is straightforward to extend across the rest of your clients, and the packs can go out within days of the close.
The free PATH report gives you a quick read on where reporting sits among your firm's other work. If you'd like to talk through your pack process, book a call.