Bank Statement To Tally Xml < CERTIFIED >
import csv import xml.etree.ElementTree as ET root = ET.Element("ENVELOPE") header = ET.SubElement(root, "HEADER") ET.SubElement(header, "TALLYREQUEST").text = "Import Data"
Here’s a full explanatory story on the topic: — covering the problem, the process, tools, and a practical example. The Problem: Manual Data Entry from Bank Statements Every month, businesses receive bank statements (PDF, CSV, or printed) listing transactions: payments received, vendor payments, bank fees, interest, etc. The accounts team must enter these into TallyPrime (or Tally.ERP 9) for reconciliation and bookkeeping. bank statement to tally xml
Would you like a sample ready-to-use Tally XML file or a Python script that handles a real bank CSV? import csv import xml
body = ET.SubElement(root, "BODY") import_data = ET.SubElement(body, "IMPORTDATA") req_desc = ET.SubElement(import_data, "REQUESTDESC") ET.SubElement(req_desc, "REPORTNAME").text = "Vouchers" Would you like a sample ready-to-use Tally XML
For non-technical teams, ready-made converters (like or Excel2Tally ) do the job. For developers, building a custom script gives full control over voucher splitting, party mapping, and rules for complex transactions.
Example Python script logic (pseudo):