Tally Automate (Accounting Automation)
Author : CA. Deepak Anand
1. Problem Statement
Clients managing accounting workflows face a daily challenge: Tally Prime, the dominant accounting ERP in India, lacks an easy-to-use interface for bulk operations import of bank statement, and GST Invoices processing. Existing workarounds involve complex manual import mapping of ledgers as well as manual exports, Excel macros, and error-prone copy-paste workflows - costing significant time and introducing compliance risk. No existing tool addresses this in a privacy-first, fully offline manner suitable for small CA firms handling sensitive client data.
2. Solution Overview
Tally Automate is a local Python Flask web application that runs entirely on the clients own machine. The user double-clicks a single .bat file - the Flask server boots on localhost:3000 and the default browser opens as the rendering surface. There is no installer, no cloud dependency, no database engine, and no authentication setup.
The app speaks to Tally Prime simultaneously over two protocols - ODBC for fast tabular data (trial balance, ledgers) and XML/HTTP for transactional data (vouchers, daybook, registers, posting) - using the protocol best suited to each data type.
3. Key Features
| Dual Tally Interface | ODBC (pyodbc 5.0+) for trial balance & ledger queries at port 9000; XML/HTTP (urllib + xml.etree) for vouchers, daybook & posting - avoiding the TDL crash that ODBC triggers on voucher tables. | GST 2A / 2B Processing | Reads GSTR 2A/2B Excel files via openpyxl 3.1+, including password-protected workbooks (msoffcrypto-tool), with full styling support on formatted exports. |
| Bank Statement Intelligence | pdfplumber as primary extraction engine + PyMuPDF (fitz) as fallback - resilient parsing of bank statement PDFs; pandas handles tabular manipulation in the processing pipeline. | Complete Data Privacy | Zero data leaves the machine. No cloud sync, no external auth, no telemetry. Client data remains strictly on the user’s desktop - critical for CA client confidentiality. |
4. Technology Stack
| Layer | Component | Technology | Role |
| Backend | Web Framework | Flask 3.0+ / Python 3 | HTTP routes, JSON APIs, Jinja2 templating (~3,600 lines, single-file monolith) |
| Backend | Tally ODBC | pyodbc 5.0+ | Trial balance & ledger queries via Tally's ODBC server on port 9000 |
| Backend | Tally XML/HTTP | urllib + xml.etree | Vouchers, daybook, registers & transaction posting |
| Processing | Excel / GST | openpyxl 3.1+ / msoffcrypto-tool | GSTR 2A/2B ingestion; decrypts password-protected workbooks |
| Processing | PDF Parsing | pdfplumber + PyMuPDF | Bank statement extraction - primary engine + fallback |
| Processing | Data Wrangling | pandas | Tabular manipulation in bank statement pipeline |
| Frontend | UI | Vanilla HTML5 / CSS3 / JS | ~1,900 lines pure DOM + fetch(); zero frameworks; custom dark theme |
| State | Persistence | JSON file | tally_post_history.json - batch history; no database engine required |
5. Deployment Model
Radically simple deployment - no installer, no admin rights, no setup wizard. Distribution is a single folder. The user runs Start_Tally_App.bat; the Flask server boots and the browser opens automatically.
Prerequisites:
- Tally Prime Silver/Gold installed and running
- XML port enabled: F1 > Settings > Connectivity > Client/Server configuration > port 9000, TallyPrime acts as Server
- Python 3 and Node.js installed
- Dependencies - flask>=3.0, pyodbc>=5.0, openpyxl>=3.1, pdfplumber, PyMuPDF, pandas, msoffcrypto-tool
The entire application runs on localhost - nothing is exposed outside the machine. Educational versions of Tally Prime should be avoided as date-range limitations degrade AI/LLM response quality.
6. Key Metrics
| 3,600 | 1,900 | 1,100 | 2 | 0 | 1-Click |
| Lines - backend server.py | Lines - vanilla JavaScript UI | Lines - HTML template | Tally protocols (ODBC + XML) | External JS frameworks used | Launch via .bat file |
7. Target Users & Benefits
Designed specifically for small and medium sized entities in India running Tally Prime (Silver/Gold). Key benefits:
- Elimination of manual GSTR 2A/2B import workflows
- Automated bank statement parsing and reconciliation
- Direct voucher posting to Tally without manual data entry
- Complete data privacy - no cloud exposure, all data stays on the user’s machine
Zero IT infrastructure overhead - runs on any Windows machine with Tally installed
