US
About Bank of America statements
Bank of America is one of the biggest US retail banks, with branches in most states. The file you want is the official statement PDF from Online Banking, under Statements & Documents, not a printed mini-statement or a transaction search.
Bank of America groups the month into Deposits and other additions, Withdrawals and other subtractions, and Checks, with daily ledger balances at the end. That's exactly the detail that gets scrambled when you paste a PDF into a spreadsheet, and exactly what the converter preserves, column by column.
Dates come through as MM/DD/YYYY and the figures stay in USD (US dollars), so the converted file matches what you'd expect locally. A scanned statement is no problem; it's read with OCR into the same layout, with the balance checked either way.
After that you're just reconciling in QuickBooks; the awkward part of getting the data out of the PDF is handled.
Why people convert Bank of America to QuickBooks
Not every Bank of America account is worth wiring a live feed to — a closed account, a rarely-used one, a single month you need on file. Converting the PDF is quicker than connecting a feed for a one-off, and it imports the same way.
It's handy mid-year too, not just at catch-up. A one-off Bank of America account, a statement the feed skipped, or a closed account you still need on file — convert the PDF and it goes into QuickBooks like any other import.
Import a Bank of America statement into QuickBooks
QuickBooks Online takes a CSV; QuickBooks Desktop takes a .qbo Web Connect file.
- Convert the PDF above. For QuickBooks Online download the QuickBooks CSV; for Desktop download the QBO.
- QuickBooks Online: Banking → Bank transactions → Link account → Upload from file.
- Pick the CSV, map Date / Description / Amount, choose the account, and import.
- QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then select the .qbo.
infoOne honest caveat
The QBO file carries a placeholder bank id, so QuickBooks Desktop can reject it with an OL-301 error ("not a participating financial institution") until you set your own bank's id. For a reliable import, use the QuickBooks CSV in QuickBooks Online instead — we don't claim the QBO will import everywhere.
The totals are checked first
Before the QuickBooks-ready file downloads, the running balance is checked end to end. A missing or doubled line is caught at this step, not after it's already in QuickBooks.
Frequently asked questions
How does the Bank of America export get into QuickBooks?expand_more
In QuickBooks Online the CSV imports cleanly under Banking → Upload from file. The Desktop QBO can hit an OL-301 error ("not a participating financial institution") until you set your own bank's id — so for Online, stick with the CSV.
How is a Bank of America statement laid out?expand_more
Bank of America groups the month into Deposits and other additions, Withdrawals and other subtractions, and Checks, with daily ledger balances at the end. The converter reads each of those into its own column, so the QuickBooks-ready file imports into QuickBooks cleanly.
Where do I download the Bank of America statement?expand_more
From Online Banking, under Statements & Documents. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Can I use a photo of my Bank of America statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
What does it cost to start?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the QuickBooks file needs a free sign-in.