Bank of America statement to Excel
Bank of America splits a statement into deposits, withdrawals, checks and fees. Here they become one list in a spreadsheet, with signs the right way round and a balance check.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Statement not read correctly, or something broke? Tell us
Your statement never leaves your device
How to do it
- Sign in to Bank of America online banking or the app, open the account and choose Statements & Documents. Download the statement as a PDF.
- Choose the PDF here. Every page is read, including descriptions that run over two lines.
- Look at the check line: if the balances add up, no transaction is missing or extra.
- Click "Download Excel" or "Download CSV".
Tips
- Amounts under "Deposits and other additions" come out positive, those under "Withdrawals and other subtractions", "Checks" and "Service fees" negative, even when the PDF prints them without a minus sign.
- Section totals such as "Total deposits and other additions" are skipped, so nothing is counted twice.
- Checked on sample statements laid out like Bank of America checking statements: every transaction was read and the balances added up.
Questions
Why is the order different from my PDF?
Rows keep the order of the PDF, section by section: first deposits, then withdrawals, then checks. Sort by the Date column in Excel to see them day by day.
Is my statement uploaded anywhere?
No. Your browser reads the PDF and makes the Excel file on your device. Nothing is sent to a server, there is no account to create and no page limit.
What if the balance check fails?
The table marks the rows where the balance chain breaks. Usually one column was read the wrong way: change its type in the table header, or the Amounts setting for a card, and the check runs again.
Does it work with a scanned or photographed Bank of America statement?
No. It needs the digital PDF you download from online banking, which has the text inside. A scan or a photo is only a picture.