Why QuickBooks Won't Let You Export Attachments Linked to Their Transactions

Inside QuickBooks Online, a receipt is never just a file. When you attach a bill, an invoice, or a scanned document to a transaction, QuickBooks stores the relationship between the two: this file supports that expense, on that date, for that amount, paid to that payee. Open the transaction and the document is right there, one click away. That relationship is most of what makes the attachment worth keeping.

When you bulk-export your attachments, the relationship does not come with them.

How attachments actually work inside QuickBooks

Every attachment lives in two places at once. There is the file itself, and there is the metadata that ties it to a transaction: which bill or expense or invoice it belongs to, and therefore which date, amount, account, and payee it documents. You never see that link as a separate object, because the software resolves it for you every time you open a record.

Because the link is internal to QuickBooks, it is not something you hold outside the software. It exists as long as your company file exists. When you export, or when the company is eventually deleted, the link is not part of what you take with you unless you rebuild it deliberately.

What comes out when you export

QuickBooks gives you two relevant tools, and neither preserves the connection.

The first is the standard export to Excel, reached from the Export Data page. Intuit's help article on exporting reports and lists is explicit that this export leaves attachments out entirely. Your ledger, your lists, and your reports come out; the documents do not.

The second is the bulk receipt export. This one does give you the files, but Intuit's own documentation on exporting receipts says they export separately from the transactions they were attached to, and that you manage the matching yourself afterward. You end up with a folder of PDFs and images named the way QuickBooks named them, with no record inside that folder of which expense each file supports.

So the export that includes your numbers leaves out your documents, and the export that includes your documents leaves out the connection to your numbers. For day-to-day use that is fine, because the live company still holds everything together. For an archive, it is the whole problem.

Why the folder of files is not enough

Think about who asks for these documents and why. An auditor, a tax examiner, a lawyer, or a buyer doing due diligence almost never asks to see a folder of receipts. They ask a pointed question: show me the source document for this specific transaction. What was this $4,200 payment on March 14, and what backs it up?

To answer that from a bare folder, you have to already know which of your files corresponds to that payment. If the files are named the way they were uploaded, with no payee or amount, you are opening them one by one until you find the right one. Across several years and a few hundred transactions, that is slow, and it is exactly the moment when being slow looks bad.

The retention windows make this worse, because the question can arrive years after you have stopped thinking about the books. The IRS generally expects you to keep records for at least three years, with six for substantial underreporting and seven for certain bad-debt and worthless-securities claims. QuickBooks keeps a cancelled paid company readable for only twelve months. The distance between those two numbers is the entire reason this matters, and we walk through it in our guide to the read-only year.

The honest do-it-yourself version

You can preserve the linkage by hand (the bulk download itself is covered here). The method is not complicated, just tedious:

• Open each transaction that has an attachment.
• Download the file.
• Rename it with a scheme that carries the context, for example the date, the payee, and the amount: 2025-03-14_acme-supply_4200.pdf.
• Keep a spreadsheet that maps each renamed file to its transaction, so the mapping survives outside the filenames too.

Done consistently, this gives you a folder you can navigate and a spreadsheet that works as an index. For a company with a few dozen attachments, it is an afternoon.

For a company with a few hundred, it is days, and it has to be finished before the read-only window closes, because once QuickBooks deletes the company you can no longer open the transactions to see what each file was for. The renaming is also easy to get subtly wrong, and a mislabeled receipt is worse than a missing one.

What a proper archive looks like

The fix is an index built while the account is still accessible: a record that maps every file, under its original filename, to the transaction it supports, with the date, amount, payee, and account spelled out. With that index, the folder of documents becomes searchable, and any future "show me the source document for this transaction" has a one-line answer instead of an afternoon of guessing.

Building that index is the part QuickBooks will not do for you, and it is why a plain export leaves you exposed. If you would rather not rebuild it by hand across years of books, that is the archive we build for you: every attachment preserved with its original filename and linked back to its transaction, verified against the live books before you cancel. If you have not cancelled yet, our guide to what happens to your data after cancellation covers how much time you actually have.