Skip to content
New: export to Excel for TallyPrime 4.0+ and JSON for TallyPrime 7.0+.
Taxfilly

Bank

Convert Kotak Bank Statement to Tally XML, Excel & JSON

Turn a Kotak Mahindra Bank bank statement PDF into Tally Payment and Receipt vouchers in a few minutes. Taxfilly has a dedicated Kotak Bank reader, checks every row against the running balance, and works entirely in your browser.

What's supported for Kotak Mahindra Bank

  • Balance-verified on real Kotak Bank statements: Account statement (PDF). These pass our regression suite: rows match the running balance and the totals reconcile to the closing balance.
  • Recognised automatically from the IFSC prefix KKBK0 or the bank name on the statement.
  • Password-protected PDFs open in memory; the password is never stored.
  • Scanned or photographed pages are read with OCR on your device, with uncertain rows flagged.
  • Ledger group: Bank Accounts (or Bank OD A/c for OD and cash credit accounts). Missing ledgers can be created for you.

How to convert a Kotak Bank bank statement to Tally

  1. 1

    Download the Kotak Bank statement

    Download the account statement as a PDF from Kotak Mahindra Bank net banking or mobile banking (or use the PDF the branch emailed you).

  2. 2

    Select Kotak Bank and add the PDF

    Open the Taxfilly converter, choose Kotak Mahindra Bank and drop the PDF. Password-protected files open in memory; scanned pages are read with OCR on your device.

  3. 3

    Choose format, ledger and dates

    Pick Tally XML (any Tally version), Tally Excel (TallyPrime 4.0+) or Tally JSON (TallyPrime 7.0+), enter the bank ledger name exactly as in Tally and the period you need.

  4. 4

    Import into Tally

    Download the file, then in TallyPrime press Alt+O → Import → Transactions and select it. The vouchers appear in the Day Book.

Which format should I choose?

  • Tally XML: works in every TallyPrime and Tally ERP 9 release. The safest choice.
  • Tally Excel (.xlsx / .xls): TallyPrime 4.0 and later. Review or edit rows in Excel before importing.
  • Tally JSON: TallyPrime 7.0 and later.
  • CSV: for review or other accounting software.

Kotak Bank to Tally: questions

Can I import a Kotak Mahindra Bank bank statement PDF directly into Tally?
Not as a PDF: Tally imports structured files, not PDFs. Convert the Kotak Bank PDF into Tally XML, Excel or JSON first, then import it with Alt+O → Import → Transactions.
Which Tally ledger group should the Kotak Bank ledger use?
Use Bank Accounts (or Bank OD A/c for OD and cash credit accounts). If the ledger doesn't exist yet, leave "Create ledgers" on and it is created with the account number, IFSC and branch from the statement.
Is my Kotak Bank statement uploaded to a server?
No. The bank statement is read and converted inside your browser, and the PDF password (if any) is only used in memory. Closing the tab clears everything.
What if my Kotak Bank statement layout isn't read correctly?
Rows that don't match the running balance are flagged so you can fix them before exporting. If a layout keeps failing, send it to us and we'll tune the Kotak Bank reader.