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.
Would you like a sample ready-to-use Tally XML file or a Python script that handles a real bank CSV? bank statement to 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. Here’s a full explanatory story on the topic:
import csv import xml.etree.ElementTree as ET root = ET.Element("ENVELOPE") header = ET.SubElement(root, "HEADER") ET.SubElement(header, "TALLYREQUEST").text = "Import Data" Would you like a sample ready-to-use Tally 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"
Example Python script logic (pseudo):