SheetStatement
Bank guides

Chime Bank Statement to Excel or CSV: How to Convert

Turn Chime checking and savings statement PDFs into a clean Excel or CSV file, check the balances, and use it for budgeting, taxes or applications.

SheetStatement Team11 min read

On this page

TL;DR Chime provides monthly statements as PDFs in the app and on the website. If you need the transactions in Excel, download each month's PDF, convert it to one row per transaction, and check that the starting balance plus every transaction equals the ending balance. Keep checking and savings in separate sheets, tag transfers between them, and save a CSV copy for accounting software. Keep the original PDFs too; landlords, lenders and visa offices usually want the statements themselves.

Chime is a financial technology company rather than a bank; the accounts are provided through partner banks, and the statement will say which one. For most people that distinction doesn't matter day to day. It does matter a little when you're collecting documents, because the partner bank's name and details appear on the statement, and some application forms ask for them.

The more practical issue is that Chime is designed around the app. There's a running transaction list on your phone, which is great for checking what happened yesterday, and monthly statements for the official record. Getting a year of transactions into a spreadsheet takes a bit of planning. This guide explains how to do it cleanly. Chime updates its app and website regularly, so the steps are described in general terms.

Why people need Chime data in Excel

The most common reasons we see:

  • Budgeting. You want a year of spending grouped by category, which the app's summaries don't quite give you.
  • Self-employment income. Gig workers and freelancers often get paid into Chime and need a list of deposits for their taxes or for proof of income.
  • Rental and loan applications. A landlord or lender asks for statements, and you want to make sure they show what you think they show before you send them.
  • Bookkeeping. A small side business runs through a Chime account and needs to get into QuickBooks, Wave or a spreadsheet ledger.
  • Disputes and record-keeping. You need to pull together every payment to or from one person or company.

All of these need complete data, and most need the balances as well as the transactions. That points to the monthly statements.

Getting your Chime statements

In general:

  1. Sign in to the Chime app or the website.
  2. Look for the documents or statements section, usually under your account settings or the account itself.
  3. Choose the account (checking or savings) and the month.
  4. Download or share the PDF.

Repeat for every month you need. If you have both checking and savings, download both; they're separate statements with separate balances.

Name the files in a way that sorts naturally: chime-checking-2026-01.pdf, chime-savings-2026-01.pdf, and so on. Put each account in its own folder if you'll be handling a full year.

If you need statements from further back than the app shows, contact Chime support and ask. Our general guide on how to get old bank statements covers what to ask for and what to keep in mind for closed accounts.

Is there a CSV download?

Some banking apps let you export transaction history as CSV; others don't, or only offer a limited range. Check the current Chime app and help pages for what's available to you. Even when an export exists, the monthly PDF is still worth having, because it shows the starting and ending balances that let you prove the data is complete.

What a Chime statement looks like

Statements from app-based accounts tend to be fairly clean. Expect:

  • A summary with the statement period, the beginning balance, the total of deposits and other credits, the total of withdrawals and other debits, and the ending balance.
  • A transaction list with dates, descriptions and amounts. Some statements also show a running balance after each transaction, or have separate sections for different transaction types.
  • Account and partner bank details, and standard disclosures.

The descriptions are where most of the useful detail lives: direct deposit employer names, card merchants, transfers to and from your savings account, peer-to-peer payments, ATM withdrawals and so on. They're also where most of the mess lives, because they include reference codes and abbreviations.

Converting a Chime statement to Excel

Copying and pasting

For a single short statement, you can copy the transaction list from a PDF viewer and paste it into Excel. Expect to spend some time fixing it: columns may land in one cell, long descriptions may break onto two rows, and amounts may come through as text with dollar signs. Excel's Text to Columns, TRIM and VALUE will get you there. It's fine for one month. For twelve, it becomes a chore and an easy place to make mistakes.

Excel's PDF import

Desktop Excel can pull tables out of a PDF with Get Data, From File, From PDF. It works well when the statement uses true tables, less well when transactions are laid out as text. Check the result carefully, especially at page breaks. Our Power Query guide explains how to clean up what it loads.

A bank statement converter

SheetStatement's bank statement to Excel converter is built for this. Upload the PDFs, and it extracts each transaction into one row with a real date, a description and a signed amount, then checks the total against the statement's balances so you know nothing was missed. You can download Excel, CSV, or files shaped for QuickBooks and Xero. The free plan covers 3 pages a month; paid plans are $9, $19 and $39 a month if you need more.

Whatever method you use, the goal is the same layout:

Date Description Amount Account
2026-02-03 DIRECT DEPOSIT EMPLOYER 1,184.50 Checking
2026-02-03 TRANSFER TO SAVINGS -100.00 Checking
2026-02-04 CARD PURCHASE GROCERY -56.27 Checking

One row per transaction, a signed amount, and a column that says which account it came from.

Checking the balances

Before you use the spreadsheet for anything, prove it's complete. For each month and each account:

Beginning balance + sum of amounts = ending balance

In Excel, with the beginning balance in H1, the ending balance in H2, and amounts in column C:

=ROUND(H1 + SUM(C2:C300) - H2, 2)

The result should be 0.

If the statement shows a running balance after each transaction, you can find the exact row where something went wrong. Calculate your own running balance alongside it and look for the first row where they differ. The difference is usually exactly one transaction amount, or twice an amount if a sign is flipped.

The balance checker runs the same test without formulas.

Cleaning up the data

With the numbers confirmed, make the spreadsheet useful.

Separate accounts. Keep checking and savings in separate tables, or one table with an Account column. Don't mix them without a label.

Tag transfers. Moves between your Chime checking and savings, and transfers to and from accounts you hold at other banks, aren't income or spending. Mark them Transfer first. If you skip this, a $100 move to savings shows up as $100 of spending and makes your budget look worse than it is.

Identify income. Direct deposits usually include the payer's name. Gig platforms and payroll providers each have recognizable descriptions. If you're using the spreadsheet for proof of income, a filter on deposits with a Source column is a good start.

Categorize spending. Add a category column. A small rules table with XLOOKUP and SEARCH handles most recurring merchants; our guide to Excel formulas for categorizing bank transactions has examples.

Clean descriptions. Keep the original description, and add a short Payee column for reports. That way you can always trace back to the statement wording.

Using Chime data for applications

If a landlord, lender or visa office asks for statements, they usually want the PDFs exactly as issued. The spreadsheet is for you: it lets you check what the reviewer will see before you send anything.

Things worth checking:

  • Every month requested is present, with no gap between one statement's ending balance and the next statement's beginning balance.
  • Regular income is visible. Make a filtered list of deposits by source and month. If payments arrive under different names (for example, a gig platform's payout processor rather than the platform itself), note that so you can explain it.
  • Large or unusual deposits are explained. Reviewers often ask about one-off deposits. Have a short note ready: a tax refund, a gift, a sale of an item, a transfer from your own savings.
  • Balances meet any threshold. If you need to show a minimum balance, calculate the daily balance from the running balance column and check the lowest point, not just the end of each month.

Our guides to bank statements for a rental application and self-employed proof of income from bank statements go into each of these in more detail. Requirements vary by landlord, lender and country, so always follow the instructions you've been given.

Getting Chime data into accounting software

If a side business runs through a Chime account, you can import the converted statements into accounting software as a bank account.

QuickBooks Online. Upload a CSV with date, description and amount (or credit and debit columns). Keep one header row and one date format. Our guide on importing bank statements into QuickBooks Online walks through the upload and the common mapping questions.

Wave. Upload a CSV to the matching bank account, then categorize and reconcile. See how to import bank statements into Wave.

Xero. Use Xero's statement import with a CSV in its template format.

Two rules apply everywhere: import one month at a time and reconcile it before the next, and if the account also has a live bank feed, only import dates before the feed's first transaction so you don't create duplicates.

A worked example

A delivery driver gets paid by two gig platforms into Chime checking and keeps a small emergency fund in Chime savings. At tax time, his preparer asks for a list of all platform payouts for the year and his main work-related expenses.

  1. Download. He downloads twelve checking statements and twelve savings statements from the app.
  2. Convert. He converts all twenty-four into one workbook, with an Account column.
  3. Check. Each statement balances to zero except one checking month, which is off by $42.18. The running balance shows the first difference on the 19th, where a fuel purchase was split across a page break and read as two partial rows. Fixing the row brings the difference to zero.
  4. Tag transfers. Fifty-two transfers between checking and savings are tagged and excluded from income and spending.
  5. Find income. A filter on deposits shows payouts from both platforms. He adds a Source column and totals each platform by month.
  6. Expenses. He tags fuel, phone, car washes and a phone mount as work-related candidates, leaving personal spending untagged.
  7. Hand over. The preparer gets the workbook, a summary by platform and month, the expense list, and the original PDFs.

The preparer decides what's deductible and how income is reported. The spreadsheet's job was to make the data complete and easy to follow.

Troubleshooting

Dates came through as text. Use DATEVALUE, or Data, Text to Columns with the right date order, to convert them.

Amounts have dollar signs or are all positive. Remove symbols and thousands separators, then give withdrawals a minus sign. If the statement lists debits and credits in separate columns, combine them: =Credit - Debit.

The same transaction appears twice. Usually a description that wrapped onto two lines, or a page break. Compare with the PDF and delete the extra row.

Beginning balance doesn't match last month's ending balance. Check you have the right account and that no statement is missing in between.

Pending transactions are confusing the totals. If you mixed an app export with statements, the export may include pending items that later changed or dropped off. Use statements for anything official.

Peer-to-peer payments are hard to categorize. The description often only shows a name. Add a note column and fill in what each one was for while you still remember.

Building a simple budget summary

Once a few months are in one table, a pivot table turns them into a budget view in a couple of minutes.

  1. Click anywhere in the table and insert a pivot table on a new sheet.
  2. Put your Category in rows and the month in columns. If you don't have a month column yet, add one with =TEXT([@Date],"yyyy-mm") so months sort correctly.
  3. Put the signed Amount in values, summed.
  4. Filter out Transfer so moves between your own accounts don't inflate anything.

Read it across a row to see whether a category is creeping up, and down a column to see where a month went. Two patterns tend to stand out quickly: small recurring charges (subscriptions, app purchases, delivery fees) that are easy to ignore individually, and months where an irregular bill landed, such as car insurance or a yearly renewal. Knowing when those land lets you plan for them instead of being surprised.

If you get paid on an irregular schedule, add a second pivot with income sources in rows and months in columns. Seeing income and spending month by month side by side is often more useful than any single total, because it shows which months you need a cushion for.

Keep the pivot on its own sheet, and refresh it each month after you append the new statement. The underlying table stays the single source of truth.

A monthly routine

  1. When the statement is ready, download the PDF for each account.
  2. Convert it and confirm the balance check is zero.
  3. Tag transfers, then categorize.
  4. Append to your workbook, or import into your accounting software and reconcile.

It's a ten-minute job each month and saves hours at tax time.

Convert your Chime statements

Upload a Chime statement PDF to SheetStatement, check the extracted rows and the balance test, and download Excel or CSV. The free plan includes 3 pages a month, which is usually enough to test one or two statements.

FAQ

Can I download my Chime statement as Excel?

Statements are provided as PDFs. Convert the PDF to Excel or CSV, then check that the beginning balance plus all transactions equals the ending balance.

Where do I find Chime statements?

In the app or on the website, usually in the documents or statements area for your account. Download each month as a PDF. Contact Chime support for anything older than what's shown.

Are Chime checking and savings on the same statement?

They're separate accounts, so expect separate statements with their own balances. Download and convert each one, and tag transfers between them.

Can I use Chime statements for a rental or loan application?

Many people do. Send the PDFs as requested, and use a converted spreadsheet to check for gaps, unexplained deposits and minimum balances before you submit. Follow the specific requirements you've been given.

Can I import Chime transactions into QuickBooks?

Yes. Convert the statement, export a CSV in the layout QuickBooks expects, upload it to the matching bank account, and reconcile each month.

How do I know the conversion is complete?

If the beginning balance plus the sum of all transactions equals the ending balance, every transaction is accounted for.

Related articles

Convert your first statement free

3 pages a month on the free plan. No credit card.