Convert Chase PDF bank statement to QuickBooks Online

Chase provides statements and transaction records for its bank and credit-card accounts.

Countries: United States, United Kingdom
Supported statement formats: PDF, CSV
Supported destinations: QuickBooks Desktop, QuickBooks Online, Quicken, Xero, CSV/Excel

Chase PDF statement details

The following details were checked against Chase statements from 2020 to 2026: business checking, personal checking, and credit card, plus scanned copies and one statement issued in Spanish. Chase changes small things between account types and years, so always reconcile the converted transactions to the statement totals.

Chase uses three different layouts

• Business checking splits transactions into sections: Deposits and Additions, Checks Paid, ATM & Debit Card Withdrawals, Electronic Withdrawals, Other Withdrawals, Fees. Every section has its own DATE, DESCRIPTION and AMOUNT header and its own total line.
• Personal checking (Chase Total Checking and similar) prints one Transaction Detail table with DATE, DESCRIPTION, AMOUNT and BALANCE columns.
• Credit card prints an Account Activity list grouped by cardholder, with a Date of Transaction, a merchant description and a dollar amount.

A converter that recognizes only one of these will read the other two as plain text. The Checking Summary or Account Summary near the top identifies the account type: a line such as "Chase Total Business Checking" or "Chase Total Checking" sits above the summary, and card statements show "Account Number: XXXX XXXX XXXX 6037".

Settings for a Chase PDF statement

• Date: transaction rows show month and day only, such as 07/03. Take the year from the period line that repeats on every page, for example July 01, 2020 through July 31, 2020, or from Opening/Closing Date 02/09/26 - 03/08/26 on card statements. Many Chase cycles run mid-month to mid-month (May 20 to June 18), so a statement crosses a month boundary every time and crosses the year in December.
• Amount: comma for thousands, point for decimals. The dollar sign appears only on the first row of each section and on total lines. Business checking prints every amount without a sign, and the section decides whether it is money in or money out. Personal checking prints withdrawals with a leading minus. Credit cards print purchases as positive and payments and refunds as negative.
• Account number: checking statements print a 15-digit number with leading zeros, such as 000000767025179. Anything that treats it as a number drops the zeros, and the online banking feed uses the shorter form, so an imported file may not match the existing account. Card statements mask the number and leave only the last four digits.
• Account type and currency: checking for the two checking layouts, credit card for the card layout, USD throughout.

The sign is in the section header, not in the amount

On business checking every amount is printed as a plain positive number. 7.43 under ATM & Debit Card Withdrawals is money out; 500.00 under Deposits and Additions is money in. The only thing that tells them apart is the section header above, and that header repeats on the next page with a (continued) mark. A converter that loses track of which section it is in flips every sign from that point on, and the statement still looks fine because nothing is printed as negative.

The Checks Paid section also changes the column order. It prints CHECK NO., a ^ or * marker, DESCRIPTION, DATE PAID and AMOUNT, so the date sits far to the right of where it sits in every other section, and the description is usually empty. ^ means a check image is available; * means a gap in the check number sequence.

Card purchases carry two dates

A debit card row reads 07/01 Card Purchase 06/29 Coffee Shop Rancho Mirage CA Card 1234. The date in the DATE column is the posting date. The date inside the description is the day the purchase happened. Chase itself uses the posting date for the balance, so that is the one that reconciles, but a bookkeeper matching receipts expects the other one. The converter should keep both and let the user choose. The trailing Card 1234 identifies which debit card was used and is useful when a statement covers several cards.

Chase hides section markers inside the PDF

Every text-based Chase statement contains tiny invisible strings such as *start*deposits and additions, *end*checks paid section3 and *start*daily ending balance2, printed at about 4 pixels high around each section. A person never sees them. A converter that reads them knows exactly where each section begins and ends without guessing from headers. Scanned statements do not have them, because a scanner only captures what is visible, which is one reason the same statement is harder to convert as a scan.

Descriptions arrive in pieces and on extra lines

Chase prints parts of a description at fixed horizontal positions. An ACH row can come through as three separate strings: the company name, the entry description and a PPD ID: or Web ID: reference, each starting at its own column. Reading them in file order can glue them together in the wrong sequence or without spaces.

Long descriptions wrap, and the wrapped part is printed on the next line with no date and no amount. A row such as Recurring Card Purchase 05/21 Phone Company 855-707-7328 MO Card is followed by a line that contains only 9380. That line belongs to the row above it. A converter must attach it to the previous transaction rather than drop it or treat it as a new row.

Summary tables look like transactions

Several tables use the same dates, amounts and column widths as the transaction rows:

• Checking Summary lists each section with an INSTANCES count and a signed total.
• Daily Ending Balance prints three DATE and AMOUNT column pairs side by side, which can read as twenty or more extra transactions with no description.
• ATM & Debit Card Summary repeats per-card totals, and Service Charge Summary repeats the fee.
• Account Summary on card statements lists Previous Balance, Payments, Purchases, Fees and New Balance, and the first page also carries a calendar grid of day numbers, a remittance coupon with a long digit string, and year-to-date totals.

None of these are transactions. Reading any of them alongside the real rows creates duplicates or phantom entries.

The statement gives you three ways to check the result

• Business checking: every section ends with a Total line, and the Checking Summary states how many transactions each section has. Sixty-four card withdrawals totalling 1,727.76 in the summary must match sixty-four rows in the section.
• Personal checking: the BALANCE column on every row, plus Beginning Balance and Ending Balance rows printed inside the table.
• Credit card: Previous Balance minus Payments plus Purchases plus Fees plus Interest must equal New Balance, and each cardholder block ends with TRANSACTIONS THIS CYCLE (CARD 6037) $10726.83-, a subtotal with a trailing minus sign.

If the counts and totals match and the ending balance is reached, every posted row was included exactly once.

Credit card statements have their own rules

• Rows are grouped by cardholder, and the cardholder's name is printed after the group, not before it. Assigning a row to a card means reading forward to the next name line.
• Transaction dates are not sorted. A February statement can list 02/22 before 02/20, and a statement that closes in early January mixes December and January dates in the same list. The year must come from the Opening/Closing Date, not from the order of the rows: any month later than the closing month belongs to the previous year.
• Purchases are positive and payments are negative on the statement. Accounting software that imports into a credit card account usually expects the opposite sign convention, so the converter must flip signs consistently, or the balance will run backwards.
• Merchant text carries processor prefixes such as IN *, PY * and SQ *, phone numbers and state codes. Those are useful for rules but noisy as payee names.
• Two identical rows can be genuine. The same online store charging 142.31 on two different days is common, and two identical restaurant charges on the same day happen. De-duplicating by date and amount removes real transactions; each row needs its own transaction ID.

Pages that are not part of the statement

A personal checking statement can open with a full page of account messages, so the summary and the transactions start on page two. Card statements continue those messages onto later pages with a (CONTINUED) heading. The address block on page one carries a mail sorting line of codes such as DRE 703 210 21420. Page footers appear as Page 2 of4 or as two fragments, 4 and Page 2 of. A converter should count pages from the Page X of Y text to confirm nothing is missing, and ignore everything else on those lines.

Statements in Spanish

Chase issues statements in Spanish for customers who request them. The layout is the same but every header changes: RESUMEN DE CUENTA, Saldo Anterior, Nuevo Saldo, Fecha de apertura/cierre. A converter keyed on the English headers finds no sections at all. Numbers keep the same comma and point format.

Scanned copies

A scanned Chase statement loses the hidden section markers, and OCR splits every word into a separate element, so rows have to be rebuilt from positions. Typical OCR errors are $l for $1, O for 0 and accented characters in Spanish statements coming through as symbols. The balance column, the section totals and the summary counts are what catch those errors, so a converter should always reconcile a scan, not only a text PDF.

PDF input challenges

A bank PDF can contain searchable text, scanned page images, or a mixture of both. Searchable text still needs layout analysis because transaction descriptions wrap, columns move, and headers or balances repeat at page breaks. A scanned statement adds OCR uncertainty.

Page breaks

A transaction may begin at the bottom of one page and continue on the next. Continuation pages can omit column headings, repeat an opening balance, or insert footer text and legal pages between transaction pages. A conversion should join split rows and exclude repeated page furniture before it writes the output.

OCR

On scanned pages, OCR can turn 0 into O, 1 into l, or 5 into S. It can also lose a minus sign or decimal mark, read two columns in the wrong order, or struggle with skewed and faint pages. The running balance is the best check: a damaged amount or missing row breaks the balance sequence.

PDF questions

Can I convert a scanned bank statement?

Yes. Review the OCR result and reconcile every balance movement. Scans with faint printing, rotation, or handwritten marks need more checking than searchable PDFs.

Why does copying and pasting a PDF into Excel fail?

PDF text stores page positions rather than a spreadsheet table. Wrapped descriptions, repeated headers, and visually aligned columns can paste in the wrong order or into the wrong cells.

How do I know whether the PDF contains searchable text?

Try selecting a transaction description in a PDF reader. If individual words can be selected, the page probably contains text. If the whole page behaves like one picture, it requires OCR.

QuickBooks Online import settings

QuickBooks Online imports bank transactions from a file through Banking, Upload transactions. It accepts QBO, QFX and OFX files, which share the OFX structure, and CSV files. Uploaded rows land in the For Review list, where QuickBooks matches them to existing entries and the user adds or excludes them.

• OFX, QFX and QBO carry the date, the amount, a payee, a memo, an optional check number and a unique transaction ID. QuickBooks Online uses the payee as the Description and the transaction ID to skip rows it has already imported.
• CSV carries less. QuickBooks Online reads a date, a description and an amount, in a three-column layout with one signed amount or a four-column layout with separate debit and credit columns. Only one description column is imported; a payee and a memo cannot both be kept.

Settings that matter:

• Account: the user picks the QuickBooks account during upload, so the account ID in the file matters less than in QuickBooks Desktop. It still helps to keep the same ID per account so the file is recognized on the review screen.
• Account type: checking or credit card. A credit card file into a checking account flips every sign.
• Dates: MM/DD/YYYY or DD/MM/YYYY depending on the company settings, digits only, four-digit years.
• Amounts: digits and one decimal separator. No currency symbols, no thousands separators in CSV.
• File size: QuickBooks Online limits a CSV upload to about 350 KB. Split a long statement into several files.
• Transaction IDs: unique per row and stable per transaction, so re-uploading a period does not double it.

QuickBooks Online questions

Should I use CSV or OFX?

Use OFX, QFX or QBO when the file can be made in that format. It carries the payee, the memo and the check number and gives QuickBooks a transaction ID for duplicate checks. Use CSV when a spreadsheet is the only source and a single description is enough.

Why does QuickBooks Online reject my CSV?

The usual causes are a date column QuickBooks cannot read, an amount with a currency symbol or thousands separator, more columns than the three- or four-column layout, or a file over the size limit. Save the file with dates as digits, amounts as plain numbers, and only the needed columns.

Why did transactions import into the wrong account?

The account was chosen during upload. QuickBooks Online does not read the account name from the file. Exclude the rows, delete them from Excluded, and upload again with the right account selected.

How do I undo an import?

In For Review, select the rows, choose Batch actions, Exclude Selected. Open Excluded, select them again, Batch actions, Delete. The rows are gone and the file can be uploaded again.

Why are some rows missing after upload?

QuickBooks Online skips rows whose transaction ID it has already seen and, for CSV, rows it reads as duplicates by date, amount and description. Two genuine identical rows on the same day can be dropped from a CSV. Use an OFX-type file with unique IDs for those.

Can I import transactions older than 90 days?

Yes. The 90-day limit applies to a live bank connection, not to a file upload. Any date range can be uploaded from a file.