# Convert Chase Bank Statement to QBO for QuickBooks

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2024-11-28
- Updated: 2024-11-28
- Category: PDF bank statements
- Canonical: https://www.simplebankconvert.com/blog/convert-chase-bank-statement-to-qbo

> How to convert a Chase bank statement to QBO when the download window has passed: read the PDF layout, check the totals and import the file to QuickBooks.
To convert a Chase bank statement to QBO, take the PDF statement for each month the Chase download no longer reaches, copy its dated activity into date, description and signed amount rows, and check the rows against the summary totals. Then build a QBO file from those rows and import it into the matching QuickBooks account.

## Can Chase still give you a QBO download for those months?

Try the bank's own download before converting anything. A file Chase produces from its records needs no checking for typos, so if the activity download in online banking still covers the dates you need, use it. Converting a PDF is the route for the months that fall outside that window.

The download window is the stretch of recent activity a bank lets you export as a file. It varies by bank and by account type, and it is usually shorter than the run of PDF statements you can open. So the common situation is this: QuickBooks needs to start in January, the download reaches back only part of the way, and the earlier months exist only as monthly PDFs.

Before you begin, write down three dates:

1. The first date QuickBooks needs to cover.
2. The earliest date the Chase download will give you.
3. The date the bank feed, if you have one connected, starts from.

The gap between the first and second dates is the work for this post. Everything from the second date on can come from the download or the feed.

[Intuit's article on downloading bank feed transactions in Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/download-bank-feed-transactions-quickbooks-desktop/L8o0Aw9VM_US_en_US) notes that some banks let you set a date range for a download and others send their maximum history on the first one. Check which kind of download you get before you plan the PDF months around it, so the two sources meet cleanly.

## Reading a Chase PDF statement before converting it

A Chase checking statement, like most US bank statements, opens with a summary of the period and then lists the activity behind it. Only the dated activity becomes rows in the QBO file. The summary, notices and any daily balance table stay on the PDF, though the summary is worth keeping beside you for the next check.

Download the statement from Chase online banking rather than scanning a paper copy. A downloaded PDF contains real text, so you or a converter can read each character exactly. A scan is a picture, and every digit has to be recognised before it can be trusted.

### Parts of the statement to find

Work through the first page and note:

- **The account:** its name and the last four digits printed on the statement. You need these to pick the right QuickBooks account later.
- **The statement period:** the start and end dates. Lines that show only a month and day take their year from this period.
- **The opening and closing balances:** the two figures every later check depends on.

Then find the activity. Some statements list everything in one table in date order. Others group lines into sections, such as deposits, checks, card purchases, electronic withdrawals and fees, each with its own total. If yours is grouped, copy every section and then sort the rows by date. A section left out is the most common reason a converted month comes up short.

### Lines that look like activity but aren't

Skip beginning and ending balance rows, section totals and any line that repeats a balance. A daily ending balance list at the back of the statement is a set of balances, not transactions. Importing those rows would throw your balance off by their combined amount.

If a Chase credit card statement is what you are converting, the reading is different, because purchases raise what you owe. [How a Chase card statement compares with an Amex one](/blog/how-to-import-amex-statement-into-quickbooks#does-a-chase-card-statement-import-the-same-way) covers the card side.

## Using the Chase summary totals as a conversion check

The summary at the top of the statement is your proof that the conversion is complete. Add up your converted deposits and compare them with the deposit total, then do the same with withdrawals. Finally, opening balance plus the net of your rows must equal the closing balance printed on the statement.

Here is an example with made-up figures for one month:

| Check | From the statement summary (example) | From your converted rows (example) |
| --- | ---: | ---: |
| Opening balance | 6,412.08 | 6,412.08 |
| Deposits and additions | 9,850.00 | 9,850.00 |
| Withdrawals, checks and fees | 8,973.61 | 8,948.61 |
| Closing balance | 7,288.47 | 7,313.47 |

Deposits agree. Withdrawals are 25.00 short, and the closing balance is 25.00 high, which means one 25.00 money-out line is missing. On a grouped statement, look first at the smallest section, often fees. A monthly service charge or a wire fee is easy to miss because it sits alone in its own box.

Fix the rows until all four lines of the check agree. Then you know the file holds the same activity as the PDF.

## Building the Chase QBO file, step by step

A QBO file, also called a Web Connect file, is a bank file in the OFX format that QuickBooks reads without column mapping. Building one from a Chase PDF means turning checked rows into that format. The order of the steps matters, because each one depends on the one before it.

1. **Copy the rows.** One row per dated line, with date, description and the amount as printed.
2. **Join wrapped descriptions.** A line with text but no date or amount belongs to the row above.
3. **Set one date format.** Write each date in full, with the year taken from the statement period.
4. **Merge the money columns.** Money out becomes negative and money in stays positive.
5. **Run the summary check** from the section above until every figure agrees.
6. **Write the QBO file.** Use a converter, or build it by hand from a CSV; the [manual spreadsheet route to a QBO file](/blog/convert-pdf-to-qbo-manually) shows the second option.
7. **Keep one file per statement.** One month, one file, named with the account and the period, so you can tell later which ones you have imported.

Converting other banks follows the same steps with different layouts. A [Wells Fargo statement to QBO](/blog/convert-wells-fargo-bank-statement-to-qbo) has its own column and check-row quirks, and a [Capital One bank or card statement to QBO](/blog/convert-capital-one-statement-to-qbo) needs care with which summary boxes to skip.

SimpleBankConvert is being built for steps 2 to 4: you give it the Chase PDF, and it is meant to hand back a QBO or CSV file with the dates in one format and money out shown as a minus. It is in early access, and the [get started page](/get-started) is where to leave your email for when accounts open.

## Importing a Chase QBO file into QuickBooks Online or Desktop

A Chase QBO file goes into QuickBooks Online through the bank upload, and into QuickBooks Desktop through Web Connect. In both, you are asked which account the transactions belong to. Choose the existing account you use for that Chase account, not a new one, so the converted months join the rest of its history.

In QuickBooks Online, the upload sits under the bank transactions area. [Intuit's guide to uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) lists QBO among the accepted files and suggests it as the format to use. After the upload, the lines wait for review rather than posting straight to the register.

In QuickBooks Desktop, a Web Connect file opens into the bank feed for the account you link it to. The Desktop article above says you cannot download the same transactions into the same company file more than once. That protects you from importing one Chase month twice, but it also means a mistake in the file is not fixed by importing it again. Correct the file first, then import.

### After the import

Compare the QuickBooks balance for the account on the statement's closing date with the closing balance on the PDF. If they agree, move on to the next month. If they don't, the gap usually points to a month imported twice, a month missing, or lines that arrived from the feed as well as the file.

## Do converted Chase months overlap your bank feed?

Converted Chase months overlap the bank feed whenever the feed's start date falls inside a month you converted. When that happens, the same transactions arrive twice, once from the file and once from Chase. Cut each file at the day before the feed begins, or exclude the duplicates during review.

The cleanest plan is a hard cut-off. Suppose the feed started on April 9. Convert January to March in full, and convert April only from April 1 to April 8. The feed covers the rest. When you run the balance check on that partial April, use the printed balance on April 8 as the closing figure rather than the end of the statement.

If the feed is new, give it a day or two to settle before you decide where its history starts. Banks don't all send new activity at the same speed, and [how often QuickBooks Online updates bank transactions](/blog/how-often-does-quickbooks-online-update-bank-transactions) explains why some lines show up later than others. Waiting until the feed's first date stops moving saves you from cutting the file in the wrong place.

### Duplicates that already got in

If both sources have already brought in the same lines, don't delete them from the register by guesswork. Work through the review screen, match or exclude the second copy of each line, and then re-run the balance comparison against the PDF. The statement stays the authority on what the account really held.