Convert Bank of America statements to Excel or CSV
Bank of America's activity download only reaches recent months, so older periods mean working from the PDF statements under Statements & Documents. Those statements split activity into sections such as deposits, withdrawals, checks and service fees, with withdrawals printed as negative numbers. BankConv converts the PDF into Excel, CSV or Google Sheets; sort by date afterwards for a single timeline.
Updated
Download your Bank of America statement
- 1.Log in to Bank of America Online Banking (bankofamerica.com) or the mobile app.
- 2.Select the account, then open Statements & Documents.
- 3.Pick the statement month and download the PDF.
- 4.Repeat for each month.
Do you need to convert at all?
Bank of America Online Banking has a download option on the account activity page, with a spreadsheet (CSV) format and formats for Quicken and QuickBooks.
Recent activity only. Older periods are available as PDF statements under Statements & Documents.
Bank of America export formats: CSV, QFX, QBO
What to know about Bank of America PDFs
- Transactions are grouped by type
- Statements usually list Deposits and other additions, Withdrawals and other subtractions, Checks and Service fees in separate sections. Rows come out in that order, so sort by date for a single timeline.
- Withdrawals print as negative numbers
- Amounts in the withdrawal and fee sections usually carry a minus sign. Keep the sign, and you can sum the whole amount column to get the net change for the month.
- Daily ledger balances in a separate table
- There's no running balance on each line. The statement usually ends with a Daily ledger balances table instead, which you can use to spot-check a given day.
Converting Bank of America statements
The downloaded statement is usually a text-based PDF, so the transaction rows come through. Because it’s split into sections, expect to sort by date afterwards.
- Download the monthly PDFs from Statements & Documents.
- Upload them to BankConv.
- Check the rows, then export Excel, CSV or Google Sheets.
Checking the totals
The account summary on page one gives the beginning balance, the totals per section and the ending balance. Use it to check the conversion.
- Sum the positive amounts and compare with Deposits and other additions.
- Sum the negative amounts and compare with withdrawals, checks and fees together.
- Beginning balance plus the net total should equal the ending balance.
If your software needs a running balance, add one in Excel after sorting: the beginning balance plus a running sum of the amount column.
Using Chase or Wells Fargo too? Their statements are set out differently, but the same checks work. For QuickBooks, see QuickBooks import.
Sources: Bank of America: Small Business Online Banking statements and transaction reporting FAQ
Columns you get
| Date | Description | Amount |
|---|---|---|
| 09/02/26 | ACME CORP DES:PAYROLL ID:XXXXX52 INDN:JANE DOE CO ID:XXXXX61 PPD | 2,140.00 |
| 09/04/26 | CHECKCARD 0903 SHELL OIL 57444 HOUSTON TX | -42.18 |
| 09/08/26 | VERIZON WIRELESS DES:PAYMENTS ID:XXXXX88 INDN:JANE DOE CO ID:XXXXX07 WEB | -85.00 |
| 09/15/26 | Zelle payment to JOHN SMITH Conf# a1b2c3d4e | -60.00 |
Sample rows in Bank of America's layout, fictional data. First 5 pages free to check.
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.
Bank of America statement questions
How far back can I download Bank of America transactions?
The activity download covers recent transactions only. For older months, download the PDF statements from Statements & Documents and convert them.
Why are my Bank of America transactions out of date order?
The statement groups transactions by type, deposits first, then withdrawals, checks and fees. Sort the converted file by the date column to get one timeline.
Does this work for Business Advantage statements?
Yes. Business statements use the same section layout, often with more pages. BankConv converts them the same way.
Other United States banks
- Chase
- Wells Fargo
- Citi
- Capital One
- U.S. Bank
- PNC Bank
- Truist
- TD Bank