The question you ask every week
It is the tenth of the month. You want to know where everyone is with last month's books. You open the practice spreadsheet and half the rows say 'in progress', a few say 'done', and several have not been touched since the sheet was set up.
So you walk round and ask, or send a message to the team channel. The answers are honest but vague: nearly there, waiting on the client, done apart from the credit card. Two days later a client emails asking why their management figures are late, and it turns out their books were one of the nearly-theres.
Why the tracker never matches the ledger
Most firms track month-end in a separate place from where the work happens. The spreadsheet or the job in the practice tool gets updated when someone remembers. The ledger, meanwhile, holds the truth: how many bank lines are unreconciled, whether anything sits in suspense, when the last reconciliation happened.
Status also has more than two states. A file can be reconciled but missing the loan account, or finished apart from three queries the client has not answered. A single tick box cannot hold that, so people stop trusting it and go back to asking.
The cost of finding out late
Late discovery means late delivery. Clients who pay for monthly figures notice when they do not get them, and a firm's reputation for being on top of things is most of what it sells. Behind the scenes the partner spends hours each month chasing status instead of reviewing work, and problems that could have been fixed on the fifth are found on the twentieth.
| State in the ledger | What it usually means |
|---|---|
| Unreconciled lines in one account only | Feed or statement missing for that account |
| Growing suspense balance | Queries waiting on the client |
| No activity since last month | File not started or feed broken |
| Reconciled but no period lock | Work done, review not signed off |
What we build: a month-end board fed by the books
- We connect to every client file in Xero or QuickBooks and read, each night, the reconciliation position per bank and card account, uncoded or suspense balances and the date of last activity.
- We pull the client list, assigned bookkeeper and service level from your practice tool, so the board knows which clients need a monthly close and by when.
- Each client gets a status worked out from the ledger itself: not started, in progress, waiting on client, ready for review, closed. The rules are yours and can be tuned.
- Staff can add a short reason where the books cannot show it, such as 'client away until the 14th', and that note stays with the client for the month.
- The board sorts by risk, so the clients near their delivery date with the most outstanding work sit at the top.
- A short summary goes to each bookkeeper and to you each morning, listing their own files that have not moved.
Nothing is written back to the client files. The board reads, it does not change your books.
A different start to the week
Instead of asking, you look. The team stops being interrupted for status updates, and the conversation moves to why a file is stuck. You see the client with the broken card feed on the third rather than the twentieth. Clients get their figures when you said they would, or a proper reason when they will not.
Signs your month-end tracking has drifted
- Your status spreadsheet is always out of date.
- You learn a client is behind when the client tells you.
- 'Nearly done' is the most common answer in the office.
- Month-end reviews bunch up at the end of the month.
- Nobody can say how many clients are closed today.