How to Export Bank of America Transactions and Download Your Transaction History as a CSV

Bank of America lets you export your transaction history as a CSV file from bankofamerica.com. One quirk catches people out: the exported file begins with five or six summary lines (beginning balance, total credits, total debits) before the real column headers appear. That is normal, and good budgeting tools skip those rows automatically.

How to export Bank of America transactions as a CSV

1. Sign in at bankofamerica.comUse a desktop browser. As with most banks, CSV export is not available in the mobile app.
2. Open the account you want to exportClick the account name from your accounts overview to open its transaction history.
3. Click the download icon near the transaction listLook for a small download arrow or a link labelled "Download" positioned above your transactions, often to the right of the search box.
4. Choose "Comma Separated Values (.csv)"Bank of America also offers Quicken, QuickBooks, and Excel formats. Pick the CSV option, because the others use different structures that most budgeting tools cannot read.
5. Set your date range and downloadChoose a custom range or a preset period, then click Download. The file lands in your Downloads folder, typically named something like stmt.csv.

What is inside a Bank of America CSV file

A Bank of America export contains these columns:

Above those headers you will see rows such as "Beginning balance as of…", "Total credits", and "Total debits". These summary lines are part of every Bank of America export. Fynnap detects the real header row automatically and ignores the summary block.

The summary rows at the top of a Bank of America CSV

This is the single most common reason a Bank of America export fails to import somewhere else, so it is worth seeing exactly what the file looks like. Open one in a text editor and the first several lines are not transactions at all:

The real column headers appear on line seven, after a blank line. Software that assumes headers are always on line one reads "Description,,Summary Amt." as the column names, finds no Amount column, and either errors out or imports four meaningless rows.

You have two ways to deal with it. You can open the file in a spreadsheet, delete the top block including the blank line, and save it again. Or you can use a tool that scans for the real header row rather than assuming it is first. Fynnap does the second, so a Bank of America export imports unmodified, summary block and all.

One thing not to do: delete the header row along with the summary. Without Date,Description,Amount,Running Bal. the file becomes harder to identify, not easier.

Bank of America CSV column format explained

Checking and savings exports use four columns. Here is what each one actually contains:

Credit card exports are different. Bank of America credit cards produce five columns:

There is no running balance, the merchant sits in Payee rather than Description, and Address carries the city and state, which is frequently blank for online purchases. Amounts follow the same convention: purchases negative, payments and refunds positive.

If you are budgeting across a Bank of America checking account and a Bank of America card together, watch for the card payment. It shows up as a negative amount on the checking export and a positive amount on the card export. That is one movement of money between two accounts you own, not spending, and counting it as spending is the most common reason monthly totals come out far too high.

Opening a Bank of America CSV in Excel or Google Sheets

Double-clicking the file opens it in Excel, but Excel makes assumptions about the contents that are frequently wrong. With a Bank of America export specifically, three things tend to go wrong: dates get reformatted into a different convention, the quoted thousands in the Amount and Running Bal. columns are sometimes read as text rather than numbers, and the summary block at the top pushes everything out of alignment.

In Excel: open a blank workbook first, go to the Data tab, choose From Text/CSV, and select your file. In the preview window, set the Date column to a date type and the Amount column to Decimal Number, then click Load. Delete the summary rows once the data is in.

In Google Sheets: open a blank sheet, choose File then Import, upload the file, set the separator to comma, and decide whether to leave "Convert text to numbers, dates, and formulas" on. Leaving it on gives you numbers you can sum; turning it off preserves the values exactly as Bank of America wrote them.

If your goal is budgeting rather than spreadsheet work, none of this is necessary. Tools that read the CSV directly parse the original file, so nothing is reformatted along the way and the summary block is simply skipped.

The mobile app, and printing your transaction history

Two things people commonly try that do not lead where they expect.

The Bank of America mobile app has no CSV export. It will show you statements and let you save them as PDFs, which looks like the same thing but is not: a PDF is a picture of a document, and getting numbers back out of it requires text extraction that gets decimal points wrong. There is no setting to enable CSV export in the app. If you only have a phone, open bankofamerica.com in your phone browser and use the browser menu to request the desktop site. The download option reappears, and the file saves to your phone's Downloads folder where you can upload it from.

Printing your transaction history works, but gives you paper, not data. Open the account activity page, filter to the date range you want, then press Ctrl+P (Cmd+P on a Mac). Use your browser's print preview to check that the transaction table is not being cut off on the right, and consider landscape orientation. This is the right approach if you need a physical copy for a landlord, a loan application, or your own records.

If what you actually want is to analyse your spending, export the CSV instead. Printing and then retyping is the long way round to the same place.

When the Bank of America download option is missing

If you cannot find the download link, work through these in order. One of them is nearly always the cause.

You are on the mobile app or mobile site. By far the most frequent reason. Use a desktop browser, or request the desktop version of the site from your phone.

You are viewing Statements & Documents rather than account activity. The statements area only offers PDFs. The download link lives above the live transaction list on the account page.

Your date range returned no transactions. If the filter is empty there is nothing to export, and the option is either hidden or produces a file containing only the summary block.

The account was opened recently. With very few transactions the export option is sometimes omitted. Widening the range usually brings it back.

An extension is interfering. Ad blockers and privacy extensions occasionally hide banking interface elements. Try an incognito window with extensions turned off.

You downloaded a .qbo or .qfx by mistake. Those are Quicken and QuickBooks formats and most budgeting tools cannot read them. Return to the download screen and explicitly pick "Comma Separated Values (.csv)".

How much Bank of America history you can export

Bank of America generally keeps around 18 months of transaction history available online for checking and savings accounts. Credit cards are broadly similar, though it varies by product. There is no published guarantee, so the practical approach is to request a wide custom range and see what comes back rather than assuming a limit.

Beyond that window you are into archived statements, which are ordered through the site and arrive as PDFs. They are fine for proof of payment and useless for budgeting, because the data has to be extracted by hand.

A habit worth adopting: export once a month, just after your statement closes, and keep the files somewhere durable. It takes under a minute and means you are never limited by how far back your bank happens to let you reach. People who start budgeting seriously in year two often wish they had a year of history, and by then it is gone.

How far back can you export?

Bank of America generally provides up to 18 months of transaction history online. Anything older usually requires ordering paper or archived statements through the site.

Common questions about Bank of America CSV exports

Guides for other banks

Fynnap is an independent budgeting tool and is not affiliated with, endorsed by, or connected to Bank of America. Bank websites change; if a menu has moved, look for any option labelled “Download”, “Export”, or “Account activity”.