# Convert Comerica CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/comerica.html_

Comerica is a more traditional bank, and its business online banking has historically supported QuickBooks Web Connect and Direct Connect, so depending on your account and QuickBooks version, you may be able to pull a .QBO directly. In practice, though, plenty of Comerica customers fall back to the CSV/spreadsheet download: Direct Connect can carry a fee, Web Connect support varies by product, and the simplest export is often a plain transaction CSV.When you're on the CSV path, QuickBooks gets fussy. QuickBooks Desktop won't import CSV at all (it needs .QBO/Web Connect), and QuickBooks Online's importer can misread Comerica's column layout, debit/credit split or date format. QBO Maker takes your Comerica CSV and rebuilds it as a clean OFX/QBO file QuickBooks reads natively, and it stamps in Comerica's routing number so Desktop can auto-match the import.The conversion runs entirely in your browser; your Comerica transactions are never uploaded. If your Web Connect download isn't available or won't import, convert the CSV here instead and get a proper .QBO in seconds.

## Steps

1. Export your transactions from Comerica 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.

**Doesn't Comerica already support QuickBooks Web Connect?**
It can, Comerica's business online banking has supported Web Connect and Direct Connect downloads. But availability varies by account and QuickBooks version, and Direct Connect may carry a fee. When the .QBO download isn't available or won't import, convert your Comerica CSV with QBO Maker instead.

**Why does my Comerica CSV import wrong into QuickBooks Online?**
QuickBooks Online expects a clean 3- or 4-column layout, while Comerica's CSV uses separate Debit/Credit columns plus a running Balance. The mapper misreads it, so amounts land on the wrong side. Converting to .QBO removes the mapping step entirely.

**Which Comerica routing number should I use?**
Comerica has state-specific routing numbers, Michigan/Detroit is 072000096, with different numbers for California and Texas. Use the one tied to where you opened the account so QuickBooks Desktop matches the .QBO correctly.

**Is the conversion private?**
Yes. QBO Maker processes the file in your browser; your Comerica data is never uploaded or stored. Want to double-check the result? Run it through the validator before importing.

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