Kotak Mahindra Bank Statement to Excel or CSV

Kotak's Net Banking can produce a statement for one account or a combined one, by financial year or calendar year, and its e-statements arrive by email with a password. For a bookkeeper that's a useful choice but a lot of PDFs. Upload them here to turn each into a table of dates, descriptions and signed amounts, with the balance checked from the opening figure to the close.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Kotak Mahindra Bank statement into Excel

  1. Download the PDF statement from Kotak Mahindra Bank online banking

    • Log in to Kotak Net Banking or the Kotak mobile banking app (Kotak811 customers log in to the Kotak811 app with CRN and MPIN).
    • In the Kotak811 app, go to Statement and tap Consolidated Statement; on Mobile Banking, go to Banking > Account Statement; on Net Banking, go to Banking > Service Request > New Service Request > Account Statement.
    • Select the month or duration (and Email or Post for a requested statement); emailed statements arrive within the same working day.
    • Save the statement for the period you need as a PDF.
    Go to Kotak Mahindra Bank Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Kotak Mahindra Bank statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · INR
Sample bank statement rows with made-up data, amounts in INR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Kotak Mahindra Bank statements

Financial year or calendar year

Books, GST reconciliations and ITR work run April to March, which Kotak offers as a financial-year statement. A calendar-year statement splits your year across two files. Either converts here, but the financial-year version saves you stitching two PDFs together and checking the join.

Combined statements cover several accounts

A combined statement puts more than one account in a single document. Before importing, check on the review screen that each account's rows and balances stayed together, or request account-level statements so each file reconciles to one opening and one closing balance.

Email statements are password protected

Kotak says its e-statements are password protected, and that applies to current account statements sent to businesses too. Upload the PDF without changing it and enter its password when the converter requests it. The password is only used to open that statement, and nothing keeps it afterwards.

Kotak811 statements by month

Kotak811 customers pick a consolidated statement month by month in the app. Twelve monthly files are easy to convert one at a time, and when you upload them together the period check tells you if a month is missing or was saved twice.

Output and review

From Kotak Mahindra Bank PDF to your books

Accounting tip

TallyPrime imports Kotak statements in Excel, CSV or MT940 when they come straight from the bank, and Kotak is on its Connected Banking list. For months you only hold as PDF, keep the converted sheet open beside Tally's bank reconciliation and enter the bank dates by hand.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Kotak Mahindra Bank statement questions

How quickly does Kotak send a statement I request?
Kotak says emailed statements are sent within the same working day of the request, and physical statements within seven working days. The emailed PDF is password protected; upload it as received and give the password when asked, which opens the file without it being stored.
Which Kotak statement should I upload for a tax audit?
The financial-year statement for each account, April to March. One file per account keeps the opening and closing balances clean, and the running-balance check confirms nothing was dropped. Keep the original PDFs with the audit file; the spreadsheet is your working copy.
Can I import converted Kotak Mahindra Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Kotak Mahindra Bank statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Kotak Mahindra Bank.