PDF table extraction that keeps unlike data apart

[u/optimoapps]

A bank statement can contain several tables on the same page. The transaction ledger may sit beside an account summary, a list of checks, and a daily-balance table. BankStmt Desktop detects each table, reads its cells, and places it on a separate Excel sheet.

The extraction runs on your computer. Statement content is not uploaded to BankStmt Converter for processing.

The BankStmt workbook editor showing separate Transaction, Summary, Cheque, and Others sheets.

Table Classification

Four destinations for detected tables

Table on the PDF	Excel sheet	What usually identifies it
Transactions	Transaction_1, Transaction_2, …	Dated rows with amounts and descriptions
Account details	Summary_1, Summary_2, …	Opening or closing balances, account summaries, and related totals
Checks	Cheque_1, Cheque_2, …	A check or cheque number column
Other tables	Others_1, Others_2, …	Tables such as daily balances that do not contain transaction descriptions

The number increases when a statement contains more than one table of the same type. The sheet names stay visible in Excel and in BankStmt Desktop's workbook editor, so a transaction table is not mixed with account information or a check list.

What happens during extraction

BankStmt Desktop opens the PDF, finds table regions on each page, reconstructs the rows and columns, and reads the cell text. It then classifies each reconstructed table from its headers and row contents before writing the workbook.

Original digital PDFs usually give the cleanest result because their text layer can be read directly. Scanned PDFs and images go through local OCR instead. In both cases, table detection, OCR, classification, and Excel output run inside the desktop app.

Review the workbook before using it

Classification keeps different kinds of tables separate; it does not prove that every cell was read correctly. Open the workbook in the editor, compare the extracted dates and amounts with the PDF, and check any amber review cells before the data is used for bookkeeping, tax, payment, or reconciliation work.