Comerica CSV to QBO Converter to Convert a Comerica CSV to QuickBooks

It ended with Comerica's online banking. Fifth Third closed its merger with Comerica on February 1, 2026 and converted the accounts over Labor Day weekend. Comerica Business Connect stopped on Friday, September 4, and customers were moved to Fifth Third Online Banking or Fifth Third Direct on Tuesday, September 8. Any QuickBooks feed pointed at Comerica stopped at that point, and the final Comerica statement covers activity through September 4.

No. Fifth Third's own Quicken and QuickBooks FAQ says Web Connect download is not supported for QuickBooks and that Direct Connect is the supported method. For QuickBooks Desktop that leaves a short runway: Intuit retires Direct Connect at every bank on October 30, 2026, and new enrollments closed on April 30. After that date, a CSV converted to .qbo is the only file route into Desktop for a former Comerica account. QuickBooks Online users can reconnect a bank feed to Fifth Third, and use a converted file for gaps the feed cannot reach.

Export the activity as a CSV from Fifth Third, or pick up a CSV you saved from Comerica before September 4, and drop it into the converter at the top of this page. It reads the date, description, and amount columns, ignores the running balance column, and produces a QuickBooks Web Connect (.qbo) file. Before you download, check the parsed row count and the preview against the CSV. In QuickBooks Online open Bank transactions, reached from Transactions on the older menu or from All apps, then Accounting, on the current one, then choose Link account and Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files.

Sign in to Fifth Third Online Banking, or Fifth Third Direct if you were a Comerica commercial customer, open the converted account, set the date range, and download the activity as a CSV. Start the range the day after the last transaction already in QuickBooks. If your last Comerica download ran through September 4, start the Fifth Third export on September 5 so no transaction arrives twice under two different IDs.

About six months of transactions. Fifth Third says six months of transaction history and 24 months of statements transferred to Fifth Third automatically, and for commercial accounts some Comerica history is available in Fifth Third Direct with more being added over time. Anything older than six months exists only as a statement now, not as a downloadable transaction list, so if you still have Comerica CSV exports from before the conversion, keep them.

Not directly. QuickBooks Desktop does not import a raw bank CSV into an account register in any version; it only accepts a Web Connect (.qbo) file through File, Utilities, Import, Web Connect Files. That is exactly why converting the CSV matters for a former Comerica account, and why it matters more after October 30, when the Direct Connect feed to Fifth Third stops. The CSV to QuickBooks Desktop page walks through the import screen.

QuickBooks Online rejects a CSV when the columns are not mapped to Date, Description, and Amount, when the date format does not match your company file, or when header rows and the running-balance column confuse the mapper. A .qbo removes that guesswork because it already carries structured dates and signed amounts. It does not lift the size limit: QuickBooks Online applies the same 350 KB and 1,000-line upload limit to a .qbo, so a busy account goes in a month or a quarter per file.

On a checking or money market export, deposits and credits come in as positive amounts and withdrawals, checks, and card payments come in as negatives, matching how a bank account posts in QuickBooks. On a business credit card export the sign is flipped so charges increase the balance owed and payments reduce it. The converter keeps whichever convention your source file uses, so check one known deposit and one known payment in the preview before you import.

Comerica exports often include a running balance column next to the amount, which is exactly what confuses QuickBooks when you try to map a raw CSV. The converter ignores the balance column and reads only the transaction amount, so a stray balance figure never gets booked as a phantom transaction. On a paid plan it also reads the last value in that balance column and writes it into the .qbo as the ledger balance, so QuickBooks sees the true closing balance rather than a bare sum of the movements.

Comerica served a lot of Texas, Michigan, California, Arizona and Florida businesses, and the people converting these files are usually the ones keeping those books: owners filling the gap around the conversion weekend, controllers on QuickBooks Desktop who need a routine that survives October 30, and bookkeepers moving several former Comerica clients onto a monthly file import. Our Starter plan is $49 a month, or $24.50 a month billed yearly, and covers 100 conversions a month from any bank.