Huntington CSV to QuickBooks: Convert and Import Transactions
No account needed for your first conversions. We never store your bank login.
Short answer: Export your Huntington activity as a CSV, convert that CSV to a QuickBooks Web Connect (.qbo) file, and import it. QuickBooks Online reads the .qbo with no column mapping, and QuickBooks Desktop reads it through File, Utilities, Import, Web Connect Files. This matters more at Huntington than at most banks, because Huntington Commercial customers sign in with a company ID, a user ID, and a password, and QuickBooks Online's bank connection form has no field for the company ID. For those accounts the file import is not a fallback. It is the only path.
Huntington National Bank serves a large share of small and mid sized businesses across Ohio, Michigan, Pennsylvania, Indiana, Illinois, West Virginia, Kentucky, Minnesota, Wisconsin, and Colorado. If your business banks there and you have spent an afternoon typing credentials into the QuickBooks connection screen and watching it fail, the problem is probably not your password.
Why won't my Huntington Commercial account connect to QuickBooks Online?
The credential shape does not match. A Huntington Commercial login asks for a company ID, then a user ID, then a password, and frequently a token or PIN on top of that. QuickBooks Online's bank connection screen collects exactly one username and one password. There is nowhere to enter the company ID, so authentication never even reaches Huntington's server. This is documented in Intuit's own community threads, where business customers describe the same three field login and get told the same two options: use a separate retail online login, or import a downloaded file.
Separately, Intuit has acknowledged periods where Huntington connections broke for customers who could otherwise log in normally, with engineers investigating and the recommended interim step being to download transactions from the bank and import them manually. Between the credential mismatch and the intermittent outages, the file route is what actually holds up.
Can I link Huntington Commercial to QuickBooks manually?
Not through the bank feed, but yes through the register. Add the bank account to your chart of accounts in QuickBooks as a normal bank account, without connecting it to anything. Then feed it transactions by importing a file each time you reconcile. QuickBooks does not treat manually created accounts differently once transactions land in them, so reconciliation, categorization, and reporting all behave exactly as they would on a connected account.
The one thing you give up is the automatic nightly pull. What you gain is a process that never breaks because of a bank side outage, a changed credential, or a login structure Intuit does not support.
How do I export Huntington transactions to a CSV file?
Sign in at huntington.com on a desktop browser rather than the mobile app. Open the account you want, find the transaction history, and use the export or download icon near the top of the list. Choose the date range you need and select the comma separated values format. Save the file somewhere you can find it.
The export is available on commercial and treasury accounts even when the QuickBooks connection is not, which is the whole reason this route exists. Nothing has to be enrolled, and there is no charge for it.
Does Huntington offer a .qbo download?
Sometimes, and it depends on your account type. Huntington has published QuickBooks conversion instructions for Web Connect, so the format is not foreign to the bank. But the download menu inside online banking differs between personal, business, and commercial platforms, and commercial customers routinely find only spreadsheet formats waiting for them. If a Web Connect or .qbo option appears on your account, take it. If it does not appear, or the file it produces gets rejected on import, convert the CSV instead and you will end up with the same thing.
Can QuickBooks Desktop import a Huntington CSV file?
No. QuickBooks Desktop has never had a native CSV transaction import. Its only route for bringing bank transactions in is Web Connect, which accepts .qbo files. Every guide that tells you to import a CSV into Desktop is either describing the Import Excel and CSV Toolkit, which handles customer, vendor, and item lists rather than transactions, or it is wrong. A converted .qbo is what Desktop expects.
How do I convert a Huntington CSV to a QBO file?
Upload the CSV to the converter at the top of this page. It reads the date, description, and amount columns, drops the extra columns Huntington includes such as the running balance and transaction type, normalizes the date format, applies the correct sign to each amount, and writes a standard Web Connect file. Before the download starts it totals every transaction it parsed and compares that total to the total in your original CSV, so a misread row shows up in the preview rather than three weeks later during reconciliation.
The whole thing takes under a minute. If you would rather see the mechanics first, the walkthrough in how to convert CSV to QBO covers each step, and the dedicated Huntington CSV to QBO converter page handles the conversion directly.
How do I import the QBO file into QuickBooks Online?
Go to Transactions, then Bank transactions. Select Link account, then Upload from file. Choose the .qbo you just downloaded, pick the QuickBooks account it belongs to, and confirm. Because a .qbo carries its own field structure, QuickBooks does not ask you to map columns the way it does with a raw CSV. The transactions arrive in the For review tab ready to categorize.
How do I import the QBO file into QuickBooks Desktop?
Open your company file, then go to File, Utilities, Import, Web Connect Files. Select the .qbo, and when prompted choose the existing bank account rather than creating a new one. The transactions land in the Bank Feeds Center. The full sequence, including what to do when Desktop asks about an account it does not recognize, is in importing a QBO file into QuickBooks.
Why won't my Huntington CSV import into QuickBooks Online?
QuickBooks Online is strict about CSV layout. It accepts a three column file of date, description, and amount, or a four column file that splits credit and debit into separate columns. It caps a single upload at 350 KB, which is roughly 1,000 transactions, and the file must be in English. A Huntington export usually carries more columns than that and orders them differently, so QuickBooks either rejects it or asks you to map every field by hand and then still misreads the dates. Converting to .qbo removes the mapping screen entirely.
How far back can I import Huntington transactions?
A connected bank feed reaches back about 90 days at most banks, Huntington included. A .qbo file import has no date restriction whatsoever. That difference is why catch up bookkeeping is almost always done with files: pull a CSV for each date range you need from Huntington's online banking history, convert each one, and import them in sequence. Older periods that only exist as PDF statements are a different problem, and you can turn a PDF statement into a clean spreadsheet first and then convert the resulting CSV the same way.
Will importing a file create duplicate transactions?
It can, if the same account is also connected to a live feed. QuickBooks matches on date, amount, and description, and near matches slip through as duplicates. Intuit's guidance is to use one method per account, not both. If you are importing Huntington files, leave the account disconnected. If a duplicate does appear in the For review tab, exclude it rather than accepting it.
Can I convert several Huntington accounts at once?
Yes. Most Huntington business customers run at least a checking account and a business credit card, and treasury customers often run several. Convert each account's CSV into its own .qbo, since QuickBooks maps one file to one account on import. When you are rebuilding a year of books across multiple accounts, the bulk CSV to QBO converter processes them together, and importing multiple CSV files into QuickBooks covers the ordering and duplicate checks worth doing first.
Businesses running a full commercial treasury setup usually have vendor bills piling up alongside the bank feed. If manual keying is eating the same hours, it is worth automating the accounts payable side rather than only fixing the bank import.
Huntington CSV to QuickBooks: the short version
If you bank on Huntington Commercial, QuickBooks Online will not accept your company ID login, and no retry will change that. Download the CSV, convert it to a .qbo, import it. The transactions arrive with clean dates, correct signs, and no mapping screen, and the process does not care whether Huntington's feed is up, down, or supported at all.
Once your file is converted, follow the exact import path in our guides on CSV to QuickBooks Online and CSV to QuickBooks Desktop, check the column requirements in the QuickBooks CSV import template, compare the paid options on the best CSV to QBO converter roundup, and read what to do when the feed itself misbehaves in QuickBooks bank feed not working. Regional neighbors are covered in Fifth Third CSV to QuickBooks, KeyBank CSV to QuickBooks, and PNC CSV to QuickBooks.