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.
ABC Traders downloads a from their bank (columns: Date, Narration, Debit, Credit, Balance). bank statement to tally xml
TallyPrime (the latest version of Tally) has improved import capabilities, though it still relies heavily on specific formats. TallyPrime (the latest version of Tally) has improved
By converting your digital bank statement (usually a PDF or Excel file) into a Tally-compatible XML format, you can import days or months of transactions in seconds. This article explores the concept, the structure, and the methods to achieve this seamlessly. While manual entry is fine for a few
While manual entry is fine for a few transactions, importing large volumes of data via XML is the most reliable method for bulk processing.
| Tool | Input | Output | |------|-------|--------| | TallyPrime (in-built CoA import) | CSV | Tally XML | | AutoEntry / Dext | PDF/CSV | Tally XML | | Excel with VBA macro | Excel | Tally XML | | Python script (open source) | CSV/Excel | Tally XML | | Tally ERP 9 – ODBC connector | Database | Tally XML |