How to Convert Bank of America Statements to Excel or CSV

Key Takeaways

• Try BofA's native CSV download first — Bank of America lets you download recent transactions as CSV or QFX directly from online banking. For recent activity, this is the fastest path.
• Monthly statement PDFs (under "Statements & Documents") cannot be exported as spreadsheet data — they are PDF-only. For those, you need a converter.
• BofA's separate debit/credit column layout is a common source of errors during conversion — always verify that deposits and withdrawals landed in the correct columns.
• Several tools can convert BofA PDFs to spreadsheets, including free open-source options (Tabula), cloud services, and on-device converters — each with different trade-offs.
• Whichever method you choose, always verify your converted data against the original statement totals.

Disclosure: This article is published by the company that builds LocalExtract. LocalExtract is presented as one option among several.

Bank of America is one of the largest banks in the United States, serving tens of millions of consumer and small business clients. If you handle bookkeeping, tax preparation, or financial management for yourself or clients with BofA accounts, you have likely needed statement data in spreadsheet form at some point.

This guide covers the main methods for converting Bank of America statement PDFs to Excel or CSV — what works, what doesn't, and the trade-offs of each approach.

Contents

• Understanding Bank of America Statement PDF Formats
• Method 1: BofA's Built-In Download
• Method 2: Manual Copy-Paste from PDF
• Method 3: Tabula (Free, Open-Source)
• Method 4: Cloud-Based Converters
• Method 5: On-Device Converter
• Tool Comparison Summary
• What to Check After Converting Any BofA Statement
• Step-by-Step: Convert BofA Statements with LocalExtract
• Bank of America-Specific Quirks
• Limitations
• Privacy Considerations for BofA Statements
• FAQ

Understanding Bank of America Statement PDF Formats

Before choosing a conversion method, it helps to understand what you are working with. Bank of America issues digital PDF statements through bankofamerica.com for several account types, and the layouts vary — sometimes significantly.

BofA Checking and Savings Statements (Advantage SafePass, Advantage Plus, Advantage Relationship, etc.) use a consistent layout:

• A header section with account holder name, address, account number (partially masked), and statement period
• An account summary showing beginning balance, total deposits/credits, total withdrawals/debits, fees, and ending balance
• A transaction detail section organized chronologically with date, description, and amount columns — deposits and withdrawals are shown in separate columns rather than a single signed-amount column (this is a key BofA formatting characteristic that causes issues with many conversion tools)
• Check images or check detail listings (if applicable)
• Service fees and account information disclosures

BofA Credit Card Statements (Customized Cash Rewards, Unlimited Cash Rewards, Travel Rewards, Premium Rewards, etc.) follow a different structure:

• An account summary with previous balance, payments, purchases, balance transfers, interest charges, fees, and new balance
• A payment information section with minimum payment due, payment due date, and late payment warning (as required by the CARD Act)
• Transaction details grouped by type — payments/credits and purchases — with transaction date, posting date, description, and amount
• Interest charge calculation and fee summary sections
• Rewards summary (if the card has a rewards program)

Merrill Lynch / Merrill Edge Statements (investment accounts linked to BofA) use a substantially different format:

• Portfolio summary with asset allocation and total value
• Holdings detail by account and asset class
• Transaction history for buys, sells, dividends, and interest
• A multi-column layout that is significantly more complex than standard bank statements

Preferred Rewards Summary Pages — BofA Preferred Rewards members sometimes receive a combined summary page at the beginning of their statement that references balances across banking, credit card, and Merrill accounts. This summary page uses a distinct layout from the transaction detail pages and can confuse tools that expect transaction data to start on page one.

All BofA and Merrill statement PDFs downloaded from online banking are text-based (not scanned images), which means the transaction data is embedded as selectable text. This allows faster and more accurate extraction than scanned documents that require OCR.

Method 1: BofA's Built-In Download

Before reaching for any conversion tool, check whether BofA's native download covers what you need. Bank of America offers a transaction download feature through its online banking portal.

What you can do:

1. Log in to bankofamerica.com and navigate to your account
2. Click on your account, then look for "Download transactions" in the account activity area
3. Select a date range and choose a format: Microsoft Excel (CSV), Quicken (QFX), QuickBooks (QBO), or Money (OFX)
4. Download the file

When this works well:

• You need recent transactions (last 60-90 days) in spreadsheet form
• You are importing into accounting software like QuickBooks or Xero
• The exact statement period boundaries are not critical

When this does not work:

• Archived statements — statements available under "Statements & Documents" can only be downloaded as PDFs. BofA does not offer a CSV or Excel version of these documents
• Statement reconciliation — the CSV export reflects raw transaction data without the beginning/ending balance, fee breakdowns, or account summary that appear on the official monthly statement
• Date-range mismatch — the download date range may not align with a specific monthly statement period
• Credit card statements — the download format for credit cards may differ from checking/savings and may omit some transaction detail fields

Method 2: Manual Copy-Paste from PDF

Open the BofA statement PDF, select the transaction table, copy, and paste into Excel or Google Sheets.

The problems specific to BofA formatting:

• Separate deposit and withdrawal columns — BofA checking statements show deposits and withdrawals in separate columns. When you copy-paste, amounts frequently land in the wrong column or merge into a single cell with no way to distinguish credits from debits. This is arguably the most frustrating BofA-specific issue because it silently corrupts your data — amounts look correct but are in the wrong column
• Multi-line descriptions — BofA transaction descriptions often include the merchant name on one line and a reference number, city/state, or card number on the next. Copy-paste either merges these into one cell or splits them into separate rows
• Check detail interference — statements with check images or check detail tables inject additional data that tangles with the transaction listing
• Page-break artifacts — headers, footers, and "continued on next page" lines mix into the data at page boundaries
• Time cost — a two-page checking statement with 30 transactions takes 10-20 minutes to clean up manually. Errors during cleanup are common, particularly with amount alignment

For a single short statement, manual copy-paste can work if you are willing to spend the time. For recurring work — monthly reconciliation for multiple clients — it is not practical.

Method 3: Tabula (Free, Open-Source)

Tabula is a free, open-source tool for extracting tables from PDF files. It runs locally on your computer (Java-based) and does not upload your data anywhere.

How it works with BofA statements:

1. Download and install Tabula (requires Java)
2. Open Tabula in your browser (it runs a local server at http://localhost)
3. Upload your BofA statement PDF (the file stays on your machine)
4. Use Tabula's Autodetect Tables feature to find table regions, or manually draw selection boxes around the transaction tables
5. Choose between "Stream" and "Lattice" extraction modes
6. Export as CSV or TSV

Where Tabula works well:

• It is completely free and open-source
• Data never leaves your computer
• The Autodetect Tables feature can identify transaction tables on straightforward statement pages
• Good community support and documentation

Where Tabula struggles with BofA statements:

• Separate debit/credit columns — BofA's two-column amount layout (deposits in one column, withdrawals in another) is a known challenge. Tabula sometimes merges these columns or misaligns amounts, especially when one column has an empty cell on a given row. You will likely need to manually verify and correct column assignments
• Multi-page tables — you need to select tables on each page separately and then combine the CSV outputs. There is no automatic "this table continues on the next page" detection
• Preferred Rewards summary pages — the summary page at the start of some BofA statements can confuse Autodetect, causing it to pick up the summary table instead of (or in addition to) the transaction tables
• Stream vs. Lattice choice — BofA statements use a mix of ruled and unruled tables. You may need to experiment with both extraction modes to find which produces cleaner output for your specific statement
• No header recognition — Tabula extracts raw cell data without understanding that the first row is a header. You add headers manually
• No balance extraction — Tabula extracts table contents only. It does not pull out the beginning balance, ending balance, or account summary fields that sit outside the transaction table

Tabula is a solid choice if you are comfortable with some manual cleanup, want a free tool, and prioritize keeping data local. For BofA statements specifically, expect to spend time verifying that the debit/credit column alignment is correct.

Method 4: Cloud-Based Converters

Cloud-based PDF converters (DocuClipper, BankStatementConverter.com, ConvertMyBankStatement, and others) accept a BofA statement PDF upload, process it on their servers, and return a CSV or Excel file.

Advantages:

• Automated extraction — generally accurate for standard BofA checking and savings formats
• No software installation required
• Some services offer batch processing and direct accounting software integration

Considerations:

• Data leaves your device — your BofA statement is uploaded to a third-party server, along with your account number, routing number, and full transaction history for that period
• Retention policies vary — DocuClipper retains uploaded data for 30 days to 5 years (privacy policy), BankStatementConverter.com retains files for 24 hours (privacy policy), and ConvertMyBankStatement states it keeps data "as long as necessary." Check each provider's privacy policy before uploading (policies reviewed March 2026)
• Ongoing cost — most cloud converters charge per page or per statement, which adds up for bookkeepers processing statements monthly across multiple clients
• BofA column handling varies — not all cloud converters correctly handle BofA's separate debit/credit columns. Some merge them into a single amount column (which may or may not be what you want), and some misalign them

For professionals handling client financial data, uploading statements to third-party servers has regulatory implications. The FTC Safeguards Rule (16 CFR Part 314) requires non-bank financial institutions — including accounting firms and bookkeeping services — to implement safeguards for customer financial information. IRS Publication 4557 outlines similar responsibilities for tax professionals. These regulations do not prohibit cloud tools outright, but they require you to assess and document the risk of each data-sharing arrangement.

Method 5: On-Device Converter

An on-device converter runs the PDF parsing engine entirely on your computer. The BofA statement never leaves your machine — no upload, no cloud processing, no third-party access.

How it differs from other methods:

Factor	Manual	Tabula	Cloud Converter	On-Device Converter
Cost	Free	Free	Per-page/subscription	One-time or subscription
Data privacy	Local	Local	Uploaded to servers	Local
BofA debit/credit columns	Manual fix needed	Often misaligned	Varies by provider	Handled automatically
Multi-page continuation	Manual	Manual combine	Automatic	Automatic
Processing speed	10-20 min	2-5 min	Includes upload/download time	Under 10ms (LocalExtract benchmark)
Balance extraction	No	No	Some providers	Yes

LocalExtract is one on-device converter that supports BofA statement formats. It detects the bank format automatically, handles BofA's separate debit/credit columns, and extracts balance information alongside transactions.

Benchmark result: A Bank of America Checking statement (2 pages, 112KB) processed in 7ms median. Test conditions: MacBook Pro M2, 16GB RAM, macOS 14.4, 3 runs median, cold start, Wi-Fi disconnected.

Tool Comparison Summary

	BofA Download	Manual	Tabula	Cloud	On-Device
Archived statements	No	Yes	Yes	Yes	Yes
BofA debit/credit handling	N/A	Error-prone	Needs verification	Varies	Automatic
Balance extraction	No	Manual	No	Some	Yes
Merrill Edge support	Partial	Difficult	Limited	Varies	Limited
Privacy	BofA servers	Local	Local	Third-party	Local
Cost	Free	Free	Free	Paid	Paid

What to Check After Converting Any BofA Statement

Regardless of which tool you use, run through this checklist before relying on the converted data:

1. Transaction count — count the rows in your spreadsheet and compare against the number of transactions listed on the original PDF. BofA statements sometimes include subtotals or section headers that tools may misinterpret as transactions.

2. Beginning and ending balances — verify that the extracted beginning balance and ending balance match the statement. If your tool does not extract balances (Tabula, manual), calculate: beginning balance + total deposits - total withdrawals should equal the ending balance.

3. Debit/credit column accuracy — this is the most common BofA conversion error. Check several transactions against the PDF to confirm that deposits landed in the deposit column and withdrawals in the withdrawal column. A single column swap can silently corrupt your entire dataset.

4. Date format consistency — BofA statements use MM/DD format without the year on transaction lines (the year is in the statement header). Verify that your converter assigned the correct year, especially for December/January statement periods that span a year boundary.

5. Multi-line descriptions — check that multi-line transaction descriptions (merchant name + reference number) were combined into a single row rather than split across two rows. A split description creates a phantom transaction with no amount.

6. Check detail rows — if the statement includes check detail, verify these were either correctly extracted or cleanly excluded. Partial extraction of check data can inject incomplete rows.

7. Page-boundary transactions — look at transactions that fall at page breaks. Confirm they were not duplicated or truncated.

8. Fee and interest rows — BofA lists service fees and interest in their own sections. Verify these appear in your output if they are relevant to your reconciliation.

Step-by-Step: Convert BofA Statements with LocalExtract

Here is the complete process for converting a Bank of America statement PDF to Excel or CSV using LocalExtract.

Step 1: Download Your BofA Statement PDF

1. Log in to bankofamerica.com and navigate to your account
2. Click "Statements & Documents" (accessible from the account details or the top navigation menu)
3. Select the statement period you need
4. Click "Download" or the PDF icon to save the statement to your computer

Step 2: Open LocalExtract

Launch LocalExtract on your Mac or Windows PC. If you haven't installed it yet, download it here — free to start, no account required.

Step 3: Import the BofA Statement

Drag and drop the BofA PDF into the LocalExtract window, or click "Select PDF" to browse. The engine detects the bank format automatically — no need to select "Bank of America" from a dropdown.

Step 4: Review the Extracted Data

LocalExtract displays the extracted transactions in a preview table. Check that:

• The statement period dates are correct
• Transaction dates, descriptions, and amounts align properly
• The beginning and ending balances match your statement
• Deposits and withdrawals are correctly categorized (BofA uses separate columns for these)

Step 5: Export to Excel or CSV

Click "Export" and choose your format:

• CSV — universal format, works with any spreadsheet app or accounting software. See our guide on converting bank statement PDFs to CSV.
• Excel (.xlsx) — formatted spreadsheet with column headers. Best for manual review or sharing with clients. See our guide on converting bank statement PDFs to Excel.

The entire process — from drag-and-drop to export — takes under 10 seconds for a typical BofA statement.

Bank of America-Specific Quirks

The Separate Debit/Credit Column Problem

This is the single biggest source of conversion errors for BofA statements. Unlike Chase or Wells Fargo, which use a single amount column with positive/negative values, BofA checking and savings statements present deposits and withdrawals in two separate columns. On any given transaction row, one column has an amount and the other is blank.

This layout creates three specific problems for conversion tools:

1. Column merging — some tools collapse the two columns into one, losing the debit/credit distinction
2. Misalignment — when one column is empty, tools may shift the amount to the wrong column
3. Clipboard corruption — copy-paste almost always scrambles this layout because the clipboard does not preserve the spatial relationship between columns

When evaluating any conversion tool for BofA, this is the first thing to test: process a statement and verify that a known deposit appears in the deposit column and a known withdrawal appears in the withdrawal column.

Merrill Edge Complexity

If you have Merrill Edge or Merrill Lynch accounts linked to your BofA login, be aware that investment account statements have a fundamentally different structure. They include asset class breakdowns, lot-level holdings, dividend reinvestment records, and tax lot information. No general-purpose PDF-to-CSV tool handles these perfectly — including LocalExtract, which provides basic transaction extraction but does not cover all investment-specific fields. For comprehensive Merrill data export, consider using Merrill's own portfolio download tools within the Merrill Edge website.

Preferred Rewards Summary Pages

BofA Preferred Rewards members (Gold, Platinum, Platinum Honors) receive a combined summary page that appears before the transaction details. This page lists balances across all linked accounts — checking, savings, credit card, and Merrill. Conversion tools that start reading from page one may misinterpret this summary as transaction data. If your converted output includes unexpected rows with large balance figures, the summary page is likely the cause.

Batch Processing Historical Statements

If you need to convert a full year of BofA statements (12 PDFs), tools that support batch input will save significant time. LocalExtract accepts multiple files at once. Tabula allows multiple PDFs but requires table selection on each. Cloud converters vary — some support batch upload, others require one file at a time.

Limitations

No conversion tool is perfect. Here are the current trade-offs to be aware of:

• Merrill Lynch / Merrill Edge statements — investment account PDFs have significantly more complex layouts than standard banking statements. Extraction accuracy may vary depending on the specific statement format and holdings detail
• Scanned paper statements — if you have a paper BofA statement that was scanned to PDF (rather than downloaded digitally from online banking), the PDF may not contain selectable text. OCR-based extraction is supported but may be less accurate than text-based extraction
• Very old statement formats — BofA has updated its statement layout over the years. Statements from more than 10 years ago may use a format that differs from current templates
• Combined statements with check images — statements that include inline check images can occasionally affect the parsing of surrounding transaction rows

Privacy Considerations for BofA Statements

Bank of America statements contain sensitive financial information, including full or partial account numbers, ABA routing numbers, transaction descriptions that reveal spending patterns and vendor relationships, and balance information showing exact financial position at statement open and close.

When choosing a conversion method, consider where your data goes:

• Manual copy-paste and Tabula keep data entirely on your device
• Cloud converters upload data to third-party servers with varying retention policies (check each provider's privacy policy)
• On-device converters like LocalExtract process data locally without network access

For professionals subject to data-handling regulations — such as the FTC Safeguards Rule for non-bank financial institutions or IRS Publication 4557 for tax professionals — the choice of tool affects your compliance posture. These regulations require you to assess and document the security of any third party that accesses customer financial data. Local processing avoids this requirement by keeping data off third-party servers entirely.

FAQ

Can I download Bank of America statements as CSV directly from BofA's website? Not for monthly statements. BofA offers CSV download for recent account activity (typically the last 60-90 days) through the "Download transactions" feature. However, your official monthly statement PDFs — available under "Statements & Documents" — can only be downloaded as PDF files. To get statement data into CSV or Excel format, you need to convert the PDF.

Should I try BofA's CSV download before using a converter? Yes. If you need recent transactions and do not need to match a specific statement period, BofA's built-in download is the fastest option. It avoids the conversion step entirely. Only use a PDF converter when you need data from an archived monthly statement or need the exact statement-period boundaries.

Does this work with BofA credit card statements? Yes. LocalExtract supports Bank of America credit card statement PDFs, including Customized Cash Rewards, Unlimited Cash Rewards, Travel Rewards, and Premium Rewards cards. The converter handles the credit card layout — which differs from checking and savings — automatically. Tabula can also extract credit card transaction tables, though you may need to adjust table selection for the different layout.

Can I convert Merrill Edge or Merrill Lynch statements? Investment account statements from Merrill Edge and Merrill Lynch use a more complex format than standard BofA banking statements. Basic transaction extraction is supported by some tools, but these statements contain portfolio summaries, asset allocation data, and investment-specific fields that may not all map cleanly to a simple CSV structure. For best results with Merrill data, try Merrill Edge's own portfolio export tools first, then use a PDF converter for anything those tools do not cover.

How far back can I convert BofA statements? You can convert any BofA statement PDF you have saved, regardless of age. Bank of America retains downloadable statements in online banking for up to 7 years. If you have older PDFs stored locally, those can be converted as well, though very old formats may differ from current layouts.

How fast is the conversion for Bank of America statements? Using LocalExtract, a 2-page BofA checking statement (112KB) processed in 7ms median on a MacBook Pro M2 with 16GB RAM running macOS 14.4 (3 runs, cold start, Wi-Fi disconnected). Larger statements take proportionally longer but remain well under one second. Tabula processing time depends on the number of pages and whether you need to manually select table regions. Cloud converter speed depends on upload speed and server load — we did not benchmark them under identical conditions.

Is the converted data accurate? How do I verify? After conversion, use the verification checklist above. At minimum, compare the beginning balance, ending balance, total deposits, and total withdrawals against the original PDF. Pay special attention to the debit/credit column alignment — this is the most common BofA-specific conversion error.

---

Disclosure: This article is published by the LocalExtract team. LocalExtract converts Bank of America statement PDFs to CSV and Excel entirely on your device. Processing times cited were measured on a MacBook Pro M2 in March 2026. Download free for Mac or Windows.