To turn a PDF bank statement into Excel, download the statement PDF from your bank's website, convert it so each transaction becomes one row with a date, description, amount and balance, then check that the opening balance plus every amount equals the closing balance. That last check proves no transaction went missing.
Downloading the right PDF bank statement
The best file to convert is the official statement PDF that your bank generates in online banking, saved straight to your computer. It holds real text, so every digit can be read exactly. A photo, a screenshot or a scan of a printout holds only pixels and converts less reliably.
Where to find the file
Most banks keep statements under a menu called Statements, Documents or Statements and notices. Pick the account, pick the month, and choose the PDF download. Avoid the print dialog. Printing a statement to a PDF from your browser usually works, but the official download is the cleaner source because the bank controls its layout.
Checks before you convert
Open the PDF before you convert it and look at three things:
- Can you select text? Drag your cursor across a transaction line. If the text highlights, the file has a text layer. If the whole page highlights as one block, it is an image.
- Are all pages there? Scroll to the last page and confirm it shows the closing balance or the end of the transaction list.
- Is it one account? Some banks combine checking and savings in one document. Convert each account separately so the balances can be checked per account.
If the only copy you have is a paper statement, ask the bank whether it can send a PDF first. The guide on whether your bank can send a PDF before you scan a statement covers that route and what to do when the answer is no.
Passwords and protected files
Some banks protect the statement PDF with a password. A converter cannot read a locked file, so open it once in a PDF viewer, enter the password, and save an unprotected copy. Keep that copy somewhere private, because it now carries your account details in plain form.
The four columns a bank statement sheet needs
A bank statement sheet needs four columns: date, description, amount and balance. Those four describe every transaction and let you check the totals. Extra columns are optional, and most of them are easier to add later than to untangle from a messy conversion.
What each column holds
- Date. The posting date, stored as a real Excel date and not as text. A real date sorts and filters correctly.
- Description. The payee or memo text exactly as the bank printed it, including the card-processor prefixes. Do not tidy it yet.
- Amount. A number with two decimals. Money leaving the account is negative if you use one amount column.
- Balance. The running balance printed after the transaction, when the bank prints one.
Columns you can skip, and one to add
The bank may print a reference number, a check number or a separate transaction date. Keep them only if you will use them. One column worth adding yourself is the statement month, such as 2026-09, because it lets you stack several months into one sheet and still tell them apart.
Keep one row per transaction and one header row. Avoid merged cells, blank rows between lines and subtotal rows inside the list, since they break sorting, filters and pivot tables later.
Converting the PDF bank statement, start to finish
Converting a PDF bank statement takes five steps: choose the file, run the conversion, review the rows, fix anything flagged, and save the workbook. The conversion itself takes seconds with a purpose-built tool. The review is where your time goes, and it is worth doing.
The steps
- Pick the PDF. Use the official download from the section above, one account per file.
- Run the conversion. A statement converter reads each page, finds the transaction table and writes one row per transaction.
- Look at the first and last rows. The first row should be the earliest transaction in the period, and the last should be the latest. A missing first or last row is a sign that a page was skipped.
- Run the balance check. The next section explains it.
- Save as XLSX. Name the file after the account and the month so it is easy to find, such as checking-2026-09.xlsx.
If you want to know what a statement converter does differently from a general-purpose tool, what a bank statement converter does with your PDF walks through it. FastBankConvert is built for this job: you drop in the statement PDF and it returns a spreadsheet with the four columns above. It is getting ready to open, so you can get started and be told when trial conversions are available.
A quick look at the result
Before trusting the sheet, scroll through it once. Check that dates run in order, that amounts look like numbers (they should align to the right), and that no description holds a stray date or page number. Those small signs tell you the table was read cleanly.
Do the opening and closing balances match after conversion?
They should. The opening balance plus the sum of every amount must equal the closing balance. If it does, no transaction was dropped or duplicated. If it does not, the difference tells you how large the missing or extra item is, which is usually enough to find it.
A worked example
The figures below are made up for illustration. A three-transaction extract from a statement with an opening balance of 3,000.00 looks like this on the PDF:
Opening balance 3,000.00
09/02 PAYROLL DEPOSIT 1,200.00 4,200.00
09/06 GROCERY MART #204 64.30 4,135.70
09/15 RENT TRANSFER 910.00 3,225.70
Closing balance 3,225.70
After conversion, the Excel rows are:
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-09-02 | PAYROLL DEPOSIT | 1200.00 | 4200.00 |
| 2026-09-06 | GROCERY MART #204 | -64.30 | 4135.70 |
| 2026-09-15 | RENT TRANSFER | -910.00 | 3225.70 |
Put the opening balance in a cell above the table, say E1, and add a check column. In E2 on the first row, the formula =E1+C2 gives the expected balance for that row. On later rows, use the previous balance: in E3, =D2+C3. Then compare each expected figure with the printed balance in column D. Each pair should match to the cent.
Reading a mismatch
If row 3 matches and row 4 does not, the problem sits between those two lines. The usual causes are a transaction skipped at a page break, a fee printed in a separate box, or a minus sign that was read as a dash. The gap between expected and printed balance is the amount to look for on the PDF. FastBankConvert runs a balance check of its own during conversion and tells you before you download if the figures do not add up, but the formula above lets you confirm it in your own workbook.
When the statement prints no running balance
A few statements print only the opening and closing balances. The check still works at the whole-statement level: opening balance plus the sum of the amounts must equal the closing balance. You lose the ability to see which row went wrong, so check that total first and then compare the row count with the PDF.
Should debits and credits share one amount column?
For most uses, yes: one signed amount column is easier to sum, filter and pivot. Money in is positive and money out is negative. Two separate columns match how many statements print the data, and they suit people who read the sheet like a paper ledger.
One signed column
A single Amount column makes the balance formula simple, as the worked example shows. A SUM over the column gives the net movement. A filter for values below zero lists every payment. Many budgeting tools and accounting imports accept this layout, so it is the safer default.
Two columns, debit and credit
Some statements show Withdrawals and Deposits side by side. Keeping that split is fine when you need to total money out and money in separately without a formula. The balance formula changes to =D2+credit-debit, using the deposit cell and the withdrawal cell on the row. Make the empty cells truly empty, not zero-length text, or sums can fail.
Converting between the two
You can move from two columns to one with a helper column: =deposit-withdrawal. Go the other way with =MAX(amount,0) for credits and =MAX(-amount,0) for debits. Pick one layout before you stack months, because mixing the two in one sheet is a common source of wrong totals. A credit card statement flips the usual sign convention, which is covered in how to export a credit card statement to Excel.
Pending and reversed items in a bank statement export
Pending and reversed items explain most cases where one transaction appears twice. A pending item is a hold the bank shows before the charge settles. A reversal is a second line that cancels an earlier one. A monthly statement PDF lists only posted items, so these mostly appear in online banking exports.
Why a transaction shows twice
A card purchase can appear first as a pending authorization and later as a posted transaction, sometimes with a slightly different description or amount. If you copy from the online transaction screen instead of the official statement, you may capture both. The statement PDF is cleaner for this reason.
Reversals are real rows
A refund or a reversed fee is a genuine line with its own date and amount. Do not delete it to tidy the sheet. If you delete a reversal but keep the original charge, your balance check will fail by exactly that amount. Keep both lines, and add a note column if you want to remember why they cancel.
How to spot true duplicates
Two lines with the same date, description and amount can both be real, and the printed running balance is what tells a genuine repeat from a copy. The method, with a safe way to remove copies, is in duplicate rows where statement months overlap.
Once the sheet balances, you can save it as XLSX, or take a plain text copy for another tool. Getting a bank statement as a CSV shows the header row and column choices that work for imports.