Tally FIN-Automate v7 (Non-Corporate Entity Financial Statements)
Author : CA. Deepak Anand
1. Problem Statement
Indian Chartered Accountants and accountants preparing financial statements for non-corporate entities - proprietorships, partnerships, AOPs etc must now follow the ICAI Guidance Note on Financial Statements of Non-Corporate Entities. Recasting a Tally Trial Balance into this prescribed format - a vertical Balance Sheet, Statement of Profit and Loss, and the full set of structured Notes - is to be done manually for every client, compute the notes and prior-year comparatives, and produces the formatted statements in one place.
- Time-intensive: every client's trial balance must be re-grouped, mapped to ICAI line items, and re-keyed into prescribed format, then balanced and cross-checked line by line.
- Error-prone: manually classifying each ledger into the correct line item, sub-group, and note - plus advances regrouping, MSME dues, and current / non-current splits - is easy to get wrong.
- Repetitive across clients and years: the same mapping and note-building is redone for every entity and again for the previous-year comparative column.
- Format-sensitive: the ICAI prescribed format has a fixed presentation - rounding, Note numbering, current / non-current classification, and party-wise disclosures.
2. Solution Overview
Tally FIN-Automate is a web-based tool that imports a Tally Trial Balance, lets the user map each ledger and group to the ICAI Non-Corporate-Entity line items, and auto-generates the complete set of financial statements - Balance Sheet, Statement of Profit and Loss, and all Notes to Accounts - in the prescribed format with current-year and previous-year columns.
It works from three data sources - live Tally over ODBC, live Tally over the XML / HTTP port, or an offline Tally NCE-XML export file - so statements can be prepared with or without Tally running, and each client-year is saved as its own workspace.
The user moves through a guided sidebar - import, ledger and group mapping, sub-group (H4) classification, the financial statements and notes, and supporting schedules such as MSME / AS applicability, deferred tax, and provision for tax - with every figure auto-computed from the trial balance and editable where professional judgment is required, alongside a parallel ITR-3 / ITR-5 mapping module.
3. Key Features
| Data Connectivity & Workspace | One-click import from Tally via (a)Tally NCE-XML export, (b) ODBC and (c) the XML / HTTP port, with a; multi-company, multi-FY workspace save / restore; the previous-year trial balance is carried for comparatives; reusable per-ledger and per-group rule libraries auto-map ledgers on the next import. | Ledger and Group Mapping | Map each ledger and Tally group to ICAI line items (FSLI) with auto-suggest rules, statement-group filters, and an Unmapped tracker; H4 sub-group classification for both CY and PY with Auto Classify and Regroup Advances (creditor-Dr / debtor-Cr) run per year. |
| NCE Financial Statements | Auto-built vertical Balance Sheet and Statement of Profit and Loss in ICAI format with current-year and previous-year columns, automatic balancing and a difference check, manufacturing / trading splits, and a live Executive Dashboard of GP / NP and turnover ratios with charts. | Notes to Accounts | All ICAI notes auto-generated with per-ledger breakups and CY / PY figures; party-wise Trade Payables (MSME / Non-MSME), Trade Receivables with ageing (> & < 6 months), Capital-account movement, and the PPE schedule (with Gross Asset Schedule reconstruction), all consistently rounded with the statements. |
| Compliance Schedules and ITR Mapping | MSME / Accounting-Standards applicability (entity classification), Deferred Tax (AS 22), and Provision for Tax calculation including Sec 40(b) partner remuneration and interest; a separate ITR-3 / ITR-5 module maps the trial balance to the ITR Balance Sheet, Manufacturing, Trading, and P&L schedules. | Reports and Excel Export | One-click multi-sheet Excel workbook in ICAI format - Balance Sheet, Statement of P&L, all Notes, Capital and PPE schedules, and the mapped trial balance - with selectable round-off (actual / hundreds / lakhs) and zero-balance suppression, plus a Tally-style Overview BS and P&L, a live ledger voucher register, and an item-wise Stock Report. |
4. Technology Stack
| Layer | Component | Technology | Role |
| Backend | Web Framework | Python 3, Flask | REST API with 85+ endpoints serving import, mapping, statements, notes, schedules, and the ITR module |
| Backend | Tally ODBC | PyODBC | Direct SQL queries to the Tally ODBC server for trial-balance and ledger data |
| Backend | Tally XML/HTTP | XML API (HTTP requests) | Fetches ledger balances, stock summary, and live voucher registers via Tally's port 9000 interface; also imports Tally's NCE-XML export |
| Processing | Excel I/O | openpyxl | Generates the multi-sheet ICAI Excel workbook and reads imported trial-balance and stock data |
| Processing | NCE-XML Parsing | Python xml.etree | Parses Tally's NCE Financial Statements XML export - ledgers, stock summary, and the prior-year comparative |
| Frontend | UI | Vanilla JavaScript, HTML5, CSS3 | Single-page app with no framework dependency (~9,000 lines across app.js and itr.js) |
| Storage | Persistence | File-based JSON database | Per-company, per-FY workspace files under data_store/ - no external database required |
5. Deployment Model
Local Desktop Application - the tool runs entirely on the user's own machine, with zero cloud dependency. All client data stays on the local system and no internet access is required.
- Single command launch: Open Tally FIN-Automate.bat (python server.py) starts the server and opens localhost:3000 in the browser
- No installation complexity: requires only Python 3.x and pip install -r requirements.txt
- Multi-client support: each client-year is a self-contained workspace file under data_store/ (named Company __ FY __ Source) with its own mappings and saved state
- Portable: the entire project folder, including saved workspaces, can be copied to another machine or backed up to cloud storage
- Tally co-location: runs on the same machine as Tally for live ODBC / XML import; the NCE-XML import and saved workspaces allow working entirely offline on any machine
6. Key Metrics
| All | ICAI Notes auto-generated | 85+ | REST API endpoints | 3 | Tally import sources (ODBC / XML / NCE-XML) | CY + PY | Comparative columns auto-built | ~19k | Lines of code (server + UI) | 1-click | ICAI Excel workbook export |
7. Target Users & Benefits
Built for Chartered Accountants and accountants preparing financial statements for non-corporate entities, small to mid-size CA firms handling many proprietorship / partnership / LLP clients each year, and accounts staff who maintain books in Tally and need ICAI-format statements.
| Practitioners | Turns a Tally trial balance into a complete ICAI-format statement set in minutes instead of hours of Excel re-keying and balancing. | Quality & Accuracy | Every figure flows from the actual trial balance; the Balance Sheet self-balances and the Notes reconcile to each statement line automatically. |
| Client Management | Each client-year is a saved workspace; per-ledger and per-group rule libraries reuse last year's mapping on the next import, and NCE-XML import works without Tally running. | Format Compliance | Enforces the ICAI Non-Corporate-Entity presentation - fixed Note numbering, current / non-current splits, advances regrouping, and MSME party-wise disclosure - so the output matches the prescribed Guidance. |
| Comparatives and ITR | Builds the previous-year comparative column from the prior trial balance and offers a parallel ITR-3 / ITR-5 mapping, all within one workspace. | Cost | Runs locally with zero subscription fees, no cloud costs, and no vendor lock-in. |
8. Tools Used - Vibecoding
This application was built using AI-assisted development (vibecoding) with the following tools:
| Tool | Role |
| Claude Code (CLI / Desktop) | Primary development partner - architecture design, full-stack code generation, iterative feature building, debugging, and code review. Every module, from ledger mapping and the notes engine to the ITR-3 / 5 schedules, was developed conversationally through Claude Code. |
| Claude Opus 4.x | The underlying AI model powering Claude Code, providing deep reasoning for complex accounting logic - per-year ledger classification, advances regrouping across CY and PY, ICAI note construction, and Balance Sheet reconciliation. |
| Preview Server | Dev server integration for real-time verification of frontend changes - screenshot capture, DOM inspection, and interaction testing without leaving the development flow. |
