Treadstone Associates
Article · Year-end files

AI for sorting a client's year-end file

A messy year-end file is not sorted by reading it. It is sorted by classifying every document against a file index the firm decided on before the season started.

Treadstone Associates · Updated 2026

Key takeaways

  • • Three passes, in order: classify the document, index it to a period and entity, then test the file against a standard index for gaps.
  • • The standard index is the precondition. Without one, “sorted” has no definition and no test.
  • • The gap report is the valuable output — a sorted file that is missing four things is still a blocked file.
  • • Keep the file in a form a CRA officer can actually inspect; that obligation sits on the client and lands on you.

The short answer

You sort a messy year-end file in three passes, and only the first two are mechanical. Pass one classifies each document by type — bank statement, purchase invoice, loan agreement, prior-year return, payroll summary. Pass two extracts the two or three identifiers that place it: entity, period, and where relevant an amount or counterparty. Pass three compares what you now hold against the standard year-end index your firm uses for that engagement type and reports what is missing.

Document classification and field extraction are exactly the workload described in Microsoft’s documentation for Azure Document Intelligence, which exists to manage the speed at which data locked in forms and documents can be collected and processed. The professional value, though, is created in pass three — and pass three is impossible without a standard index.

Why the standard index comes first

Most firms believe they have one and do not. What they have is a habit: the manager who does this client’s file knows which schedules should exist. Written down, the index for an owner-managed corporate year end is perhaps thirty to fifty lines, grouped by cycle — cash and banking, receivables, payables and accruals, capital assets, debt, equity and shareholder accounts, payroll and remittances, taxes, and the legal and governance documents that change infrequently.

Once that list exists, “sorted” acquires a definition that a machine can test against, and so does “incomplete”. Before it exists, an AI can produce beautifully organised folders that nobody can certify as complete, which is organisation without assurance — the least useful outcome available.

What each pass produces

Pass one, classification. Every file gets a type and a confidence. Send low-confidence items to a human queue rather than to a folder; a misfiled document is worse than an unfiled one because it stops being looked for.

Pass two, indexing. Extract entity name, period end, document date and, where the type warrants it, a control figure. This is what lets you catch the commonest year-end waste of time: documents for the wrong year, sent in good faith by a client who pulled the same report twice.

Pass three, the gap test. A table with three columns — index line, what we hold, what is missing. This is the artefact the engagement actually needs, because it converts a folder into a decision about whether work can start.

Keep the file inspectable

There is a statutory shape to all of this. Section 230 of the Income Tax Act requires records and books of account to be kept in such form and containing such information as will enable the tax payable to be determined, and subsection 230(4.1) requires records kept electronically to be retained in an electronically readable format. Separately, section 231.1 lets an authorized person inspect, audit or examine any document, including books and records, that may be relevant in determining a taxpayer’s obligations, at all reasonable times.

The practical consequence for a firm sorting files with software is small but real: do not let the tidy version become the only version. Keep the original document alongside the extracted index, keep the audit trail of what was classified as what, and do not rename in a way that destroys the client’s own reference. The Auditing and Assurance Standards Board sets the assurance and related services standards that govern what the file has to contain.

Worked example (illustrative)

A two-partner practice receives a client’s year end as a shared drive folder containing roughly four hundred files with names like “scan_0043.pdf”. The old process: a junior opens each one and drags it somewhere, taking most of a day, and the gaps surface a week later during fieldwork. The rebuilt process: the folder is run through classification and indexing overnight; in the morning the junior works a queue of about forty low-confidence items rather than four hundred documents; the gap report goes to the client the same morning as a query list.

The gain is not mainly the sorting time. It is that the missing items are identified on day one instead of day eight, which is a week of client response time recovered inside the same deadline. That is the number to track: days between file receipt and first gap report.

What the tool must not do

It must not conclude that the file is complete, and it must not decide that a document is sufficient evidence of the thing it appears to support. A signed loan agreement in the folder is not proof that the balance is correct. The determination of sufficiency is professional judgment, exercised by a person who is accountable for it. The software’s job ends at “here is what we hold and here is what the index says should exist”.

If what you need is the internal month-end close of a single business rather than the year-end file of a client, that belongs on the accounting automation page.

Questions we get asked

Can it handle a folder of mixed-client documents?
Yes, if entity extraction is part of pass two — but route anything ambiguous to a person. Filing one client’s document into another client’s file is a confidentiality incident, not a sorting error.

Should we rename the client’s files?
Add a structured name and keep the original in the metadata. Clients search by what they called it.

How accurate is classification?
It depends entirely on your document mix, so measure it on your own files rather than trusting any published figure. Run one completed engagement through the pipeline and count the corrections.

See where AI pays off first in your firm.

A 30-minute call is enough to tell you whether AI pays for itself here.