Accounting Firm Workflow: When the Spreadsheet Tracker Breaks

Most accounting firms run on a tracker. Sometimes it's a shared spreadsheet with a row per client and a column per status. Sometimes it's several spreadsheets, one per service line, plus a whiteboard in a partner's office. It works until it doesn't, and the moment it stops working is usually the second week of March.

July is a good time to look at it honestly. The spring deadlines are behind you; the extension deadlines are not. For calendar-year taxpayers in 2026, IRS Publication 509 lists March 16 as the due date for partnership and S corporation returns, September 15 for those returns on extension, and October 15 for extended individual returns. The IRS When to file page gives April 15 for individual returns and notes that an extension of time to file is not an extension of time to pay. Whatever strained in the spring will strain again this fall.

What the tracker is really doing

A workflow tracker in an accounting firm is doing at least four jobs at once:

• Status. Where is each return, each monthly close, each payroll filing?
• Client requests. What have we asked for, what has arrived, and what is still missing?
• Assignment and capacity. Who is working on what, and who has room?
• Deadlines. Which of these is due soonest, and which are on extension?

A spreadsheet can hold all four as columns. What it cannot do is connect them. The status column doesn't know the client's K-1 is still missing. The assignment column doesn't know the preparer has fourteen other returns due the same week. The deadline column doesn't know an extension was filed unless someone remembers to update it.

Document collection is the bottleneck firms name first

Ask a team where the week goes and chasing clients will usually come up early. Financial Cents' 2025 State of Accounting Workflow and Automation report, based on a survey of 816 accounting, bookkeeping, and tax firm owners and administrators, found that getting documents from clients was the biggest workflow issue, ahead of manual administrative tasks. The report also observes that many firms still rely on spreadsheets.

A spreadsheet makes this harder in a specific way. Requests go out by email. Documents come back by email, portal, text message, or in a folder dropped at the front desk. Someone then has to reconcile what arrived against a column that says "waiting on client." When that reconciliation lags, preparers start returns they can't finish, and half-completed work piles up in the middle of the pipeline where nobody can see it clearly.

Capacity is the real constraint

The staffing picture is well documented. In the AICPA's 2024 PCPS CPA Firm Top Issues Survey, finding qualified staff ranked as the top issue for every firm-size group except sole practitioners. The 2026 edition, conducted from April 20 to May 22, 2026, with 629 respondents, found staff retention in the top five for every firm size over the next five years, hiring experienced staff as the top issue for firms with 11 to 30 employees, and staff workload management among the top four issues for the larger firm groups.

When you can't simply hire your way through busy season, the tracker's job changes. Knowing what's done is not enough. You need to know, in February, which preparers will be overloaded in March and which clients are likely to send documents late. A spreadsheet can answer that only if someone rebuilds the answer by hand every week.

Signs your tracker has broken

Spreadsheet trackers rarely fail all at once. They fail in ways that are easy to miss until a deadline exposes them:

1. More than one version of the truth. Two people keep their own copies, or a master tab is reconciled from team tabs every Monday morning.
2. Status lags reality. The sheet says "in review," but the reviewer finished yesterday and the return is waiting on a client signature.
3. Nobody can see the next two weeks. You can sort by due date, but you can't see how many hours of work land on each person in the same window.
4. Client requests live outside the tracker. The list of outstanding items sits in someone's inbox, not next to the return it's holding up.
5. Extensions are tracked separately. The extension goes into one list, and the return quietly drops off the main one until September.
6. Recurring work is re-created by hand. Monthly bookkeeping and quarterly payroll tasks are copied forward each period, and occasionally one isn't.
7. Only the person who built it understands it. When they're out, the firm slows down.

Two or three of these are normal in a growing firm. Five or more usually means the tracker is costing more time than it saves. We cover the broader pattern in signs your business has outgrown off-the-shelf software, and the risk of a critical spreadsheet that one person maintains is explored in the $47,000 spreadsheet that ran a practice.

What a better setup looks like

Whether you adopt a practice management tool, configure one you already own, or build something around your own process, the target is the same.

• One record per engagement. The client, the service, the due date, the extension status, the assigned preparer and reviewer, and the outstanding requests all hang off the same record.
• Requests tied to work. When a client uploads a document, the item it satisfies is checked off and the return it was blocking moves forward.
• Recurring work generated on schedule. Monthly, quarterly, and annual engagements create their own tasks without anyone copying rows.
• Capacity visible ahead of time. A view by person and by week, built from real due dates and estimated hours, so you can rebalance before a deadline rather than after it.
• Deadlines that know about extensions. Filing an extension updates the due date on the same record, so nothing drops out of sight.

Dedicated practice management products handle much of this well for many firms. Where firms tend to struggle is the edges: bookkeeping in one system, tax preparation in another, billing in a third, and a spreadsheet stitching them together. Each of those connections is a place where status goes stale and someone re-enters data.

What to do this month

You don't need to replace anything to make progress before the September and October deadlines.

• Audit the extension list now. Every extended return should have an owner, an estimate of remaining hours, and a list of what the client still owes you.
• Put outstanding requests next to the work. Even if it's just a new column, get the missing-items list out of individual inboxes.
• Build a two-week capacity view. For each preparer and reviewer, add up estimated hours on work due in the same two-week window. Imbalances will be obvious.
• Write down the rules the spreadsheet depends on. Which colors mean what, who updates which columns, and when. If that takes more than a page, it tells you something.
• Decide what "done" means. Agree on the handful of statuses every engagement moves through, and use the same ones across tax, bookkeeping, and payroll.

If, after that exercise, the tracker still feels like it's carrying the firm rather than the other way around, it may be time to look at a system built around your actual workflow. Localhost Labs builds that kind of platform for accounting and other professional services firms, and our guide to custom software costs sets out what actually drives the price if you're weighing that path.

Either way, summer is the calm window to decide, and if it would help to talk it through, you can book a short conversation.