Reporting pack redesign
Cutting a 60-tab spreadsheet down to the numbers that get reviewed
Published 14 March 2024 ยท Vare Consulting, operations and compliance advisory
Reporting packs grow the way a workshop floor collects offcuts. A bank asks for one figure during a facility review, someone adds a tab, and it stays. Three years on, the pack runs to sixty tabs and the person preparing it has stopped asking whether half of them still mean anything. The monthly routine stretches into a week, and the numbers that actually get read are buried somewhere in the middle.
We usually meet these packs during a two-week diagnostic, when the finance lead opens a file and admits they dread the last week of the month. What follows is how we audit an existing pack, which sections lenders and auditors return to first, and how the routine gets handed to a junior staffer with a written procedure instead of tribal knowledge.
Tabs are rarely added by decision. They arrive as a request: a supplier query, a stock count that went sideways, a once-off insurance schedule. Nobody removes them because removing something feels riskier than leaving it. In light manufacturing and logistics firms with 15 to 80 staff, the same pack often serves three audiences at once, the bank, the accountant, and the owner, and each one wants a different level of detail.
In our experience the first pages reviewed are the debtors ageing, the creditors ageing, the bank reconciliation, and a short cash movement summary. Everything else is reference material. If those four are clean and tie back to the trial balance, the rest of the pack can be lean. If they do not reconcile, no amount of extra tabs will help.
Deleting the wrong tab is worse than keeping a redundant one, so we move candidates into an archive file for two full reporting cycles before anything is removed for good.
A rebuilt pack is only useful if it survives a busy month. We write the monthly procedure as a checklist: which system to export from, which reconciliations to run, which figures to check against the prior month, and who signs off before the pack goes out. The person running it does not need to understand every line, only the sequence and the checks. That is usually enough to keep the routine stable when the finance lead is on leave.
Related reading
Working through a pack that has outgrown its purpose? Start with a scoping call via contact.html.