Banks / United States
Convert Bank of America statements to Excel
Turn a Bank of America PDF statement into Excel, CSV, a QuickBooks/Xero import file or OFX. Each row is checked against the balance printed on the statement, so you know nothing was dropped.
Statements
| File | Pages | Transactions | Status | Actions |
|---|
| Reviewed | Date | Description | Out | In | Balance | Check | Actions |
|---|
Something wrong with this result? Report a problem
What TiedOut handles in United States statements
- MM/DD dates (often without the year on each row)
- A single Amount column with withdrawals shown as negatives, or separate Deposits and Withdrawals sections
- Descriptions that wrap onto two or three lines are joined back into one cell
- Multi-page statements, including brought-forward and carried-forward balances between pages
- Scanned statements, read with OCR and then checked the same way
Questions
How do I convert a Bank of America statement to Excel?
Download the statement PDF for your checking or savings account from Bank of America online banking, then drop it into the box above. When the conversion finishes, check the verdict and download the Excel file.
Can I import the transactions into QuickBooks Online, Xero or Wave?
Yes. Choose the QuickBooks/Xero CSV (date, description and a signed amount) or the OFX file, then use your software's bank statement import.
What if a row doesn't tie to the balance?
It's marked with a red cross and the expected and printed balances, so you can correct one cell instead of re-checking the whole statement. If a Bank of America layout gives consistent trouble, tell us and we'll add support.
Other banks in United States
ChaseWells FargoCitibankCapital OneU.S. BankPNC BankTruistTD Bank
TiedOut is not affiliated with or endorsed by Bank of America.