QuickBooks: "Your file does not contain the three required columns: transaction date, memo and amount"
QuickBooks Online bank-transaction uploads show this exact message — "Your file does not contain the three required columns: transaction date, memo and amount" — when the file’s columns cannot be matched to Date, Description and Amount, even when a person looking at the file can see all three are there.
Built for bookkeepers, accountants and small-business owners preparing a bank, invoice or journal file for Xero or QuickBooks Online.
Read from QuickBooks Online’s own community, with a QuickBooks Team reply confirming the causeI uploaded a CSV file with bank transactions, I keep getting “Your file does not contain…” — quickbooks.intuit.com/learn-support — read 7 September 2026
What this error means
QuickBooks Online’s three-column bank-transaction format needs a Date, a Description and an Amount column — or, in the four-column layout, Date, Description, Credit and Debit. This error means the importer could not match any column in your file to one of those required fields, most often because a heading is spelled or capitalised differently than QuickBooks expects, an export used a different file encoding (a documented Mac CSV issue), or the amount is split into columns the importer does not recognise on its own.
What causes it, and what our engine actually checks
Accounting Import Check runs the same requirement QuickBooks does before a single row is read: does the file, once its headings are matched, satisfy Date + Description + Amount, or Date + Description + Credit + Debit? The rule is missingRequiredColumn, and it is a file-level finding rather than a row-level one — it fires once, for the whole file, because no row can be checked until the columns that mean something to the importer are known.
What the engine found in a sample file
A three-column sample file with headings "Date", "Description" and "Reference" — no Amount column, and no Credit/Debit pair either — raised missingRequiredColumn immediately, before any row was checked. The engine also separately reported the "Reference" column as unmapped, because nothing in QuickBooks’ bank-transaction format means that heading. The file’s overall verdict came back "not ready."
missingRequiredColumnBlockerDate + Description + Amount | Date + Description + Credit + Debit
Blocker stops the import outright. Warning usually gets through but is worth checking before you trust the numbers. Notice is informational — safe to leave, safe to clear.
Reproduced from a sample file — read September 7, 2026.
Check your own file for this
Drop the file you were about to import below. It is read in this browser tab, the same engine runs the same check, and you will see immediately whether this exact problem is in it.
CSV, TSV or Excel, up to 20 MB
How to fix it by hand
Open the CSV in a spreadsheet program and check the first row spells the three required headings exactly — "Date", "Description" and "Amount" — or provides "Credit" and "Debit" in place of "Amount". If your bank’s own export uses different names (such as "Transaction Date" or "Memo"), rename the header cells rather than the data below them. If you are on a Mac, Intuit’s own support advises saving the file specifically as "Windows CSV" — the default Mac CSV export has been reported to produce this exact error even when the columns are correct.
Frequently asked questions
- What does "Your file does not contain the three required columns" mean?
- It means QuickBooks Online’s bank-transaction importer could not match any column in your CSV to Date, Description and Amount (or Date, Description, Credit and Debit). The columns you need are usually present in the file — the headings just are not spelled the way the importer expects.
- Why does this error happen even when my columns look correct?
- QuickBooks Online’s own community support has confirmed one common, invisible cause: saving a CSV from a Mac in the default format rather than as “Windows CSV”, which changes how the file is encoded without changing how it looks when you open it.
- Which columns does QuickBooks Online actually require for a bank upload?
- Either Date, Description and Amount as one signed figure, or Date, Description, Credit and Debit as two separate figures. Accounting Import Check checks your file against both accepted shapes, because either one satisfies QuickBooks.
- Can Accounting Import Check fix a missing-column error automatically?
- It proposes a mapping for every column and tells you exactly which required field is still unmatched, so you can rename a heading or map an existing column in seconds — but it cannot add a column of data that was never exported in the first place.
What Accounting Import Check does with this file
Accounting Import Check proposes a mapping for every column in your file before you upload anything, matching common alternate spellings automatically (“Transaction Date”, “Posting Date”, “Value Date” and more all resolve to Date). If nothing in the file can satisfy Date + Description + Amount — or the Credit/Debit pair — it tells you which columns QuickBooks still needs before you ever see the upload screen, rather than after.
The file you'd check is read in your browser tab — it is never uploaded anywhere.
What it cannot do here
The tool can propose a mapping and tell you which required field is still unfilled, but it cannot invent a column of data your file never had — if your bank export genuinely has no amount figures in it, someone still has to add them from the original statement.