My books had 138 expenses and not one receipt attached to any of them
I asked Laura, the agent that runs our bookkeeping, to pull the receipts and invoices out of my email and make sure the books had what they needed. She came back with a number I did not expect. This fiscal year we had 138 expense transactions in QuickBooks and not one of them had a document attached. Not a few. None. The charges were categorized, the books balanced, and if anyone had asked me to prove a single line I would have been digging through email for a week.
Clean books and no evidence are not the same thing
This is the part that got me. Nothing looked wrong. Every transaction was in there, categorized, reconciled against the bank feed. By every surface measure the books were in good shape. What was missing was the layer underneath, the actual document proving each charge was what we said it was.
I never decided not to attach receipts. I just never attached any, for a year and a half, and nothing in the process ever told me. That is the quiet kind of problem. There is no error message for a thing you were supposed to do and did not.
The documents were already in my inbox
Here is the embarrassing and encouraging part. Almost all of it was sitting in my own email the whole time. Vendors had been emailing receipts for eighteen months and those emails had been quietly filed and forgotten.
So we built a small tool that reads the mailbox, pulls out every receipt and invoice, and drops them into one folder organized by fiscal year. Where a vendor attaches a PDF it takes the PDF. Where a vendor does not, and plenty do not, it saves the receipt email itself, which is still valid documentation when it shows the vendor, the date and the amount. It pulled 297 documents on the first pass and it now runs on its own every morning at 06:25.
Laura then matched those documents against the transactions and attached them. By the end of the night she had attached 108 documents to 108 separate transactions, covering 27 different vendors. Start to finish it took three and a half hours, and a good part of that was her waiting on me to answer questions.
Four vendors we were wrong about
This was the genuinely useful lesson and it is the reason I am writing this one up. Our first pass flagged a handful of vendors as the ones that simply never email a receipt, the kind where you have to log into their portal and download it by hand. We nearly accepted that list and moved on.
Four of them were wrong. They do email receipts. They just do not use the words receipt or invoice in the subject line. One says thank you for your order. One says your account has been recharged. One says we received your payment. One puts an order number in the subject and the word confirmed after it. Our search was looking for the two words everyone assumes, so four vendors looked like portal-only vendors when the documents were in the mailbox the entire time.
That is now a standing rule for us. Nobody declares that a vendor does not email receipts until someone has actually looked at what that vendor's subject line says. It is a one line fix each time and it keeps shrinking the list.
What is actually left, honestly
Sixteen transactions out of 139 are still undocumented, about twelve percent. Thirteen of those sixteen are a single vendor that genuinely sends nothing by email, so those invoices have to be pulled from their billing portal once by hand. We now keep a written list of exactly which vendors those are and where the document lives, so nobody repeats the hunt next quarter.
The rest are in-person purchases where the only receipt was paper. That is a different problem and the fix for it is a habit, not a tool.
I would rather publish the remainder than pretend the number went to zero. We went from 138 transactions with no attachment on any of them, which is zero percent, to 88 percent documented, overnight. The point is not that it is perfect. The point is that it went from no evidence at all to a short, known, written-down list of gaps, and that it stays current now without anybody remembering to do it.
Why I care more about this than it sounds like I should
Two reasons. The first is that the biggest single item in that pile was a capital asset, a piece of equipment that gets depreciated over years rather than expensed once. Having no document for that is not a filing annoyance, it is a problem with how the asset is carried on the books.
The second is the one that applies to everybody. The cost of missing documentation is never felt on the day you miss it. It is felt at year end, or during a review, when somebody asks you to prove a line from fourteen months ago and the answer is a weekend of searching. We just moved that weekend from the future into one overnight run.
Your books are probably missing their evidence too. We build the agent that goes and finds it.
← Back to all posts