Convert Comerica CSV to QuickBooks (.QBO)
Works with Comerica CSV and Excel exports Nothing uploaded
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.
A typical Comerica export has columns like Date, Description, Debit, Credit, Balance and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Comerica statements into QuickBooks
- Export your transactions from Comerica 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.
Comerica-specific things to watch for
- Web Connect/Direct Connect may exist, but isn't guaranteed. Comerica has long offered QuickBooks transaction download, yet availability depends on your account type and QuickBooks version; CSV conversion is the dependable fallback.
- Separate Debit and Credit columns. Comerica often splits money out and money in into two columns rather than one signed Amount; QBO Maker merges them into the single signed value QuickBooks expects.
- Running Balance column. A per-row Balance rides along and is not a transaction, QBO Maker drops it so you don't import phantom entries.
- Multiple routing numbers by state. Comerica uses different routing numbers across Michigan, California and Texas; the Detroit/Michigan number is 072000096, so confirm yours matches your account.
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, Comerica's routing number is often 072000096, which we prefill when you open the converter from this page.
Frequently asked questions
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 your Comerica statement now
Free, in your browser, nothing uploaded. We will prefill the Comerica routing number for you.
Open the converter