KeyBank Statement to Excel: Personal and Business Guide

TL;DR For a KeyBank statement in Excel, download the monthly statement PDFs, convert them so each transaction is one row with a real date and a signed amount, and check that the beginning balance plus all activity equals the ending balance. Keep check numbers in their own column, because check-heavy accounts are where most errors hide. Use transaction downloads for quick looks at recent activity, and statements for bookkeeping, loans, audits and taxes.

KeyBank customers who need statements in a spreadsheet tend to fall into two groups. Households want a budget, a record for a loan application, or a tidy year for their tax preparer. Small businesses and nonprofits want the activity in their accounting software, or a reconciled record for their accountant. Both groups hit the same problems: statements spread across many pages, checks listed separately from other withdrawals, and dates that don't carry a year.

This guide covers the workflow from download to a finished, balanced workbook, with extra detail on the things business accounts tend to need: check registers, deposit matching and month-end reconciliation. Online banking menus change over time, so we describe them in general terms rather than listing exact clicks.

Choose the right source file

There are usually two ways to get data out of online banking.

Transaction downloads export recent activity in a format such as CSV, often with an option for accounting software formats. They're fast and good for checking last week's spending. They may only cover a limited date range, can include pending transactions, and don't include the official opening and closing balances.

Monthly statement PDFs are the bank's official record for each period. They include balances, every posted transaction, fees, interest and, on many checking accounts, a separate list of checks paid. They also go back further, and they're what lenders, auditors and preparers expect.

If you need to reconcile, if you're catching up on months of bookkeeping, or if someone else will rely on the numbers, start from statements. Download every month for every account and name the files consistently, for example keybank-operating-2026-03.pdf. If you're missing older months, see how to get old bank statements.

How a checking statement is usually organized

Layouts vary by account type, but expect these sections:

• Account summary: beginning balance, total deposits and other credits, total withdrawals and other debits, checks paid, fees, and ending balance.
• Deposits and other credits: payroll, transfers in, merchant deposits, mobile and branch deposits.
• Withdrawals and other debits: card purchases, ACH payments, transfers out, wires.
• Checks paid: check number, date paid and amount, often in a compact multi-column grid.
• Fees and interest: sometimes in their own section.
• Daily balance summary: the ending balance on each day with activity.

That sectioned layout is the main thing to get right. If you copy the sections one under another, your spreadsheet isn't in date order and the checks may be missing a description entirely. A good conversion merges every section into one chronological list and labels each row with a type.

Converting the statement

Copy and paste works on a single short page. On a business statement with dozens of checks printed in a three-column grid, it falls apart: the grid pastes as one wide row, and you have to rebuild it by hand.

Power Query can detect tables in a PDF and is worth trying on clean layouts. It often treats each section as a separate table, which you then append and sort. See our Power Query bank statement guide.

A statement converter saves the most time on long statements. SheetStatement merges sections into one list, keeps check numbers, adds the year from the statement period and runs a balance check before export. Download Excel, CSV, or QuickBooks and Xero formats. The free plan covers 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover larger volumes, which matters for business accounts with long statements.

Target layout:

Prove the statement balances

Before you categorize or import anything, check the math:

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

It should return 0. For a business account, also check each section against the summary block. If the summary lists total checks paid, compare it with:

=-SUMIFS(Tx[Amount], Tx[Type], "Check")

Do the same for deposits and other debits. Section checks narrow a problem down fast: if deposits match and checks don't, you know exactly where to look.

If the overall difference isn't zero:

• Equal to one check: a check row is missing, usually from the grid layout.
• Twice one amount: a sign is wrong.
• Matches the fee total: the fee section was skipped.
• Off from a specific date onward: compare your running balance with the daily balance summary. Our guide to the running balance formula in Excel shows how.

The free balance checker is a quick way to confirm the totals without building formulas.

Build a check register from the statement

Businesses, landlords, churches and nonprofits that still write checks get a lot of value from a proper check register. With check numbers in their own column you can:

Find gaps in the sequence. Sort the checks by number and add a column that flags a jump:

=IF(C3-C2>1, "Gap after " & C2, "")

A gap isn't necessarily a problem. It may be a voided check or one that hasn't cleared. But every gap should have an explanation, and outstanding checks belong on your reconciliation. Our guide to outstanding checks and deposits in transit explains how to handle them.

Match checks to payees. The statement usually shows only "CHECK" and a number. Keep a small table of check numbers, payees and purposes from your checkbook or accounting software, and pull the payee in with XLOOKUP:

=XLOOKUP(C2, Checks[Number], Checks[Payee], "Unknown")

Rows that return "Unknown" are checks you haven't recorded yet.

Spot duplicates. A check number that appears twice is worth investigating:

=COUNTIF(Tx[Check #], C2)>1

Matching deposits

Deposits can be just as tricky. A single deposit line on the statement often represents several customer payments, a batch of card sales, or a mix of cash and checks. If your accounting software records each payment individually, the deposit won't match any single invoice.

A practical approach:

1. Keep a deposit log with the date, total and the payments included.
2. Match the statement deposit to the log by date and total.
3. Where card processors deduct fees before paying out, record the gross sales and the fee separately so the net equals the deposit. Our guide to reconciling Stripe payouts shows that pattern in detail.

Getting it into accounting software

For bookkeeping, you'll usually import rather than keep a separate spreadsheet.

• QuickBooks Online accepts CSV with either one amount column or separate debit and credit columns, and QBO files. See importing into QuickBooks Online.
• Xero accepts CSV in its own layout. See the Xero CSV import format.
• Other software usually accepts CSV or OFX. Our guide to converting a bank statement PDF to OFX explains when OFX is the better choice.

Import one month, reconcile it to the statement's ending balance, then move to the next. Importing a whole year at once makes duplicate detection and reconciliation much harder. If you're doing a big catch-up, our guide on catch-up bookkeeping lays out an order that works.

Organizing personal statements

For personal accounts, the next steps are about answering questions rather than importing:

1. Flag transfers between your checking, savings and credit card so they don't count as spending.
2. Categorize with a rules table. Our Excel formulas for categorizing transactions guide has patterns you can copy.
3. Summarize with a pivot table or a SUMIFS grid by month and category.
4. Prepare for a loan by filtering large or unusual deposits and noting where each came from. Lenders will usually want the original statements too.

A worked example

A small contractor uses a KeyBank business checking account, writes 30 to 40 checks a month to suppliers and subcontractors, and is three months behind on bookkeeping.

1. Download the three missing statements.
2. Convert each one. The checks come out as individual rows with their numbers, merged into date order with deposits and debits.
3. Balance check. Two months balance immediately. One is off by the amount of a single check. The checks-paid section total confirms the shortfall is in checks; comparing numbers shows check 2213 was printed at the bottom of a page and missed in an earlier manual attempt. The converter version has it.
4. Check register. A gap flag shows 2208 missing. The checkbook shows it was voided. One check written at month-end hasn't cleared and goes on the outstanding list.
5. Payee lookup. An XLOOKUP against the checkbook fills in payees for all but two checks, which the owner identifies from memory and invoices.
6. Import each month into the accounting software as CSV and reconcile to the ending balance.

Total time is far shorter than typing three months of checks by hand, and every figure ties back to the statement.

A month-end reconciliation for business accounts

Once the statement is in a spreadsheet and balances on its own, the next question for a business is whether the books agree with the bank. A simple reconciliation layout on its own sheet makes this a five-minute job each month.

The outstanding checks come straight from your check register: any check you've written that isn't in the statement yet. Deposits in transit are deposits you've recorded that the bank posted after the statement date. Both lists should be short and should clear on the next statement. If a check stays outstanding for several months, follow up with the payee; it may have been lost, or it may need to be voided and reissued.

If the difference isn't zero, work through these in order:

1. Bank items not in the books. Fees, interest, automatic payments and returned items often appear on the statement before anyone records them. Filter the statement table for types like "Fee" and "Interest" and make sure each is in the books.
2. Book items not in the bank. Anything recorded in the books but not on the statement should be on your outstanding or in-transit lists. If it isn't, it may be a duplicate or an error.
3. Amount mismatches. A check recorded as 420.00 in the books but paid as 402.00 at the bank shows up as a difference of 18. Differences divisible by 9 often point to transposed digits.

Our step-by-step guide to reconciling a bank statement in Excel has a full template, and the month-end close checklist puts this step in the context of the rest of the close.

A year-end package for your accountant

Accountants and tax preparers appreciate a tidy handoff. If you've converted and reconciled each month, building the year-end package takes very little extra work:

• All twelve statement PDFs for each account, named consistently.
• One combined workbook with every transaction, a Month column, a Category column and the Type and Check # columns.
• A summary sheet with totals by category and month, built with a pivot table or SUMIFS.
• The reconciliation sheet for December, showing outstanding checks and deposits in transit at year-end.
• A notes column explaining anything unusual: a loan deposit, an owner contribution, an equipment purchase, a refund from a supplier.

The notes are often the most useful part. A large deposit that's actually a loan or an owner contribution isn't income, and a preparer can't tell that from the statement alone. This is general information rather than tax advice; your preparer will tell you what they need. Our checklist on bank statements for tax preparation covers common requests.

Troubleshooting

Checks appear in one long row. The checks-paid grid has several checks side by side. Split them into separate rows, or use a converter that understands the grid.

The statement balances but the books don't. The difference is usually outstanding checks, deposits in transit, or something recorded twice in the software. See finding bank reconciliation discrepancies.

Dates show the wrong year in January. Statements spanning December and January often omit the year. Assign it from the statement period.

Amounts are text. Use NUMBERVALUE or multiply by 1, and remove any trailing minus signs or currency symbols first.

Duplicate transactions after import. You probably imported overlapping files or combined a download with a statement. Our guide to fixing duplicate transactions in QuickBooks covers the cleanup.

Convert a KeyBank statement

Upload a KeyBank statement PDF to SheetStatement, review the rows and check numbers, confirm the balance check, and download Excel, CSV, QuickBooks or Xero formats. The free plan covers 3 pages a month, enough to test a real statement.

FAQ

Can I export KeyBank transactions without converting a PDF?

Online banking typically offers a download of recent activity. That's useful for quick checks. For full statement periods, older months, official balances or bookkeeping, convert the statement PDFs.

How do I keep check numbers when converting?

Use a method that keeps the check number as its own column. A statement converter that recognizes the checks-paid section does this automatically; with copy and paste you'll need to split the check grid manually.

Why doesn't my converted statement balance?

The most common causes are a missing check from the grid layout, a skipped fee section, or a sign error. Compare each section total with the summary block to find which section is off.

Can I import the result into QuickBooks or Xero?

Yes. Export CSV in the layout your software expects, or a QuickBooks or Xero format, then import one month at a time and reconcile to the ending balance.

How do I handle deposits that contain several payments?

Keep a deposit log that lists the payments in each deposit, and match the statement line to the log by date and total. Record processor fees separately so the net equals the deposit.

Does this work for business and personal accounts?

Yes. The conversion and balance check are the same. Business accounts usually add a check register, deposit matching and an import into accounting software.

Is my data safe?

See the security page for how SheetStatement processes and stores statements, and review any service's policy before uploading financial documents.

What should I do about a check that never clears?

Keep it on your outstanding checks list and follow up with the payee after a reasonable time. If it's lost, you may need to stop payment and reissue it. Either way, record what happened so the reconciliation stays clean.

Can I combine personal and business KeyBank statements?

You can convert both, but keep them in separate workbooks or at least separate Account values. Mixing personal and business activity makes bookkeeping and tax preparation harder.

How much does it cost?

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