Guide · Bank of America
Convert Bank of America statements to Excel, CSV or QuickBooks®
Download your Bank of America statements, drop them into Pennyrow, and get every transaction as a clean spreadsheet, with a check that each statement adds up. Free. Your statements are read inside your browser; we never upload, receive, see or store them.
Step 1: download your statements from Bank of America
- Sign in to Online Banking.
- Hover over Accounts and click Statements & Documents.
- Choose the account and year.
- Click a statement to open or download the PDF.
- Sign in to the Mobile Banking app and open the Menu.
- Tap Statements and Documents.
- Choose the account and year.
- Tap a statement to open it.
Bank of America's pages give different numbers: recent statements (up to about 6 years for banking, 3 years for cards) can be opened right away, and older ones up to 7 years can be requested online.
Transaction downloads
Bank of America also lets you download transactions as a file. Pennyrow reads CSV, OFX and QFX files:
- Transaction download: Open the account and click Download on the Activity tab, then pick a date range and file type.
PDF statements are usually the better choice for catching up a year: each one has opening and closing balances, so Pennyrow can check every month adds up.
Good to know
- Requested older statements arrive in 24 to 36 hours and stay downloadable for 7 days.
- Mailed copies of requested statements may cost $5 each, so download the PDF instead.
Checked October 13, 2026 against Bank of America's help pages: promotions.bankofamerica.com/digitalbanking/instructions/manage-statements-documents, www.bankofamerica.com/credit-cards/credit-card-account-information-faq, www.bankofamerica.com/smallbusiness/online-banking/quickbooks/faqs. Banks move menus around; if a step has changed, the help page has the current one.
Step 2: drop them into Pennyrow
- Open Pennyrow and choose your files, or drag them in. A whole year at once is fine, and you can mix Bank of America with your other banks and cards.
- Each statement gets a balance check: opening balance plus money in, minus money out, should equal the closing balance. You see "✓ Balanced", or which row is off and by how much.
- Catch-up checks look across all your files: missing months, statements that don't follow on from the last one, the same transaction in two files, and transfers between your own accounts (including card payments) so they aren't counted twice.
- Export: Excel (.xlsx), CSV, a QuickBooks Online bank CSV, a QuickBooks Desktop .iif file, or OFX.
If a Bank of America statement doesn't read right
- Pennyrow reads statement layouts with general rules, not a Bank of America-specific template, and it hasn't been tried on every Bank of America layout. The balance check is how you know: if a statement doesn't balance, Pennyrow shows the row that's off so you can fix it.
- Scanned or photographed statements can't be read (there's no OCR). Download the PDF from Bank of America's site instead of scanning a paper copy.
- Password-protected PDFs open with your own password, used only in that tab.
- If a layout keeps failing, tell @minsoesantun which Bank of America account type it was. Please don't send the statement itself.
Questions
Is it free?
Yes. Converting statements, the catch-up checks and every export are free.
Does my Bank of America statement get uploaded?
No. The converter page is locked so it can't make network requests, and it works with Wi-Fi off once it's open. Here's how to check that yourself.
Do I need to sign in to Bank of America through Pennyrow?
No, and you never should. You download the statements yourself; Pennyrow never asks for a bank login.
Does it make a .qbo (Web Connect) file?
Not yet. For QuickBooks Online use the bank CSV export; for QuickBooks Desktop use the .iif export.
Other banks and cards
Any bank or card with text PDF, CSV, OFX or QFX statements can work; these guides cover where to download them.