How to convert a Bank of America statement to Excel

By Kayabyte · Last updated 28 October 2026

Bank of America statements arrive as PDFs, and you may need the transactions in Excel to reconcile an account, prepare a tax return, or send a clean record to an accountant. This page covers the options, starting with what costs nothing.

We are not affiliated with Bank of America, and the labels on their site change from time to time, so look for the idea rather than the exact words.

1. Look for a transaction download

Bank of America generally lets you download recent transactions from the account’s activity page, with a choice of file formats that usually includes CSV and sometimes formats for money-management software. Look for a “download” option near the transaction list. Statements themselves are PDF.

If the range you need is available, download it and open the file in Excel. Check these before you trust it:

The first rows may contain a summary or notes rather than transactions. Delete them so the headers sit in row 1.
Running balances may appear in some files and not in others.
Amounts may use negative numbers for money out. Make sure your sums and your accounting program agree on the sign.

2. The PDF route for older months

When only the PDF statement exists:

Open it in Preview and see if the text can be selected. If so, copy the deposits and withdrawals sections.
Paste them into Excel. Bank of America statements often list deposits and other credits separately from withdrawals and other debits, so you will have several tables to combine.
Put every transaction into one table with date, description and a signed amount, with debits negative.
Remove page headers, footers and “continued on next page” lines.
Check dates. Statements show month and day without a year on each line, so add the year from the statement period, and take care across a December to January boundary.

That last point matters: if you paste a year of statements, rows near New Year are the ones most often given the wrong year.

3. Tie it out to the statement

Compare your sheet with the statement’s summary: beginning balance, total deposits and credits, total withdrawals and debits, ending balance. They should satisfy:

beginning balance + deposits - withdrawals = ending balance

If they do not, look for a transaction missed at a page break, a duplicated line, or a debit pasted as positive.

4. Where Balanced helps

Splitting several tables and fixing years by hand is where this gets slow. Balanced is a Mac app we make that reads the statement on your Mac and builds one table. Statements are processed on your Mac and never leave it, and there is no AI guessing: every number is copied from your statement and checked.

It reads text PDFs, scanned PDFs and images (with Apple’s on-device text recognition) and CSV files.
A preview shows the table it found. You can fix column roles (date, description, debit, credit, amount, balance), switch between day/month and month/day, and change sign handling. The layout is remembered for the next statement.
The totals check compares opening balance plus transactions with the closing balance. If it does not add up, it tells you which rows and the size of the difference, and exporting needs an explicit “Export anyway”.
Export to Excel (.xlsx) or CSV, or OFX, QFX, QBO, QIF, YNAB CSV, Actual Budget, Lunch Money, Xero bank statement CSV, Beancount or Ledger/hledger.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file, so you can see how your own statement comes out before paying. Pro is USD 59 per year or USD 7.99 per month, up to 3 Macs, cancel anytime, with a 30-day money-back on the first payment. macOS 14 or later, Apple silicon and Intel.

Limits: results depend on layout, so check the preview. Heavily skewed or low-quality scans can fail. Password-protected PDFs need unlocking first with the password from your bank. We cannot promise every statement will parse.

5. Getting it into your accounting software

Once you have Excel or CSV, most programs import bank transactions from a file; the exact labels vary by version.

QuickBooks: bank files in QBO format are the usual route. Balanced can write QBO and has a bank id setting (default 3000).
Xero: it takes a bank statement CSV in its own column layout, which Balanced can export.
Quicken: QFX files, which Balanced can export.
YNAB, Actual Budget, Lunch Money: each has its own CSV import, and Balanced has a matching export for each.

After importing, check the opening balance and a few transactions in the program. This is a conversion aid, not accounting advice.