# Bank statement PDF to Excel: check dates, amounts, and missing rows

> Check six fictional transactions after extracting a bank statement. Keep dates, descriptions, signs and balances with the right rows.

[Read this guide in Edit PDF Pages](https://editpdfpages.com/guides/bank-statement-to-excel/)

Content updated: 2026-10-12. Example checked 12 October 2026 in Chrome 155 on macOS.

A payment in the wrong row is easy to overlook once a statement becomes a spreadsheet. Before sorting or calculating, compare each transaction with the PDF, including wrapped descriptions, minus signs and empty cells.

The fictional [sample statement](https://editpdfpages.com/guides/examples/statement.pdf) has six transactions to check. Its September 25 payment is **-1,300.00**, and the closing balance is **16,770.55**. Those values give you useful checkpoints without using a real account record.

## Get the first page into the table preview

Open the statement in the [PDF workspace](https://editpdfpages.com/) and select the transaction page. Choose **Extract table**, leave **Extract from** on **Current page**, then choose **Extract table** inside the dialog.

Identify the date, description, amount and balance columns before editing. Extraction follows text positions and may also pick up an account heading, summary or footer. Click a cell to correct it, use **Row** or **Column** to add space, and remove unwanted rows with their × buttons.

## Work down the statement one transaction at a time

- **Count transactions.** This sample has six. A merchant description wrapped onto another line is still part of the same transaction. Repeated headings on a longer statement are not extra payments.
- **Keep each date with its description and amount.** Follow the source's date format. Do not add a missing year unless the statement establishes it.
- **Inspect the signs and decimal points.** Check the September 25 payment carefully. A lost minus sign changes its meaning even when every digit survives.
- **Keep blanks distinct from zero.** If a statement separates money in and money out, preserve those columns instead of guessing how an empty cell should be filled.
- **Compare the balances.** Check the closing 16,770.55 as well as the individual rows. One matching total cannot catch every misplaced transaction.

Different banks arrange their statements differently. A successful extraction of this sample does not establish that another layout will produce the same columns. If the preview misses substantial content, the [invoice example](https://editpdfpages.com/guides/pdf-table-to-excel/) shows what manual repair can involve.

## Save the checked values

Choose **Export Excel** for XLSX or **Export CSV** for a plain table. Open the downloaded file in your spreadsheet app and inspect dates, identifiers and amount formats before sorting or adding formulas. The export contains cell values; it does not apply accounting rules.

For a scanned statement, run [English OCR](https://editpdfpages.com/guides/make-scanned-pdf-searchable/) first and compare recognized digits and punctuation with the page. Pages containing redactions or replacement edits are excluded entirely from extraction, so the table cannot expose the concealed source values.

**Keep the spreadsheet download.** Table corrections are temporary and are cleared when the PDF changes. Projects and local drafts do not save them.

## Worked example

![Extracted fictional statement showing transaction dates, descriptions, amounts and balances](https://editpdfpages.com/guides/images/bank-statement-to-excel.png)

All six fictional transactions were compared with the source. The CSV keeps the September 25 payment of -1,300.00 and closing balance of 16,770.55.

## Related guides

- [PDF table to Excel: fix the rows before you export](https://editpdfpages.com/guides/pdf-table-to-excel/)
- [How to make a scanned PDF searchable](https://editpdfpages.com/guides/make-scanned-pdf-searchable/)

These guides were prepared with AI assistance and checked using fictional documents. Examples contain no real customer or account data. See each guide's example for the workflow and its limits.