How to Convert a Bank of America Statement PDF to CSV

To convert a Bank of America statement PDF to CSV, download the statement from bankofamerica.com, then run that PDF through a converter that reads it into rows of date, description, and amount. Here's the exact path - including where Bank of America hides the download button - and how to do it without uploading your account data to a stranger's server.

Bank of America makes it easy to view a statement and surprisingly fiddly to get a clean spreadsheet out of it. The online CSV export only covers a short, recent window of activity; anything older than that - last quarter, last tax year - is locked inside a PDF. If you need those transactions in a spreadsheet for taxes, bookkeeping, or a loan application, you have to convert the PDF yourself. Below is the reliable way to do it.

Why Bank of America's built-in export isn't enough

Inside Online Banking, Bank of America does offer a download for recent activity - you can pick a format including a spreadsheet/.csv option. But it has two real limits:

• The date range is short. The CSV-style download only reaches back over recent activity, not the full history. Your January statement is often already out of range by spring.
• Official statements are PDF-only. The documents you actually need for taxes and audits - the formatted monthly statements under Statements & Documents - download as PDFs, with no CSV equivalent.

So for any real bookkeeping job, you end up with a stack of PDFs and the question this article answers: how do you turn them into CSV?

Step 1: Download the statement PDF from Bank of America

Start by getting the official PDF in hand:

1. Go to bankofamerica.com and sign in to Online Banking.
2. Select the account you want - checking, savings, or a credit card.
3. Open the Statements & Documents tab (on a credit card it may read Statements & Documents under the account menu).
4. Find the statement period you need and click Download / PDF. Bank of America serves it as a standard PDF.
5. Save each month you need. For a tax year, that's typically twelve PDFs per account.

That's the whole download side. You don't need the limited CSV export at all - the PDF carries every transaction, and that's all a good converter needs.

Step 2: Convert the PDF to CSV

Now turn the PDF into structured rows. A converter reads the statement's transaction table and pulls out three things per line: the date, the description, and the amount. Bank of America statements lay transactions out in a consistent table, which is exactly what a parser is built to read.

This is what Quill was built for: drop in a Bank of America statement PDF and it parses every transaction on your own computer, then lets you export the result as a clean CSV.

Unlike a copy-paste-into-Excel approach, parsing keeps amounts aligned to the right rows and handles multi-line descriptions without scrambling your columns. You get a spreadsheet that opens cleanly in Excel, Google Sheets, or Numbers.

Step 3: Categorize before you export (optional, but worth it)

A raw CSV of dates and amounts is fine for an accountant, but you can do better in the same pass. Quill auto-categorizes each transaction - recognizing that "AMZN Mktp" is shopping or that a recurring "Adobe" charge is software - and splits everything into Personal and Business. You review the list, override anything that landed in the wrong bucket, and keep final say on every line. The export then carries those categories with it.

Step 4: Export to CSV or QuickBooks

Once the transactions look right, export. Quill writes a standard CSV you can open anywhere, or a QuickBooks-compatible .QBO file if you'd rather import straight into your books. Either way, you've gone from a locked PDF to clean, usable data in a few minutes.

Doing more than one statement

If you're converting a whole tax year, download all the monthly PDFs first, then run them through together so categories stay consistent across the year. The same method works for any Bank of America account - personal checking, business checking, or a credit card statement. For a bank-agnostic walkthrough that applies to any institution, see our guide on how to convert a bank statement PDF to CSV.