Convert a Kotak Mahindra Bank Statement to Excel
Kotak prints withdrawals and deposits in one column, each figure marked (Dr) or (Cr). How that breaks converters, and how to read and check it.
Kotak Mahindra statements have one structural quirk that causes more conversion failures than anything else about them, and it is worth understanding before you convert one.
The combined amount column
Most banks print two separate columns — one for withdrawals, one for deposits. In the Kotak statement we checked, the table reads Date, Narration, Chq/Ref No, Withdrawal(Dr)/Deposit(Cr), Balance: one amount column, with (Dr) or (Cr) written straight after each figure, as in 1,000.00(Dr). The Balance carries a marker too.
A converter that expects two columns will map this one column to whichever of debit or credit it happens to match first, and every transaction in your file ends up on the same side. Your totals become meaningless and the balance chain fails on the second row.
The correct handling is to read the marker on each amount: it is the only thing that says which way the money moved. Where a marker is missing, the running balance settles it: if the balance went down, it was a debit.
What you get back
| What Kotak prints | What the spreadsheet holds |
|---|---|
| Date | Exactly as printed, DD-MM-YYYY. Nothing is reformatted |
| Narration | The full text, UPI and IMPS padding included, with wrapped lines joined into one cell |
| Chq/Ref No | Its own column, as printed, stored as text in the Excel file so a long reference stays whole |
| Withdrawal(Dr)/Deposit(Cr) | One column, as Kotak prints it, every figure still carrying its (Dr) or (Cr) |
| Balance | As printed, marker included, and what every row is checked against |
The combined column is not split, because splitting it would be a column Kotak never printed. The markers are what the checks read instead: a Completeness sheet beside the table tests every row against the balance printed next to it, so a marker read the wrong way round shows up as that row disagreeing. If you need separate signed amounts, the QBO and Tally XML downloads turn each marker into a debit or a credit.
An example in Kotak's layout
A made-up example. Every row below is invented — SAMPLE names, round amounts — and set out the way the Kotak statement we checked sets out its table: the same five headings, in the same order, dates as DD-MM-YYYY and the marker written straight after each figure. The second transaction's narration wraps onto a second line.
| Date | Narration | Chq/Ref No | Withdrawal(Dr)/Deposit(Cr) | Balance |
|---|---|---|---|---|
| 01-04-2025 | NEFT SAMPLE EMPLOYER LTD SALARY | NEFT-000000000001 | 25,000.00(Cr) | 30,000.00(Cr) |
| 02-04-2025 | UPI/SAMPLE CAFE/000000000002 | UPI-000000000002 | 200.00(Dr) | 29,800.00(Cr) |
| PAYMENT FROM PHONE | ||||
| 06-04-2025 | ATM WDL SAMPLE BRANCH | ATM-000000000003 | 3,000.00(Dr) | 26,800.00(Cr) |
What the Excel or CSV gives back. The same five headings in the same order, every figure exactly as printed with its (Dr) or (Cr) still attached, and the wrapped line joined back into its narration — three transactions, three rows.
| Date | Narration | Chq/Ref No | Withdrawal(Dr)/Deposit(Cr) | Balance |
|---|---|---|---|---|
| 01-04-2025 | NEFT SAMPLE EMPLOYER LTD SALARY | NEFT-000000000001 | 25,000.00(Cr) | 30,000.00(Cr) |
| 02-04-2025 | UPI/SAMPLE CAFE/000000000002 PAYMENT FROM PHONE | UPI-000000000002 | 200.00(Dr) | 29,800.00(Cr) |
| 06-04-2025 | ATM WDL SAMPLE BRANCH | ATM-000000000003 | 3,000.00(Dr) | 26,800.00(Cr) |
Verifying the markers
The balance column is what proves the (Dr) and (Cr) markers were read correctly. Walk it from the opening balance: previous balance minus a (Dr) figure, or plus a (Cr) one, should equal each row's printed balance — 30,000.00 less 200.00 is 29,800.00 in the example above. If a credit was taken for a debit, the chain breaks at exactly that row.
Then compare your debit and credit sums against any totals Kotak prints. The chain proves the markers were read right; the totals prove nothing is missing. More on why both are needed in balance-chain reconciliation.
Converting a Kotak statement
- Download the statement from Kotak net banking If the file is password-protected, the covering email or the download page states the rule.
- Upload the whole file Including any summary carrying opening and closing balances.
- Check the markers came through Every figure in the combined column should still carry the (Dr) or (Cr) Kotak printed. That marker is what tells a withdrawal from a deposit.
- Walk the chain Which confirms every marker was read the right way round. The Completeness sheet does this row by row.
Kotak UPI narrations
Kotak packs the payment mode, a reference and the counterparty VPA into one narration field, with placeholder padding on many rows. The converted file keeps that narration exactly as printed, so it still matches the PDF when you search it.
To group on the counterparty, pull the VPA out with a formula rather than reading the whole string. Keep the reference as text when you do: a twelve-digit number is a candidate for being misread as currency by whatever tool reads the file next.
Frequently asked questions
Does Kotak 811 use the same format?
Yes, Kotak 811 digital accounts produce the same statement layout as regular savings accounts.
How do I check the (Dr) and (Cr) markers were read correctly?
Read the Completeness sheet. Every row is checked against the balance Kotak printed beside it, so a marker read the wrong way round shows up as that row disagreeing.
Are Kotak credit card statements supported?
Yes, though they carry no running balance, so verification compares against the printed total spend and payment figures.
Are Kotak narrations shortened?
No. Each narration comes through exactly as printed, padding included, with a narration that wraps onto a second line joined back into one cell.
Related posts
- Convert a UCO Bank Statement to Excel or CSV
- Convert a Yes Bank Statement to Excel
- Convert a Bank of India Statement to Excel
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.