Upload any Bank of America statement PDF — Advantage Plus Banking, Advantage Relationship Banking, Business Advantage, Business Fundamentals, or a Merrill cash management statement — and get a clean Excel file with one row per transaction, running balance preserved, deposit detail handled.
Convert your BofA statement — free
BofA statements split activity into separate sections — Deposits and Other Additions, Withdrawals and Other Subtractions, Checks, Service Fees, Daily Ledger Balances. Copy-paste into Excel and you get five disconnected blocks of transactions instead of one continuous ledger. The Daily Ledger Balances section at the end repeats balance data already shown line-by-line, which clutters any naive extraction.
Business Advantage statements add deposit detail pages listing every check and ACH credit deposited that period. Multi-account statements (linked checking + savings) bundle multiple ledgers in one PDF. Generic PDF-to-Excel converters either miss the section structure entirely or pull each section as a separate orphan table.
PDFExcel reads BofA's section structure automatically. Deposits, Withdrawals, Checks, and Service Fees merge into one chronological transaction list with the section preserved as a column. Multi-account statements tag each transaction with the source account number so a linked checking + savings PDF comes back as one workbook with both ledgers. Running balance reconciles end-to-end against the Daily Ledger Balances section.
Works on every BofA product: Advantage Plus / Advantage Relationship / Advantage SafeBalance / Premium Rewards Banking on the personal side; Business Advantage Fundamentals / Business Advantage Relationship / Premium Business Checking on the business side; plus Merrill Edge cash management statements. Drop the export into QuickBooks via PDF import, Xero, or your reconciliation worksheet. Built-in OCR handles scanned BofA statements automatically.
The model knows BofA's section structure — Deposits and Other Additions vs Withdrawals and Other Subtractions vs Checks vs Service Fees — and merges them into one chronological ledger while preserving the section tag for filter-driven reconciliation.
Most PDF tools either treat BofA's section structure as a single grid (and fail) or extract each section as an orphan table (and require manual stitching). PDFExcel handles BofA's layout natively.
Section tag preserved as a column. Multi-page deposit detail and check listings consolidated into one chronological transaction list.
| # | Date | Description | Section | Debit | Credit | Running Balance | Check # |
|---|---|---|---|---|---|---|---|
| 1 | 03/01/2025 | Beginning Balance | — | $32,184.55 | |||
| 2 | 03/03/2025 | ZELLE FROM CASCADE LLC — INVOICE 4421 | Deposits | $5,840.00 | $38,024.55 | ||
| 3 | 03/05/2025 | CHECK #2188 — VENDOR PAYMENT | Checks | $1,420.00 | $36,604.55 | 2188 | |
| 4 | 03/08/2025 | ATM WITHDRAWAL — 100 N MAIN ST CHARLOTTE NC | Withdrawals | $300.00 | $36,304.55 | ||
| 5 | 03/12/2025 | ACH CREDIT — STRIPE PAYMENTS | Deposits | $8,210.00 | $44,514.55 | ||
| 6 | 03/14/2025 | MONTHLY MAINTENANCE FEE | Fees | $30.00 | $44,484.55 |
BofA is the second-largest U.S. consumer bank — almost every accounting practice has at least one client on a BofA business or personal account. PDFExcel is built for the people doing the actual reconciliation.
Restaurant client on BofA Business Advantage Fundamentals. Monthly statement runs 18 pages with deposit detail. Convert to QuickBooks-ready CSV, import in 5 minutes per month.
BofA Advantage Plus client never set up bank feeds. Twelve months of statements → Excel batch → trial-balance prep.
Pulls quarterly Merrill Edge cash management statements for HNW client portfolio review. Convert all to Excel for tax-prep and contribution-tracking workflow.
Yes. The model merges sections into one chronological transaction list with the section preserved as a column. Choose to keep the column for filter-driven analysis, or drop it for a clean ledger view.
Yes. The running balance is preserved transaction-by-transaction across page breaks and reconciles to the printed ending balance. Daily Ledger Balances section is read for verification but not duplicated as separate rows.
Yes. Merrill cash management statements use a different layout than BofA checking (more brokerage-statement-like) but extract correctly with the same workflow. For Merrill investment statements with security holdings, see brokerage statement conversion.
Built-in OCR runs automatically when there's no embedded text layer. Native BofA PDFs (downloaded from bankofamerica.com) extract at near-perfect accuracy; scanned, faxed, or printed-and-rescanned copies trigger OCR with no extra setup.
Yes. Export as CSV with QuickBooks' standard columns (Date, Description, Amount, Memo) and import via Banking → File Upload. The dedicated QuickBooks PDF import flow pre-formats BofA exports to QBO's exact schema so you skip column mapping.