Convert Kotak Mahindra Bank PDF Statement to Excel
Kotak Mahindra Bank serves over 4 crore customers and is known for its fully digital 811 account. Kotak's net banking and mobile app generate PDF statements with exceptionally detailed narrations and a unique amount-formatting style that uses Indian-comma separators with trailing decimals, making accurate conversion challenging without purpose-built software.
Kotak Mahindra Bank PDF Statement Quirks
Indian comma formatting
Amounts use strict Indian numbering with commas: 1,50,000.00. Generic parsers expecting Western comma formatting (150,000.00) misinterpret these values.
Narration includes merchant category
UPI transactions include the merchant category code (MCC) and terminal ID inside the narration field, making it 3–4 lines long.
811 vs. full-KYC different templates
Kotak 811 (digital) accounts generate a simpler PDF template than full-KYC savings accounts. Column positions differ between the two.
Password is DOB-based
Statement PDF password is the date of birth in DDMMYYYY format, unlike most private banks that use Customer IDs.
How to Download Your Kotak Bank Statement
Log in to Kotak Net Banking or app
Visit https://www.kotak.com and click 'Net Banking Login', or open the Kotak Mobile Banking app. Authenticate with your CRN and password.
Request e-Statement
Go to Service Requests → e-Statement (or Accounts → View Statement on the app). Select the account and choose date range. Pick PDF.
Save the PDF
The statement downloads protected with your date of birth (DDMMYYYY). Save it and drop it into TruLedger — no need to remember the password, TruLedger prompts you once.
PDF Password
Date of birth in DDMMYYYY format — e.g., 15061985
Available Statement Formats
- PDF (password-protected)
- Excel (.xlsx)
Kotak Statement Columns Detected by TruLedger
TruLedger automatically maps these Kotak Mahindra Bank PDF columns to your Excel output:
Common Issues with Kotak Statements
- Indian-comma formatted amounts cause import errors in non-Indian Excel locales
- 811 digital-account and full-KYC templates have different column counts
- Multi-line UPI narrations with MCC codes look like separate rows in copy-paste
- Passbook-style mini-statements omit the running balance column entirely
TruLedger is designed to handle these patterns in supported layouts, but users should review outputs before operational use.
Frequently Asked Questions — Kotak Mahindra Bank
What is the password for my Kotak Mahindra Bank PDF statement?
The password is your date of birth in DDMMYYYY format. For example, if your DOB is 15 June 1985, the password is 15061985.
Does TruLedger support Kotak 811 digital account statements?
Yes. TruLedger auto-detects both the Kotak 811 template and the full-KYC savings-account template. No manual selection needed.
Will the Indian-format amounts (1,50,000.00) convert correctly?
Yes. TruLedger understands Indian numbering (Lakhs and Crores) and converts amounts to proper numeric values in Excel.
Ready to Convert Your Kotak Statements?
Download TruLedger and convert Kotak Mahindra Bank PDF statements to Excel in the Windows desktop workflow. Users should review exported outputs before operational use.
Download for Windows