Skip to content

QuickBooks won't accept my bank file. How do I fix it?

When QuickBooks refuses a bank file, the message rarely says why. Almost every failure comes down to one of six things. Work through them in order below, or drop the file into the converter above: it fixes all of them and shows you the result before you pay.

Columns (only if we guess wrong)

Column numbers in your CSV or Excel file, counting the first column as 1.

No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.

1. The file type is not one QuickBooks reads

QuickBooks Online uploads CSV, QBO, QFX, OFX and TXT files. PDF statements and Excel workbooks have to be converted first. QuickBooks Desktop imports bank transactions only as QBO (Web Connect) files, so a CSV that works in Online will not work in Desktop.

2. The file is too big

QuickBooks Online limits uploads to roughly 350 KB. A busy account can pass that in a few months. Split the file by month or quarter and upload the parts one after another.

3. The CSV has the wrong columns

QuickBooks Online expects either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit), with one header row. Bank exports often add balance, reference or category columns, summary lines at the top, or no header at all (Wells Fargo). Delete the extras, or convert the file to QBO so there is no column mapping at all.

4. Dates QuickBooks cannot read

Every date in the file must use the same format, and it must be the format you choose during the upload. A file that mixes 3/4/2026 and 2026-03-04, or that uses day-first dates while QuickBooks expects month-first, is rejected or imports with the wrong dates. QBO files avoid this completely, because they store every date as YYYYMMDD.

5. Money in and money out are the wrong way round

In QuickBooks, money out is negative. Many credit card exports show purchases as positive numbers, so they import as payments. Flip the signs before uploading, or choose Credit card as the account type in the converter and it is done for you.

6. Transactions are silently skipped

QuickBooks skips any transaction whose ID (FITID) it has already seen. Some banks give two identical charges on the same day the same ID, so one of them never shows up. A converted file gives every row its own stable ID, so both import and nothing is duplicated if you upload the same file twice.

Pricing

Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.

  • 1 file

    $9 per file

    $9

  • 10 filesBest value

    $2.90 per file

    $29

  • Unlimited files every month

    $0.08 per file, billed monthly, cancel any time, fair use 500 files a month

    $39/mo

Deleted after 24 hours

Your upload and the result are removed automatically.

Never used for training

Files are processed only to make your result.

Refund if it is wrong

If a result is unusable, we fix it or refund you.

Privacy policy · Refund policy

Questions

QuickBooks says "the file you selected is not valid". What does that mean?

Usually the wrong file type (a PDF or XLSX), a CSV with extra columns or summary rows, or mixed date formats. Converting the file to QBO avoids all three.

The upload worked but some transactions are missing. Why?

They probably shared a transaction ID with another row, or fell outside the dates QuickBooks showed for review. Check the For review tab, then re-convert the file so every row has a unique ID.

Can I upload a PDF bank statement to QuickBooks?

Not directly. Convert it to QBO first; the PDF to QBO converter above reads the statement and checks the balances.

Does QuickBooks Desktop accept CSV bank files?

Not for bank feeds. Desktop imports bank transactions as QBO (Web Connect) files, so convert the CSV to QBO first.