Document Tracking Spreadsheet or Dedicated Tool? What Each Can Check

This article is for information only and is not legal advice. Regulatory references are accurate at the date of publication and describe Commonwealth rules; state and territory rules vary. The AML/CTF framework has been under reform, so check current legislation. Seek qualified advice for any decision about an individual file.

A document tracking spreadsheet is enough while the job is to record which documents have arrived and when they expire. It stops being enough when the job becomes comparing them: does the name on the payslip match the driver licence, does the ABN on the invoice belong to the business named, does the bank account belong to the applicant. A spreadsheet stores what a person typed; a dedicated tool reads the fields from the documents and compares them. The choice depends less on how many files you handle than on which checks those files need.

What a spreadsheet does well, and where it stops

A spreadsheet is a good tracker and a poor checker. It records status, owner and dates cheaply, and anyone can adapt it in an afternoon. Trouble starts when the same sheet is asked to prove that a file is consistent.

The middle rows are the point. A sheet that says "ID received: yes" and "payslip received: yes" says nothing about whether the two belong to the same person. Our guide to verification automation covers the wider pipeline; this article stays on the tracking-versus-checking line.

The cross-checks a tracker cannot run on its own

A cross-check compares one field on one document with a field on another document or a public register, and defines in advance what a mismatch looks like and what the reviewer does next. If the sheet only holds a "received" box per document, none of these exist. If it holds typed values, the comparison depends on the typist.

Two rules keep this table honest. A mismatch is a question, not a verdict: marriage, preferred names and a dropped middle name explain most name differences, and rejecting on them alone is unfair. And the next step is written down per mismatch type so the outcome does not depend on who is on shift. A spreadsheet can hold the rules as a text column, but it cannot apply them.

Where spreadsheets break in practice

Spreadsheet trackers fail quietly, which is why they last longer than they should. The common failure modes are structural, not a sign of careless staff.

1. Dates stored as text. "03/12/2027" is 3 December in Australia and 12 March in the US; one person typing day-first and another month-first produces a sheet that sorts wrongly, and an expiry formula that returns nothing.
2. Copies in circulation. Two people download the sheet on Monday; by Friday there are two versions of the truth.
3. Sensitive data in an uncontrolled place. Licence numbers, tax file numbers and bank details in a shared sheet are visible to everyone with the link, and rows for rejected applicants stay indefinitely.
4. Overwritten history. When a status flips from "mismatch" to "OK," the sheet rarely records who decided and why.
5. Rules that live in someone's head. The knowledge that a joint account is acceptable for a tenant but not for payroll is nowhere in the file.

The Privacy Act 1988 and its Australian Privacy Principles apply to most Commonwealth agencies and to many private organisations. APP 11 requires reasonable steps to protect personal information and, when it is no longer needed, to destroy or de-identify it; see the OAIC's guidance. Tax file numbers carry additional handling rules. A sheet with no destruction logic is where files outlive their purpose.

Australia: what each official check proves

An official check proves a status on the day it was run, not that your copy of the document is genuine. Your tracker should record the result, the date and the person.

For business counterparties, ABN Lookup gives free access to public Australian Business Number information from the Australian Business Register, including whether an ABN is active or cancelled, the entity type, GST status and past trading names. Compare the ABN and entity name on the supplier's invoice with the result. It confirms what is on the register; it does not confirm who submitted the file. For companies, ASIC holds the company register with registration details and officeholders.

For work rights, the Department of Home Affairs' VEVO service lets employers check the visa entitlements of a visa holder with their consent. It shows a visa status and conditions at the time of the check, and the result should be recorded with the date. It does not authenticate the passport scan in your folder. Find the service through Home Affairs.

For reporting entities, AUSTRAC guidance covers customer identification and record-keeping under the AML/CTF Act 2006; the Act has generally required customer identification records to be retained for seven years, and the framework has been amended and extended to new sectors. Check the current Act and AUSTRAC guidance for your sector before fixing deletion dates.

What people ask about spreadsheet trackers

Recurring questions in compliance, HR and operations communities are practical.

"Can I just use Excel or Google Sheets for document control?" Yes, for a small, stable process: one document type, a handful of files a week, one owner. Add data validation on dates, restrict the sheet to named users and add a destruction-date column. Stop when a second person edits it or when you need field comparisons.

"How do I keep the sheet from going stale?" Make the document the source of truth, not the sheet: a typed expiry date will drift. Tools that extract the date remove the retyping, where most drift starts.

"Is there a free document tracking template I can download?" Many exist, and most give you columns for name, status and date. None provides the comparison rules in the table above. Treat a template as a status list and write your own mismatch rules beside it.

When to move: five triggers

Move when any one of these is true, not when volume hits an arbitrary number.

1. More than one person edits the tracker in a day.
2. Reviewers retype data from documents into cells.
3. A regulator or auditor asks who approved a mismatch and when.
4. Files include a time-limited document that must be re-checked (visa, insurance certificate, licence).
5. Chasing missing or inconsistent documents takes more time than reviewing them.

Migration need not be abrupt. Keep the sheet for reporting, move capture and comparison to the tool, and export the mismatch log back for management. A related case is tracking expiry of supplier documents, where the re-check is the whole purpose.

Choosing a tool: questions for a vendor

1. Does it read fields from each document, or only store the images?
2. Can I write my own comparison rules and choose which block and which flag?
3. Does it show the reviewer both values side by side, with the source document?
4. Does it log who resolved each mismatch and what they decided?
5. Where is data stored, for how long, and can I set retention per file type? Ask how it supports your APP 11 obligations.
6. Does it state plainly what it does not check? Be wary of any tool implying that a field match proves authenticity.

Where CheckFile fits

CheckFile is a validation layer that compares the documents in a file: whether it is complete, whether dates are current, and whether names, addresses, income figures and bank details agree across documents. Mismatches go to a reviewer with the fields highlighted, and the decision stays with your team. It does not replace ABN Lookup, VEVO or your AUSTRAC obligations, and a match is not proof that a document is genuine. For onboarding files see the HR onboarding solution, or review pricing. For more depth, read the article on cross-document consistency checks.

Frequently Asked Questions

Is a spreadsheet enough to track documents?

It is enough to track status and expiry dates for a small, stable process with one owner. It is not enough once you need to compare fields across documents or evidence who approved a mismatch.

What is the difference between document tracking and document validation?

Tracking records that a document is present and when it expires. Validation reads the document and compares its fields with other documents or a register, then routes mismatches to a reviewer.

Does ABN Lookup confirm that an invoice is genuine?

No. It confirms what the Australian Business Register holds for that ABN, such as status and GST registration. It does not confirm who produced the invoice.

Does a dedicated tool prove my documents are genuine?

No. A tool shows whether fields agree and dates are in range. Whether the original is authentic is a separate question that field matching does not answer.

How much does a dedicated tool cost compared with a spreadsheet?

A spreadsheet looks free but costs reviewer hours in retyping and chasing. Compare a tool's per-file price with those hours, and get the pricing basis in writing.