How to Convert Bank of America Statements to CSV or Excel

Why Convert Bank of America Statements?

Bank of America (BofA) is the second-largest bank in the United States, serving approximately 69 million consumer and small business clients. Their PDF bank statements are a critical source of financial data for bookkeepers, accountants, and individuals managing personal or business finances. Manually transcribing transaction data from a BofA PDF into a spreadsheet is time-consuming and invites errors — especially for accounts with dozens of transactions per month. BankRead automates the entire process, extracting every transaction from your Bank of America statement PDF and producing a clean CSV or Excel file in seconds.

Understanding the Bank of America Statement Format

Bank of America checking and savings statements use a portrait PDF layout. The transaction table lists entries by date with columns for Date, Description, Amount, and Running Balance. Deposits and withdrawals appear together in chronological order. The header section shows the account number (partially masked), statement period, beginning balance, ending balance, and total deposits/withdrawals for the period. BofA credit card statements have a separate layout: a summary section at the top, followed by transactions grouped into 'Purchases,' 'Payments and Other Credits,' and 'Fees and Interest Charged,' each with Date, Description, and Amount.

How to Convert with BankRead

Follow these steps to convert your Bank of America PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Bank of America online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your Bank of America Statement PDF

1. Log in to Bank of America Online Banking at bankofamerica.com or through the BofA mobile app.
2. Navigate to the account from your accounts overview.
3. Click 'Statements & Documents' in the account menu.
4. Select the statement period you need — BofA stores eStatements for up to 7 years.
5. Click 'Statement' (PDF icon) to download the file to your computer.

What Data Gets Extracted

BankRead extracts the following fields from your Bank of America statement:

• Transaction date (posted date as shown on the statement)
• Description / payee (e.g., 'PURCHASE AUTHORIZED ON 01/15 TARGET T-1234 CHICAGO IL')
• Amount (combined debit/credit column on checking; separate sections on credit cards)
• Running balance (after each transaction on checking statements)
• Check number (when a check clears, the number is included)
• AI-assigned category (e.g., Retail Shopping, Groceries, Subscription, Income)

Export Options

Once your Bank of America statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for Bank of America Statements

• BofA checking statements list deposits and withdrawals together in chronological order — BankRead extracts them as-is with amounts correctly signed.
• BofA credit card statements group transactions by type (Purchases, Payments, Fees). BankRead combines all sections into a single chronological list.
• Check images may be included in the PDF appendix. These image pages are automatically skipped during extraction.
• Multi-page statements with high transaction volumes (common for business accounts) are handled in a single upload.
• Bank of America's 'Online and Mobile Banking Activity' description format includes the authorization date and merchant location, which is fully captured in the extracted description.

Common Issues and Solutions

• BofA credit card statements separate purchases, payments, and fees into distinct sections. BankRead merges them chronologically so your export has a unified view.
• Some BofA statements include a 'Daily Balance Summary' section — this informational table is not extracted as duplicate transactions.
• BofA Merrill Edge investment account statements are not banking statements and may have different extraction results. Checking and savings accounts are fully supported.

Frequently Asked Questions