How to Convert a Bank of America Statement to CSV

Bank of America actually does offer a built-in CSV export - but it only covers recent activity. For anything older, the official statement comes as a PDF, and you need a conversion step to get it into a spreadsheet. This guide covers both paths: the native BofA export for recent data and the local PDF method for everything else.

Knowing both options saves you time. Use the built-in export for current-year budgeting or a quick look at recent spending. Switch to the PDF path for tax season, multi-year analysis, or any time you need a period outside the export window. Here's exactly how each one works.

Option 1: BofA's built-in transaction export (recent activity)

For transactions in the recent window, Bank of America's Online Banking lets you download data directly. This is the fastest path when it covers the date range you need.

How to use the built-in export on bankofamerica.com

• Sign in at bankofamerica.com and open the account (checking, savings, or a credit card).
• On the account activity screen, look for the Download button - it's usually near the top right of the transaction list, sometimes labeled with an arrow or a document icon.
• A dialog appears. Choose the file format: Microsoft Excel (XLSX) or CSV. For most spreadsheet and accounting uses, either works; CSV is more universal.
• Choose the date range. BofA typically allows anywhere from 30 days to 18 months of recent activity depending on account type.
• Click Download. The file saves to your computer and opens directly in Excel, Google Sheets, or any spreadsheet app.

A useful detail: the downloaded file includes a column for transaction type (debit, credit, check) alongside the date, description, and amount. This makes it easier to filter deposits from withdrawals without manual tagging.

BofA Mobile app export

The mobile app has a similar option. Open the account, tap the download/export icon in the transaction view, and choose your format. The mobile export covers the same recent window as the desktop site.

The built-in export's main limitation

The date range cap is the critical constraint. For the prior tax year, or for a longer analysis window than BofA's system allows, the activity download stops working. The moment you need older data, you're looking at PDF statements - and that's where Option 2 comes in.

Option 2: Convert BofA PDF statements (older periods)

Bank of America's official monthly statements - the ones under Statements and Documents - are PDF-only and go back several years. For tax prep, loan applications, or any analysis that needs historical data, this is the correct source.

Step 1: Download the PDF statement

• Sign in at bankofamerica.com and open the account.
• Choose Statements and Documents from the account menu (on credit cards this is sometimes under Account Services).
• Find the statement period you need, click the PDF icon, and save the file to your computer.
• Repeat for each month or quarter you need to cover.

Step 2: Convert the PDF to CSV locally

Do not use an online converter for a Bank of America statement. These tools upload your PDF - which contains your account number, balance history, and every transaction - to a third-party server. For a bank statement, that's an unnecessary exposure.

A local desktop converter does the same job without the upload. The PDF is parsed on your own machine, every transaction is extracted into rows of date, description, and amount, and the result is a CSV you control.

Quill handles both BofA checking statements and credit card statements. Drop in a PDF and it reads the layout locally, extracts each transaction, auto-categorizes it (Groceries, Software, Travel, etc.), and exports to CSV or QuickBooks. Your data never leaves your computer.

Handling multiple BofA accounts

Many BofA customers have multiple accounts: a checking account, a savings account, a BofA credit card, and sometimes a Merrill Edge or Merrill Lynch investment account. The export steps above apply per account, and each account produces its own CSV file.

If you want a consolidated view across accounts - useful for net worth tracking or understanding total cash flow - the practical approach is:

1. Export or convert each account to its own CSV.
2. Add an "Account" column to each file to label which account the rows came from.
3. Stack all CSVs into one sheet in Excel or Google Sheets.
4. Use a pivot table to break down spending by account, category, or month across all of them at once.

If you're using Quill, you can drop in PDFs from multiple BofA accounts and export a single merged CSV with an account label already attached to each row.

BofA Business accounts

Business Complete Banking and Business Advantage accounts follow the same download path at bankofamerica.com. The PDF statements are available under Statements and Documents in your business login. One difference: business statements separate categories of transactions more explicitly (credits, debits, service charges), and the format is slightly different from personal checking. A good PDF converter handles both - you don't need a separate tool for business vs. personal BofA statements.

For self-employed customers using a BofA account for mixed spending, converting to CSV first and then splitting into Personal vs. Business categories is the cleanest path to tax-ready records. Quill's Personal and Business split handles this automatically.