Cosmovex/tools

Convert a statement with 1,23,456.78 amounts and dd/mm/yy dates to Excel

Lakh-grouped amounts with Statement to Spreadsheet

This page opens with a statement that groups digits as 1,23,456.78, prints dates as dd/mm/yy, and has Withdrawal, Deposit and Closing Balance columns plus a reference number and a value date. Those columns are read and kept, and the amounts arrive in Excel as plain numbers.

  1. Drop your statement PDF on the tool. It is read in your browser and never uploaded.
  2. Leave the date order on day, month, year (or Automatic if a date such as 25/03/25 appears in the file).
  3. Check the amounts in the preview: 1,23,456.78 should show as 123,456.78, and extra columns such as the reference number are kept.
  4. Press Download Excel.
bank statement pdf to excel lakh statement with withdrawal and deposit columns to exceldd/mm/yy bank statement to excelconvert statement 1,23,456.78 to excelchq ref no value date statement to excel
Open Statement to Spreadsheet Free to start · no account

What to know

Some statements group digits in twos after the first three, so one lakh is written 1,00,000 and ten lakh 10,00,000. A parser that assumes groups of three can misread these. The tool strips the grouping commas and reads the decimal point, so 1,23,456.78 becomes the number 123456.78, and the Excel cell is a real number you can add up.

Two-digit years and day-first dates are common on these statements. A date such as 14/03/25 can only be a day-first date, and the tool uses that to settle the order when it can. If every date in the file is ambiguous, it shows its reading and lets you choose, so 04/05/25 is never silently turned into the wrong month.

Statements often carry columns beyond date, narration and amounts: a cheque or reference number and a value date. They are kept as extra columns after Balance, named as they are printed, so the reference stays beside the transaction it belongs to. The Balance check works with Closing Balance in the same way as on any other statement.

Updated · Cosmovex

Questions

Does it understand 1,23,456.78 grouping?

Yes. Commas are treated as grouping marks, and the dot is the decimal point, so 1,23,456.78 is read as 123456.78 and written to Excel as a number.

What about the reference number and value date columns?

They are kept as extra columns, named as printed, after the Balance column, so each reference stays with its transaction.

How are dd/mm/yy dates read?

A date with a day above 12 settles the order automatically. If every date is ambiguous the tool shows day first and asks you to confirm or change it. Two-digit years from 00 to 69 are read as 2000s and 70 to 99 as 1900s.

Can I get Withdrawal and Deposit as one signed column?

Yes. The workbook has Debit and Credit columns and also a signed Amount column where money out is negative.

Is anything uploaded?

No. The statement is read and the Excel file built in your browser. Nothing from the PDF is sent to our servers.

The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.