Filing due date tracker template for a multi-client practice

The unit is the obligation. One company may owe an annual return, quarterly payroll filings, a VAT return, a board resolution and a licence renewal, each with its own row and its own dates.

Every period gets a fresh row. Last quarter’s closed row stays as history instead of being overwritten, which matters when an authority asks what you filed and when.

Start with a master list of the obligations you handle, grouped by entity type, because a company, a partnership and an individual owe different things. Build the rows from that list. Memory always misses something.

The statutory date belongs to the authority and is the last day, not the target, so the team should work to an internal date set earlier.

Choose the margin by obligation. A simple monthly return needs a few days of slack, while an annual filing that waits on audited figures, a director’s signature and a board approval needs weeks.

Sort by the internal date. Once that date passes, the row turns amber, and amber is where a missed statutory deadline gets caught before the authority notices.

Every row names one owner. Name a person, not a team. Add a reviewer where the filing needs a second signature, such as an annual return or a payroll summary sent to the authority.

Use a short list of statuses that everyone shares, such as papers awaited, in preparation, in review, with client for approval, filed and closed. Free text cannot be sorted.

Add a next action and its date. A note such as chase bank statements on Tuesday tells a colleague exactly what to do when the owner is out sick, and it takes ten seconds to write.

Finished work does not close a row. A row closes only when you hold proof: the acknowledgement number, the filing date and the receipt saved in the client folder.

Record the acknowledgement reference in one column and the file location in another, so when an authority writes six months later you can answer in a minute.

Note which preparer filed. Note whether the client approved the final figures, and if approval came by email, link that message to the row so nobody has to hunt for it later.

A tracker dies when updates lag. Fix a weekly slot. Walk only the amber and red rows.

Add new rows at onboarding, not later, because the day a client signs the coordinator should create every obligation from the master list and set the first internal dates.

Once the sheet passes a few hundred rows, or several people edit at once and versions drift, consider practice software that generates rows and sends reminders by itself. Export the sheet before you switch.