April 11, 2026 · 5 min read
Convert a Bank of America Statement to Excel
How to download a Bank of America PDF statement and turn it into a clean Excel file ready for QuickBooks, Xero, or Sheets.
Bank of America statements come in two flavours: native PDFs you download from Online Banking (clean text layer) and older scanned statements (image-only). Both work in our converter; the path differs slightly.
Download the PDF
- Sign in at bankofamerica.com → Statements & Documents
- Pick the account, year, and month
- Click PDF — never use "save as image" or print-to-PDF, you'll lose the text layer
For accounts older than 7 years, BofA may show only image-based copies — those go through OCR (see our scanned bank statement guide).
Convert to Excel
Drop the PDF on our Bank of America converter or the general PDF to Excel page. Output:
- One row per transaction
- Separate Debit / Credit columns (BofA prints them as a single signed amount; we split them)
- ISO dates
- Account number and statement period preserved
A typical 6-page BofA checking statement converts in under 20 seconds.
BofA quirks
- Combined statements. Personal checking + savings often arrive on one PDF. The converter outputs each account on a separate sheet.
- "Withdrawals and other subtractions" / "Deposits and other additions" sections. These are split sections in the PDF, not interleaved by date. The converter merges them and re-sorts by posted date.
- Pending transactions are excluded — they're not yet posted and would create duplicates when they clear.
What's next
- For QuickBooks: use PDF to QBO so re-uploads dedupe automatically.
- For Quicken: use PDF to QFX — same OFX engine, with the INTU.BID tag Quicken requires.
- For Xero: use PDF to Xero CSV — see the Xero bank statement import guide.
- For analysis in Sheets/Numbers: stick with PDF to Excel.
Other US banks: Chase, Wells Fargo, Citi, Capital One.