For bookkeepers & accountantsPricingLog inConvert a statement

Home › Guides › How to import a bank statement into QuickBooks Online

How to import a bank statement into QuickBooks Online

QuickBooks Online fills gaps in the bank feed from an uploaded file. For statement PDFs, the file has to be created first: convert the PDF to QuickBooks' three-column CSV, then upload it in the Banking center.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Step by step

  1. Download the statement PDFs. From the bank's online banking, download each missing month's statement as a PDF.
  2. Convert to the QuickBooks CSV layout. Convert the PDFs with a statement converter and choose the QuickBooks export: a CSV with exactly Date, Description and Amount columns, signed amounts, reconciled against each statement.
  3. Open QuickBooks Online Banking. Go to Transactions, then Bank transactions, choose the account, and select Upload from file (Link account dropdown).
  4. Upload and map the file. Upload the CSV and confirm the three columns map to Date, Description and Amount.
  5. Review and categorize. Work through the imported transactions in the For Review tab, then reconcile the month against the statement.

Questions and answers

Why does QuickBooks reject my CSV?

The usual causes are extra columns, dates in an unsupported format, or amounts with currency symbols or thousands separators. The converter's QuickBooks export is produced in the three-column layout to avoid exactly these errors.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Related reading from the blog

QuickBooks · November 2, 2026

QuickBooks Desktop, QBO files, and Web Connect explained

How QuickBooks Desktop imports bank data with QBO Web Connect files, why plain CSV does not work for banking, and how to prepare a clean import file.

QuickBooks · November 3, 2026

QuickBooks import errors caused by dates, and how to fix them

Fix QuickBooks Online date import errors from weekday text, mixed formats, and day month ambiguity, with a safe format choice for every converted file.

QuickBooks · November 4, 2026

Splitting a large CSV for QuickBooks Online, safely

Split a large bank CSV for the QuickBooks Online upload size limit by month, with continuity checks at every cut so no transaction is lost or doubled.

More on the StatementVerified blog.

All guides

How to convert a bank statement · How to convert a bank statement PDF to Excel · How to import a bank statement into QuickBooks Online · How to import a bank statement into QuickBooks Desktop · How to import a bank statement into Xero

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.

Convert a statement — free