Convert Kotak Mahindra Bank Bank Statement to Excel
Kotak statements carry Date, Narration, Chq/Ref No, Withdrawal (Dr), Deposit (Cr) and Balance — but with two quirks that wreck spreadsheets. The balance is printed with a Cr or Dr suffix, and amounts use Indian digit grouping, so ₹1,50,000 refuses to behave as a number after a plain copy-paste; Excel treats ‘1,50,000.00 Cr’ as text and every SUM returns zero. UPI narrations follow the compact ‘UPI/{VPA}/{12-digit ref}’ pattern, which at least stays on one line, yet manually keying dozens of VPAs is its own purgatory. SheetMyBank strips the Cr/Dr suffix into a proper sign, converts lakh-grouped figures into real numeric cells, and leaves the narration searchable in a single column.
On the Kotak app the official route is Statement → Consolidated Statement → pick a month; in net banking it is Accounts → Statement Download. Either PDF converts inside your browser’s memory — SheetMyBank keeps the file on your device from start to finish, with nothing transmitted or retained. Because Kotak prints a balance on every transaction, the tool replays the ledger, adding each deposit and subtracting each withdrawal, and marks any row where the recomputed figure drifts from the printed one.
Drop your Kotak Mahindra Bank statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
Kotak Mahindra Bank statement FAQ
What is the password for a Kotak e-statement PDF?
Kotak email statements open with your CRN — the Customer Relationship Number, typically eight or nine digits, printed on your debit card and visible in the mobile app. Multiple independent sources agree on this scheme, making Kotak one of the more predictable banks for statement passwords.
Why do Kotak balance figures import as text instead of numbers in Excel?
Two reasons: the trailing Cr or Dr marker, and Indian comma placement like 1,50,000.00 that Western Excel locales reject. SheetMyBank removes the suffix, applies the correct sign, and re-emits the value as a plain number, so formulas work without any find-and-replace surgery.
Where do I download a monthly statement in the Kotak app?
Open the app and go to Statement → Consolidated Statement, then select the month you need — that is Kotak’s official menu path. For custom date ranges or older periods, net banking’s Accounts → Statement Download gives finer control over the span covered by the PDF.