# Convert Bank of America CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/bank-of-america.html_

Bank of America lets you download account activity from the Activity tab as a CSV or Microsoft Excel file, but the export it hands you is not something QuickBooks will swallow cleanly. The typical CSV uses the headers Date, Description, Amount, and Running Bal., and that trailing balance column, plus a couple of summary rows at the top (Beginning/Ending balance), is exactly what trips up QuickBooks Online's bank-upload mapping screen.While Bank of America does offer a QuickBooks Web Connect (.QBO) download on some accounts, it is frequently greyed out, limited to ~90 days, or simply missing on business and certain card products, which is why so many bookkeepers fall back to the CSV. The problem: a raw BofA CSV needs the balance column stripped, the summary rows deleted, and the date/amount columns mapped by hand every single time.QBO Maker bridges that gap. Drop your Bank of America CSV or Excel file in, and it builds a clean, valid .QBO (OFX) file QuickBooks imports without a mapping dance. Everything runs in your browser, nothing is uploaded to a server. Convert your Bank of America file now.

## Steps

1. Export your transactions from Bank of America online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Does Bank of America let me download a QBO file directly?**
Sometimes. Personal checking accounts often expose a QuickBooks Web Connect (.QBO) option under download, but it is frequently unavailable on business accounts, credit cards, or older history. If the option is greyed out or limited to 90 days, download the CSV instead and run it through QBO Maker to get a clean .QBO.

**Why won't QuickBooks accept my Bank of America CSV as-is?**
Two reasons: the file usually starts with balance summary rows that aren't transactions, and it includes a Running Bal. column QuickBooks doesn't expect. QuickBooks Online's CSV upload also caps at three or four specific columns. QBO Maker strips the noise and outputs a proper OFX/.QBO so there's no manual cleanup.

**What date format does the Bank of America CSV use?**
Bank of America exports dates as MM/DD/YYYY (for example, 06/18/2026). QBO Maker reads this automatically and writes ISO-formatted dates into the .QBO so QuickBooks matches transactions correctly.

**Is my financial data uploaded anywhere?**
No. The conversion happens entirely inside your browser using JavaScript. Your Bank of America transactions never leave your computer, nothing is sent to QBO Maker's servers or stored. You can even validate the output before importing.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.