LedgerMatch
Huntington Bank CSV Export: Column Layout & Reconciliation Guide
Huntington truncates merchant names to 40 characters and occasionally inserts "Heads Up®" alert rows — non-transaction metadata mixed into the data stream — that cause import errors when QuickBooks encounters a row with no date or amount. The 40-character cutoff also means high-volume accounts end up with dozens of identically-named "ONLINE TRANSFER" entries that are impossible to match manually. This tool strips non-transaction rows and accepts truncated descriptions without throwing a column error.
CSV format at a glance
- Date format: MM/DD/YYYY
- Amount layout: one signed amount column
- Negative values are debits. Positive values are credits.
Where to export the CSV
Sign in → Accounts → select account → Download Transactions → CSV
Common import issues
- Huntington Heads Up® alerts appear as data rows in some exports — they look like transactions but have no date or amount. QuickBooks throws a "date is required" error when it hits them. Delete any row where the Date cell is blank or contains text.
- Merchant names are truncated at 40 characters. "AMAZON MARKETPLACE PAYMENT" becomes "AMAZON MARKETPLACE PAY" — the cutoff makes high-volume accounts hard to reconcile by description alone.
- Huntington's export covers a maximum of 18 months. For older history, you must request statements directly from a branch.
- Recurring transfers between Huntington accounts show as "ONLINE TRANSFER" with no payee detail. If you have multiple such transfers per month, add the dollar amount to the description manually before importing.
Useful setup tips
- Map Date → Date, Description → Description, Amount → Amount. The four-column format is clean once Heads Up® rows are removed.
- For accounts with many truncated descriptions, add a Reference note during LedgerMatch's exception review to record the full merchant name for future reconciliation periods.