4 Methods Compared · Updated 2026

How to Convert a Bank of America Statement to CSV

Bank of America offers a transaction download from the Activity page, but only in Excel and Quicken/QuickBooks formats, not directly as CSV. For PDF statements (especially older ones, multi-month exports, or scanned files), you need a converter. This guide walks through the four practical methods, with step-by-step instructions and an honest assessment of where each falls short.

Quick Answer

The four methods to convert a Bank of America statement to CSV are: (1) BoA's native Activity download (free, exports as Excel/.xls or QBO; resave as CSV in Excel), (2) Excel Power Query Get Data from PDF (free, Windows only, struggles with BoA's two-column debit/credit layout), (3) Adobe Acrobat Pro export (paid, manual cleanup required), and (4) dedicated bank statement converters (free tier available, handles BoA quirks automatically). For older statements, batch conversion, or anything BoA's native download won't cover, dedicated converters are the most reliable option.

Jump to methods Which method should I use?

Why converting Bank of America statements is harder than it should be

Bank of America provides bank statements as PDFs, with a transaction download option for recent activity, but several specifics make the workflow more complicated than it looks at first:

No direct CSV button. BoA's transaction download offers Microsoft Excel Format (.xls), QFX (Quicken), and QBO (QuickBooks Web Connect) as file types. To get true CSV, you download the .xls and resave it as CSV in Excel. Some account types may show CSV as an option; many do not.

Two-column debit/credit layout. BoA statements present withdrawals and deposits in separate columns rather than as a single signed Amount column. Accounting tools and CSV importers typically expect one signed Amount column, so the data needs to be merged into one column with proper signs before import.

Daily Balance Summary section. BoA includes a Daily Balance Summary table at the end of statements (showing the closing balance for each day of the period). Many generic PDF-to-CSV tools mistakenly extract this as transaction data, producing duplicate or confusing output. The transaction section and the daily balance section need to be handled separately.

3,000 transaction download cap. BoA limits each download to roughly 3,000 transactions. Active business accounts can hit this cap quickly. Credit card downloads are capped at 12 months of history, with the earliest data starting from April 2021.

No bulk statement download. Each PDF statement must be downloaded individually. Bookkeepers doing year-end work across 12+ months are clicking the download button 12 times before they even start converting.

The rest of this guide walks through the four practical methods, with step-by-step instructions and a clear view of where each method fits.

BoA's native Activity download

Free Easiest Recent transactions only

Bank of America's online banking includes a Download Transactions option on the account Activity page. Output is Microsoft Excel Format (.xls), QFX, or QBO. There is no direct CSV button for most account types, but the .xls file can be opened in Excel and resaved as CSV in one step.

You'll need:

Bank of America online banking login
Transactions within the available activity window (recent transactions; credit cards limited to 12 months back to April 2021)
Excel or another spreadsheet tool to resave as CSV if needed

Log into bankofamerica.com on a desktop browser.
Select the account you want to export from your accounts list.
Scroll down to the Activity section and locate the Download link on the right side of the section header.
Click Download. A dialog appears.
Select your Transaction period from the dropdown, or use Custom date range to specify exact dates in mm/dd/yyyy format.
Under File type, choose Microsoft Excel Format (most account types), or QFX for Quicken or QBO for QuickBooks Web Connect if those options appear.
Click Download Transactions. The file downloads to your computer.
To convert .xls to CSV: open the downloaded file in Excel, then File > Save As and select CSV (Comma delimited) as the file type.
(Optional) If you want a single signed Amount column instead of separate Withdrawals/Deposits columns, add a formula column in Excel before saving as CSV: =IF(B2<>"",-B2,C2) where B is Withdrawals and C is Deposits.

What works well

Free and fast, no third-party tools
Data comes from BoA directly, so it's authoritative
QBO option imports directly into QuickBooks Online
Excel format includes balance reconciliation columns

Limitations

No direct CSV option, requires an extra Excel save-as step
3,000 transaction cap per download (active accounts hit this)
Credit cards limited to 12 months, earliest data April 2021
One account at a time, no batch download
Cannot reach older PDF statements (BoA keeps 7 years of eStatements but the Activity download window is much shorter)
Two-column debit/credit format requires reformatting for most CSV importers
Bookkeepers receiving PDF statements from clients can't use this method

Use this method when your transactions are recent and you only need a single account converted. Skip ahead to methods 2-4 for older statements, multi-month batches, or PDF-only data.

Excel Power Query (Get Data from PDF)

Free with Excel Moderate Windows only

Microsoft Excel includes a PDF data import feature called Power Query (also called "Get Data from PDF"). Works on Windows versions of Microsoft 365 and Excel 2019+. Free if you already have Excel. For BoA statements specifically, Power Query handles simple cases but trips on several BoA layout features.

You'll need:

Excel 2019 or later, or Microsoft 365, on Windows
The BoA statement saved as a PDF on your computer
A digital (text-based) PDF, not a scanned image
Comfort using the Power Query Editor for cleanup

Open a blank Excel workbook.
Go to the Data tab in the ribbon.
Click Get Data > From File > From PDF.
Browse to your Bank of America PDF and click Import.
The Navigator window opens, showing tables Power Query detected. BoA statements typically show multiple tables (transactions, Daily Balance Summary, and account info). Click each to preview.
Select the transaction table(s) you want. Skip the Daily Balance Summary table unless you want it separately.
Click Transform Data to open the Power Query Editor.
In the editor, BoA-specific cleanup: rename column headers, remove header/footer rows, filter out the "Daily Balance Summary" rows if they appear in the same table, and unify the two-column Withdrawals/Deposits into a single signed Amount column using Add Column > Custom Column.
Adjust column data types (Date, Currency, Text).
Click Close & Load to push the cleaned data into a new Excel sheet.
Save the file as .csv via File > Save As if you need CSV format.

What works well

Free if you already have Excel
Refreshable: load a new statement to the same folder and Power Query applies the same cleanup steps
Full control over data transformations

BoA-specific issues

Two-column debit/credit layout requires manual unification into a signed Amount column
Daily Balance Summary table often gets mixed into transaction extraction
Pre-2019 BoA statements use a legacy PDF generator that places text elements at irregular positions, making table detection fail
Embedded check images can disrupt table boundaries on some statement layouts
Often picks up only page 1 of multi-page statements (a documented Power Query behavior)
No balance reconciliation built in, so errors pass through silently
Not available on Mac (Power Query for PDF is Windows-only)

Best for: technically comfortable users on Windows with single-month BoA checking statements from 2019 or newer. Skip for pre-2019 statements, batch processing, or anyone who doesn't want to merge debit/credit columns manually.

Adobe Acrobat Pro export to Excel

Paid (Adobe subscription) Easy Cleanup required

Adobe Acrobat Pro (part of the Adobe Acrobat subscription) includes PDF-to-Excel export. Convenient if you already pay for Adobe, but BoA's complex statement layout makes the output messier than for simpler bank PDFs.

You'll need:

Adobe Acrobat Pro subscription (currently around $23 per month standalone, included in Creative Cloud)
The BoA statement PDF
Excel or Google Sheets for cleanup

Open the BoA PDF in Adobe Acrobat Pro.
Click All Tools in the left sidebar.
Select Export a PDF.
Choose Microsoft Excel as the export format.
From the dropdown, select Excel Workbook (.xlsx).
Click Convert to XLSX.
Choose a save location and click Save.
Open the resulting Excel file. Expect significant cleanup: extra columns from BoA's two-column layout, merged cells from the Daily Balance Summary, and rows from check image captions.
Manually unify Withdrawals and Deposits into a single Amount column, remove the Daily Balance Summary rows, and clean up check-image-related rows.
If you need CSV, save the cleaned Excel file as CSV via File > Save As.

What works well

Works on both Mac and Windows
Handles scanned BoA paper statements via OCR (using Enhance Scans > Recognize Text first)
Familiar workflow if you already use Adobe

BoA-specific issues

Often produces 20+ columns from layout artifacts (extensively documented in Adobe's user forums)
Doesn't separate the Daily Balance Summary from transaction data
BoA's two-column debit/credit layout amplifies the column-explosion problem
Embedded check images can create extra rows with image-name placeholders
No bank-statement-specific features: no balance reconciliation, no duplicate detection, no two-column merging
Cleanup time often equals or exceeds the conversion time itself
Requires paid Adobe subscription

Best for: occasional one-off conversions when you already pay for Adobe and have time for the cleanup. Avoid for recurring bookkeeping work or batch processing.

Dedicated bank statement converters

Free tier + paid plans Easy Built for the job

Several tools are purpose-built for bank statement extraction. They understand the structure of statements (transactions vs summaries, debit/credit columns, balance reconciliation) and handle BoA's specific quirks automatically. The category includes SendItSheets, DocuClipper, CapyParse, Bankstatemently, LedgerBox, Lido, and others. Most offer free tiers for trial.

You'll need:

Your Bank of America PDF statement (or several, for batch processing)
A free account on whichever converter you choose

Choose a converter. Most offer free tiers (typically 5-10 pages per month, sometimes up to 50) so you can test before committing.
Sign up for a free account. No credit card is usually required for the free tier. Try SendItSheets here if you want to start with a BoA PDF now.
Upload your BoA PDF via drag-and-drop or file picker. Multiple statements can be uploaded at once for batch processing.
Wait for processing (typically 6-30 seconds per statement depending on length).
Review the extracted data on screen. Most tools show a side-by-side comparison with the original PDF.
Verify BoA-specific elements: the Daily Balance Summary should be excluded from transaction output, withdrawals and deposits should be unified into a single signed Amount column, and check images should be ignored.
If the tool offers it, check the balance validation: beginning balance plus transactions equals ending balance.
Export to your preferred format: CSV, Excel (XLSX), or QBO for QuickBooks.
Import into Excel, Google Sheets, QuickBooks, Xero, or your accounting software.

What works well

Designed specifically for bank statements: understands transactions vs summaries
Two-column debit/credit layout merged into single signed Amount automatically
Daily Balance Summary excluded from transaction extraction
Multi-account combined statements split into separate accounts
Balance reconciliation built in: catches errors before export
Batch upload for multiple statements
Works on Mac and Windows (browser-based)
Handles scanned PDFs and older pre-2019 BoA layouts via OCR

Tradeoffs

Requires creating an account (most are free for low volume)
Higher volume usually requires a paid plan
Cloud-based, so uploads leave your computer (most use encryption in transit)
Different tools handle BoA quirks with varying accuracy. Test on the free tier first

Best for: bookkeepers handling multiple client statements, anyone reconciling year-end records from older PDFs, users with batches of statements, and anyone who needs the two-column layout merged automatically. SendItSheets falls in this category and is designed for bulk bookkeeper workflows. See the comparison below for when it's the right fit.

Which method should I use?

The right method depends on your situation. Use this table to match your use case to the best method.

If you...	Use this method	Why
Need recent transactions for one account and don't mind an extra Excel save-as step	Method 1: BoA Activity download	Fastest path for recent data. The .xls download opens in Excel and you save as CSV in one click.
Need to import recent BoA transactions directly into QuickBooks	Method 1: BoA download (QBO format)	QBO option is direct QuickBooks Web Connect import. No conversion needed.
Have a single-month, single-account BoA checking statement PDF from 2019 or newer, on Windows Excel	Method 2: Power Query	Free, works on simple cases. Skip for pre-2019 statements or anything with check images.
Convert one or two statements occasionally and already pay for Adobe	Method 3: Adobe Acrobat	Convenient if Adobe is in your stack. Expect significant cleanup time for BoA's layout.
Need to convert older PDF statements (beyond BoA's Activity window)	Method 4: Dedicated converter	Only practical method for older PDFs. BoA keeps 7 years of eStatements but the Activity download covers a much smaller window.
Need to convert credit card transactions older than April 2021	Method 4: Dedicated converter	BoA credit card downloads are capped at 12 months back to April 2021. Anything older requires PDF conversion.
Need batch conversion across multiple statements	Method 4: Dedicated converter	BoA does not offer bulk statement download. Dedicated converters accept multiple PDFs at once.
Have an account with more than 3,000 transactions in a period	Method 4: Dedicated converter	BoA's 3,000-transaction cap forces multiple downloads. Converting the PDF skips this limit.
Are a bookkeeper processing many client BoA statements monthly	Method 4: Dedicated converter	Batch uploads, two-column merging, and validation save hours per client.
Have scanned paper BoA statements (older accounts, pre-eStatement era)	Method 4 (with OCR) or Method 3	Dedicated converters with built-in OCR handle scanned statements directly. Adobe Acrobat Pro can OCR first via Enhance Scans.

Bank of America-specific quirks every method has to handle

Regardless of which method you choose, four BoA-specific issues will affect your output. Knowing about them upfront lets you verify the conversion handled them correctly.

Two-column debit/credit layout

BoA shows Withdrawals and Deposits in separate columns rather than one signed Amount column. CSV importers typically expect a single Amount with positive (deposit) or negative (withdrawal) signs. After conversion, verify your output has either properly signed amounts in one column, or check that your destination system can handle separate debit/credit columns.

Daily Balance Summary section

BoA statements include a Daily Balance Summary table at the end showing the closing balance for each day of the period. This is not transaction data and should not appear in your CSV alongside the actual transactions. After conversion, check that the Daily Balance Summary rows are not interleaved with transaction rows.

Embedded check images

BoA checking statements often include images of cleared checks at the end of the statement. These can confuse PDF parsers, sometimes creating empty rows or rows with image-filename text. After conversion, verify your output doesn't contain rows for check images that aren't actual transactions.

How the two-column merging works

This is the most common transformation a Bank of America statement needs before its data is usable in accounting software. BoA presents transactions in two columns (Withdrawals and Deposits); most CSV importers expect a single Amount column with signs. Here's how the conversion looks in practice.

This transformation is the BoA-specific work that Methods 1, 2, and 3 require you to do manually. Method 4 dedicated converters handle it automatically.

Need this for other banks?

The methods above work for any US bank's PDF statements with bank-specific quirks. For Chase, see our Chase bank statement to CSV guide. For Wells Fargo, Citi, Capital One, and other major banks, see our general bank statement converter guide with supported institutions, security details, and bulk processing workflows.

Frequently asked questions

Does Bank of America offer a direct CSV download?

Not directly. Bank of America's Activity page offers a download with Microsoft Excel Format (.xls), QFX (Quicken), and QBO (QuickBooks Web Connect) as file types. You can open the .xls file in Excel and save it as CSV. There is no CSV option directly in the BoA dropdown for most account types. Some users report seeing CSV as an option for specific account types, but Excel format is the standard.

How many transactions can I download from Bank of America at once?

Bank of America limits each transaction download to roughly 3,000 transactions. For credit cards, BoA limits the available history to about 12 months, with the earliest data starting from April 2021. Active business accounts can hit the 3,000 cap quickly; for those cases, multiple downloads with date ranges are required, or PDF statement conversion (Method 4) becomes more practical.

How many years of Bank of America statements are available online?

Bank of America keeps up to 7 years of eStatements available through online banking and the mobile app. To access them, log into bankofamerica.com, go to Statements & Documents, select your account, then select the month. The Activity-page download for structured data covers a significantly shorter window, varying by account type.

Why do Bank of America statements use two columns for transactions?

Bank of America statements present debits and credits in separate columns (Withdrawals and Deposits) rather than as a single signed amount. This is intentional readability formatting, but it causes problems for CSV importers that expect a single Amount column with positive or negative signs. Most accounting tools need debits and credits combined into one signed column for import. Method 4 dedicated converters handle this automatically. For Methods 1, 2, and 3, you'll need to merge the columns manually in Excel before importing.

Can I bulk-download multiple Bank of America statements?

No. Bank of America does not offer bulk-download for statements. Each statement must be selected and downloaded individually. For 12 months of statements, that's 12 separate clicks. Dedicated converters that accept batch uploads (Method 4) are the practical workaround for year-end or multi-month conversion work; you still have to download each PDF individually, but the conversion happens in one batch.

Will Power Query work on Bank of America statement PDFs?

Power Query works for simple single-account BoA checking statements on Windows from 2019 or newer. It typically struggles with BoA's two-column debit/credit layout (requires manual merging), the Daily Balance Summary table at the end (gets mixed into transaction extraction), embedded check images (disrupt table boundaries), and pre-2019 BoA statements that used a legacy PDF generator. Power Query is not available on Mac. Method 2 in this guide walks through the steps.

What's the easiest way to convert multiple Bank of America statements at once?

Dedicated bank statement converters handle batch uploads natively. SendItSheets, DocuClipper, CapyParse, Bankstatemently, LedgerBox, and others all accept multiple PDFs in a single upload. Power Query and Adobe Acrobat are designed for single-file processing; converting 12 monthly statements with them requires running the workflow 12 times. For year-end work across multiple months, batch processing typically saves several hours.

Can I import Bank of America statements directly into QuickBooks?

Yes, via two paths. (1) BoA's native download offers QBO (QuickBooks Web Connect) format for recent transactions. Import directly via Banking → Upload transactions in QuickBooks Online. (2) For older PDF statements, convert first using Method 4; most dedicated converters output QBO directly. Or use CSV upload in QuickBooks Online and map columns manually after merging the two-column debit/credit format.

Are scanned Bank of America statements supported?

Native BoA PDFs downloaded from bankofamerica.com are digital and work with most methods. Scanned or photographed paper statements require OCR before conversion. Power Query and basic Adobe export struggle with scanned files; dedicated converters with OCR built in (Method 4) handle them better. Note that pre-2019 BoA statements use a legacy PDF generator that places text elements at irregular positions, making table detection harder even for digital PDFs.

What is the Daily Balance Summary section in Bank of America statements?

Bank of America includes a Daily Balance Summary table at the end of statements showing the closing balance for each day of the statement period. This is not a list of transactions; it is a separate summary. Many generic PDF-to-CSV tools mistakenly extract this summary as if it were transaction data, producing duplicate or confusing output. Account-aware converters skip this section automatically.

Need a dedicated converter? Try SendItSheets free

If Method 4 fits your situation, SendItSheets is built for bookkeepers, batch statement processing, year-end catch-ups, and BoA's specific layout challenges. 10 free pages monthly, no credit card required.

Try SendItSheets Free