Skip to main content
Back to Articles

Convert a Chase Bank Statement to Excel/CSV for QuickBooks

How to convert a Chase bank statement PDF into a clean CSV or QBO file QuickBooks Online imports without errors. Step-by-step, with format tips.

Save 10 hours monthly on data entry

Join accountants who automate their extraction

Try for free

You have a stack of Chase statement PDFs and you need the transactions inside QuickBooks. Maybe the bank feed only goes back 90 days, maybe the account is closed, or maybe you’re a bookkeeper working from a client’s PDFs. Whatever the reason, the cleanest path is to convert the Chase statement to a CSV or QBO file and import that. Here’s how to do it without the import errors that come from messy data.

First: QuickBooks Online can read PDFs now — but there’s a catch

Let’s clear up a common myth. Older guides say “QuickBooks can’t read PDF bank statements.” That’s no longer true for QuickBooks Online. Intuit’s manual upload feature now accepts either an account statement as a PDF or image (QuickBooks’ AI extracts the transactions) or a transaction file in CSV, QBO (Web Connect), QFX, or OFX.

So why convert at all? Because the PDF route has real limits:

  • Size and length caps: the upload must be English, 350 KB or smaller, and up to 1,000 transactions per file. Multi-page Chase PDFs blow past the size limit fast.
  • Chase’s layout trips up automatic extraction. Chase statements don’t use one running ledger. Transactions are split across labeled sections — Deposits and Additions, Checks Paid, ATM & Debit Card Withdrawals, Electronic Withdrawals, Other Withdrawals, Fees & Charges — each with its own subtotal line. Whether money is in or out depends on which section a row sits in, not on a plus/minus sign. Automatic parsers often misread subtotal rows as transactions or get the sign backwards.
  • No review before it lands. A clean CSV or QBO file lets you check every row before import. The QBO/Web Connect format is even better: it carries the data QuickBooks needs with no column mapping required.

Bottom line: converting to a structured file gives you accuracy and control that the raw-PDF shortcut doesn’t.

Convert a Chase statement for QuickBooks: step by step

Step 1 — Download the PDF from Chase

Sign in at chase.com, open Statements & documents, pick the account and the statement period, and save the PDF. Chase keeps roughly seven years of statements online.

Chase does offer a direct Download account activity option (CSV, QBO, QFX) on the activity page — but it’s typically capped to recent history (commonly the last ~24 months) and a limited number of rows. For anything older, or for the formal monthly statement, you’ll be working from the PDF, which is why conversion matters.

Step 2 — Convert the PDF to CSV or QBO

Upload the statement to BankStatementLab. It reads the Chase sections, normalizes deposits and withdrawals into a single consistent structure, and exports a clean file as CSV or QBO.

Two things make Chase conversion accurate here:

  • Chase PDFs are text-based, not scanned images, so extraction doesn’t depend on shaky OCR.
  • The converter consolidates multi-line descriptions into one row per transaction and drops the per-section subtotal lines that confuse other tools — giving you a true one row = one transaction file.

Step 3 — Import into QuickBooks Online

Go to Transactions → Bank transactions → Upload from file, choose your file, select the Chase account, and import.

  • If you exported a QBO (Web Connect) file, QuickBooks reads it directly — no mapping.
  • If you exported CSV, map the columns. QuickBooks accepts a 3-column layout (Date, Description, Amount — one signed amount, negatives = money out) or a 4-column layout (Date, Description, Credit, Debit).

Step 4 — Review before you accept

Confirm the transaction count matches the statement, spot-check a few descriptions and signs (deposits positive, withdrawals negative), and verify the date range. Then accept the transactions and move on to categorization and reconciliation.

Chase statement format: what to watch for

ElementOn a Chase statementWhy it matters for import
Transaction layoutSplit into labeled sections, each with a subtotalSubtotal rows must be excluded; sign depends on the section
Running balanceUsually only beginning/ending balance, not per lineYou reconcile against the ending balance, not line balances
Date formatOften MM/DD (year implied by the period)Expand to MM/DD/YYYY consistently for QuickBooks
DescriptionsFrequently wrap across multiple linesMust be merged into a single field per transaction
File typeText-based PDF (selectable text)Clean extraction, no OCR guesswork

CSV delimiter for US software is the comma, and the decimal separator is a period. Keep dates in one consistent format across the whole file — mixed date formats are the most common reason a QuickBooks CSV import fails.

What this saves you

Re-keying a year of Chase transactions by hand is hours of work and a typo on every other line. Converting each statement turns it into a two-minute job per file with exact figures — and because you’re importing a clean file, QuickBooks categorization and reconciliation run smoothly afterward.

Try it on your own Chase statement5 credits included to start, no install.

Frequently asked questions

Can QuickBooks Online import a Chase PDF directly?

Yes — QuickBooks Online now extracts transactions from an uploaded PDF or image via AI. But the file must be English, 350 KB or smaller, and under 1,000 transactions, and Chase’s multi-section layout often causes misreads. Converting to a clean CSV or QBO file is more reliable and lets you review before importing.

What’s the best file format to import into QuickBooks?

The QBO (Web Connect) format is easiest — QuickBooks reads it with no column mapping. CSV also works well and is easier to inspect and fix. Both beat importing a raw PDF when accuracy matters.

Why not just download CSV/QBO straight from Chase?

You can, when the data is recent enough — Chase’s activity download is generally limited to about the last 24 months and a capped number of rows. For older periods or the formal monthly statement (PDF only), conversion is the way to get a clean import file.

How many transactions can I import into QuickBooks Online at once?

QuickBooks Online caps a single upload at 1,000 transactions and 350 KB. (The often-cited 5,000 limit applies to QuickBooks Desktop, not Online.) Split large statements into multiple files if needed.

My Chase PDF is password-protected. What do I do?

Remove the password first — see our guide on unlocking a password-protected bank statement — then convert it.

Conclusion

QuickBooks Online can technically swallow a Chase PDF, but its size limits and Chase’s section-based layout make that route error-prone. The dependable workflow is: download the Chase PDF → convert it to a clean CSV or QBO file → import and review in QuickBooks. You get accurate data, no re-keying, and a smooth reconciliation afterward.

Convert your first Chase statement in under two minutes.


---
🎁 5 credits on signup, then 5/month
💎 1 credit = 1 page

Ready to Automate your Excel exports?

Transform your bank statement PDFs into usable Excel files in seconds.

Try BankStatementLab
Written by bankStatementLab Team