How to Import a Bank Statement into QuickBooks Online and Desktop (2026)

What file formats QuickBooks accepts

QuickBooks Online accepts CSV, QBO, and OFX files for bank imports. QuickBooks Desktop accepts only QBO and OFX. Neither version accepts raw PDF files.

If your bank provides a direct CSV or QBO download, use that. It is the cleanest starting point. If your bank only provides PDF statements, you need to convert the PDF to CSV or QBO before importing.

How to import into QuickBooks Online (step by step)

1. Go to Bookkeeping (or Accounting in older versions), then select Transactions.
2. Click the Banking tab.
3. Select Upload transactions from the dropdown in the top right.
4. Choose your file (CSV, QBO, or OFX).
5. If uploading a CSV, map your columns: Date, Description, Amount (or Debit and Credit separately).
6. Select the bank account in QuickBooks to associate the transactions with.
7. Review the transactions QuickBooks detected and click Add to import them.

For QBO and OFX files, QuickBooks skips the column mapping step and reads the structure automatically. The import is faster and less error-prone than CSV.

How to import into QuickBooks Desktop (step by step)

1. Go to Banking in the top menu.
2. Select Import Web Connect File.
3. Browse to your QBO or OFX file and open it.
4. QuickBooks Desktop will ask which bank account to associate the transactions with. Select the correct account.
5. Click Use an existing QuickBooks account and select the account from the list.
6. The transactions will appear in your register ready for review.

QuickBooks Desktop does not accept CSV files for bank imports. If you only have a CSV, you need to convert it to QBO first using a third-party converter.

How to handle PDF-only bank statements

If your client's bank only provides PDF statements, or you need historical data beyond the bank's online download window, you need to convert the PDF before importing into QuickBooks.

The process:

1. Upload the PDF to an AI conversion tool like Documentric (/dashboard).
2. The tool extracts transactions into a structured table.
3. Download as QBO for a direct QuickBooks import, or CSV if you prefer to map columns manually.
4. Import using the steps above.

AI conversion tools handle both digital PDFs and scanned statements. Processing a full year of statements typically takes 2 to 5 minutes.

Common import errors and how to fix them

Wrong date format

QuickBooks Online requires dates in MM/DD/YYYY format for CSV imports. If your file uses DD/MM/YYYY or YYYY-MM-DD, reformat the date column in Excel before importing. QBO and OFX files handle dates internally and do not have this issue.

Duplicate transactions

QuickBooks uses transaction IDs in QBO files to detect duplicates. If you import the same date range twice from different files (which can happen when transaction IDs differ between exports), QuickBooks may import duplicates. Always check whether the date range you are importing overlaps with transactions already in your register.

Column mapping errors in CSV import

If QuickBooks misidentifies which column is Date, Description, or Amount, your transactions will import with wrong data. The fix is to rename your columns before importing. QuickBooks recognizes column headers named Date, Description, Amount, Debit, and Credit automatically.

File rejected without an error message

This usually means the file format does not match what QuickBooks expects. For QBO files, verify the XML structure is valid. For CSV files, check for special characters, merged cells, or extra header rows above the column names. Open the file in a text editor to inspect it if the Excel view looks correct but the import still fails.

How to import multiple months of statements

If you are importing multiple months at once, import in chronological order starting with the oldest statements. This ensures your register stays in date order and makes any discrepancies easier to spot.

Check for overlapping date ranges between files. If January and February statements both include January 31, importing both files will create a duplicate for that date. Trim the overlapping period from one file before importing.

FAQ

Can I import a PDF directly into QuickBooks?

No. QuickBooks does not accept PDF files. You need to convert the PDF to CSV or QBO first. AI conversion tools handle this automatically in under two minutes for most statements.

How far back can I import transactions?

There is no technical limit on how far back you can import. However, QuickBooks Online performance can slow with very large import files. For imports covering more than two years of transactions, split the file into 6-month chunks.

Will imported transactions match my existing bank rules?

Yes. After import, QuickBooks applies your existing bank rules to categorize imported transactions automatically. This is one of the main advantages of importing via QBO or CSV over entering transactions manually.

Can I undo a bank statement import?

In QuickBooks Online, imported transactions appear in the For Review section before they are added to your books. You can exclude them before adding. Once added to your books, you need to delete individual transactions manually. There is no bulk undo for an import, so review before adding.