Convert a Kotak bank statement PDF to Excel, CSV & Tally XML,
without uploading it anywhere

Drop your Kotak Mahindra Bank e-statement below and export it as .xlsx, CSV or Tally Prime vouchers. Parsing runs inside your own browser tab — the PDF is never sent to a server — and every row is checked against the statement's running balance before you export.

Drop your bank statement PDF here

or click to choose a file · SBI, HDFC, Kotak, Axis, ICICI, Federal e-statements

Which Kotak statements work

The netbanking “Account Statement” PDF (delivered as AccountStatement_<from>_<to>.pdf).

verified Verified against a real 193-transaction netbanking statement. Opening and closing balances matched the summary printed on the statement itself.

Scanned or photographed statements are not supported for any bank yet — they are images and need OCR. Native e-statements downloaded from netbanking are also more accurate, because the text is already in the file rather than being guessed from pixels.

How to download your Kotak statement as PDF

  1. Sign in to Kotak Net Banking.
  2. Open the account and select the statement period.
  3. Download the account statement as PDF.
  4. Drop it into TieOut; enter the password if the file is protected.

Menu labels move around as banks redesign their portals. If yours does not match, look for “statement”, “e-statement” or “account statement” and choose PDF rather than Excel or CSV — the PDF is the authoritative document, and TieOut validates against the balances printed on it.

What TieOut does with Kotak's layout

A PDF has no table in it. It stores text fragments at x/y coordinates, and the neat columns you see on screen are visual alignment. Rebuilding rows means knowing what this particular bank does — and Kotak does the following.

  • Kotak’s own name does not reliably appear on page one of the statement, so the bank is detected from the KKBK0 IFSC prefix instead of from the letterhead. Converters that key off the bank name alone frequently fail to recognise the file at all.
  • The header row repeats on every transaction page, which makes the column layout self-describing and Kotak one of the more reliable formats to parse.
  • There is an explicit “Opening Balance” row with “-” placeholders in the amount columns. It is a baseline, not a transaction, and is used to seed the balance chain rather than being exported as a voucher.
  • Narration wraps onto the lines below the dated row, and the continuation is attributed back to that transaction rather than being left as an orphan line or merged into the next one.

Kotak statement columns

Columns# | Date | Description | Chq / Ref. No. | Withdrawal (Dr) | Deposit (Cr) | Balance
Date formatdd-mm-yyyy

How the Kotak conversion is checked

Every extracted row must satisfy balance = previous balance + credit − debit, and the last balance must equal the closing balance printed on your statement. Rows that break the chain are flagged rather than dropped, so a fully green table is provable evidence that no transaction was missed. That is running-balance validation, and it runs on your file rather than on someone else's test set.

Import a Kotak statement into Tally Prime

Export as Tally XML, create the bank ledger in Tally under the same name you exported with, then go to Gateway of Tally → Import → Vouchers and select the file. Rows arrive as Receipt and Payment vouchers with stable IDs, so re-importing the same statement updates rather than duplicates. The full path, including the two things that usually go wrong, is in how to import a bank statement into Tally Prime.

Is it safe to convert a Kotak statement online?

It depends entirely on where the file goes. Almost every online converter uploads your PDF to its server, which puts your account number, balances and every transaction into someone else's storage under their retention policy. TieOut does not upload the file at all — and you can prove it in ten seconds by switching off your Wi-Fi and converting anyway. More on what different converters actually do with your statement.

Kotak Mahindra Bank conversion FAQs

How do I use a Kotak bank statement PDF to Excel converter?

Download the account statement PDF from Kotak Net Banking, drop it into TieOut and export as .xlsx or CSV. Nothing is uploaded — the parsing runs in your own browser tab — and every row is checked against the running balance first.

Why is my Kotak statement not recognised by other converters?

Because the bank’s name often does not appear on page one of a Kotak statement. Tools that identify the bank from the letterhead simply do not match it. TieOut detects Kotak from the KKBK0 IFSC prefix that does appear.

Does the opening balance row get imported as a transaction?

No. Kotak prints an explicit Opening Balance row with dashes in the amount columns; it is used as the starting point for the balance check and is not exported as a voucher.

How accurate is the Kotak conversion?

On the real 193-transaction statement it was verified against, every row passed the balance chain and the opening and closing balances matched the summary printed on the statement. That is the check you can repeat on your own file — a fully validated table is provably complete.

Other banks