How to export statements from Bank of America (PDF, CSV, QFX, QBO)

Bank of America splits things sharply: PDF statements live under Statements & Documents, while a separate transaction download offers the spreadsheet and accounting formats. The two cover different date ranges, and once a month rolls out of the activity window, the PDF is the only native way to get it back.

The official PDF statement

1. Sign in to Online Banking at bankofamerica.com.
2. Go to the Accounts tab and choose Statements & Documents.
3. Pick the account and statement period.
4. Open the statement as a PDF and save it.

Online statement viewing covers a shorter window than what the bank keeps on file — older statements exist, but you fetch them by request rather than by clicking.

The transaction download (CSV, QFX, QBO, OFX)

The download is consistently documented as offering CSV for Excel, QFX for Quicken, QBO for QuickBooks and OFX for Money — one of the broader format lists among US banks. None of it applies to archived statements: the download draws from recent activity only.

Reading BofA's statement lines

• CHECKCARD MM/DD prefixes. Debit card purchases embed the transaction date in the description, while the date column shows the posting date — two dates per line, and reconciliations trip on the difference.
• DES: and ID: fields. ACH lines pack originator metadata into the description — a payroll line reads like COMPANY DES:PAYROLL ID:XXXXX. Useful data, hostile formatting.
• Sectioned statements. Deposit accounts list deposits and additions separately from withdrawals and other subtractions, rather than one chronological list — so a parser (or a copy-paste) has to stitch sections back into a timeline.
• Store numbers jammed into names. Merchant lines often carry store numbers and truncated cities pressed against the merchant name — the classic reason exports need cleanup before an import. (Decoding the descriptors themselves is what our charge identifier is for.)

Getting a clean spreadsheet

Recent months: use the download — CSV straight into Excel, QBO straight into QuickBooks. Anything older lives in PDFs, and the Bank of America statement converter handles their quirks specifically: it reads both statement sections into one chronological list, splits the CHECKCARD dates and DES/ID fields into their own columns, reconciles every line against the printed balances, and names the merchant behind each descriptor.