Bank of America
Download Bank of America business statements (PDF) and convert to Excel
Updated January 2025 · 6 min read
Bank of America business accounts (including CashPro) often provide PDF statements that are more reliable than CSV exports, especially for complex activity with ACH batches and wire transfers.
Download a Bank of America PDF statement
- Sign in to Bank of America Business Online or CashPro.
- Go to Statements & Documents or Account Services.
- Select the account and statement period.
- Download the monthly PDF statement (not the transaction list).
- Verify the PDF includes opening/closing balances and all transaction details.
Convert to Excel for reconciliation
- Upload the PDF to StatementScribe for transaction extraction.
- Bank of America statements may include ACH batches—validate batch totals match individual transactions.
- Export to Excel with columns: date, description, amount, balance, reference number.
Common challenges
- CashPro accounts may have complex activity formats with multiple transaction types.
- ACH batches may appear as summary lines—request detailed transaction files if needed.
- Wire transfers may have separate fees that appear on different statement pages.
Tips for accountants
- PDF statements from BofA are more consistent than CSV exports which can vary by account type.
- When clients can't share account access, request PDF statements directly from the bank.
- For multi-account clients, download separate PDFs per account for cleaner reconciliation.
FAQ
Are PDF statements better than CSV exports?
PDF statements from BofA are more consistent than CSV exports which can vary by account type. PDFs also include balances automatically.
How do I handle ACH batches?
ACH batches may appear as summary lines. Request detailed transaction files if needed, or validate batch totals match individual transactions.
Related reads
- How to reconcile when your client won't share logins (PDF statement workflow)
When clients won't share banking credentials, PDF statements become your primary data source. Here's how to reconcile effectively.
- Business banking quirks: positive pay, lockbox, ACH batches break spreadsheet imports
Business banking statements include features that can break standard imports. Here's how to handle them properly.