Convert a Huntington statement PDF to Excel

How to convert a Huntington statement PDF to Excel

1. Download the PDF: sign in to Huntington Online Banking, open the Service Center and choose Statements, then pick the account and period and save the PDF. Use the downloaded PDF if you can: it reads exactly, while a scan of a paper statement is read with OCR and a phone photo needs saving as a PDF first.
2. Upload it above. Utilly reads every activity table, signs each row by the (+) or (-) in the table's heading, and checks Beginning Balance + credits − debits − fees = Ending Balance for each account. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
3. Download the CSV and open it in Excel. Dates and amounts come in as real dates and numbers.
4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a Huntington statement

A Huntington statement starts with a Relationship Summary (statement period and every account's balance), then one section per account: the product name ("Asterisk-Free Checking Account", "Huntington Premier Savings Account") with "Account: <number>" on the right, a summary box, and one table for each type of transaction. Amounts carry no sign: each table's heading says which way the money went.

What this is based on: test statements built in Huntington's layout above, with made-up names and transactions (checking with a negative beginning balance, deposits, three checks two across with a break in the sequence, ATM, card and Zelle rows with wrapped descriptions, and a savings account with interest on the same statement; plus a December-to-January statement), and one public Huntington statement (Asterisk-Free Checking and Huntington Premier Savings) posted as an example file: all 105 of its rows were read and both accounts balanced to the cent. We don't link to it because it contains a person's details. We haven't run every Huntington statement style through it: business checking, money market, Huntington credit card statements and statements with a fee table haven't been tested. The balance check tells you straight away whether yours read correctly.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-04,DIRECT DEP SAMPLE PAYROLL 260904 000123,1850.00,
2026-09-18,MOBILE DEPOSIT REF 0918001,265.50,
2026-09-08,Check 1041,-120.00,
2026-09-12,NON-HUNTINGTON CASH WITHDRAWAL 100 EXAMPLE ST COLUMBUS OH 5175000000004417,-103.00,
2026-09-05,PURCHASE SAMPLE GROCERY #12 SAMPLE GROCERY #12 COLUMBUS OH 5175000000004417,-84.17,
2026-09-30,NON-HUNTINGTON ATM CASH WITHDRAWAL FEE,-3.00,

The rows keep the statement's order, table by table (deposits, then checks, ATM, card and other withdrawals), so you can tick them off against the PDF. To see the month day by day, sort by the Date column. Want money in and money out in two columns? Use =MAX(C2,0) and =MAX(-C2,0).

How far back Huntington statements go

Sources: Huntington: What Is A Bank Statement? (statements available online for 24 months, older ones by contacting Huntington, the Statements tab), Huntington: Digital Banking Tools (Service Center → view statements; Download Account Transactions in Quicken, QuickBooks and CSV formats), Huntington: Business Online Information and Reporting (24 months of statement history), Huntington: PC Banking (Quicken and QuickBooks downloads, no monthly cost). Checked Oct 28, 2026.

QuickBooks and Quicken files for Huntington

Huntington Online Banking can download transactions for Quicken and QuickBooks or as CSV. If that download covers the dates you need, use it. For statements a client sent you as PDFs, months you only have as statements, or when you want every row tied to the statement's Ending Balance, start from the PDF. The same Utilly conversion that gives you Excel also includes:

One credit covers every format of that statement, and every account on it. If a download or a bank feed already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, Capital One statement to Excel, U.S. Bank statement to Excel, Citibank statement to Excel, PNC statement to Excel, Truist statement to Excel, Navy Federal statement to Excel, Citizens statement to Excel, Regions statement to Excel, Ally statement to Excel, or USAA statement to Excel.