Convert Bank of America statements to Excel and CSV
To convert a Bank of America statement to Excel or CSV, upload the PDF (or a scan or photo) to statement.work and export every transaction as a row with date, description, amount and running balance, merged into one chronological list.
Not affiliated with Bank of America. statement.work is an independent tool. Bank of America is a trademark of its owner and is named here only to describe the statements this page is about.
About Bank of America statements
Bank of America is one of the largest banks in the US, headquartered in Charlotte, North Carolina, with a large base of consumer, small business and credit card customers. Its statements are a staple of US bookkeeping, especially for small businesses that keep business checking alongside personal accounts.
What the statements typically contain
- An account summary with the beginning balance, total deposits and other additions, total withdrawals and other subtractions, and the ending balance.
- Transactions organized by type, such as deposits, withdrawals, checks and service fees, often with a subtotal for each group.
- Dates in month/day form.
- On many statements, a separate list of checks with check numbers.
Statement design varies by account type and changes over time, so check against your own documents.
Common conversion problems
- Typed sections with subtotals. Subtotal lines look like transactions when copied, and double-count if they aren’t removed.
- Checks without payees. A check line usually shows only the number, date and amount. Matching it to a payee needs your own records.
- Fees in their own section. Service fees can sit apart from other withdrawals and are easy to overlook. statement.work flags fee spikes. See spotting hidden fees.
- Merging back into date order. Reconciliation is easier with one chronological list than with several typed lists.
How to convert it
- Download the statement PDF, or use a scan or photo.
- Upload to statement.work.
- Review the single, date-ordered table of transactions.
- Export as CSV for import, or Excel for review.
- Check the totals against the account summary.
Reconciling afterwards
Because the export is one chronological list with a running balance, reconciling against your books is a matter of matching rows, not reassembling sections. The reconciliation guide shows a quick routine. If clients also bank with Chase or Wells Fargo, their exports line up column for column.
Questions
How do I get a Bank of America statement as a PDF?
Statements are generally available to download from the statements and documents area of Bank of America online banking. Download the PDF and upload it to statement.work.
How are checks handled?
Checks usually appear with a check number and amount but not the payee. statement.work extracts them like any other transaction; add the payee from your check register if you need it.
Is statement.work affiliated with Bank of America?
No. statement.work is independent and is not affiliated with or endorsed by Bank of America.