Rules that keep a tracker useful
- One row per return, not per client.
- Status changes only at defined stages, never “nearly done”.
- Every row has an internal cutoff before the due date.
- Review the tracker in a weekly team meeting during the season.
Tax Return Tracking Spreadsheet Template (Free) | HelloBooks A return-status tracker template with columns and status stages for a tax practice. Copy it as CSV into Excel or Google Sheets.
Template · Return tracker
Return-status tracker template
A spreadsheet layout for tracking every return from engagement to acceptance. Copy the CSV into Excel or Google Sheets and filter by status, preparer or due date.
Free Plan with invoices within 200 transactions, bills & quotes — no credit card.
Tracker columns (CSV)
Client,Return type,Tax year,Preparer,Reviewer,Due date,Internal cutoff,Status,Documents complete (Y/N),Missing items,Extension filed (Y/N),Extended due date,Sent for signature,E-file accepted,Fee,Invoiced,Notes [Client A],1040,2026,[Initials],[Initials],2027-04-15,2027-03-26,Waiting on documents,N,Final pay stub,N,,,,[Fee],N, [Client B],1120-S,2026,[Initials],[Initials],2027-03-15,2027-02-26,In preparation,Y,,N,,,,[Fee],N,
Status stages
1. Engaged (letter signed) 2. Organizer sent 3. Waiting on documents 4. Documents complete 5. In preparation 6. In review 7. Questions to client 8. Ready for signature 9. Signed, ready to file 10. Filed, awaiting acceptance 11. Accepted 12. Extension filed
When a spreadsheet stops being enough
Once several people update the same sheet, versions drift. HelloBooks practice management tracks engagements with live status, a kanban pipeline and US deadline auto-scheduling for 1040, 1120, 1120-S and 1065 returns.
FAQ
Frequently asked questions
- Where do the due dates come from?
- The sample rows use dates from the IRS draft 2027 Publication 509. Use the extension tracker for each return type.
- Can I add state returns?
- Yes. Add a row per state return, or a state column if most clients file in one state.
Sources
Templates are starting points for your firm to adapt. They are not legal or tax advice.
Start automating your books today
Free Plan with full access to the AI accountant — no credit card, no time limit.