Convert a Chase Bank Statement to Excel/CSV for QuickBooks

You have a stack of Chase statement PDFs and need the transactions in QuickBooks Online. The account may be closed, the feed may not cover the period, or a client may have supplied only PDFs. One controlled route is to convert the unlocked Chase statement to CSV, review it, and import it manually into QuickBooks Online.

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 official manual-upload guide documents two routes: upload an English-language account statement as a PDF or image for extraction, or upload a structured transaction list such as CSV, QBO, QFX or OFX.

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

• Different limits apply to different routes. Intuit’s 350 KB guideline and 1,000-line limit apply to a structured transaction-list upload, not to the separate PDF or image statement route.
• Chase statements require section-aware review. Checking and card statements can separate deposits, payments, purchases, fees and summary totals. Whatever extraction route you use, verify which rows are transactions and which figures are statement summaries.
• CSV can be reviewed before upload. Intuit’s PDF workflow includes a side-by-side review inside QuickBooks. A CSV lets you perform the same date, description and sign checks before you start the manual import.

Bottom line: both routes require review. A structured CSV is preferable when you want a reusable, inspectable file before the data enters QuickBooks.

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 says that, depending on account type, up to seven years of statements may be available.

If Chase offers a CSV or QuickBooks-format activity download for the full period you need, use that bank-supplied structured file. Convert the PDF only when the monthly statement is the source you actually have.

Step 2 — Convert the PDF to CSV

Upload the unlocked statement to BankStatementLab, then choose CSV for the QuickBooks Online manual-upload workflow. XLSX is useful for spreadsheet review and JSON for a custom workflow, but QuickBooks does not use either one for this CSV import path. BankStatementLab does not create QBO/OFX files, connect to Chase or post transactions directly to QuickBooks; you download the result, review it and upload it yourself. The general conversion guide covers the checks to run on any converted statement.

Two checks matter before you continue:

• If the PDF still asks for a password, unlock it locally first. BankStatementLab rejects a file it cannot open and never asks you to upload the banking password.
• Confirm the export contains one row per real transaction. Remove statement headers, balances and section subtotals if any appear, and compare the date range and signs with the PDF.

Step 3 — Import into QuickBooks Online

Follow Intuit’s CSV formatting guidance: go to Transactions → Bank transactions → Upload from file, choose your CSV, select the Chase account, and map the columns. QuickBooks Online accepts a 3-column layout (Date, Description, Amount) or a 4-column layout (Date, Description, Credit, Debit). Pick one layout and keep all dates in one consistent format.

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

Element	On a Chase statement	Why it matters for import
Transaction grouping	May be separated into deposits, payments, purchases or fees	Preserve the section context while checking transaction signs
Statement totals	Beginning, ending and section totals may sit near transactions	Do not import summary figures as transaction rows
Date format	The printed transaction date may omit the year	Add the statement year only after checking the covered period
Descriptions	A description may wrap onto another printed line	Confirm the export keeps one transaction per row
PDF type	The file may contain selectable text or scanned pages	Review OCR-derived fields more closely when the source is an image

Keep dates in one consistent format across the whole file and inspect the mapped amounts in QuickBooks’ preview before confirming the upload.

How do I import older Chase statements without duplicating the bank feed?

Import only the periods QuickBooks does not already hold, and use the upload preview to untick anything that overlaps. When a Chase account is connected, the bank feed backfills a limited window of recent history; everything older has to come from converted statements, and the two collections meet at a seam where the same transaction can land twice.

A safe order of operations:

1. Open the Chase account register in QuickBooks and note the oldest date the feed brought in.
2. Trim the converted file so its last transaction falls the day before that date.
3. Upload, then on the preview screen deselect any row already present in the register.
4. After importing, sort the register by date around the boundary and check the day either side.

Working one file per statement period, oldest first, keeps that seam easy to control: each import has a clean start and end date, and if something does slip through you know exactly which file to look at.

Can I convert a Chase credit card statement the same way?

Yes — the conversion workflow is identical, but two things change on the QuickBooks side. First, the destination must be a credit card account, not a bank account, so charges and payments post in the right direction. Second, a Chase card statement is organized into its own labeled sections (payments and credits, purchases, fees, interest charged) and prints summary figures — previous balance, new balance, minimum payment due — that are not transactions.

Those summary figures can become phantom rows if they are mistaken for transactions. Scan the exported file for them before upload, and compare its row count with the entries printed in the statement’s transaction sections.

A word of warning if your ledger lives in QuickBooks Desktop

This guide is written for QuickBooks Online, and the distinction matters. The PDF/image and CSV workflow above is an Online workflow. Intuit’s QuickBooks Desktop bank-feed guide says Web Connect bank-transaction imports use a .qbo file supplied by the bank.

A BankStatementLab CSV does not become a .qbo file and does not create a Desktop bank-feed import. It can still serve as a readable file for checking dates, descriptions and totals; obtain the Web Connect file from Chase when you need that Desktop route.

What this saves you

Converting the statement replaces re-keying with a reviewable transaction table. You still need to compare the file with the PDF, perform the manual QuickBooks upload, review the imported rows and reconcile the account.

Run the full mapping and duplicate checks on a small date range before importing the rest of the statement. The pricing page lists the included credits and current plan limits.

Frequently asked questions

Can QuickBooks Online import a Chase PDF directly?

Yes. QuickBooks Online can extract an English-language account statement uploaded as a PDF or image and provides a side-by-side review. The 350 KB and 1,000-line limits belong to structured transaction-list uploads, not this separate statement route. A CSV is useful when you want to review and normalize rows before the manual upload.

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

Use CSV when your starting point is a PDF and you want an inspectable file. QuickBooks maps CSVs in three or four columns. Use a QBO, QFX or OFX file when Chase supplies it for the period. BankStatementLab exports CSV, XLSX and JSON, not QBO or OFX.

Why not just download CSV/QBO straight from Chase?

Use Chase’s own structured download whenever it includes the period you need. Convert the PDF when the monthly statement is the source available to you, such as an archived statement or a client-supplied document.

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

For a structured transaction-list upload, Intuit allows up to 1,000 lines and gives a 350 KB file-size guideline. Split a CSV into shorter date ranges when needed. Do not apply those limits to the separate PDF/image statement workflow.

Does this work for QuickBooks Desktop too?

No — this guide is written for QuickBooks Online. Desktop’s native bank-transaction import path is the Web Connect (.qbo) file, via File → Utilities → Import → Web Connect Files, and a CSV does not replace it. On Desktop, a converted CSV is the readable copy you check the data against, not the import file.

Can I convert a Chase credit card statement as well as a checking statement?

Yes, with the same workflow. In QuickBooks the destination must be a credit card account, and the summary figures a card statement prints (previous balance, new balance, minimum payment due) must not end up as rows in the import file.

How do I avoid duplicate transactions when the Chase bank feed already covers part of the period?

Import only what QuickBooks does not already hold: note the oldest date the feed brought in, trim the converted file to stop the day before, and deselect any overlapping row on the upload preview screen.

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 extract an uploaded Chase PDF, while a CSV gives you an inspectable file before import. When you choose the CSV route, the workflow is: download the Chase PDF → convert the unlocked file to CSV → review it → map the columns → import manually → reconcile in QuickBooks Online.

Create your BankStatementLab account — 5 credits are included to process your first statements.

---

Related articles

• Convert a bank statement PDF for Xero (CSV, not PDF)
• Guide: How to convert a bank statement PDF to Excel or CSV
• Import a bank statement into accounting software with no bank feed
• OFX vs QIF vs CSV: which bank statement format to choose
• Why bank statement PDF formats vary and parsing fails