Almost every small firm has a spreadsheet somewhere: clients in rows, months in columns, coloured cells for “received”, “missing” and “late”. It is a perfectly reasonable place to start. The question is how to make it work well, and how to recognise when it has stopped working.
How to build a tracking sheet that works
- One row per client and document type, not per client - “Anna Ltd - bank statement” and “Anna Ltd - sales invoices” are separate rows.
- One column per period, with a small, fixed set of statuses: requested, received, accepted, rejected, nothing this month.
- A due date column, so overdue items can be filtered.
- A “last contact” column - when you last reminded the client and how.
- A single owner who keeps the sheet up to date, or clear rules for who updates what.
Where spreadsheets work well
A spreadsheet is free, flexible and familiar. For a firm with a few dozen clients and one or two people doing the collection, it can be all you need - provided someone updates it every day.
The signs it is time for something more
- The sheet is out of date - documents arrive by e-mail, but nobody marks them as received until days later.
- Two sources of truth - the sheet says “missing”, but the file is already in someone's inbox.
- Reminders are still manual - the sheet tells you who to chase, but you still write every message.
- Several people edit it and statuses get overwritten.
- Clients cannot see it - so they keep asking what they still owe.
What a dedicated tool changes
The key difference is that the status updates itself. When a client uploads a document, the item changes to “received” without anyone typing it. When you accept or reject it, the client sees it immediately. Reminders are generated from the same data, so they always list exactly what is missing. The tracker stops being a separate task and becomes a side effect of the work.
A practical path
If your spreadsheet still works, keep it - and make it stricter with the structure above. If you recognise two or more of the warning signs, try a dedicated tool with your most difficult clients first. You will know within one month whether it saves time.
MonthDocs replaces the tracking sheet with live statuses: every upload, acceptance and rejection updates the overview automatically, and clients see the same list you do.
