How to Convert Kotak Mahindra Bank Bank Statement to Excel

How Kotak Mahindra Bank statements are structured

Kotak Mahindra Bank occupies a unique position in Indian banking as both a traditional full-service bank and an early digital banking pioneer through its Kotak 811 zero-balance digital account — and this dual identity creates a split-format challenge that no other Indian bank presents. Regular Kotak savings and current account statements use one PDF layout; Kotak 811 statements use a different, simplified layout; and customers who hold both (common, since 811 accounts are often opened as secondary accounts linked to a primary Kotak relationship) may receive a consolidated statement combining both formats in one document. The regular account format uses six columns: Date, Narration, Chq/Ref No, Withdrawal, Deposit, and Closing Balance. This is a clean split-column design (separate Withdrawal and Deposit columns rather than a single Amount with Dr/Cr suffix) — easier to parse than Axis Bank's format but with its own complications in the Narration field. Kotak's Narration begins with a channel identifier prefix: 'MB' (Mobile Banking via Kotak app), 'NB' (Net Banking), 'ATM', 'POS', 'CDM' (Cash Deposit Machine), 'BRN' (Branch), 'API' (third-party app integration). After the channel prefix comes the transaction type and details, concatenated without a consistent separator. A UPI transaction via mobile app reads: 'MB UPI 412345678901 PAYEE NAME payee@kotak'. A net banking NEFT reads: 'NB NEFT KKBK0001234 BENEFICIARY NAME REF123'. The absence of slash or pipe delimiters — Kotak uses spaces throughout — makes it significantly harder to programmatically separate the channel, mode, reference, and beneficiary components compared to HDFC's slash-delimited format. Kotak 811 account statements use a simplified four-column layout: Date, Description, Amount (single column, no Dr/Cr suffix — debits are negative, credits are positive), and Balance. The Description field uses a different narration format from regular accounts: shorter, no channel prefix (since 811 is digital-only, MB is implied), and often truncated to 30 characters. When a consolidated statement combines both account types, the format switches mid-document at the 811 section header — a transition that breaks any converter expecting a consistent column count throughout the PDF. Interest credit entries on Kotak statements include the calculation period in parentheses within the narration: 'INT CREDIT (01-APR-24 TO 30-JUN-24) @ 3.50% PA'. This parenthetical data wraps to a second line on the PDF, creating a continuation line with no date and no amount that parsers mistake for a new transaction. Kotak's Standing Instruction (SI) section lists auto-debit mandates with their next execution dates and amounts — informational, not transactional, but formatted as a table. The TDS (Tax Deducted at Source) summary for interest above Rs. 40,000 appears as a mini-table showing the interest amount, TDS rate, and TDS deducted. Kotak business (Current Account) statements add Cheque Book Inventory (tracking issued, used, and cancelled cheques), a Cash Deposit Detail section (listing denomination-wise currency notes for each cash deposit — unique to Kotak among Indian banks), and a Transaction Charge Summary itemizing fees per transaction type. CleanStmt detects whether a statement is regular, 811, or consolidated format; handles the space-separated narration by identifying the channel prefix and transaction mode boundaries; correctly processes negative amounts in 811 format and split columns in regular format; merges interest credit continuation lines; and excludes SI mandates, TDS summaries, cheque inventory, and cash denomination sections from the transaction export.

Compare with similar statement converters

Browsing alternatives in the same category helps teams choose the right conversion workflow for each statement source.

Related conversion use cases

• Convert PDF Statements to Excel for Bank Reconciliation
• Convert Bank Statements to QuickBooks-Ready CSV
• Convert Scanned Invoices to QuickBooks CSV
• Scanning Invoices into QuickBooks Without Manual Entry
• Scan Receipts to Excel — Turn Any Receipt into a Spreadsheet
• Convert Invoice PDFs to Excel — Extract Line Items Automatically
• Convert Credit Card Statements to Excel
• Convert Bank Statement PDF to OFX — Import into Quicken & Accounting Software
• Convert Bank Statement PDF to IIF — Import into QuickBooks Desktop
• Convert PDF Bank Statement to Excel
• Convert Bank Statement to Google Sheets
• Angus Cheng Bank Statement Converter Alternative
• Bank Statement to Tally Prime Converter
• CSV Bank Statement — Clean Format for Accounting Tools
• Convert Multiple Bank Statements to Excel — Batch Processing
• Bank Statement Excel Converter — Clean Spreadsheet Output
• Bank Statement CSV Format — Standard Structure Explained
• Bank Statement to CSV Converter — Free Online Tool
• Bank Statement to PDF Converter — Searchable PDF from Scans
• Convert Bank Statement to Excel — Free Instant Conversion