The Lodgment Program You Track in a Spreadsheet
A spreadsheet of BAS, IAS and tax due dates works right up until it doesn't. Here's why deadline tracking belongs inside your practice management system, not beside it.
Most firms started the same way. Someone built a spreadsheet. One tab for BAS clients, one for monthly IAS, a column for tax return due dates, maybe a highlighted cell for the odd ASIC review. It was quick, it was free, and for a small client list it did the job.
Then the practice grew. New clients arrived on staggered lodgment cycles. Staff came and went. A quarterly BAS client moved to monthly. A company's ASIC annual review date sat in a field nobody looked at. And slowly, the spreadsheet stopped being a source of truth and started being a source of anxiety — the thing you check at 9pm before a due date to make sure you haven't missed anything.
If that sounds familiar, the problem isn't your discipline. It's that a spreadsheet was never designed to run a lodgment program. It has no connection to the actual work, no owner, and no memory.
What a deadline spreadsheet can't do
A tracking spreadsheet holds dates. That's all it does, and that's the limit of its usefulness. Consider everything it can't do:
- It doesn't know if the work is done. A cell showing "28 Feb" tells you a BAS is due. It doesn't tell you whether the client has sent their records, whether the return is in draft, or whether it was lodged last Tuesday. You have to go somewhere else to find out — and then remember to update the cell.
- It doesn't chase anyone. When a client hasn't provided their documents, the spreadsheet sits there silently. The follow-up depends entirely on a person noticing.
- It doesn't roll forward. Every quarter, someone has to manually recreate the next round of due dates. Every year, the same for tax returns. This is where dates get dropped — not through negligence, but through the sheer repetition of rebuilding the same job.
- It has no audit trail. If a deadline is missed, the spreadsheet can't tell you who was responsible, when the status last changed, or why. It just shows an empty cell.
The deeper issue is that the spreadsheet lives beside your work instead of inside it. The BAS is prepared in one place, the client's records sit in another, and the due date lives in a third. Nothing is connected, so nothing reconciles itself. The gaps between those three places are exactly where things fall through.
Deadlines are attached to clients and work — so track them there
An ATO or ASIC obligation is never abstract. It belongs to a specific client, it has a specific piece of work behind it, and it has a person responsible for getting it done. The moment you separate the deadline from those three things, you create manual reconciliation work.
This is the core case for tracking compliance obligations inside accounting client management software rather than in a standalone file. When the deadline lives with the client record and the work item, several things stop being your problem:
Obligations generate the work automatically
A quarterly BAS obligation shouldn't require anyone to remember it exists. In a proper client accounting workflow, the recurring obligation creates the job on the board when the period opens, assigns it, and shows its due date — every cycle, without a person rebuilding it. The lodgment program runs itself forward instead of being retyped each quarter.
Status and deadline are the same view
When the due date and the work are the same object, you can finally answer the question that a spreadsheet can't: not just what's due, but what's actually at risk. A BAS due in three days where the client hasn't sent records is a very different situation from one that's already in review — but on a spreadsheet they look identical. Seeing status alongside the deadline is what lets you triage instead of panic.
The ASIC review date nobody diarised
ASIC annual review dates are the classic casualty of spreadsheet tracking because they don't fit the neat quarterly rhythm of BAS and IAS. They land once a year, on the anniversary of registration, scattered across your company clients. In a spreadsheet they're easy to forget to add and easy to overlook once added. When the review date is stored against the company's record — with its ACN and registration details — and surfaces as a work item ahead of time, it stops being the deadline you find out about after the late fee.
One calendar beats four spreadsheets
Firms often don't have one deadline spreadsheet. They have several, plus a wall planner, plus whatever the ATO portal shows, plus what individual staff carry in their heads. Each source is partially right and none is complete. Reconciling them is a job in itself.
The alternative is a single view where BAS, IAS, tax returns and ASIC reviews all appear together, filtered by client, by staff member, or by what's due this week. This isn't about a fancier calendar — it's about having one place that is authoritative, so nobody has to cross-check four sources to trust that nothing's been missed.
Finye is built around exactly this: obligations tracked against each client, recurring jobs that regenerate on schedule, and every ATO and ASIC deadline visible on one board and one calendar. It's worth being clear about what that means — Finye doesn't lodge returns or replace your ledger. It's not tax return software in the lodgment sense. What it does is run the practice around the work: tracking what's due, whose job it is, and what stage it's at, so the compliance program stops depending on someone's memory of a spreadsheet.
Making the switch
You don't have to move everything at once. A practical sequence:
- Get the client list clean first. Your deadlines are only as reliable as the entities they're attached to. Make sure each client's ABN, ACN and lodgment cycle are correct before you build obligations on top of them.
- Set up recurring obligations, not one-off dates. The point is to stop rebuilding. Define BAS and IAS as recurring jobs so future periods appear on their own.
- Enter ASIC review dates while you're there. They're the easiest to forget and the most expensive to miss. Capture them against each company now.
- Retire the spreadsheet deliberately. Keep it read-only for a cycle if you need reassurance, then let it go. Two systems is worse than one.
A spreadsheet asks you to remember. A practice management system remembers for you — and connects that memory to the work, the client and the person doing it. For a lodgment program that keeps growing, that difference is the whole point.