Tracking worker compliance: spreadsheet vs software
When a spreadsheet is enough for tracking care worker compliance, where it breaks down, and what compliance software adds that a sheet cannot.
On this page
Most care providers start tracking worker compliance in a spreadsheet. It is free, familiar and flexible, and for a small team it can genuinely do the job. The question is not whether a spreadsheet can ever be compliant. It can. The question is where manual tracking starts to break down, and what dedicated software adds that no sheet can reproduce.
This guide takes both seriously. A diligent team with a good spreadsheet can stay compliant. Software does not remove your legal duty. What it removes is the manual re-verification, the expiry guesswork and the version sprawl that cause otherwise careful teams to slip.
Where a spreadsheet works fine
A spreadsheet is a reasonable tool when your workforce is small and static, and one person owns the records. In that setting it handles the basics well:
- A single column per credential type, with a clearance number and an expiry date.
- A handful of workers whose details rarely change.
- One owner who knows the rules and reviews the sheet regularly.
- Simple filtering and conditional formatting to highlight expiring items.
If you employ a dozen workers, rarely hire, and have someone diligent watching the dates, a spreadsheet can keep you compliant. There is no rule that says you must buy software. The obligation is to hold current evidence and act on it.
Where the spreadsheet breaks
The trouble is that none of the conditions above stay true for long. As you hire, roster casuals, take on subcontractors or operate across sectors, the manual model starts to crack in predictable ways.
Expiry blind spots. A spreadsheet shows an expiry date, but it does not chase it. Someone has to open the file, scan the dates and act before each one lapses. Miss a single row and a worker can keep shifts while their clearance has quietly expired. National Police Checks (Nationally Coordinated Criminal History Checks), Working With Children Checks and NDIS Worker Screening Clearances all run on different cycles, which multiplies the chances of a missed date.
No source verification. A sheet only knows what was typed into it. A pasted AHPRA number or a clearance reference proves nothing about whether the credential is still valid today. Anyone can transpose a digit, record an old expiry or simply not notice that a clearance was later cancelled. The spreadsheet will keep showing the worker as compliant regardless.
Manual re-checks. To trust a spreadsheet you have to periodically re-confirm each entry against the issuing source by hand. That means logging into state Working With Children Check portals, searching the AHPRA register and checking ban registers, worker by worker. It is slow, easy to defer and almost never done on the cadence it should be.
Software takes the ban registers off that list: Koora screens every Career Passport holder against all three every night. The portal re-checks stay a manual job for everyone. Koora verifies a Working With Children Check against the public state lookup (in Victoria, Queensland, WA, Tasmania and the NT) at the point it is collected and then tracks it to expiry, so if your policy is to re-confirm a clearance mid-term, that is still someone's task. Say so in the policy rather than assuming a platform absorbs it.
No audit trail. When a regulator or auditor asks how you knew a worker was cleared on a given day, a spreadsheet cell rarely answers it. There is usually no record of who checked what, when, or against which source. Manual edits overwrite history, so you cannot show your working.
Version sprawl. Spreadsheets get copied, emailed, renamed and edited offline. Soon there are three versions and nobody is sure which is current. A worker fixed in one copy still looks lapsed in another. This is where confident teams discover, mid audit, that their single source of truth was never single.
A clean sheet is not a verified sheet
A spreadsheet with no blank cells looks compliant. It only proves that someone entered data, not that the credentials are valid at the source today. Source verification, expiry tracking and nightly screening against the three government ban registers are exactly what a sheet cannot do for you.
What software adds
Compliance software changes the model from "record what someone typed" to "confirm what is actually true, and keep confirming it". The meaningful difference is source verification and ongoing monitoring.
- Source verification where it is possible. Working With Children Checks can be verified against public state lookups in Victoria, Queensland, WA, Tasmania and the NT, AHPRA registration against the national register of practitioners, and worker eligibility against government ban registers. That is verification at the source, not a transcribed number in a cell.
- Ongoing monitoring and expiry tracking. The three government ban registers are screened nightly, so a banning order is reflected rather than sitting unnoticed in a row. Every other credential is verified by Koora where a register exists and then tracked to its expiry date, which catches a lapse but not a mid-term suspension. Koora is working towards continuous monitoring on more sources.
- Checked credentials. Uploaded National Police Checks, qualifications, training records and NDIS Worker Screening Clearances have no source to query. The compliance engine checks them against the requirements for the role, and a person reviews the documents themselves once a worker shares their passport, or across your own records through the Crew service. NDIS Worker Screening source verification is on the roadmap; in-platform National Police Checks, run through an ACIC-accredited body and verified by Koora, are being switched on.
- A real audit trail. Each check is timestamped and attributable, so you can show how a worker's status was established when a report was run.
It is worth being precise about scope. Aged Care worker screening from 1 November 2025 means one of two things: a National Police Check issued within the last 3 years, or an NDIS Worker Screening Clearance. AHPRA registration is never a substitute for screening. In disability and childcare settings, police history is bundled into the NDIS Worker Screening Check and into state Working With Children Checks, so it is not a separate item to track.
The trade-off
Software does not make compliance happen on its own, and it does not lift your legal obligation. The provider still keeps the legal responsibility for who they engage and who can work. What software removes is the manual re-verification, the date chasing and the version sprawl that turn a careful team's spreadsheet into a quiet liability.
Put plainly: a diligent team plus a sheet can be compliant. Software makes that state easier to hold, easier to evidence and harder to lose by accident. It is a rigour multiplier, not a replacement for rigour.
Compliance is also current-state. Whether you use a sheet or software, what you can demonstrate is the status when the report runs, not a reconstructed history. Software simply makes that current state accurate and quick to produce instead of something you assemble by hand under audit pressure.
Authoritative sources
- Screening requirements for the Aged Care workforce (Department of Health, Disability and Ageing)
- NDIS Worker Screening (NDIS Quality and Safeguards Commission)
- AHPRA Register of Practitioners
How Koora fits
Koora is built for the point where the spreadsheet stops being enough. It holds worker credentials in a portable Career Passport, verifies what can be verified at the source, checks the rest against each role's requirements, and tracks every credential to its expiry so a lapse surfaces instead of hiding in a row. The three ban registers are screened nightly on top of that. A clearance cancelled mid-term is the case that stays with you: that notice comes from the issuing scheme to the employer linked against the clearance. You keep the legal responsibility for who you engage and who works; Koora removes the manual re-verification around it. Koora connects to your existing tools through API and webhooks, and can build a direct integration for your rostering or HR system on request.
To go deeper, see worker compliance tracking for providers, how to approach choosing care sector compliance software, and getting your workforce records audit ready.
Frequently asked questions
Can a spreadsheet meet Aged Care compliance obligations?
Yes, in principle. A diligent team with a well maintained spreadsheet can stay compliant, especially with a small, stable workforce. The legal duty is about holding current evidence and acting on it, not about which tool you use. The risk is that manual tracking quietly fails as the workforce grows and credentials expire on different dates.
What can compliance software verify that a spreadsheet cannot?
Software can check certain credentials against authoritative sources: Working With Children Checks via public state lookups in Victoria, Queensland, WA, Tasmania and the NT, AHPRA registration via the national register, and government ban registers. A spreadsheet only records what someone typed into it. It cannot confirm a credential is still valid at the source or flag when a clearance is later cancelled.
Does software remove our legal compliance duty?
No. Software removes manual re-verification and expiry tracking, but the provider keeps the legal responsibility for who they engage and who can work. Koora checks credentials against the role, screens every Career Passport holder against the three government ban registers every night and tracks every credential to its expiry date, and it does not assume responsibility for your engagement decisions. Convenience never replaces the underlying duty.
This is general information, not compliance advice. Always confirm requirements with the relevant regulator, and remember that providers keep the legal responsibility to sight credentials and decide who can work.
We work hard to keep everything accurate, and our compliance engine keeps up with the rules as they change. Even so, we might get a detail slightly wrong or miss something. No one's perfect. If you think something here needs updating, email us at resources@koora.care. We would genuinely rather know, because we all do better when we help each other get it right.
See where your team stands.
Run the free workforce audit on the records you already hold, or find your service on Koora and claim it. Your first five workers are free of passport-access charges.