Convert Bank of America statements to Excel, CSV, QBO & OFX
Drop a Bank of America PDF statement below. It is converted on your computer, reconciled against the printed balances, and exported in the format your accounting software imports.
About Bank of America statement layouts
Typical layout: Deposits, withdrawals and checks in separate sections. Transactions are grouped under headings such as "Deposits and Additions" and "Electronic Withdrawals", with a daily balance table at the end. Rowledger reads the section headings to assign the sign, skips the daily balance table, and checks the totals against the statement summary.
- Sections are titled "Deposits and other additions", "Withdrawals and other subtractions", "Checks" and "Service fees"; amounts are unsigned and the sign comes from the section.
- Check rows list the check number, date and amount in a compact grid; Rowledger keeps the check number as the reference.
- The "Daily ledger balances" table is skipped rather than treated as transactions.
- Dates on Bank of America statements are read as month/day (MM/DD); Rowledger confirms the order from the dates themselves and defaults the export to the matching format.
- Currency: USD. Amount columns are exported as plain numbers; the currency is recorded in the Summary sheet and OFX header.
Common products: Advantage Plus, Advantage SafeBalance, Business Advantage.
How to download a Bank of America statement as PDF
Log in → Accounts → Statements & Documents → select the statement month → Download PDF.
Menus change; if the path differs, search your bank's help centre for "download statement PDF".
Step by step
- Download the statement PDF (or scan the paper statement at 200–300 dpi).
- Drop it into the converter above. Conversion takes about a second per statement; OCR a few seconds per page.
- Check the badge. Reconciled means every row adds up to the printed balances.
- Choose an export: CSV or Excel (free); QBO, OFX or QIF (Pro) for accounting software.
Importing into accounting software
- QuickBooks Online (CSV) · QuickBooks Desktop (QBO)
- Xero (OFX or CSV) · Wave (OFX)
- Excel with real dates and numbers
Questions about Bank of America statements
Is my Bank of America statement uploaded?
No. Bank of America statements are converted by code running in your browser. Nothing is sent to Rowledger or any third party, and the conversion works with the internet disconnected.
What format should I export for QuickBooks or Xero?
For QuickBooks Online use the 3-column CSV preset or QBO; for QuickBooks Desktop use QBO; for Xero use OFX or the Xero CSV preset; for Wave use OFX. All are produced from the same conversion.
Does it handle Bank of America credit card statements too?
Yes. Card statements are detected from the summary block and use the card sign convention (charges out, payments in), verified against previous and new balance.
What if my Bank of America statement is a scan?
Drop it anyway. Rowledger runs OCR in your browser, then applies the same balance verification so OCR slips are flagged on the row. Free covers the first two pages per scan; Pro is unlimited.
Other banks in United States
Rowledger is independent software and is not affiliated with or endorsed by Bank of America. Layout notes describe statements we have tested or that customers have reported; formats change over time.