Guides

How to Convert a Bank Statement PDF to Excel

Excel is where most statement work ends up. Bookkeepers live in it. Clients understand it. Tax preparers ask for it by name. This guide shows how to get from a PDF statement to a clean Excel file with the statement converter, what a good Excel result should contain, and the small habits that keep a workbook trustworthy after you start editing it.

CSV or Excel: what is the real difference?

A CSV file is one flat table of text. An Excel file (.xlsx) is a workbook. It can hold several sheets, keep numbers stored as numbers, and carry formulas that add things up. That difference sounds small. In day-to-day work it is not.

The rule of thumb: if the file is on its way into another program, choose CSV (or the program's own format). If a person will read, check, annotate or present it, choose Excel. Many of our users download both: CSV for the accounting tool, Excel for the client. Our CSV guide covers the other path in full: converting a statement PDF to CSV.

What a good Excel conversion contains

A plain copy-paste from a PDF gives you a mess: merged cells, amounts stored as text, dates that are not dates. A proper conversion gives you a workbook built for work. When you convert a statement to Excel here, the file has two parts:

• A Transactions sheet: one row per transaction, with Date, Description, Debit, Credit, Amount and Balance columns. Dates are real dates. Amounts are real numbers. The header row is frozen, so it stays on screen while you scroll.
• A Summary sheet: the bank, the account, the statement period, the opening and closing balances, the totals in and out, and the result of the balance check. Anyone who opens the file can see, in five seconds, whether the statement reconciled.

The Summary sheet is the part people thank us for. Months later, when a client or a tax preparer asks 'is this the full statement?', the answer is printed in the file itself. No digging through email. No re-converting the PDF to check.

Step by step: from PDF to Excel

1. Download the PDF statement from your bank. Use the digital original, not a scan — the difference is explained in our guide to scanned and digital statements.
2. Drop the PDF into the converter. Type the PDF password if the file asks for one.
3. Wait for the read to finish, then look at the balance check. Reconciled means the rows reproduce the closing balance exactly.
4. Fix anything the check flags, right in the table. Save, and the check runs again.
5. Choose the Excel download. You get the .xlsx workbook with the Transactions and Summary sheets.
6. Open it and do the two-minute check from the next section before you send it anywhere.

The two-minute check inside Excel

The converter checks the balance for you, but a fast second look in Excel costs little and catches the mistakes that are yours, not the file's — like deleting a row by accident while tidying up. This is the routine accountants use:

1. Click the cell under the Credit column and look at the status bar sum, or add =SUM over the column. Do the same for Debit.
2. Compare both totals with the Summary sheet. They should match to the cent.
3. Check the last row's Balance against the closing balance on the Summary sheet.
4. Sort by date, briefly, to confirm the order reads cleanly — then undo the sort if your tool expects statement order.

If a total moved after your edits, our guide on checking a converted statement walks through the full routine, and the guide on statements that do not balance explains how to find the row that broke things.

Working in the workbook without breaking it

Once the file is yours, a few habits keep it reliable:

• Add your notes in a new column or a new sheet. Do not type over the Description column — that text is the audit trail back to the statement.
• If you split one statement across categories, copy rows to a working sheet and keep the Transactions sheet untouched as the record.
• Keep the file name boring and clear: Bank_Account_2026-01.xlsx beats Statement_final_v2.xlsx in February, and beats it by more in three years.
• Store the workbook with the PDF it came from. The PDF is the document of record; the workbook is the working copy. The IRS asks businesses to keep records that support income and expenses — the pair of files does exactly that, and our sources at the end of this guide link to the official rules.

Merging several months into one workbook

A common job: a lender or a tax preparer wants a full year. Convert each month's statement on its own first — each one gets its own balance check — then combine. Paid plans can download a batch as one merged CSV with a column naming the source file of every row, which drops straight into Excel as a single table. Doing it in this order matters: a year built from twelve checked months is trustworthy. A year merged first and checked never is twelve chances to hide one bad row.

Batch size is the only limit to plan around: free accounts convert up to 5 files at a time, paid plans up to 20, and plans and page limits are counted per page that converts, not per file you try.

When Excel is the wrong choice

Excel is for people. Machines prefer simpler food. If the destination is QuickBooks, download QBO instead and skip the mapping screens entirely — see importing statements into QuickBooks. If it is Quicken or Xero, OFX is the native format. The guide to OFX, QBO and QIF lays the three side by side. And if a human will forward the file to another human who will forward it again, Excel wins every time — nobody ever thanked anyone for a raw CSV in an email thread.

Pick the format by the reader, keep the Summary sheet with the file, and let the balance check do the worrying. That is the whole craft.

Formulas that earn their keep

Because the amounts in the Excel file are real numbers, a few simple formulas turn the workbook from a record into a tool:

• A SUM over the Debit or Credit column re-proves the totals any time you edit. If the sum stops matching the Summary sheet, an edit changed the math — find it now, not at year end.
• A SUMIF over the Description column answers 'how much did we pay the landlord this quarter?' in one line, by adding only the rows whose text matches a payee.
• A quick pivot table (Insert → PivotTable) groups the sheet by month or by payee. It is the fastest route from raw rows to 'where did the money go' for a client meeting.
• A simple =Date check: sorting by the Date column should never scramble rows, because the dates are real dates, not text that merely looks like dates.

Keep formulas on a separate working sheet when you can, and leave the Transactions sheet as the clean record. If a formula sheet and the record disagree one day, you will be glad one of them was never edited.

Sharing the workbook

Excel files travel well. Accountants, clients, lenders and tax preparers all open .xlsx without fuss, in Excel, Google Sheets or LibreOffice. Two sharing tips: first, the Summary sheet means the file explains itself — the recipient sees the balances and the check result without asking you. Second, if you add formulas, remember that other tools show the last calculated values stored in the file, so save once in Excel before sending and the numbers everyone sees will be the numbers you saw.

When a recipient only needs to look — a lender reviewing three months, say — exporting the workbook to PDF for sending is fine, but keep the .xlsx as the master. A PDF of a spreadsheet is a picture of data; the workbook is the data. You already know, from the scanned statements guide, how much difference that makes when someone needs to work with it later.

A month-end routine built on the workbook

Here is how the Excel file earns its place in a real month-end close. Download the month's statement PDF on the first working day. Convert it, confirm the check says Reconciled, and download the Excel workbook into the month's folder. Add one working sheet: a pivot of the Transactions sheet grouped by payee gives the owner their 'where did it go' view in two minutes. Add a second sheet only if you must split a cost across categories — and do the splitting there, by copying rows, never by editing the record sheet. Finish by glancing at the Summary sheet one last time: period, balances, check result. The month is closed when the folder holds the PDF and a reconciled workbook, and not a minute of typing was spent getting there.

Compare that with the spreadsheet most people inherit: a hand-typed sheet with no summary, no source PDF, and totals nobody can re-derive. The workbook habit is not about neatness. It is about every number being one question away from its proof.

Protecting the record inside the workbook

A workbook you will rely on later deserves two small protections. Set the Transactions sheet as the untouched record: if you share the file with someone who will edit it, send a copy, and keep your master. And when a workbook is final — the version behind a filed return, say — save a PDF snapshot of the Summary sheet beside it. Formats and software change over the years; a one-page summary with the balances and the check result stays readable forever, and it is the page every future question will actually be about.

None of this needs special software. It needs the ten seconds of discipline at save time that separates records from drafts: clear name, right folder, master kept apart from copies.

Excel in Google Sheets and on your phone

The workbook is not chained to a desktop copy of Excel. Google Sheets opens .xlsx uploads directly, formulas and frozen panes intact, which makes it the easiest way to share a live workbook with a client who has no Office licence — send the file, they import it, and both of you look at the same numbers. The Excel phone apps open the file happily for reading and light edits; the Summary sheet's small table was made for exactly that glance on a small screen. Two cautions. If you edit in Sheets and download back to .xlsx, check the totals once more on return — round trips between programs are where a formula quietly becomes a fixed number. And keep the master file in one place: three copies of the workbook in three inboxes will diverge, and only one of them is the record.

None of this changes the order of work. Convert, reconcile, download the workbook — then let it travel. A checked file is welcome everywhere; an unchecked one is just a prettier rumour.

One last thought on taste. People apologise for sending spreadsheets, as if a workbook were a humble gift. It is not. A reconciled workbook — transactions a person can sort, totals a person can re-derive, a summary that states its own proof — is one of the most useful objects in small-business life. Sent on time, named clearly and checked before it leaves, it quietly raises the sender's reputation with every accountant, lender and partner who opens it. That is a lot of return on one conversion and two minutes of checking.

Sources and further reading

• What kind of records should I keep? — Internal Revenue Service (IRS)
• What is a bank reconciliation? — University of Central Florida (graduate studies guide, PDF)
• Manage your finances — U.S. Small Business Administration

More guides

How to Convert a Bank Statement PDF to CSV · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist