Convert a Kotak Mahindra Bank statement to Excel
Kotak is the one bank on this site with two genuinely different real layouts: the downloaded PDF and the Excel/net-banking export do not share a single header token. Both are carried as one profile with two layout variants, so whichever file you have is matched rather than forced into the other's column map. CleanStatement takes your Kotak Mahindra Bank export — whether from Kotak NetBanking or the Kotak 811 app — and turns it into a continuous, verified Excel ledger. Junk rows are stripped, wrapped narrations are re-joined, every date and amount is normalized. The file is processed entirely inside your browser: it is never uploaded to a server.
What makes a Kotak Mahindra Bank statement hard to use in Excel
Opening a Kotak export in a spreadsheet rarely gives you something you can work with. The specific problems with this bank's format are:
- The downloaded PDF carries a bare serial-number column (#) that column inference can mistake for a money column.
- A reprinted page banner can be glued into the narration of the nearest transaction.
- The PDF and the Excel export have different column counts, so one column map cannot serve both.
The Kotak column layout
When you download a statement from Kotak NetBanking or the Kotak 811 app, it typically contains these columns in order:
- **#**
- **Date**
- **Description**
- **Chq/Ref. No.**
- **Withdrawal (Dr.)**
- **Deposit (Cr.)**
- **Balance**
How CleanStatement extracts your data
CleanStatement detects Kotak Mahindra Bank statements by looking for its specific column header pattern. When it sees columns like "#" and "Balance", the engine knows exactly how to map the data.
Because this layout is verified against real Kotak statements, it runs on an exact fast-path rather than guessing.
From there, the same pipeline runs for every bank: repeated page headers, logos, and footers are dropped; continuation rows are folded back into the transaction above them; dates are normalized; amounts with lakh/crore grouping become real numbers; and newest-first statements are re-ordered so the running balance reconciles.
Steps to convert your Kotak statement
You can download your statement from Kotak NetBanking or the Kotak 811 app in PDF and Excel from Kotak NetBanking. Any of these formats works — they all normalize to the same internal table.
- Open CleanStatement and drop the file onto the upload area. Nothing is transmitted; the file is read by your own browser.
- If the PDF is password-protected, enter the password when prompted — it is used locally to decrypt the file and never sent anywhere.
- Review the status card: the detected bank, the transaction count, the statement period and a pass/fail balance-verified badge.
- Check the issues panel for duplicates, balance gaps, round-figure anomalies and returned or bounced transactions.
- Optionally click Classify to tag every row to an accounting ledger head.
- Download the cleaned .xlsx.
Frequently asked questions
Is my Kotak statement uploaded anywhere?
No. The entire conversion happens inside your browser tab. Your Kotak Mahindra Bank statement is never uploaded to a server, and there is no third-party API involved. This is why the tool keeps working even if you go offline after the page has loaded.
Can I convert a password-protected Kotak PDF statement?
Yes. Kotak statements downloaded from NetBanking are often encrypted with your date of birth, customer ID or a similar key. CleanStatement prompts for the password and decrypts the file locally in the browser.
Will the running balance in the converted file be correct?
The tool recomputes the running balance row by row and compares each figure against the balance printed on your Kotak statement. If every row reconciles you get a Balance verified badge; if any row does not, it is flagged for review rather than silently corrected.
Can I import the converted Kotak statement into Tally?
Yes. After classification, the downloaded workbook includes a voucher-import sheet for Tally, Zoho Books, QuickBooks or Vyapar, using a proper double-entry mapping — money out as a Payment voucher, money in as a Receipt.