Toolzy
Finance and document tools
ToolsBank statementsAI AgentsPricingInsightsHelp CenterContact Us
Home/Bank statement converter/Kotak/Tally XML

Kotak Mahindra Bank (Kotak) Bank Statement PDF to Tally XML Converter

Convert Kotak Mahindra Bank (Kotak) statement PDFs into Tally-compliant XML files for voucher import into TallyPrime and Tally.ERP 9. Designed for digital/text PDFs downloaded from Kotak portals (scanned copies are detected and rejected). Credit entries are formatted as Receipt vouchers and debit entries as Payment vouchers. Preview page 1 without signing in, unlock password-protected PDFs, and get 10 free pages on signup.

Open the bank statement converter10 free pages · 1 credit per page
Other formats for Kotak: Excel (XLSX)·CSV·All Kotak formats

What you get in the Kotak Tally XML export

The converter parses text elements from digital Kotak Mahindra Bank statements and maps them into the exact data fields required for Tally XML. Here is what is included in the output:

Tally XML Voucher Envelope

Root XML structure conforming to Tally's Import Data standard for accounting vouchers.

Field / TagDescription
<VOUCHER VCHTYPE="Receipt">Generated for deposit transactions (credits) to record incoming receipts in your Tally company.
<VOUCHER VCHTYPE="Payment">Generated for withdrawal transactions (debits) to record outgoing payments.

Voucher Field Mapping

XML tags constructed for each individual accounting entry in the statement.

Field / TagDescription
<DATE>Transaction date formatted as YYYYMMDD as required by Tally's import engine.
<VOUCHERNUMBER>Sequential voucher numbering across transactions.
<NARRATION>Combined transaction description and reference identifier, XML-escaped for safety.
<ALLLEDGERENTRIES.LIST> (Bank)Bank account ledger entry (default name 'Bank') with deemed positive/negative indicator and transaction amount.
<ALLLEDGERENTRIES.LIST> (Counter)Contra ledger entry (default name 'Suspense') ready for accountant allocation in Tally.

How to convert a Kotak statement to Tally XML

  1. Download the text-based digital e-statement PDF from Kotak Mahindra Bank.
  2. Upload the PDF to the converter and supply the document password if a Kotak statement is protected.
  3. Preview page 1 transactions to verify dates, debits, and credits. Create a free account to convert the entire statement with 10 free pages.
  4. Download the Tally XML voucher file to your computer.
  5. Open your company in TallyPrime or Tally.ERP 9, navigate to Import Data > Vouchers, and select the downloaded XML file to create your bank vouchers.

Kotak statement layout & password details

Statement Layout

  • Kotak statements usually show the CRN and account number in the header and a table of date, narration, debit, credit, and balance. UPI and NEFT references sit in the narration. A custom date range from the statement request is the file bookkeepers need. A last-five-transactions view is too short to reconcile a month.
  • Your CRN is the user id Kotak documents for net banking. It identifies the relationship. It is not, by itself, a password this page can promise will open every PDF.

PDF Password

Kotak Mahindra Bank does not publish one PDF password that fits every statement on the public pages this guide cites. When the file is protected, use the password printed in the e-statement email or on the download screen. Your CRN (Customer Relationship Number) is the identifier Kotak documents for net banking. Kotak's "What is my CRN?" help page says you can get it by sending the SMS CRN to 9971056767 or 5676788 from your registered mobile. That page does not say the CRN is the statement-PDF password.

Reported, not confirmed by Kotak, and the reports disagree: TaxGuru (updated 30 January 2025) says the e-statement password is the CRN. Another guide reports the date of birth as DDMMYYYY (15 March 1990 would be 15031990) and says to use the CRN only if the email or download screen identifies it as the password. A third reports lowercase name letters plus DDMM, or the CRN. This page does not treat any of those as a rule. Follow the email or the download screen. Password-protected PDFs are supported directly: enter the password to unlock the statement before conversion.

Published (CRN identifier, not a PDF-password rule): Kotak, What is my CRN?

Reported: TaxGuru bank e-statement table (updated 30 Jan 2025)

Password-protected statements are unlocked directly in memory before conversion. If you need to permanently decrypt a file first, use the PDF Password Remover.

Digital PDFs Only

The converter works exclusively with digital/text PDFs downloaded from Kotak Mahindra Bank internet banking or mobile apps. Scanned documents, photos of physical passbooks, and flattened image files are detected and rejected to ensure data integrity.

Importing XML Vouchers into Tally

Learn step-by-step how to configure ledgers, verify voucher dates, and import your converted XML file into TallyPrime or Tally.ERP 9 without data errors.

Read the Tally XML import guide →

Frequently asked questions: Kotak to Tally XML

How do I import Kotak statement transactions into Tally?

Upload your digital Kotak Mahindra Bank statement PDF to Toolzy, convert it, and download the Tally XML file. In TallyPrime or Tally.ERP 9, open your company, navigate to Import Data > Vouchers, and select the downloaded XML file. Toolzy generates a standalone XML voucher file that you download and import through Tally's Import Data menu; it does not connect to or control desktop accounting software.

What voucher types are generated for Kotak statements?

The XML file categorizes transactions automatically: credit entries (deposits) are structured as Receipt vouchers, and debit entries (withdrawals) are structured as Payment vouchers. Each voucher contains the transaction date, sequential voucher number, and narration.

Which ledgers are assigned in the Kotak Tally XML file?

The exported XML uses standard placeholder ledgers: 'Bank' for the bank account entry and 'Suspense' for the counter entry. Once imported into Tally, you or your accountant can review the vouchers and reassign the Suspense ledger to the appropriate customer, vendor, or expense accounts.

Does the converter work with password-protected Kotak PDFs for Tally export?

Yes. You can enter your Kotak PDF password during upload to decrypt the statement in memory before conversion. Files are processed securely and deleted within 24 hours.

Can I convert scanned Kotak statements or passbook photos to Tally XML?

No. The converter requires text-based digital PDFs downloaded directly from Kotak Mahindra Bank online banking. Scanned copies and camera images are detected and rejected to prevent posting corrupt accounting vouchers into Tally.

Convert other Indian bank statements to Tally XML

Bank of Baroda to Tally XMLPNB to Tally XMLCanara to Tally XMLUnion Bank to Tally XMLIDFC FIRST to Tally XML

Looking for a different format or institution? Return to the Kotak bank statement converter or the main Bank Statement Converter hub.

Convert a Kotak statement to Tally XML

Upload your Kotak PDF statement and download Tally XML. Preview page 1 without signing in. New accounts get 10 free pages, then 1 credit per page. Uploaded files and converted outputs are permanently deleted within 24 hours.

Open the bank statement converter10 free pages · 1 credit per page
For CAs and bookkeepers·For CA firms (multi-client)·Tally XML converter·Password-protected PDFs·ITR & GST working papers·Zoho Books (CSV)·QuickBooks (CSV)·GST reconciliation (Excel)·Loan & visa applications·Toolzy vs generic converters·SBI statement·HDFC statement·ICICI statement·Axis statement·Kotak statement·Bank of Baroda statement·PNB statement·Canara statement·Union Bank statement·IDFC FIRST statement·YES Bank statement·IndusInd statement·Bank of India statement·Indian Bank statement·Central Bank of India statement·IDBI Bank statement·Federal Bank statement·Indian Overseas Bank statement·UCO Bank statement·AU Small Finance Bank statement·RBL Bank statement·Bandhan Bank statement·South Indian Bank statement
Privacy Policy•Terms & Conditions•Contact
Toolzy © 2026 — finance, document, and developer toolsOwned and operated by Toolzy Team