Convert Bank of America CSV to QuickBooks (.QBO)
Works with Bank of America CSV and Excel exports Nothing uploaded
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.
.QBO QuickBooks accepts. For Bank of America, its dates are usually MM/DD/YYYY, and amounts arrive as a single signed column (negative = money out, positive = money in), both detected automatically.A typical Bank of America export has columns like Date, Description, Amount, Running Bal. and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Bank of America statements into QuickBooks
- Export your transactions from Bank of America online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Bank of America-specific things to watch for
- Summary rows up top. BofA's CSV often begins with Beginning balance / Total credits / Total debits / Ending balance lines before the real transactions, QuickBooks chokes on these, but QBO Maker skips them automatically.
- Running Bal. column. The fourth column is a running balance, not a transaction amount. QuickBooks only wants the signed amount; the converter ignores the balance column for you.
- QBO download is hit or miss. The native Web Connect (.QBO) option is missing or limited on many BofA business and credit-card accounts, leaving CSV as the only practical export.
- Long memo lines. Debit-card and ACH descriptions can be lengthy and include dates inside the text, the converter keeps them intact as the transaction memo.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID, Bank of America's routing number is often 026009593, which we prefill when you open the converter from this page.
Frequently asked questions
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 your Bank of America statement now
Free, in your browser, nothing uploaded. We will prefill the Bank of America routing number for you.
Open the converter