Convert Kotak Mahindra Bank statement to Excel — how it works
- Upload your PDF — download the statement from Kotak Mahindra Bank netbanking/app. It is password-protected? Enter the password (DOB DDMMYYYY or Customer ID) in the password field first.
- Auto-parse — the Kotak profile detects your layout (Date | Narration | Chq/Ref No | Withdrawal (DR)/Deposit (CR) [SINGLE col, neg=DR] | Balance) and extracts every row.
- Download Excel — clean .xlsx with transactions + summary sheets, sorted by date.
What the Kotak export contains
- Date & Value Date — both date columns, standardised to DD/MM/YYYY-safe ISO format
- Description — full narration (UPI/NEFT/IMPS/ACH refs preserved), wrapped lines joined automatically
- Ref / Cheque No — reference and cheque numbers in their own column
- Debit & Credit — withdrawals and deposits in separate columns (INR)
- Balance — running balance, with automatic reconciliation check (every row verified)
- Summary sheet — opening/closing balance, totals, net change, balance check %
Kotak Mahindra Bank statement formats supported
Savings, current/checking, salary and joint accounts — single-page and multi-page statements, INR amounts , Indian-format grouping (1,23,456.78), and repeated page headers are handled automatically. Batch-convert several months at once; duplicates across files are marked (yellow) but never deleted.
The tool above is the real converter — it runs entirely in your browser. If the box doesn't load (some ad-blockers block iframes), open the tool in a new tab with Kotak pre-selected.
Frequently Asked Questions
A: Upload your Kotak Mahindra Bank statement PDF in the tool below (or on the main converter page), and download the Excel file. Every transaction — date, description, ref/cheque no, debit, credit and running balance — is extracted automatically.
A: Date, Value Date, Description, Ref/Cheque No, Debit, Credit and Balance — exactly as in your Kotak Mahindra Bank statement (Date | Narration | Chq/Ref No | Withdrawal (DR)/Deposit (CR) [SINGLE col, neg=DR] | Balance), plus a Summary sheet with opening/closing balance and totals in INR.
A: Kotak Mahindra Bank statements are password-protected. DOB DDMMYYYY or Customer ID. Enter it in the password field — the PDF is unlocked locally in your browser.
A: No — everything runs in your browser. Your file never leaves your device.
A: Yes. The engine reads the balance column of your Kotak Mahindra Bank statement and verifies each row: previous balance − debit + credit = balance. A 100% balance check means the export matches Kotak exactly.
🚀 Open the Kotak Converter
About Kotak Mahindra Bank statements
Kotak Mahindra Bank (India, INR) e-statements show: Date | Narration | Chq/Ref No | Withdrawal (DR)/Deposit (CR) [SINGLE col, neg=DR] | Balance. These PDFs are great to read but hard to analyse — copy-paste breaks columns and drops wrapped narrations. This converter reads the actual text layer of the PDF, detects your Kotak layout automatically and rebuilds every row in clean Excel columns, cross-checking each amount against the running balance before export.
- D
- o
- w
- n
Independent tool — not affiliated with Kotak Mahindra Bank. Your file is processed entirely in your browser and never uploaded.