The copy-and-paste part of the month
The books are closed. Now the bookkeeper exports a profit and loss, a balance sheet and an aged debtors report, pastes them into the client's Excel template, fixes the columns that moved since last month, updates the charts, and writes a paragraph on what changed. Then does the same for the next client, whose template is slightly different.
The monthly bookkeeping reports are what the client sees and values. They are also the part of the month that most feels like copying, and when the team is stretched, packs go out late or with last month's commentary lightly edited.
Why packs are still made by hand
Each client wanted something a little different when they joined: this one wants gross margin by site, that one wants cash runway, another only reads the first page. Templates multiplied. Ledger reports do some of it, but not the per-client layout, the combined view of several entities or the narrative.
Commentary is the stubborn part. Writing it well means looking at the movements, knowing the client and choosing what matters. That takes thought, but the first draft, stating what went up and down and by how much, is mechanical and eats most of the time.
What hand-made packs cost the firm
Senior time goes on formatting. Packs arrive later in the month than clients would like, which reduces their usefulness. Errors creep in when a pasted range shifts. And the service is hard to scale, because each new reporting client adds hours of assembly to someone's month.
| Pack element | By hand today | Generated |
|---|---|---|
| Profit and loss, balance sheet | Exported and pasted | Read from the ledger |
| Client-specific KPIs | Formulas in a template | Calculated from ledger data |
| Charts | Updated manually | Drawn each run |
| Commentary | Written from scratch | Drafted, then edited by the bookkeeper |
| Sending | Email with attachment | Portal or email once approved |
How we build client pack generation
- We read each client's figures from Xero, QuickBooks or other ledgers through their APIs, including tracking categories and multiple entities where they exist.
- Each client's layout and KPIs are set up once as a configuration, based on the templates you use today, so a new pack looks like the ones the client is used to.
- When a client is marked closed for the month, the pack builds itself as a PDF or a web page, with charts and comparisons against last month, last year and budget where one exists.
- A language model drafts the commentary from the actual movements, flagging the largest changes and anything unusual, written in your firm's tone.
- The bookkeeper reviews the pack, edits the commentary and adds the context only they know, such as a one-off payment the client told them about.
- Once approved, the pack goes to the client through your portal or by email, and a copy is filed to their record.
Numbers come straight from the ledger, never from the model. The model only writes words about them, and a person reads every draft before it is sent.
Packs that go out while they are still useful
Assembly time falls away and what is left is the part that needs a person: reading the numbers and saying something useful. Packs go out soon after close, while the month is still fresh for the client. Templates stay consistent, errors from shifted ranges disappear, and adding a reporting client stops meaning another afternoon of copying.
Does this sound like your month?
- Bookkeepers paste ledger reports into Excel for every client.
- Each client has a slightly different template to maintain.
- Commentary is often last month's text lightly edited.
- Packs reach clients well after the month is closed.
- You hesitate to offer reporting to more clients because of the work.