Chase Download Statement CSV, How to Export Activity and Older Months

The exact labels in online banking change from time to time, so treat the wording below as a guide and look for the closest match on your screen. The flow is the same on checking, savings and most credit card accounts.

• Step 1. Sign in to Chase online banking on a desktop browser. The download option is easier to find there than in the mobile app.
• Step 2. Open the account you need from the accounts overview, so the account activity list is on screen.
• Step 3. Find the download icon near the top of the activity list. It usually looks like a downward arrow and is labelled as a download of account activity.
• Step 4. In the download window, set the file type to the spreadsheet option, which produces a CSV file. The same menu often lists formats for Quicken and QuickBooks as well.
• Step 5. Choose the activity range. You can usually pick the current display, all available transactions, or a custom date range with a start and end date.
• Step 6. Set the date range to match a statement period exactly, for example the statement start date through the statement end date, rather than calendar months.
• Step 7. Click download and save the file with a clear name, such as the client, the last four digits of the account and the period.

Matching the date range to the statement period matters later. If your CSV covers September 1 to September 30 but the statement runs from September 6 to October 5, the totals will never line up, and you will spend time chasing a difference that is only a cutoff problem.

A typical checking account export includes columns for details, posting date, description, amount, type, balance and check or slip number. Credit card exports usually show transaction date, post date, description, category, type and amount. Column names and order can differ between account types, so check the header row before you map the file into another tool.

Amounts in a Chase CSV are signed. Debits appear as negative numbers and credits as positive ones on checking exports, while card exports show purchases as negatives and payments as positives. Keep that in mind when you import into an accounting app that expects a separate debit and credit column.

Pending transactions are generally left out of downloads, which is what you want for bookkeeping. Only posted items belong in the ledger.

Online banking does not keep downloadable activity forever. The download window for account activity is typically limited to roughly the last couple of years, and on some accounts it can be shorter. The exact limit depends on the account type and can change, so check the date picker in your own account before you plan a catch-up project around it.

A quick test saves time. Open the custom date range, enter a start date far in the past, and see what the bank accepts or how far back the file actually begins. The earliest row in the file tells you where the window ends.

Monthly PDF statements usually stay available for much longer than downloadable activity. Chase keeps them under the statements and documents area of online banking, typically for several years. That is where you go for anything older than the download window.

When a client hands you a prior year catch-up, the months you need are often outside the activity window. You can still get every row, it just starts from the PDF.

• Step 1. Open the statements and documents section in Chase online banking and pick the account.
• Step 2. Download each monthly statement you need as a PDF. Save them in one folder per account so the order is obvious.
• Step 3. Check that you have every period with no gaps. Statement periods run end to end, so the closing date of one should sit right before the opening date of the next.
• Step 4. Convert the PDFs into rows. Our guide to pdf bank statement to excel covers the spreadsheet route, and bank statement to csv covers the plain CSV route for imports.
• Step 5. Combine the converted months with any recent CSV exports, using the statement periods as the boundary so nothing is counted twice.

Retyping statements by hand is where most errors come from. A missed line or a transposed digit does not show up until reconciliation, and by then you are searching through hundreds of rows. A converter that reads the whole statement and checks the result against the printed balances removes that risk.

If the client only has paper statements or phone photos of old months, the same approach works. Scanned pages and photos can be converted too, as long as the image is readable.

Whatever route a month took, the final test is the same. The rows have to explain the movement between the opening and closing balance on the statement.

• Step 1. Write down the opening balance and the closing balance printed on the statement for that period.
• Step 2. Add up all credits and all debits in your converted or downloaded rows for exactly the same dates.
• Step 3. Calculate opening balance plus credits minus debits, treating signs consistently.
• Step 4. Compare the result with the closing balance. They should match to the cent.
• Step 5. If they do not match, compare the row count with the statement, then look for duplicates where a recent CSV and a converted PDF overlap.

Many Chase statements also print a summary block with total deposits and total withdrawals for the period. Comparing your sums with those two figures narrows a problem down to one side before you look at individual rows.

StatementsConverter runs this balance check on every statement automatically. Each converted statement shows whether the extracted rows reconcile to the printed opening and closing balances, and flags the ones that do not, so you only review the statements that need attention.

CSV is the most flexible choice for spreadsheets and for apps with a column mapping step. If the books live in QuickBooks Online or QuickBooks Desktop, a QBO Web Connect file usually imports with fewer steps because dates, amounts and payees are already in fields the app understands. For Quicken and older personal finance tools, QIF or OFX may be the better fit.

StatementsConverter exports XLSX and CSV on every plan, and adds QBO, QIF, OFX and Xero CSV on Professional and above. That means the same converted Chase statement can feed a working spreadsheet and an import file without being processed twice.