Automating T1 data entry, from the shoebox to the tax software
In two halves. First the paperwork is read: every document sorted, every figure pulled out and tied to the spot on the page it came from. Then the reviewed figures go into the firm's own tax software through that program's own way in. The person who signs the return still checks every number; they stop typing them.
Two halves, with a review in the middle
Data entry on a T1 is really two jobs that a preparer does at once: working out what is on each piece of paper, and typing it into the right place in the tax software. Automating it means separating them again, and putting a person between them.
1. Read the dropoff
Everything the client handed over goes in as it arrived: phone photos, scans, PDFs, statements, the receipts in no particular order. Each document is identified for what it is, matched to the right person on the file, and every figure that matters is pulled out: the amount on a medical receipt and the date and patient beside it, the rent and expenses for a T776, income and costs for a T2125, the eligible amount on a donation receipt rather than the gift.
The part that makes the rest safe: each figure stays tied to the exact spot on the page it was read from. Without that link, review means redoing the work.
2. Review against the documents
The preparer looks at the figures beside the paperwork, corrects what is wrong, and approves. Anything the software was unsure of is flagged and holds the return until a person decides. This is where the professional’s time goes now, and it is far less of it: checking a number against the page it came from takes seconds; finding it in a bag and typing it takes minutes.
3. Enter it through the program’s own way in
The approved figures go into the firm’s own tax software. The safe way to do that is through the program’s own import or entry, never by writing to its return files, and with every value read back from the program before it counts as entered. Each program has a different way in:
- TaxCycle: TaxCycle’s own Excel import.
- Taxprep Desktop: Taxprep Desktop’s own Import Data.
- ProFile: ProFile’s own fields.
- Taxprep Cloud: Taxprep Cloud’s own import in your browser.
- DT Max: DT Max’s own keyword entry.
If the client has no return yet, one can be created; if the return exists, it is opened and filled. Either way the preparer finishes, reviews and files in the program exactly as before.
What changes in the firm, and what does not
What changes: nobody types the shoebox. A return with a rental, a side business, a year of medical bills and a pile of donation receipts stops being a day of entry, and the complex returns stop queueing behind the simple ones. Seasonal hiring for data entry becomes a question rather than a given.
What does not: the professional judgement, the review, the signature and the filing. The tax software still calculates and transmits. Automating the entry should never touch the CRA, and a tool that offers to should be read as a warning.
Slips are the smaller part of this. Auto-fill My Return already brings down what issuers file with the CRA; see what it does not fill for everything that is left.
What we do about it
This is KeyGlance. Drop in the shoebox, even for the most complex return: it extracts every document, you review each figure beside its source, and one click enters it all into TaxCycle, Taxprep Desktop, ProFile, Taxprep Cloud or DT Max in minutes. It never files anything with the CRA.
Questions we get asked about this
Is automated data entry the same as OCR?
OCR turns a picture of text into text. It does not know that one number on a pharmacy printout is the amount paid and another is the prescription number, or which line of the return either belongs on. Automating T1 entry needs the document understood: what it is, who it belongs to, which figures matter and where they go.
What happens when the software reads a number wrong?
It is caught at review, because every figure is shown beside the spot on the document it was read from. Values the software is unsure of should be flagged and should stop the return from going further until a person decides. The failure to design for is a silent wrong number, not a slow one.
How long does an automated T1 take?
The reading and the entry take minutes, however thick the envelope. Review still takes a person's attention, but it is checking figures against documents side by side rather than typing them, which is the part that used to fill the day.