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 LocalExtract team. We build the desktop converter and have a commercial interest in this topic. Verify the exported rows against your own statement; bank guides and generic screenshots are not compatibility guarantees.

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.

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.

Check the actual PDF by trying to select and copy its transaction text. Do not assume every file from this bank has the same format. A scan or image-only copy can require OCR, and both text extraction and OCR results must be checked against the original.

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:

LocalExtract is an on-device converter you can try with your own BofA PDF. Check debit and credit signs against the original. The desktop CSV exports date, description, and amount; it does not export balances as a separate column.

Before relying on a conversion, try one statement from your own account and compare each exported date, description, and amount with the PDF. Processing time and extraction quality depend on the document layout, scan quality, hardware, and app version. A supported language or another account at the same bank does not establish support for every statement format. No bank-specific accuracy or timing guarantee is provided here.

Tool Comparison Summary

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. Review the resulting transactions against your original PDF; not every statement layout is guaranteed to work.

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 CSV and Open It in Excel

Click Download CSV to save the reviewed transactions. The current desktop apps export three columns: date, description, and amount.

• CSV — use it for spreadsheet review or an accounting import after checking the required column mapping.
• Excel — open or import the CSV in Excel. If you want an .xlsx workbook, save a copy from Excel; LocalExtract does not export a native XLSX file.

Compare the exported rows with the original PDF before using them. The App does not export investment holdings, security symbols, quantities, prices, or cost basis as separate columns.

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

The current desktop workflow imports one PDF at a time. For multiple months, convert and verify each file separately, then combine the CSV files in your spreadsheet if needed.

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? It depends on the statement layout. Try your own statement PDF and verify the resulting transactions. This guide does not establish compatibility for every account or card variant.

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? Try one statement from your own account and compare the exported dates, descriptions, and amounts with the PDF. Extraction quality and processing time depend on the document and hardware. This article does not provide a verified bank-specific benchmark.

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. We build the desktop converter and have a commercial interest in this topic. Verify the exported rows against your own statement; bank guides and generic screenshots are not compatibility guarantees.