How to Import Bank of America Transactions into QuickBooks
Jul 16, 2026 · Updated Aug 21, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Short answer: Bank of America no longer hands out a QBO file. It ended its OFX service on September 30, 2025, which retired Direct Connect and Web Connect together, so the QuickBooks (.qbo) and Quicken (.qfx) downloads are gone from bankofamerica.com. Two routes are left: the live bank feed, which backfills only about 90 days, and CSV, which reaches roughly the last 12 to 18 months and does not work in QuickBooks Desktop as a Web Connect import. For an older period, a closed account, or a real .qbo file, converting the PDF statement is now the only way to get one.
Can you import Bank of America transactions into QuickBooks?
Yes, but the routes changed in 2025. A live bank feed still connects Bank of America to QuickBooks Online and refreshes automatically, backfilling about 90 days. The bank's own Download transactions option now produces CSV only, because the QBO and QFX formats were retired on September 30, 2025. A converted PDF statement produces a genuine Web Connect .qbo for any period, including everything past the search window, which is what QuickBooks Desktop still needs. The route you pick decides how much history you get and whether Desktop is an option at all.
| Route | File or method | History reach | Desktop? |
|---|---|---|---|
| Live bank feed | Automatic sync | About 90 days on first connect | Online focus |
| BofA activity download | CSV or Excel only (.QBO and .QFX retired Sept 30, 2025) | About 12 to 18 months of searchable activity | Only via CSV import |
| Converted PDF statement | A real .QBO Web Connect file | Any period, up to 7 years | Yes |
How to download a Bank of America QBO file for QuickBooks
You cannot, not from the bank. Bank of America switched off its OFX service on September 30, 2025, and the QuickBooks (Web Connect) option disappeared from the Activity download menu along with Quicken (QFX) and Direct Connect. What is left on that screen is CSV and Microsoft Excel. QuickBooks Online can take the CSV through Transactions, Bank transactions, Upload from file. QuickBooks Desktop still expects a Web Connect file at File, Utilities, Import, Web Connect Files, so Desktop users need a converted .qbo instead.
The second catch is the search window. BofA's activity export reaches only the transactions the online search still returns, roughly the last 12 to 18 months on the web site. The moment you need an older month, the download comes back empty even though the statement for that month is still available as a PDF. The full walkthrough of the download options is in how to export Bank of America transactions to CSV or Excel.
How do I import older Bank of America history into QuickBooks?
Through the PDF statement. Bank of America keeps monthly statements under Statements and Documents for about seven years, long after the activity search stops returning those transactions. The statement is also the only record left once an account is closed. Convert the PDF with the bank statement to QBO converter, choose QBO, and you get a Web Connect file you import exactly like a bank download used to work, for any month BofA still shows. Since the bank stopped issuing .qbo files in September 2025, this is the only remaining source of one. Because the statement carries no search window with it, a period from three years ago imports the same way as last month.
How to import a Bank of America statement into QuickBooks step by step
- Find the statement. On bankofamerica.com open Statements and Documents and download the PDF for the period you need.
- Convert it to QBO. Drop the PDF into the converter and pick QBO. QFX, OFX, CSV, and Excel sit next to it if a different target needs them.
- Import it. QuickBooks Online: Transactions, Bank transactions, Upload from file, then choose the Bank of America account. Desktop: File, Utilities, Import, Web Connect Files.
- Review and categorize. The transactions land in the For Review queue so your bank rules run and nothing posts blind. Categorizing runs faster when you already track spending in software that reads and codes every charge.
Why does QuickBooks only import 90 days of Bank of America transactions?
Because a new bank feed backfills only about 90 days by design, no matter how much history the bank holds. That is a QuickBooks limit on the feed, not a Bank of America limit. It is the single most common reason a year-end catch-up starts with most of the year missing. The fix is to bring the earlier months in as files: convert the statements and upload them behind the feed. There is more on the backfill rule in why QuickBooks only imports 90 days of transactions.
Does Bank of America charge for QuickBooks?
The bank feed and the CSV and Excel downloads on bankofamerica.com are free on personal and most business accounts. Direct Connect, the paid two-way feed some commercial and CashPro products carried, was retired with the rest of BofA's OFX service on September 30, 2025, so it is no longer an option at any price. QuickBooks Desktop users now import a converted file instead. Converting the PDF statement avoids any feed fee entirely and works the same on either version of QuickBooks.
Avoiding duplicate Bank of America transactions
Duplicates appear when a live feed and an uploaded file overlap. Open the account register, find the oldest transaction the feed brought in, and end your uploaded file the day before it. Load history behind the feed, never on top of it. If you are rebuilding a heavy year, remember a QuickBooks Online upload caps at 1,000 lines and 350 KB per file, so split the year into date ranges under that ceiling. The details are in how many transactions QuickBooks accepts at once.
The short version
Bank of America gives you a free QBO for the roughly 12 to 18 months its activity search still covers, and a PDF archive for about seven years. Use the download for recent months, and convert the statement for anything older, for a closed account, or for QuickBooks Desktop. Import into the Bank of America account, review, and reconcile. You can also take the same statement as a spreadsheet with the Bank of America statement to Excel converter, and the general case for any institution is the bank statement to QBO converter.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required