How to Convert Kotak Bank Statement PDF to Excel & CSV
The Complete 2026 Guide
1. Quick Answer: How to Convert a Kotak Mahindra Bank Statement to Excel
To convert a Kotak Mahindra Bank statement PDF to Excel, first download the statement from Kotak NetBanking, the Kotak Mobile App, or via SMS, then unlock the password-protected PDF using your Customer Relationship Number (CRN) (for account statements) or first 4 letters of your name in lowercase + your date and month of birth in DDMM format (for credit card statements). Then use an offline browser-based converter running on WebAssembly — your Kotak data never leaves your device.
The entire process takes under 60 seconds: download → unlock → convert → verify → download Excel. No installation, no upload, no subscription required for basic use.
Privacy Compliance active
StatementConverter offers 5 free conversions per day with no account required. For unlimited conversions, batch processing, and advanced features, Pro plans start at ₹2,799/month (billed annually).
2. Why Kotak Mahindra Bank Account Holders Need Excel Conversion
Kotak Mahindra Bank is one of India's leading private sector banks, serving millions of retail, NRI, business, and digital-first (Kotak 811) customers across savings accounts, current accounts, credit cards, home loans, personal loans, auto loans, and fixed deposits. Every month, Kotak customers receive password-protected PDF statements — but a PDF is a viewing format, not a working format.
| Task | With Kotak PDF | With Kotak Excel/CSV |
|---|---|---|
| ITR filing | Manually copy 50–300 transactions into Excel for your CA | Export directly; your CA imports and categorizes in minutes |
| GST reconciliation | Cannot match GSTR-2B with Kotak UPI/NEFT/RTGS payments | Filter by date, sort by amount, auto-match with supplier invoices |
| Tally import | No direct import path; manual ledger entry | CSV maps directly to Tally Prime's bank ledger format |
| Expense tracking | Scroll through pages to find a specific UPI transaction | Ctrl+F search, date filters, vendor grouping via pivot tables |
| Loan EMI tracking | Cannot calculate principal vs. interest breakup | Excel formulas auto-calculate EMI components |
| FD interest verification | No way to verify TDS on interest income | Filter "Interest Credit" entries, sum TDS amounts |
| Kotak 811 digital banking | Cannot analyze zero-balance account transactions separately | Filter by account type, track digital payment patterns |
| Audit support | Disorganized paper files | Chronological, searchable digital ledger with balance validation |
The Kotak PDF problem is unique: Kotak statements are not just PDFs — they are password-protected, multi-page, densely formatted documents with UPI IDs, IMPS references, NEFT narration, RTGS details, cheque numbers, EMI schedules, and running balances. Manual extraction is error-prone and time-consuming. For a CA firm handling 30 Kotak client statements per month, manual conversion costs 20+ hours of billable time that could be spent on actual tax strategy.
3. Kotak Statement Password Formats: The Complete Reference
Kotak uses different password formats depending on the statement type and source. Entering the wrong password is the #1 reason users fail to convert Kotak statements. Use this table as your definitive reference:
Kotak Account Statement Passwords (Savings/Current/Kotak 811)
| Source | Password Format | Example |
|---|---|---|
| All Account Statements (Primary) | Customer Relationship Number (CRN) | 12345678 |
| Alternative (if CRN fails) | Date of birth in DDMMYYYY | 15081990 (DOB 15-Aug-1990) |
| Kotak 811 Account | CRN | 12345678 |
| Corporate Accounts | CRN | 12345678 |
| NRI Accounts | CRN | 12345678 |
Critical Note: Your CRN is your Customer Relationship Number — an 8-digit number (not your account number, not your debit card number). You can find it on your Kotak debit card, welcome kit, or by sending SMS with "CRN" to 9971056767 or 5676788.
Kotak Credit Card Statement Passwords
| Source | Password Format | Example |
|---|---|---|
| Primary Format (Email e-Statement) | First 4 letters of name (lowercase) + DDMM of DOB | raje0112 (Name Rajeev Bhargav, DOB 01-Dec) |
| Alternative 1 (Email e-Statement) | CRN + DDMM of DOB | 123456780112 (CRN 12345678, DOB 01-Dec) |
| Alternative 2 (older statements) | First 4 letters (UPPERCASE) + YYYY of birth | SURE1985 (Name Suresh Kumar, birth 1985) |
Quick Password Lookup by Scenario
| Scenario | Try This Password First | Try This Second |
|---|---|---|
| Account statement from NetBanking/Mobile | CRN | DOB (DDMMYYYY) |
| Kotak 811 statement from app | CRN | DOB (DDMMYYYY) |
| Email e-statement (account) | CRN | DOB (DDMMYYYY) |
| Credit card statement via email | First 4 letters (lowercase) + DDMM | CRN + DDMM |
| Joint account statement | Primary account holder's CRN | Primary holder's DOB (DDMMYYYY) |
4. How to Download Your Kotak Statement (6 Methods)
Before you can convert, you need the PDF. Here are the six reliable ways to get your Kotak statement.
Method 1: Kotak NetBanking (Best for Desktop & Full History)
- Visit netbanking.kotak.bank.in and log in.
- Navigate to Accounts → Select your account number.
- Click View Detailed Statement or Download Statement.
- Choose statement period, select PDF format, and click Download.
Method 2: Kotak Mobile Banking App (Fastest for Mobile Users)
- Open the Kotak Mobile Banking app on your device.
- Log in with your CRN and MPIN, or biometric details.
- Tap Accounts → Select your account number.
- Tap Statement or Download Statement and save the PDF.
Method 3: Kotak 811 App (For Digital-First Accounts)
- Open the Kotak 811 app on your smartphone.
- Log in with your credentials, tap Accounts → Select your Kotak 811 account.
- Tap Statement or e-Statement and download the PDF.
Method 4: Email e-Statement (Automatic Monthly Delivery)
- Check your registered email inbox for emails from Kotak Bank.
- Look for the subject: "Account Statement for your Kotak Account" or "Statement for your Kotak Credit Card".
- Download the PDF attachment and open using your CRN or credit card password.
Method 5: SMS Banking (For Quick Statements)
Send SMS "CRN" to 9971056767 or 5676788to get your CRN, or "MINI" to get a quick mini-statement. SMS does not support full statement downloads.
Method 6: Missed Call Banking (For Balance & Mini-Statement)
Give a missed call to 1800-274-0110. You will receive an SMS with your balance and last 3–5 transactions.
5. Step-by-Step: Convert Kotak Statement to Excel
Once you have the password-protected PDF, follow this exact workflow.
Prepare Your PDF File
Rename the file descriptively (e.g. `Kotak_Savings_FY2025-26.pdf`) and open it in a reader to ensure it is not corrupted.
Open the Converter
Go to getstatementconverter.com. The WebAssembly engine loads in browser RAM automatically.
Select Kotak and Enter Password
Choose Kotak Mahindra Bank in the bank selector, and type your CRN or credit card password. Drag and drop the PDF into the terminal.
Convert and Review
Click convert. Wasm processes the statement. Verify transaction row counts, opening balance, and closing balances in the preview table.
Download Your File
Select Excel (.xlsx) or CSV, and download. The file is saved locally from your browser cache.
6. What the Excel Output Looks Like
StatementConverter's Kotak parser extracts the following standardized columns:
| Column | Description | Example |
|---|---|---|
| Date | Transaction date in DD-MM-YYYY | 15-03-2026 |
| Description | Full transaction narration | UPI/CR/1234567890/ABC TRADERS |
| Debit | Amount withdrawn (negative cash flow) | 5,000.00 |
| Credit | Amount deposited (positive cash flow) | 25,000.00 |
| Balance | Running balance after transaction | 1,25,430.50 |
Special Kotak Fields Preserved:
- UPI Reference Numbers: `UPI/CR/1234567890/...` preserved in full for audits.
- NEFT Reference Numbers: `NEFT/DR/123456/...` kept intact.
- RTGS Transaction IDs: `RTGS/123456789012/...` maintained.
- IMPS References: `IMPS/123456789012/...` extracted.
- Cheque Numbers: `CHQ/123456` extracted when present.
- Kotak Bank Charges: `CHG/ATM/WDL` SMS or annual fee parameters categorized.
- Kotak 811 Specific: Digital account flags highlighted.
7. Kotak Credit Card Statement Conversion
Kotak credit card statements have a different layout from savings account statements. They include merchant names, reward points, and auto-debits:
| Column | Description | Example |
|---|---|---|
| Date | Transaction date | 10-03-2026 |
| Description | Merchant or transaction detail | AMAZON.COM*Z2K9L3 |
| Amount | Transaction amount (always positive) | 2,499.00 |
| Type | Debit (purchase) or Credit (refund/payment) | Debit |
| Reward Points | Points earned | 25 |
Note: Kotak credit card statements do not show running balances per transaction. The parser extracts the statement summary (total dues, minimum due, credit limit, available credit, cash limit) as a separate metadata sheet in the Excel file.
8.Kotak Loan, FD & Kotak 811 Statement Conversion
Kotak offers unique layouts for home loans, personal loans, fixed deposits, and the popular Kotak 811 digital account:
Kotak Home Loan Statement
Typically includes disbursements, monthly EMIs with principal/interest breakups, part-payments, and outstanding principal balances.
StatementConverter extracts EMI dates, principal/interest components, total amounts, and outstanding principal.
Kotak Fixed Deposit (FD) Statement
FD principal amounts, maturity dates, interest rates, and TDS interest deductions (verified against Form 26AS details).
StatementConverter extracts principal, maturity dates, interest credits, and TDS interest deductions automatically.
Kotak 811 Digital Account
Zero-balance accounts with high digital transaction density. virtual debit cards, and automated billing details.
Extracts all digital transactions (UPI, NEFT, IMPS) and tags the account type as "Kotak 811" for easy filtering.
9. Use Cases: ITR, GST, Tally, and Audit
For Individual Taxpayers (ITR Filing)
Verify salary receipts against Form 16, trace taxable savings/FD interest, track section 80 deductions (ELSS, PPF), and home loan EMI breakups (Section 24).
For GST-Registered Businesses
Match GSTR-2B credit profiles against actual NEFT/RTGS/UPI outflows, track reverse charge mechanism (RCM) payouts, and monitor Section 194C contractor TDS.
For Tally Prime Users
Tally Prime supports CSV import for bank reconciliation. The converted Kotak CSV matches Tally's expected structure (Date, Narration, Debit, Credit).
For Chartered Accountants & Tax Audits
CAs conducting audits under Section 44AB can filter for deposits exceeding ₹10 lakh, search for high-value items, and validate parameters securely without violating client confidentiality.
10. Batch Processing: Multiple Kotak Statements at Once
Accounting firms and businesses can convert entire folders of Kotak statements in one step:
- Collect all Kotak PDF files.
- Drag and drop them together into the terminal.
- Download as individual Excel files or merge into a single master ledger with a "Source File" identifier.
This reduces processing time for 30 monthly statements from 15+ hours manually to under 10 minutes.
11. Troubleshooting: Kotak Conversion Errors Solved
Error 1: "Password Incorrect"
Ensure you are using your 8-digit Customer Relationship Number (CRN) for account statements, or first 4 letters of name in lowercase + DDMM of birth for credit cards.
Error 2: "No Tables Detected"
The statement is a scanned image (e.g. photos of physical books). Use the Scan Extractor (OCR) mode at 300+ DPI.
Error 3: Missing Transactions in Output
Some multi-line narrations wrap to new rows. Enable "Split Multi-Line Descriptions" in the advanced settings before parsing.
Error 4: Balance Does Not Match Passbook
Verify opening balance matches the first page. Check for page-break transactions split across consecutive pages.
Error 5: Credit Card Password Not Working
Check the name format on your card. If DOB DDMM + lowercase name fails, try CRN + DDMM of birth.
12. Frequently Asked Questions (FAQ)
What is the password for my Kotak bank statement PDF?
For **Kotak account statements** (savings/current/Kotak 811/corporate/NRI), the password is your **Customer Relationship Number (CRN)** — an 8-digit number. You can find your CRN on your debit card, welcome kit, or by sending SMS "CRN" to **9971056767** or **5676788**. For Kotak credit card statements, it is the first 4 letters of your name in lowercase + your date and month of birth in DDMM format.
Can I convert Kotak statements without knowing the password?
No. Kotak encrypts PDF statements to protect your financial data. You must know the correct password to open the PDF. However, once you open it in StatementConverter, you can download an unprotected Excel file for easier future access. Never share your password — it is tied to your personal identity.
Is it safe to convert Kotak bank statements online?
Only if the converter is 100% offline. Cloud-based converters upload your Kotak statement to their servers, creating a data breach risk. StatementConverter uses WebAssembly to process Kotak statements inside your browser — your data never leaves your device. This is the only method compliant with ICAI confidentiality guidelines for CAs handling client Kotak data.
Can I convert multiple Kotak statements at once?
Yes. StatementConverter supports batch processing for Pro users. You can drag and drop multiple Kotak PDFs, and they will be converted individually or merged into one consolidated Excel file. The free tier allows 5 conversions per day.
Does this work for Kotak credit card statements?
Yes. Both Kotak account statements and Kotak credit card statements are fully supported, including password-protected PDFs. Credit card statements extract merchant names, transaction amounts, reward points, and EMI details. All Kotak card types are supported including Urbane Gold, League Platinum, Royale Signature, Delight Platinum, Essentia Platinum, Mojo Platinum, Fortune Gold, PVR Gold, Aqua Gold, and 811 DreamDifferent.
Can I import converted Kotak statements into Tally Prime?
Yes. Tally Prime supports CSV import for bank reconciliation. StatementConverter's CSV output aligns with Tally's expected column structure (Date, Narration, Debit, Credit). Map the columns during Tally import, and your Kotak ledger will populate automatically.
Will my Kotak statement data be stored online?
No. With StatementConverter's WebAssembly architecture, your Kotak PDF is processed entirely on your local device. No data is transmitted to any server, stored in any cloud, or retained after your browser session ends. This is the core privacy advantage over DocuClipper, Lido, and other cloud-based tools.
What if my Kotak statement has 50+ pages?
StatementConverter handles multi-page Kotak statements of any length. A full financial year statement (April–March) with 500+ transactions and 30+ pages processes in under 2 minutes. The Pro plan removes any page limits per document.
Can I convert scanned Kotak passbook pages?
Yes, but only with OCR (Optical Character Recognition). Kotak passbook pages are image-based, not text-based. Use the Scan Extractor mode, ensure the scan is 300+ DPI, and review the output carefully — handwritten entries or faded print may cause OCR errors.
How do I convert Kotak statements for ITR filing?
1. Download the full FY statement (April to March). 2. Convert to Excel using StatementConverter. 3. Sort transactions by date. 4. Add a "Category" column: Salary, Interest, Rent, Utilities, Investments, EMI, Kotak 811, etc. 5. Share the categorized file with your CA for ITR preparation.
Why does my Kotak statement show different balances in Excel vs. PDF?
This usually happens because a transaction was split across a page break and missed, or Kotak bank charges or interest credits were treated as regular transactions, or a reversal or correction entry was not captured. Always verify opening and closing balances. If they do not match, review the statement for summary rows or page-break transactions.
Is there a free way to convert Kotak statements to Excel?
StatementConverter offers 5 free conversions per day with no account required. For unlimited conversions, batch processing, and advanced features like the analytics dashboard, Pro plans are available starting at ₹2,799/month (annual billing).
How do I find my Kotak CRN?
Your Kotak CRN (Customer Relationship Number) is an 8-digit number found on your Kotak debit card (front side), welcome kit, by sending SMS "CRN" to 9971056767 or 5676788, via the Kotak Mobile App, via NetBanking, or by calling customer care at 1860-266-2666.
Does this work for Kotak 811 (zero-balance) accounts?
Yes. Kotak 811 statements are fully supported. The parser extracts all standard transaction fields and tags the account type as "Kotak 811" in the output. This allows you to filter and analyze digital-first banking activity separately from traditional banking. Both Kotak 811 Lite and Kotak 811 Full KYC accounts are supported.
Can I download Kotak statements older than 1 year?
Kotak NetBanking and Mobile App allow you to download statements for up to the last 1 year. For statements older than 1 year, you can request via email e-statement archives, visit your nearest Kotak branch, or contact customer care at 1860-266-2666.
How do I download a password-free Kotak credit card statement?
You can download a password-free Kotak credit card statement from the Kotak Mobile App: Login to Kotak Mobile → Go to Credit Cards → Statements → Select Past Statement → Choose the period and tap Download → Save the PDF to your device. This version has no password. Alternatively, use NetBanking: Cards → Credit Cards → e-Statement → Download.
How do I enable e-statements for my Kotak account?
1. Log in to Kotak NetBanking. 2. Navigate to Accounts → e-Statements. 3. Register your email address. 4. Kotak will start sending monthly e-statements automatically. Monthly e-statements are free.
13. Conclusion
Converting Kotak Mahindra Bank statements from PDF to Excel is not just a convenience — it is a financial compliance necessityfor ITR filing, GST reconciliation, Tally bookkeeping, EMI tracking, and audit preparation. With millions of Kotak customers — including India's largest zero-balance digital banking base through Kotak 811 — and password-protected PDFs that use a unique CRN-based format, having a reliable, secure, and Kotak-specific converter is essential.
StatementConverter is the only tool that combines Kotak-specific format detection (handling the CRN password format, credit card name + DOB format, Kotak 811 tagging, and multi-page statements) with absolute offline privacy via WebAssembly. Whether you are an individual taxpayer preparing for ITR, a business owner tracking GST payments, a Kotak 811 user managing digital transactions, or a CA firm managing 30 client Kotak accounts, the workflow is the same: download, unlock, convert, verify — done in under a minute.
Ready to convert your Kotak statement?
Open our secure Kotak converter terminal. Extract all transactions instantly to formatted spreadsheets entirely on your device.
Launch Kotak Converter Terminal