Turn a bank statement PDF into Excel

A statement is the one recovered table that can check itself, and that check is the whole feature. Rows are read, typed as dates and numbers, and then verified against the balance column.

• Each row is checked against the one above it, to the paisa.
• A break in the chain names the row it broke at, rather than failing quietly.
• Dates and amounts are written as dates and numbers, not as text.

The balance column is the proof

Any converter can produce a grid of strings. The question nobody else answers is whether the grid is right, and on a statement there is an answer: every row carries a running balance, so the previous balance plus the debit or credit has to equal this one. Where it does, the row was read correctly. Where it does not, something was lost.

And something is lost surprisingly often. A transaction that straddles a page break is the usual culprit, and it disappears without any visible damage at all: the spreadsheet looks complete, the columns line up, and one line of the month is simply missing. Naming the row the chain broke at is the difference between fixing the file and quietly distrusting every statement you convert from now on.

Column direction is worked out rather than assumed. A debit and credit pair settles it; failing that, a marker column; failing that, an inline marker on the amount; failing that, the balance delta itself, which is the only way a statement with one money column can be read at all. Where the numbers only add up with two columns swapped, they are swapped, because a bank that prints deposits first under headings that do not say so is a real bank.

Typed output, or there was no point

A date written into a cell as text is a date you cannot sort by, and an amount written as text is an amount you cannot total. Both are written properly here, with the Indian grouping recognised where the statement used it, so a figure printed as 48,20,000 is not read as forty-eight point two.

The heading row stays in view when you scroll, the columns are set wide enough that dates and grouped amounts do not show as hashes, and the file opens in Excel, Numbers, LibreOffice and Google Sheets. A downloaded statement is read straight off the page where it can be; a scanned or photographed one goes through recognition first, which is what the first step of the plan is for.

Is my statement uploaded?

No. It is opened and converted inside this browser tab. Nothing is sent anywhere and nothing is kept once you close it.

What if a row does not add up?

You are told which row, rather than being handed a file that looks fine. That is almost always a transaction lost at a page break.

Does it work for any bank?

It reads the layout rather than a per-bank template, including statements with a single money column and no headings.

Support and billing: support@gosmartpdf.com. Operated by Mrityunjay Kumar, India. Payments by Dodo Payments, our merchant of record.

Loading the editor…