Vartu Download

How to export your US bank transactions as CSV

Where the big banks put their download option, what to look for, and what to do with the file.

Most large US banks let you download transactions from the website, and a CSV file is the simplest way to move them into a budgeting app. This guide shows how to export bank transactions as CSV from Chase, Bank of America, Wells Fargo, Capital One and Citi, links to the bank's own help where we found it, and ends with importing the file into Vartu on your iPhone.

A caution before the steps. Banks rename menus and move buttons often, and we have not tested every bank's file with Vartu. So the directions below say what to look for, not exact click paths. When in doubt, the bank's own help page wins.

Quick overview

BankWhere to lookTypical formatsHelp
ChaseOpen the account on the website, look for a download or "Download account activity" optionUsually CSV, plus other formatsSearch Chase's help for "download account activity"
Bank of AmericaOpen the account, look for Download or Export on the activity listSeveral formats are usually offered; pick CSV or a spreadsheet-friendly oneOnline financial management FAQs
Wells FargoAccount Activity page, then look for a Download optionSeveral, including CSVAccount Activity and statement FAQs
Capital OneOpen the account or card, look for a download or export option in the transaction listOften CSVSearch Capital One's help for "download transactions"
CitiAccount activity, look for Download or ExportVaries by accountSearch Citi's help for "download transactions"

The table describes where to look, based on what banks have offered; it is not a guarantee, and your account type (checking, savings, credit card, business) can change the options. Where the help-page column has no link, we could not confirm a stable official page, so use the search box on the bank's own help site.

General steps that work almost everywhere

  1. Use a computer if you can. Web banking usually offers more download options than the mobile app.
  2. Open the account, then its transaction or activity list.
  3. Look for words like Download, Export, Download account activity or a small download arrow.
  4. Choose a date range. Banks often limit how many months, or rows, one file can hold, so you may need several files.
  5. Choose CSV, or the closest spreadsheet-friendly format (some banks offer "Excel" or "Comma separated"). Avoid formats meant for accounting software (such as QFX, QBO or OFX) unless CSV is not offered; Vartu reads CSV and PDF statements.
  6. Download. Keep the file somewhere easy, such as iCloud Drive.

Chase

On Chase's website, open the account and look for a download option near the activity list. Chase has described downloading account activity as a choice of date range and file type. We did not find a single stable official help page to link, so search "download account activity" on chase.com's help. Credit cards and checking accounts may be in different places.

Bank of America

Open the account and look for Download, then choose your date range and file type. Bank of America's online financial management FAQs describe what can be downloaded. If you see a choice between spreadsheet and software formats, take the spreadsheet or CSV one.

Wells Fargo

Wells Fargo describes viewing and downloading transaction detail on its Account Activity page, and its statement FAQs cover statements. The download option sits on the activity view; choose the date range and a file format that opens as a spreadsheet.

Capital One and Citi

Both offer a download or export option from the transaction list on the website, for at least some account types. We did not find official help pages that we could link with confidence, so use each bank's help search. Credit card exports and bank-account exports are not always laid out the same way.

Check the file before importing

Import into Vartu

  1. Move the file to your iPhone, then open it from Files or Mail and choose Vartu when asked "Import this file?". Or use Settings → Import statements. This is a Pro feature.
  2. Choose the date, amount and description columns. Vartu remembers them for that bank, so next month's file needs no setup.
  3. Check every row on the review screen, then save.
  4. If your files overlap (for example, you re-download the same week), Vartu does not add duplicate rows twice.
  5. Create rules so merchants are categorized automatically from now on.

PDF statements work as well; every row is shown for checking before you save. The full walk-through is in our import guide. Vartu has ready-made support only for a few sources (Interactive Brokers, Trading 212 and some UK apps and banks); for US banks you pick the columns yourself, which takes a minute the first time.

Is there a no-file route?

In the US, Apple's FinanceKit only covers Apple Card, Apple Cash and Apple Savings, so ordinary bank accounts still need a file. If you want to avoid connections altogether, importing a file monthly is the usual rhythm. For the philosophy behind that, read budgeting without a bank connection, and if you have an old Mint file, see how to import it.

Common problems

Bank websites change, so if a step here no longer matches what you see, the bank's help page is the authority. Nothing here is financial advice.

When you have a file ready, try Vartu from the App Store. One spending account and one broker account are free, and your data stays on your iPhone.

Download

On a computer?
Scan with your iPhone camera to open Vartu in the App Store.

More guides

Vartu is not financial advice. Forecasts and estimates are arithmetic on your own figures.