To convert a Bank of America statement PDF to Excel, download the statement from BofA online banking, open it in Bank Statement PDF Converter on macOS, review the extracted transaction table against the original, and export to XLSX or CSV. The converter handles BofA's combined checking/savings/credit statements, strips the Total activity summary, and preserves the running balance column — no template setup and no copy-paste cleanup.
1. Download the BofA statement
Bank of America typically keeps up to seven years of statements online for most retail and business accounts (verify with your account's statement history). From a Mac browser:
- Sign in to bankofamerica.com.
- Open the account tile — checking, savings, or a credit card.
- Go to Statements & Documents.
- Pick the month you need and download the PDF.
If you have multiple BofA accounts, the bank typically produces a combined statement per cycle — a single PDF with checking, savings, and sometimes credit card activity stitched together. Download it as one file; the converter handles every section.
For statements older than the online window, BofA's customer service can provide archived copies.
2. What a Bank of America statement looks like
BofA statements have a few layout quirks that matter when you convert them:
- Total activity summary page. Near the front of each account section, BofA prints a "Total activity" block that sums deposits, withdrawals, and fees for the cycle. It's useful reading for a human but it's not transaction data — and it's the single biggest copy-paste trap if you try to do this by hand.
- Account breakdown sections. A combined statement stacks each account vertically: Advantage Relationship Checking, then the linked Savings, then any credit card. Each section has its own transaction table.
- MM/DD/YY dates. BofA prints a short-year date on each row. The converter normalizes to full
YYYY-MM-DDusing the statement period. - Running balance column. Checking statements include a running balance to the right of every posted transaction. Credit card statements do not — card statements show new purchases and payments but not a running "balance owed" per row.
- QR codes and disclosure blocks. Many BofA statements include a QR code at the bottom of pages (linking to service options) and multi-page disclosure text at the end. The converter ignores both.
- Deposits, withdrawals, fees. Checking statements separate Deposits and other additions, Withdrawals and other subtractions, Checks, and Service fees — each as its own sub-table.
3. Open the PDF in the Mac app
Install Bank Statement PDF Converter from the Mac App Store (macOS 13.5+). Drag the BofA statement onto the window, or use File → Open.
For a combined statement, each account section — checking, savings, credit card — is picked up as its own block. The original PDF renders on the left, the extracted table on the right, and you can scroll both together for verification.
4. BofA quirks the converter handles
- Total activity stripped. The Total activity block is recognized as a summary and excluded from the row output. You won't see its numbers duplicated in your spreadsheet.
- Sub-section headers merged. "Deposits and other additions," "Withdrawals and other subtractions," and similar section titles are removed from the rows. Their categorization is retained as an optional column.
- Signed amounts. BofA prints withdrawals as unsigned positives under a "Withdrawals" header. The converter converts them to signed negatives so one
Amountcolumn works in Excel or your bookkeeping app. - Running balance preserved. For checking statements the Balance column is kept intact — useful for reconciliation against your ledger.
- Multi-line descriptions reassembled. BofA wraps long descriptions (Zelle, ACH, merchant address lines) across multiple lines in the PDF. The converter stitches them back into one description cell.
- QR codes and disclosure text ignored. Neither shows up as a ghost row.
5. Review, then export
In the side-by-side preview, check the first row of each account section, one multi-line description in the middle of the statement, and the last row on the last transaction page. Toggle transactions-only mode to hide the account summary block, Total activity, and disclosure text so you see only the rows that will export.
When it looks right:
- Click Export.
- Choose XLSX for Excel or Numbers, or CSV for bookkeeping imports.
- Save next to your other month-end files.
Here's a sample of how a BofA checking row renders in the CSV output:
Date,Description,Amount,Balance
2026-04-02,"Online Banking transfer from SAV 1234",750.00,3210.55
2026-04-05,"BKOFAMERICA ATM WITHDRWL 123 MAIN ST",−100.00,3110.55
2026-04-09,"ZELLE PAYMENT TO JORDAN CONF# A1B2C3",−85.00,3025.55
2026-04-12,"PAYROLL DES:DIR DEP ID:XXX INDN:YOU CO:EMPLOYER",2980.12,6005.67
2026-04-21,"CHECKCARD 0418 WHOLE FOODS MKT",−62.44,5943.23Dates are normalized, amounts are signed, and the running balance column comes straight through.
6. Tips for specific BofA products
- Advantage SafeBalance, Advantage Plus, Advantage Relationship. Same layout across the retail checking tiers. The converter treats them identically.
- Bank of America Savings. Usually appears as the second section of a combined statement. Transaction volume is low but the format matches checking.
- Business Advantage Fundamentals / Relationship Banking. Business statements add wire, ACH, and service-fee detail sections. Keep the section column in the export if you reconcile fees separately.
- BofA Customized Cash Rewards / Travel Rewards / Unlimited Cash Rewards. Credit card statements. Export carries Date, Posting date, Description, and Amount; no running balance column on card statements.
- Merrill-linked accounts. Preferred Rewards tiers may include a Merrill summary page. That page isn't transaction data and isn't picked up as rows.
7. Batch-converting a year of BofA statements
For year-end or tax prep, drag all twelve statements onto the Mac app at once. Batch mode runs them in a single pass with consistent column structure — every output file has the same Date / Description / Amount / Balance shape, so you can stack them into a master workbook without schema reconciliation.
Scanned BofA statements (common for older archived PDFs) work too — the built-in OCR handles image-based pages at 200–300 DPI.
Related guides
- Convert Chase bank statement PDF to Excel on Mac — the Chase-specific walkthrough.
- Convert bank statement PDFs to Excel on Mac — the general workflow.
- Best bank statement converter for Mac in 2026 — how the options compare.
Convert your BofA statement
Download Bank Statement PDF Converter on the Mac App Store and convert your first Bank of America statement in about a minute. The iPhone & iPad app handles the same statements from Files, Mail attachments, or iCloud Drive.
FAQ
Where do I download my Bank of America statement PDF?
Sign in to Bank of America online banking, open the account, go to the Statements & Documents section, and download the PDF for the month you need. BofA typically keeps up to seven years of statements online for most account types (verify with your account's statement history).
Does the converter handle BofA's combined statement with checking, savings, and credit card together?
Yes. Bank of America often mails one PDF that contains Advantage Relationship Checking, a linked savings account, and one or more credit card summaries. The converter detects each account's transaction table separately and preserves the account identifier so you can split or stack them in the export.
Do I need to strip out the Total activity summary before converting?
No. The Total activity summary page — the one that totals deposits, withdrawals, and fees for the cycle — is not transaction data. The converter detects it as a summary block and excludes it from the row output.
Can I keep the BofA running balance column in my export?
Yes. Bank of America checking statements print a running balance to the right of each posted transaction. That Balance column is picked up into the export, so you can reconcile each line against your ledger without recalculating.
Will it handle Bank of America business statements?
Yes. Business Advantage Fundamentals Banking, Business Advantage Relationship Banking, and Business credit card statements all convert cleanly. Additional sections for wires, ACH, and per-service fee detail are preserved in the output.