Convert Bank of America Statements to Excel (2026)
Step-by-step guide to converting Bank of America checking, savings, and credit card statement PDFs into Excel, CSV, or QBO format.
You've got a Bank of America statement PDF sitting in your downloads folder, and you need that data in a spreadsheet. Whether it's for expense tracking, bookkeeping, or tax prep, Bank of America doesn't exactly make it easy to get your statement data into Excel.
Sure, BofA offers some download options — but they come with frustrating limitations. And if you've ever tried copying and pasting from a BofA PDF, you know the result: a wall of jumbled text in a single column.
Here's how to actually get your Bank of America statement data into Excel, with methods that work for checking, savings, and credit card accounts.
What Bank of America Gives You (And Where It Falls Short)
Before diving into conversion methods, let's look at what BofA provides natively.
PDF statements — available for up to 7 years through Online Banking under Statements & Documents. These are the official statements with opening/closing balances, fee summaries, and complete transaction detail. PDF format only.
Activity downloads — available through your account's transaction history. BofA offers CSV, QFX (Quicken), and QBO (QuickBooks) export options. This sounds like it should solve the problem, right?
Not quite. The activity download has real limitations:
- 60-day download window — BofA limits each CSV export to roughly 60 days of transactions, so a full year requires multiple downloads stitched together
- 3,000 transaction cap for checking/savings accounts — if your date range contains more transactions, the export gets truncated
- 12 months of credit card history — credit card CSV downloads only go back about a year
- Not official statements — the download is a transaction feed, not the complete statement. It's missing opening/closing balances, interest breakdowns, fee summaries, and daily balance tables
So if you need data older than a year, need the full statement (not just a transaction list), or need to process credit card statements beyond 12 months — the PDF is your only option.
Method 1: Use a Bank Statement Converter (Recommended)
The fastest and most accurate approach is a specialized bank statement converter — a tool built specifically to extract structured transaction data from bank statement PDFs.
Unlike generic PDF-to-Excel tools, bank statement converters understand financial document layouts. They know that BofA checking statements separate "Deposits and Other Credits" from "Withdrawals and Other Debits." They handle multi-line merchant descriptions, running balances, and BofA's date formatting.
Step-by-Step with PDFSub
- Download your BofA statement — Log into bankofamerica.com → Statements & Documents → select the month → download PDF
- Go to PDFSub's Bank Statement Converter
- Upload the BofA PDF — drag and drop or click to browse
- Review the extracted data — PDFSub shows you the transactions before you download, so you can verify accuracy
- Choose your format — Excel (XLSX), CSV, QBO (QuickBooks), OFX (Xero), or any of 8 supported formats
- Download — click Download or use "Download All" for a ZIP with every format
For Bank of America's digital PDFs (downloaded directly from Online Banking), PDFSub's Tier 1 extraction handles the conversion entirely in your browser — the file never leaves your device.
Why this works well for BofA specifically:
- Auto-detects BofA's date format and column structure for checking, savings, and credit card statements
- Handles BofA's multi-line transaction descriptions without creating duplicate rows
- Correctly separates deposits from withdrawals into proper signed amounts
- Recognizes BofA's international currency transactions and fee line items
- Exports to QBO format for direct QuickBooks import with FITID duplicate detection
PDFSub plans start at $10/month, with bank statement conversion at $29/month (Business + BSC add-on, 500 pages) and a 7-day free trial.
Method 2: BofA's Built-In Activity Download
If you only need recent transactions (not the full statement), BofA's native CSV export is the quickest option.
How to Download
- Log into bankofamerica.com
- Navigate to your account
- Click "Download Transactions" or the download icon
- Set your date range (max ~60 days per download)
- Select "Microsoft Excel & Spreadsheet (CSV)"
- Open the downloaded file in Excel
What You Get
BofA's CSV includes these columns:
| Column | Description |
|---|---|
| Date | Transaction date (MM/DD/YYYY) |
| Description | Merchant or transaction detail |
| Amount | Signed amount (negative for debits) |
| Running Bal. | Balance after transaction (sometimes included) |
Limitations to Watch For
The 60-day download window. Each download covers roughly 60 days. Need a full year? You'll have to download in chunks and combine them manually. That means 6–7 separate downloads, each requiring you to set the date range, export, and merge.
The 3,000-transaction cap. For checking and savings accounts, BofA limits CSV exports to 3,000 transactions per download. High-volume business accounts can hit this easily.
12-month credit card limit. Credit card CSV downloads only cover about 12 months of history. For anything older, you need the PDF statement.
Not the official statement. The CSV is a transaction feed — it doesn't include opening/closing balances, fee summaries, interest charges, or the daily balance table. If you need these for auditing or tax purposes, you need the PDF.
This method works for quick personal finance tracking of recent activity. For anything more comprehensive, convert the PDF.
Method 3: Copy-Paste from PDF (Not Recommended)
You can try selecting text in a BofA PDF and pasting it into Excel. Here's what actually happens:
Everything lands in a single column. Dates, descriptions, amounts, and balances get smashed together because BofA PDFs use space-based formatting — and Excel can't tell where one field ends and another begins when spaces appear within descriptions too.
You can try Excel's Text to Columns feature (Data tab → Text to Columns) to split it apart, but:
- BofA's multi-line descriptions break the row alignment
- Running balances don't line up with their transactions
- Section headers ("DEPOSITS AND OTHER CREDITS") get mixed in with transaction data
- The BofA logo and header information bleeds into the first rows
- You'll spend 30+ minutes cleaning up a single statement
For one or two simple statements with few transactions, this is tedious but doable. For anything more, it's not worth the effort.
Method 4: Adobe Acrobat Pro
Adobe Acrobat Pro has an "Export PDF → Spreadsheet → Microsoft Excel Workbook" feature. For BofA statements, the results are consistently poor.
Here's what typically happens:
- Scattered columns. Acrobat creates far more columns than needed, with data fragments spread across the sheet in seemingly random positions.
- Garbled text. Some users report that BofA statement text converts to symbols or unreadable characters rather than clean text.
- Merged header data. The BofA logo, account number block, and statement period header get merged into the transaction table.
- Broken amounts. Dollar amounts may be split across cells — "$1,234" in one cell and ".56" in the next.
Adobe's own community forums have multiple threads from frustrated users trying to convert Bank of America statements specifically. The typical Adobe moderator response suggests using alternative methods or getting data directly from the bank.
If you have Acrobat Pro, it's worth a quick try — some BofA statement periods convert better than others. But budget significant cleanup time.
BofA-Specific Quirks You Should Know About
Bank of America PDFs have several characteristics that trip up generic converters:
Statement Format Consistency
Unlike Chase (which has changed formats multiple times), BofA has maintained a relatively consistent statement layout. This is good news for conversion — a tool that works on one BofA statement will generally work on statements from other periods too.
Deposit and Withdrawal Sections
BofA checking statements split transactions into clearly labeled sections: "Deposits and Other Credits" and "Withdrawals and Other Debits." This section-based layout helps specialized converters categorize transactions, but confuses generic PDF-to-Excel tools that don't understand the structure.
Credit Card Statement Differences
BofA credit card statements have a different layout from checking/savings statements. They include:
- A payment summary section at the top
- Transaction groups by posting date
- Foreign transaction fees listed as separate line items
- Rewards summary section that shouldn't be extracted as transactions
Business Account Features
BofA business checking and Merrill Lynch statements may include additional sections like account analysis, lockbox deposits, and treasury management details. These extra sections can interfere with transaction extraction if the converter doesn't know to skip them.
eStatements vs. Paper Statement PDFs
Statements downloaded directly from BofA Online Banking are digital (text-based) PDFs — ideal for conversion. If you've scanned a paper statement, the quality drops significantly because OCR processing is required. Always use the digital version from Online Banking when possible.
Tips for Working with Converted BofA Data
Once you have your BofA transactions in Excel, here are some practical tips:
Verify with the opening and closing balance. Add up all transactions and check that they match the balance change shown on the statement header. This is the fastest accuracy check.
Watch for pending vs. posted discrepancies. If you're comparing converted statement data with BofA's CSV download, amounts might differ slightly due to pending transactions that hadn't posted when the CSV was downloaded.
Standardize the date column. Excel sometimes interprets dates as text rather than date values. Select the date column → Data → Text to Columns → select Date format (MDY) to ensure proper date handling.
Combine multiple months carefully. If you're stitching together several months of data, watch for duplicate transactions at month boundaries — the last transaction of one statement and the first of the next might overlap.
Add a category column. Use Excel's SEARCH function to auto-categorize based on merchant names:
=IF(SEARCH("AMAZON",B2)>0,"Shopping",IF(SEARCH("TRANSFER",B2)>0,"Transfers","Other"))
Convert monthly, not annually. Don't wait until tax season to convert 12 months of statements at once. Convert each month as it arrives and keep an organized folder structure.
Frequently Asked Questions
Can I download BofA statements as Excel files directly?
No. Bank of America only provides statements in PDF format. You can download recent transaction activity as CSV through the transaction history download feature, but this is a transaction feed — not the official statement. For full statements with balances and fees, you must convert the PDF.
How far back can I get BofA statements?
Up to 7 years for PDF statements through BofA Online Banking (Statements & Documents). The CSV activity download covers shorter periods — roughly 12–18 months for most accounts. For statements older than 7 years, contact Bank of America customer service at (800) 432-1000 and ask about archived statement retrieval.
Why is my BofA CSV download incomplete?
BofA has two key limitations: a 60-day download window per export and a 3,000-transaction cap for checking/savings accounts. If your download looks incomplete, try shorter date ranges. For credit cards, CSV downloads are limited to approximately 12 months of history.
Does this work for BofA credit card statements?
Yes. Both checking/savings and credit card statements from Bank of America produce digital PDFs that convert well. Credit card statements have a different layout (payment summary, rewards section, foreign transaction fees), but specialized converters handle these variations.
Which format should I choose for QuickBooks import?
Choose QBO format. It's designed for QuickBooks and includes transaction IDs (FITIDs) that prevent duplicate imports. CSV works too but requires manual column mapping and doesn't have built-in duplicate detection. See our guide to importing bank statements into QuickBooks for detailed steps.
How accurate is the conversion?
For BofA's digital PDFs (downloaded directly from bankofamerica.com), specialized bank statement converters typically achieve 95–99% accuracy. Generic PDF-to-Excel tools average around 70% on bank statements due to their complex formatting. Scanned or photographed statements will have lower accuracy because they require OCR processing.
Does this work for Merrill Lynch statements?
Merrill Lynch investment account statements have a different structure from standard BofA banking statements. They may include portfolio summaries, asset allocation charts, and performance tables. Specialized bank statement converters focus on transaction extraction, so results may vary for investment account statements.