Upload Bank Statements to QuickBooks Online — Step-by-Step (2026)

TL;DR

-QuickBooks bank feeds are the preferred method, but they disconnect, don't support all banks, and can't import historical statements.
-Manual file upload works with QBO, OFX, or CSV files — download from your bank portal and import via Banking → Upload Transactions.
-PDF bank statements can't be uploaded to QuickBooks directly — they must be converted to CSV or QBO format first.
-AI extraction converts PDF bank statements (including scanned) to QuickBooks-compatible CSV automatically. Try the free converter →

QuickBooks Online's bank feed feature is supposed to import transactions automatically — but it doesn't always work. Bank feeds disconnect, some banks aren't supported, and historical statements beyond a few months can't be imported via the feed. When the automated connection fails, you need to upload bank statements manually.

This guide covers three paths to get bank statement data into QuickBooks Online: reconnecting the bank feed, manually uploading transaction files, and using AI to convert PDF statements into QuickBooks-compatible format.

Why bank feeds fail

Bank connection drops: Authentication tokens expire, banks update their APIs, or security policies change. You'll see a 'Connection needs attention' warning.
Bank not supported: Smaller banks, credit unions, and international banks may not have direct QuickBooks integration.
Historical data limits: Bank feeds typically import the last 90 days. Older transactions need manual import.
Closed accounts: Once an account is closed at the bank, the feed stops — but you may still need those transactions in QuickBooks.
Multiple banks: Managing feeds for 5+ bank accounts means 5+ potential disconnection points.

Option 1: Reconnect the bank feed

If your bank feed disconnected recently, try reconnecting first. In QuickBooks Online, go to Banking → click on the bank account → Update or Fix connection. Re-enter your bank credentials. This resolves most temporary disconnections.

Option 2: Upload a transaction file manually

QuickBooks Online accepts three file formats for manual bank statement import: QBO (QuickBooks Web Connect), OFX (Open Financial Exchange), and CSV (comma-separated values). Most bank portals offer at least one of these as a download option.

Download the transaction file from your bank

Log in to your bank portal → Transaction History → Download/Export → Select QBO, OFX, or CSV format. Choose the date range you need.

Upload to QuickBooks Online

In QuickBooks, go to Banking → Upload Transactions (or Link Account → Upload from file). Select your bank account and choose the downloaded file.

Map columns (CSV only)

If uploading CSV, QuickBooks asks you to map columns — match Date, Description, and Amount fields. QBO and OFX files are pre-formatted and don't need mapping.

Review and accept transactions

QuickBooks shows the imported transactions in the 'For Review' tab. Review, categorize, and accept them to add to your books.

QBO format is preferred over CSV for QuickBooks import. QBO files include transaction type metadata (check, deposit, transfer) that CSV lacks. If your bank offers QBO download, use it.

Option 3: Convert PDF statements with AI

When your bank statements are only available as PDFs — older statements, scanned documents, statements from closed accounts — QuickBooks can't import them directly. You need to convert the PDF to CSV format first.

AI extraction converts any bank statement PDF (including scanned and printed statements) into a clean CSV file that QuickBooks can import. The AI reads the statement, identifies every transaction (date, description, amount, balance), and outputs structured data in QuickBooks-compatible format.

Upload the PDF bank statement

Upload to Parsli's bank statement converter. Any bank, any format — digital or scanned.

AI extracts all transactions

Date, description, debit/credit amount, and balance — extracted from every page automatically.

Download as CSV

Export the structured transaction data as a CSV file formatted for QuickBooks import.

Upload CSV to QuickBooks

Follow the manual upload steps above (Banking → Upload Transactions) with the generated CSV file.

Free Bank Statement to CSV

Convert any bank statement PDF to QuickBooks-compatible CSV — free, no sign-up.

Try it free

Stop copying data out of documents manually.

Parsli extracts structured data from PDFs, invoices, and emails — automatically. Free forever up to 30 pages/month.

Try it for free

No credit card required. · Or book a demo call

Frequently Asked Questions

Can I upload a PDF bank statement directly to QuickBooks?

No. QuickBooks Online only accepts QBO, OFX, and CSV files for bank transaction import. PDF bank statements must be converted to one of these formats first. AI extraction can convert PDFs to CSV automatically.

What file format is best for QuickBooks import?

QBO (QuickBooks Web Connect) is the preferred format — it includes transaction type metadata that CSV lacks. If your bank doesn't offer QBO download, CSV works but requires column mapping during import.

Can I import scanned bank statements to QuickBooks?

Not directly. Scanned statements must be converted to CSV first using AI extraction with OCR. Parsli's bank statement converter handles scanned and printed statements from any bank.

How far back can I import bank statements?

QuickBooks bank feeds typically import the last 90 days. For older transactions, download the statement file from your bank portal or convert PDF statements to CSV for manual upload. There's no time limit on manual file uploads.