PingtailSpreadsheet tracker or document request software?
A tracker spreadsheet works up to a point. How to tell when you have passed it, and what changes for your team when you switch to request software.
Most small firms track client documents in a spreadsheet, and many of them should keep doing so. A well built tracker costs nothing, everyone can read it, and it bends to fit any client. It is a good tool for this job, up to a point.
This is a spreadsheet tracker vs document request software comparison for bookkeeping and accounting firms of one to twenty people: what a good tracker looks like, where it works, the five signs you have passed that point, and what really changes if you switch.
What a good tracker spreadsheet looks like
The most common mistake is one row per client with a column per document. That layout cannot hold a date, a reminder or a note for each document. A good tracker has one row per item per period: "Acme Cafe, August, business checking statement" is one row, with its own status and history. These are the columns it needs.
| Column | What goes in it | Why it matters |
|---|---|---|
| Client | The client name, always spelled the same way. | Lets you filter to one client before a call. |
| Period | The month, quarter or tax year, in one format, for example 2026-08. | Stops the July and August rows from being confused. |
| Item | One document, named exactly: "Business checking statement, account ending 4417". | "Bank statements" is not trackable. One account is. |
| Requested on | The date you first asked. | Shows how long the client has had it. |
| Due | The date you need it by. | Sort by this column every morning. |
| Status | One of a fixed list: requested, received, checked, sent back, not applicable. | A fixed list can be filtered and counted; free text cannot. |
| Last reminder | The date of the most recent reminder. | Stops two reminders in two days. |
| Next reminder | The date the next one should go. | This column is your to-do list. Filter it to today. |
| Owner | The one person responsible for this client. | If everyone can follow up, no one does. |
| Notes | Short facts: "Tom says the card was closed in June". | Saves asking the client the same question twice. |
Three habits make the sheet work. Keep "received" and "checked" as separate statuses, because a file that has arrived is not yet a file that is right. Use a drop-down list for the status column. And copy last month's rows forward at the start of each period, so the list does not have to be rebuilt from memory. The emails that go with the sheet are in the email templates for missing client documents.
Where the spreadsheet works well
A tracker works well when three things are true: you have fewer than about ten recurring clients, one person keeps the sheet, and the list of documents per client is stable. That number is a judgement, not a measured figure. A careful solo bookkeeper may run twenty clients on a sheet; a firm of three may struggle at six.
With one person, the sheet and that person's memory say the same thing. With a stable list, copying rows forward takes minutes. Ten clients with about eight items each is eighty rows a month, which one person can read in a single pass. Add a second person, double the clients, or let the lists change each month, and the sheet gets harder to keep true.
How do you know you have outgrown the spreadsheet?
One of these signs in a busy month is normal. Two or more, most months, means the sheet is costing more time than it saves.
1. The status is stale
The file arrived on Tuesday. The row still says "requested" on Friday, because updating the sheet is a separate step nobody did. Once people stop trusting the sheet, they check the inbox instead.
2. Two people remind the same client
Mira Chen at Bright Dental gets a reminder from you on Monday and one from your colleague on Tuesday, for a statement she sent last week. This is the sign the client sees. It means the "last reminder" and "owner" columns are not being kept.
3. Nobody knows whether the file that arrived is the right one
The row says "received". It does not say that the PDF is the July statement for an August request, or pages 1 to 3 of 5. You find out during the close, ask again, and wait again. A spreadsheet can record that you checked; it cannot check. More on this in the wrong-document problem.
4. Month-end starts with a hunt
The first day of the close is spent searching inboxes, a shared folder and a chat thread to find out what came in, then renaming and moving files. The books start on day two or three.
5. The person who owns the sheet goes on holiday
For two weeks, no reminders go out and no rows change. When a process stops because one person is away, it lives in their head and the sheet is only their notebook.
What document request software changes, and what it does not
What it does not change
Software will not make a client care. A client who ignores three emails from you will ignore three from a tool. The client who does not open mail and the contact who left need a phone call, and no product replaces it. Software also does not decide what to ask for: if your list of items is vague, a tool will send a vague list on time.
What it does change
It removes the manual steps a person forgets on a busy day.
- Status updates itself. The upload is the status change. Nobody has to edit a row, so sign 1 goes away.
- Reminders go out on schedule from one place, so sign 2 and sign 5 go away. Better tools list only the missing items.
- The file sits next to the item it answers. There is no inbox to search, so sign 4 shrinks.
- Some tools check the file on arrival against the item and the period, which addresses sign 3 without a person opening every file. Not every product does it, so ask.
- The whole team sees one picture: who is complete, who is overdue, who has not opened the request.
A fair test of any tool, including ours: set it up for one real client, then upload the wrong month as if you were that client, and see what happens.
The cost of switching
The subscription is the smallest cost. Count the others first.
- Setup time. Entering clients and contacts, and turning each client's list into a template. Your spreadsheet already holds most of this. Plan a few hours.
- A change for your clients. They will receive a different kind of email, so tell them first in one short message from you. If the tool needs an account or an app, expect some to resist.
- A month of running both. Move three to five clients first and keep the sheet for the rest.
- New habits for the team. Reviews happen in the tool, not the inbox. Someone has to own that.
- Your way out. Before you put client files into any product, check that you can export them with sensible names, and still can if you stop paying.
Timing matters too: a quiet month for a bookkeeping firm, the autumn for a tax firm. Not January, and not the week before a deadline.
Stay with the spreadsheet if
- You have fewer than about ten recurring clients and the sheet is current today, not "mostly".
- One person does all the requesting and reminding, and that will not change this year.
- Your clients respond to the first or second email, so a tool would save little.
- Wrong files are rare: your clients send the right statement the first time.
- Your work is mostly one-off engagements with a different list every time.
- You already own a practice management suite with client tasks that your clients use. See document request tool or practice management suite.
- You are in the middle of your busiest season. Decide afterwards.
If most of this describes you, improve the sheet with the columns above and look again in six months.
Questions
Can a spreadsheet send reminders automatically?
Partly. With scripts or a mail merge add-on a sheet can send emails on a date. Someone then has to maintain that script, and the reminder still cannot know that a file arrived unless a person updated the row first. It can work, but usually one person becomes the only one who understands it: the holiday problem again.
Is a firm of two already too big for a spreadsheet tracker?
No. Two people can share a tracker well if each client has one owner and both update the sheet the same day, every day. Test it once a month: pick five rows at random and check them against the inbox. If all five are correct, the sheet is working. If two are wrong, the status is stale.
Can you run the spreadsheet and the software side by side?
Yes, and you should, for about a month. Move three to five clients into the tool and keep the sheet for the rest, then compare a full cycle: reminders written by hand, wrong files found, days to complete. Keep each client in one system only, so nobody has to wonder which one is true.
What should you bring from the spreadsheet if you switch?
Three things: the client and contact list, the item names with the exact wording that works for each client, and the notes column, because "the card was closed in June" is worth keeping. Leave the row-by-row history behind and keep the old file as an archive.
Doing this with Pingtail
In Pingtail the rows of your tracker become a request: one client, one period, a list of items with instructions, built from a ready-made checklist or your own saved template. Clients can be imported by pasting a list or CSV text. Status changes when the client uploads, each upload is checked at once for problems such as the wrong period or missing pages, and automatic reminders list only the required items still missing, then stop and tell you it is time for a call. When the request is complete you export one zip with files renamed to your own pattern, on every plan, and also when an account is read-only. The full list is on the features page. You can try it on yourself first: send a test request to your own email and upload the wrong file on purpose.