How to Download & Convert a Bank of America Statement to Excel

Whether you are reconciling expenses, preparing for taxes, or applying for a loan, you usually start with the statement itself. This guide walks through downloading a Bank of America statement as a PDF from Online Banking on a computer or from the mobile app, then turning that PDF into a spreadsheet you can actually work with.

Menu labels and layouts can vary by account type and app version, so treat the steps below as the general flow rather than exact wording you will see on every screen.

Download from Online Banking (desktop)

Bank of America keeps electronic copies of statements available to sign-in for several years on most accounts. To pull one as a PDF:

1. Sign in to Online Banking from your computer.
2. Open the account you want a statement for (checking, savings, or credit card).
3. Look for the section that holds your documents — often labeled Statements & Documents or Statements, sometimes found under a "More" or account-details menu.
4. Select the account again if prompted, then choose the statement period you need. Statements are typically organized by monthly billing cycle.
5. Open or download the PDF to your computer.

If you do not see older periods, look for an option to view archived or paperless statements. Some accounts require paperless enrollment before electronic statements appear, and the range of history available can differ between checking, savings, and credit card accounts.

When the PDF opens, save it somewhere you can find it later — a downloads or documents folder works fine. If you need to combine several months, downloading them all into one folder first makes the next step easier.

Download from the mobile app

The mobile app follows the same idea with a touch-friendly layout:

1. Open the app and sign in.
2. Tap the account you want a statement for.
3. Find the Statements & Documents or Statements option (it may sit under a menu or the account details view).
4. Pick the statement period you need.
5. Use the view, share, or download icon to save the PDF to your phone, then move it to your computer or cloud storage if you plan to convert it.

Choosing the right account and period

A few things worth checking before you download:

• Pick the correct account. If you have several Bank of America accounts, statements are listed per account, so confirm you are looking at the right one.
• Match the period to your purpose. A monthly cycle covers one billing period. For taxes or a loan application, you may be asked for several consecutive months — download each period separately.
• Mind the closing date. Statement periods follow your billing cycle, not the calendar month, so the date range may start and end mid-month.
• Keep the original PDF. Even after you convert it, hold on to the source document. You may need the official PDF for a lender, accountant, or the IRS at tax time.

Why a PDF is not enough

A PDF is convenient for reading and for sharing as proof, but it is a poor format for analysis. You cannot sort transactions, sum a category, or filter by date inside a PDF. To do any real work with the numbers, you need the data in rows and columns.

Manually retyping every line into a spreadsheet is slow and error-prone, especially across multiple months. A typo in a single amount can throw off a reconciliation or a tax total, and the work has to be repeated every billing cycle. A better approach is to extract the transactions directly from the PDF so the numbers carry over exactly as they appear on the statement.

Convert the statement to Excel or CSV

Once you have the PDF, you can turn it into a clean spreadsheet:

• For a step-by-step walkthrough of the options, read how to convert a bank statement to Excel.
• To do it right away, drop the file into the free bank statement converter and export the transactions to Excel or CSV.

The converter reads the statement and outputs each transaction as a row, with the date, description, and amount in separate columns. From there you can sort, total, categorize, or import the data into your accounting tool.

Putting it together

The workflow is simple once you know the path:

1. Sign in to Online Banking or the mobile app.
2. Open the right account and find the statements section.
3. Choose the period and download the PDF.
4. Convert the PDF to Excel or CSV for analysis.

With the statement in a spreadsheet, the tedious part is done and you can focus on what the numbers actually tell you. If you handle statements every month, saving the PDFs in a dated folder and converting them as they arrive keeps your records ready whenever you need them.