Huntington Bank Statement to Excel: Convert and Check

TL;DR To put a Huntington statement into Excel, download the monthly statement PDFs, convert them so each transaction is one row with a proper date and a signed amount, and confirm that the beginning balance plus all activity equals the ending balance. Flag transfers and card payments so they don't count twice. If you share an account with a partner or roommates, add a "Who" column and a split rule so a single formula tells you who owes whom. Keep the PDFs with the workbook for anything a lender or preparer will see.

Huntington is a regional bank with a large footprint in the Midwest, and plenty of its customers use more than one of its products: a checking account, a savings account, maybe a credit card, sometimes a business account alongside. Getting all of that into one spreadsheet is the quickest way to see where money actually goes, prepare for a loan, or hand clean records to a tax preparer.

This guide covers the general workflow, then spends extra time on a situation that comes up often with shared checking accounts: working out who paid for what. We describe online banking in general terms only, since menus and labels change over time.

Two kinds of file, two kinds of job

Transaction downloads. Online banking usually lets you download recent activity in a spreadsheet-friendly format. It's the fastest way to look at last month. The trade-offs: the date window may be limited, pending items can appear and later change, and there are no official opening or closing balances to check against.

Statement PDFs. The monthly statement is the official record. It has the beginning and ending balances, every posted transaction, fees and interest. It covers older months, and it's what lenders, landlords and accountants ask for.

So: for anything that needs to be complete, reconciled, or shown to someone else, use statements. For a quick look, use the download. If you mix both in one workbook, you'll almost certainly get duplicates, so pick one source per period.

Download every month you need and name files consistently, such as huntington-checking-2026-06.pdf and huntington-card-2026-06.pdf. If you need months that are no longer available online, our guide on how to get old bank statements explains the usual routes.

What's on the statement

Statement layouts vary by account type, but checking statements typically include:

• The statement period and account details.
• A summary: beginning balance, deposits and credits, withdrawals and debits, fees, ending balance.
• Itemized activity, sometimes grouped by type rather than strictly by date.
• Checks paid, if you write checks.
• A daily balance list.

Credit card statements show a previous balance, payments and credits, purchases, fees and interest, and a new balance. The arithmetic runs the other way from checking: purchases increase what you owe.

Converting to Excel

Copy and paste is fine for a page or two. Beyond that you'll spend your time fixing wrapped descriptions, amounts stored as text, and dates without a year.

Power Query in desktop Excel can pull tables out of a PDF. It works best on tidy grid layouts and less well where sections and subtotals break up the table. See our Power Query bank statement guide.

A statement converter handles the layout for you. SheetStatement merges sections into one chronological list, adds the year from the statement period, and runs a balance check before you export to Excel, CSV, QuickBooks or Xero. The free plan includes 3 pages a month, and Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

The shape to aim for:

Check each statement balances

This is the step that tells you nothing is missing.

For checking and savings:

=ROUND(BeginningBalance + SUM(Amounts) - EndingBalance, 2)

For credit cards, with purchases positive and payments negative:

=ROUND(PreviousBalance + SUM(Amounts) - NewBalance, 2)

Each should return 0. If one doesn't:

• The difference equals one transaction: missing or duplicated row, usually at a page break.
• Twice one transaction: a sign is flipped.
• The fee or interest total: that section was skipped.
• Wrong only after a certain date: add a running balance and compare it to the statement's daily balances. Our guide to the running balance formula in Excel walks through it.

Or drop the totals into the free balance checker.

Splitting a shared account

Joint checking accounts and shared household accounts are common, and so is the question "did we each pay our share this month?" A converted statement makes this easy to answer with a couple of extra columns.

Add who and how to split

Add three columns to your table:

• Who paid: for deposits into the shared account, which person the money came from. For spending from a personal card on a shared expense, who paid.
• Shared?: TRUE if the transaction is a shared household cost, FALSE if it's personal.
• Split: the share for person A, as a decimal. 0.5 for an even split, or something like 0.6 if you've agreed to split in proportion to income.

Calculate the balance between you

With your combined table named Tx and amounts negative for spending:

Person A share of shared costs:
=-SUMPRODUCT(Tx[Amount] * Tx[Shared?] * Tx[Split])

Person B share of shared costs:
=-SUMPRODUCT(Tx[Amount] * Tx[Shared?] * (1 - Tx[Split]))

Then total what each person contributed, whether as deposits into the shared account or as shared expenses they paid from their own cards. The difference between each person's share and what they contributed is what one owes the other.

A simple layout:

In this example, B owes A 160.00 for the month.

Rules that keep it fair

• Agree the split before you calculate. Even or income-based, write it down and use it consistently.
• Keep personal items out. Mark them Shared? = FALSE rather than deleting them, so the statement still balances.
• Treat transfers carefully. A transfer from a personal account into the shared account is a contribution, not spending.
• Settle monthly. It's far easier to agree on one month than to untangle a year.

This works the same for roommates. The workbook stays reconcilable to the statement because you haven't removed any rows, only labeled them.

Organizing for budgets, loans and taxes

Budget

1. Flag transfers between your own accounts and card payments, so you don't count spending twice.
2. Categorize with a rules table. Our Excel formulas for categorizing bank transactions guide has ready-made patterns.
3. Summarize with a pivot table, Category in rows and Month in columns.

Loan or rental application

Lenders and landlords generally want the original statements. Use the spreadsheet to prepare: filter large or unusual deposits and note their sources, confirm there are no missing months, and check ending balances. See bank statements for a mortgage application and bank statements for a rental application.

Taxes

If your preparer wants totals for certain categories, summarize them and keep the transaction detail and the PDFs as backup. This is general information, not tax advice. Our tax preparation checklist covers what preparers commonly ask for.

A worked example

Two people share a Huntington checking account for rent, utilities and groceries. Each also has a personal credit card that's occasionally used for shared costs. They've agreed a 55/45 split based on income.

1. Download the month's checking statement and both card statements.
2. Convert and check. All three balance. One card statement initially showed a difference of twice a single refund; the refund had a positive sign. Fixed.
3. Label. Every row gets Shared? TRUE or FALSE. Deposits into checking are labeled with who made them. Shared costs on personal cards are labeled with who paid.
4. Split. The Split column is 0.55 for every shared row.
5. Calculate. Shared costs total 3,600.00, so A's share is 1,980.00 and B's 1,620.00. A contributed 1,900.00 to checking and paid 140.00 of shared costs on a personal card, 2,040.00 in total. B contributed 1,600.00. A is over by 60.00; B owes A 60.00.
6. Keep the record. The workbook and the three PDFs go into a shared folder, so either person can check any number.

Keep it going each month

After the first month, the routine is short:

1. Download the new statements as soon as they're available.
2. Convert, and check each balances before doing anything else.
3. Append the rows to your table. If it's an Excel table, formulas and pivot sources extend automatically.
4. Categorize new payees and label shared items.
5. Refresh the summary and, if you share costs, settle up.

Track savings goals from your statements

Many households move money into savings for specific goals: an emergency fund, a car, a holiday, annual insurance premiums. If you use one savings account for several goals, the statement only shows one balance, which makes it hard to see how each goal is doing. A spreadsheet can track them separately without opening extra accounts.

Add a Goal column to every transfer into or out of savings. Then build a small summary:

=SUMIFS(Tx[Amount], Tx[Account], "Savings", Tx[Goal], A2)

with goal names down column A. Add a target column and a progress column:

Interest earned on savings is a small line on the statement. Assign it to a goal of its own, or spread it across goals in proportion to their balances, whichever you prefer. The key check is that the total of all goals equals the savings ending balance on the statement. If it doesn't, a transfer is missing a goal label.

This is also a good way to plan for irregular bills. If you know insurance, car registration and holiday spending come once a year, divide each by twelve and set up a monthly transfer for the total. Your converted statements will show whether the transfers actually happened every month.

A year in review

At the end of the year, twelve converted and balanced statements give you a clear review with very little extra work. A few views worth building:

Spending by category by month. A pivot table with Category in rows and Month in columns. Look for categories that grew steadily through the year. Subscriptions and food delivery are frequent culprits.

Fixed versus variable costs. Add a column marking each category as fixed (rent, insurance, loan payments) or variable (groceries, fuel, eating out). The ratio tells you how much flexibility you really have if income drops.

Largest single transactions. Sort by amount and look at the top twenty. These often explain why a particular month felt tight.

Recurring payments. Count how often each payee appears. Anything that shows up every month is a subscription or a bill. A formula like this, in a list of unique payees, gives you the count:

=COUNTIFS(Tx[Payee], A2, Tx[Amount], "<0")

Cancel the ones you no longer use. Our guide to tracking expenses from bank statements goes further, with a simple system you can keep running all year.

Net change. Compare January's beginning balance with December's ending balance across all accounts, adjusted for any credit card balance. That single figure tells you whether the year added to or reduced your savings.

If you also have a business account

Some customers run a small business account next to their personal accounts. Keep the two strictly separate in your workbooks: different files, or at least a clear Account value and separate summaries. For the business account, the converted statements are usually imported into accounting software and reconciled each month rather than analyzed in a standalone sheet. See our guides to importing into QuickBooks Online and to categorizing business expenses from bank statements.

Troubleshooting

Dates don't sort. They're stored as text. Convert them with DATEVALUE, or rebuild them with DATE. Our guide on fixing bank statement dates in Excel covers every common case.

Amounts don't sum. They're text. Use NUMBERVALUE, and remove currency symbols or trailing minus signs first.

Spending looks doubled. Card payments from checking are being counted alongside the card's purchases. Flag the payment as a transfer.

Duplicates after mixing a download with statements. Remove duplicates on date, amount and description, then rerun the balance check. Better: pick one source per period.

A scanned statement won't convert. It needs OCR first. See converting scanned bank statements.

Convert a Huntington statement

Upload a Huntington checking, savings or credit card statement to SheetStatement, review the rows, confirm the balance check, and download Excel or CSV. The free plan covers 3 pages a month.

FAQ

Can I download Huntington transactions directly into Excel?

Online banking typically offers a download of recent activity. Use it for quick looks. For complete statement periods, older months, balances and anything official, convert the statement PDFs.

How do I split a joint account's expenses in Excel?

Add columns for whether each transaction is shared, who paid, and the split percentage. Then use SUMPRODUCT to calculate each person's share and compare it with what they contributed.

Why doesn't my credit card statement balance?

Check that interest and fees are included and that payments and refunds reduce the balance. A difference of exactly twice one amount almost always means a flipped sign.

Should I combine checking and credit card data?

Yes, for budgeting, as long as you flag card payments as transfers so spending isn't counted twice.

Can I import the converted file into accounting software?

Yes. Export CSV, QuickBooks or Xero formats, import one month at a time, and reconcile to the statement's ending balance.

What if I only have paper statements?

Scan them at good resolution and run them through OCR. Always check the balance afterward, since OCR can misread digits. See OCR accuracy for scanned statements.

Is my data secure?

Read SheetStatement's security page for how statements are processed and stored, and check any service's policy before you upload.

How do I handle a month where we forgot to settle up?

Leave each month's calculation as it is and carry the balance forward. Add a row at the top of the next month's summary for the amount brought forward, so the running total of who owes whom stays correct and every month can still be checked on its own.

Can I track savings goals in one savings account?

Yes. Label each transfer into or out of savings with a goal, then total by goal with SUMIFS. The goals should add up to the statement's savings balance; if they don't, a transfer is missing its label.

What's the best way to store the PDFs?

Keep them in one folder per year, named by account and month, next to the workbook. That way anyone checking a figure can go from the summary to the row to the exact statement page without searching.

How much does conversion cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro $19 and Business $39.