Automation of Financial Statements
Author : CA Sanjay Kumar
24eTax
Financial Reporting Module
Use cases, workflows and application screens
From trial balance to Schedule III financial statements, notes, statutory reports and exports
Prepared for CA firm partners, managers and staff
October 2026
Screens shown are from a demonstration firm with sample data (Zenith Auto Components Private Limited, FY 2025-26).
This document describes how a chartered accountancy firm uses the Financial Reporting module of 24eTax. It sets out each use case in the same shape: who does it, what they need before they start, the steps on screen, and what they get at the end. Every use case is illustrated with a screenshot of the actual application.
The module takes a client entity from its trial balance to a complete set of financial statements, the notes and policies that go with them, the supporting registers (fixed assets, share capital, inventories, related parties), the year-end close, and the statutory reports that accompany the accounts (auditor's report, directors' report, AGM minutes and management reporting).
| Role | What they do in Financial Reporting |
| Partner / Admin | Full access. Finalises and locks trial balances, periods and reports; signs off statements; manages firm settings and users. |
| Manager | Reviews mappings and statements, closes periods, prepares statutory reports, approves the work of staff. |
| Staff | Uploads trial balances, completes COA mapping, maintains registers, prepares drafts of statements and reports. |
Every page in the module works on one entity and one financial year at a time. The bar at the top of the screen shows the entity, its type, the financial year and the trial balance in use ("TB v1 · to 31-03-2026"). The Change link switches entity or year, and every page below it follows. Pages that need a trial balance say so until one is uploaded.
Figure 1: The firm dashboard after sign-in: clients, entities, trial balances awaiting mapping and reports in draft, with the Financial Reporting group in the sidebar.
The sidebar group "Financial Reporting" holds the pages below. The table lists them in the order a year-end engagement usually runs.
| Page | Purpose | Use case |
| Trial Balances | Upload, create or import the ledger balances for an entity and period; versioning and finalisation. | UC-01, UC-02 |
| COA Mapping | Map every ledger to a Schedule III head; auto-mapping, AI mapping, copy from last year. | UC-02 |
| Sub-Ledgers | Party, loan, asset, cost-centre and project masters behind the ledgers. | UC-11 |
| Bank Reconciliation | Books balance against the bank statement with reconciling items. | UC-11 |
| Ageing Reports | Debtor and creditor ageing, MSME outstanding, party ledger statements. | UC-11 |
| Share Capital | Authorised and paid-up capital by share class for the notes. | UC-08 |
| Fixed Assets | One register giving both the Companies Act and the Income-tax Act schedules. | UC-07 |
| Closing Entries | Audit entries, pre-close adjustments and locking the period. | UC-06 |
| Related Party Disclosures | Related parties, KMP, transactions and the Ind AS 24 / AS 18 note. | UC-10 |
| Inventories | Opening and closing stock, break-up and valuation disclosures. | UC-09 |
| Reports | Generate, review, edit and export the complete financial statements. | UC-03, UC-04, UC-05 |
| Auditors', Directors', AGM and Management reports | Statutory reports that read their figures from the prepared statements. | UC-12 |
| Actor | Staff or Manager |
| Goal | Bring the client's ledger balances for the year into 24eTax so that statements can be prepared from them. |
| Preconditions | The client and entity exist; the entity type (company, LLP, firm, proprietorship, trust) and financial year are set on the entity. |
| Outcome | A balanced trial balance for the period, versioned, with every ledger mapped to a Schedule III head or flagged for mapping. |
Figure 2: The upload dialog: entity, period and the file drop zone. Format Info describes the accepted columns.
Figure 3: Before import the file is read and checked: 69 ledgers, debit and credit columns found, totals balanced, and every ledger already given a head.
Figure 4: The trial balance list: entity, client, period, source file, balance check and status, with edit, view, finalise and delete actions.
Variations. A Tally trial balance exported without ledgers expanded is detected and the user is told how to re-export it. Read layout with AI works out the columns of an unusual file. A later upload for the same period becomes a new version, and the Finalise action locks a version once it is agreed.
| Actor | Staff prepares, Manager reviews |
| Goal | Make sure every ledger sits under the right Schedule III line so that the statements classify correctly. |
| Preconditions | A trial balance has been uploaded (UC-01). |
| Outcome | All ledgers mapped, the mapping saved, and the trial balance shows "All ledgers mapped". |
Figure 5: The mapping page: period, totals and balance check at the top; each ledger with its head, nature, confidence and source below.
Figure 6: The edit dialog reached from the pencil icon: ledgers, heads and amounts can be changed in place, rows added or pasted, and the balance check updates as you type.
| Actor | Staff or Manager |
| Goal | Produce the complete set of statements for the entity type from the mapped trial balance. |
| Preconditions | A mapped trial balance for the year (UC-01, UC-02). A previous-year trial balance if comparatives are wanted. |
| Outcome | A draft report with Balance Sheet, Statement of Profit and Loss, Cash Flow, Changes in Equity and Notes, saved against the entity and year. |
The Reports page offers one report type per entity type. The company format is Schedule III with the Balance Sheet, Statement of Profit and Loss, Cash Flow Statement, Statement of Changes in Equity and Notes. Proprietorships, partnership firms, LLPs and trusts each get their own format (capital accounts, appropriation, members' contribution, receipts and payments, fund-wise balance sheet). Only the format that matches the entity is enabled.
Figure 7: The Reports page: one card per entity type, with the sections each format contains. The card for the working entity's type is enabled.
Figure 8: Generation options: report nature, current and previous year trial balances, rounding, signing place and date, signature and watermark options.
| Actor | Manager (review), Staff (edits) |
| Goal | Check every statement and note before export, and correct what needs correcting without touching the books. |
| Preconditions | A generated report (UC-03). |
| Outcome | A reviewed draft with no reconciliation breaks, saved as a versioned copy. |
The preview shows the statements as they will print, in tabs. Any value can be clicked and edited; totals recompute. Each edit is auto-saved as a draft copy with the time of the last save shown at the top. If the trial balance or entity details change later, a notice offers Regenerate to rebuild from the current data.
Figure 9: The Balance Sheet tab. Above the statement: observations from the preparation (stock, tax provision, deferred tax), the reconciliation summary, the tax working and the classification review.
Figure 10: Further down the Balance Sheet: property, plant and equipment, deferred tax assets and long-term loans and advances, each with its note number.
Figure 11: The Statement of Profit and Loss: revenue from operations and other income with note references, followed by expenses.
Figure 12: The end of the Statement of Profit and Loss: profit before tax, current and deferred tax taken from the computation, and the profit for the period.
Figure 13: The Cash Flow Statement under the indirect method: profit before tax, adjustments for depreciation, finance costs and interest income, then working-capital changes.
Figure 14: The Statement of Changes in Equity: equity share capital and the movement in each reserve (opening, profit, dividends, transfers, closing).
| Actor | Manager, then Partner for finalisation |
| Goal | Confirm the notes and policies, clear the review points, and export the statements in the sections required. |
| Preconditions | A reviewed draft (UC-04). |
| Outcome | A PDF (or Excel) of the chosen sections, the report listed under Generated Reports, and optionally finalised and locked. |
The Notes and Policies tab carries the significant accounting policies and a note for every line on the face of the statements. Notes are built from the mapped ledgers and the registers (share capital, fixed assets, inventories, related parties), so a figure in a note always ties to the statement it supports. Notes that do not apply to the entity are left out and the numbering stays continuous.
Figure 15: Note 1, Share Capital: authorised capital shown for information and the issued, subscribed and paid-up capital that forms the total, with the standard disclosures below.
Figure 16: Note 8, Deferred Tax Assets: the timing differences on depreciation and section 43B items, measured at the enacted rate, with the explanation printed under the table.
Three panels sit above the tabs. Reconciliation lists breaks (which block export) and items worth checking, such as a movement in reserves that is not explained by the profit for the year. The tax working shows how the provision was computed from the saved computation of income. Classification review lists unmapped ledgers, anything routed to "Other", and the notes the preparation made.
Figure 17: The reconciliation panel opened: a movement in reserves and surplus that the profit does not explain, with the figures that should agree and the difference.
Figure 18: The tax working: the computation of total income behind the provision, from profit per the books through section 32, 40(a), 43B and 56 adjustments.
Figure 19: The classification review: no ledger unmapped, nothing routed to "Other", and the four observations recorded while preparing the statements.
Figure 20: Section selection before export. Sections that depend on another report say what they need.
Figure 21: Two pages of the exported PDF: the cover and the Balance Sheet.
Figure 22: Generated Reports: the saved report with its period, date, status and actions.
| Actor | Manager; Partner locks the period |
| Goal | Record audit entries and pre-close adjustments against the trial balance, see their effect, and lock the period once the accounts are agreed. |
| Preconditions | A balanced trial balance for the period. |
| Outcome | Adjusted figures flowing into the statements; the period closed so that no further change is possible without a logged reopen. |
Figure 23: Year-End Closing: period selection, the period's result, closing totals and the closing journal preview, with tabs for audit entries, adjustments and closing the period.
| Actor | Staff |
| Goal | Record each asset once and obtain both the Companies Act depreciation schedule and the Income-tax Act block-wise schedule. |
| Preconditions | The entity and year are selected. Opening balances can be imported from the previous year. |
| Outcome | The fixed asset note and the tax depreciation working, both read live by the statements and the computation of income. |
Figure 24: Adding an asset: Companies Act details and movement on the left and top, Income-tax Act block values below, with the difference between the two Acts computed.
| Actor | Staff |
| Goal | Hold the authorised capital and the paid-up capital by share class so that the share capital note is complete. |
| Preconditions | A company entity. |
| Outcome | Note 1 of the statements populated with authorised, issued, subscribed and paid-up capital and the movement during the year. |
Figure 25: Share Capital: authorised capital and the share-class-wise paid-up capital for the selected period.
| Actor | Staff |
| Goal | Give the statements the opening and closing stock and the inventory break-up and valuation disclosures. |
| Preconditions | The trial balance for the year. |
| Outcome | The change in inventories on the Statement of Profit and Loss, inventories on the Balance Sheet, and the inventories note. |
The page explains how the stock adjustment is worked out against the trial balance: closing stock less the ledger balance goes to the profit and loss and the same amount to inventories, so nothing is counted twice where the books already carry a closing entry. The break-up by raw materials, work-in-progress, finished goods and stock-in-trade, the valuation method and any write-downs are entered below for the note.
Figure 26: Inventories: the stock adjustment for cost of goods sold at the top, and the inventory break-up for the note below.
| Actor | Staff prepares, Manager marks final |
| Goal | Identify related parties and key managerial personnel, record transactions and balances, and produce the disclosure note. |
| Preconditions | The entity and year are selected. |
| Outcome | The related party note in the statements, and a standalone Word or PDF of the disclosure. |
Figure 27: Related Party Disclosures: the four tabs, the completeness indicator, the controlling entity and the related parties list.
| Actor | Staff |
| Goal | Support the balances in the trial balance: party-wise detail, a bank reconciliation statement and debtor and creditor ageing. |
| Preconditions | The trial balance for the year; party masters where ageing is wanted. |
| Outcome | Working papers that tie to the ledger: sub-ledger masters, a BRS per bank account, ageing schedules and MSME outstanding. |
Sub-Ledger Masters holds party accounts, loan accounts, asset registers, cost centres and projects for the entity. Masters can be imported and exported, filtered by type, and flagged as MSME so that the MSME disclosures can be prepared.
Figure 28: Sub-Ledger Masters: counts by type, search and filters, and import and export of the masters.
Bank Reconciliation takes the ledger's closing balance from the trial balance, the balance per the bank statement (typed in or imported from a CSV or Excel statement), and the reconciling items: cheques issued but not presented, deposits not yet credited, and bank entries the books do not carry. The difference not explained is shown until it reaches zero. The statement is saved and printed to PDF.
Figure 29: Bank Reconciliation: the bank ledger and its book balance, the statement balance and date, reconciling items and the reconciliation.
Ageing Reports produces debtor ageing, creditor ageing and the MSME creditors schedule as at a chosen date, from the party sub-ledgers. Clicking a party opens its ledger statement.
Figure 30: Ageing Reports: entity, as-of date and the three schedules on offer.
| Actor | Manager prepares, Partner marks final |
| Goal | Prepare the reports that accompany the accounts without re-keying any figure. |
| Preconditions | Finalised or reviewed statements (UC-05). |
| Outcome | Auditor's report, directors' report, AGM report and management report, each saved per entity and year and exported to PDF or Word, and available as sections of the statements bundle. |
The report is organised by the sections of SA 700 and the Companies Act: auditor information and letterhead, opinion and basis, responsibilities, reporting under section 143(3) and Rule 11, CARO 2020 and the report on internal financial controls. Standard wording is pre-filled; the reconciliation bar at the top lists the figures in the report that are checked against the statements.
Figure 31: Auditor's Report: the six sections, completeness, the firm letterhead and auditor details, with PDF, Word and Save actions.
The directors' report takes the financial performance summary from the statements and the company particulars from the entity master. The sections follow section 134 of the Companies Act, with required fields marked, and the report exports with the company letterhead.
Figure 32: Directors' Report: the financial summary taken from the statements, section tabs, and the company letterhead preview.
AGM Report records the meeting details, attendance and quorum, resolutions, agenda and the minutes, with the chairperson picked from the directors register. Management Reporting prepares the Management Discussion and Analysis and the Corporate Governance report, section by section with guidance text, and exports to PDF.
Figure 33: AGM Report (left) and Management Reporting (right).
| Control | How the module applies it |
| Balance check | A trial balance that does not balance is shown as Unbalanced and cannot be used for statements. |
| Complete mapping | Unmapped ledgers are counted on the mapping page and in the classification review; a ledger routed to "Other" is flagged for a decision. |
| Reconciliation | Every preview runs the reconciliation. A break blocks export; an item to check is shown with the figures that should agree. |
| Versioning | Trial balances are versioned; statement edits are saved as a draft copy with the time of the last save; Regenerate rebuilds from the current books. |
| Finalise and lock | Trial balances, periods and reports are finalised by a Partner and locked; reopening is logged. |
| Firm isolation | Every row is scoped to the firm in the database; a user sees only their firm's clients, entities and reports. |
| Signatories | One rule decides who signs: the directors or partners ticked for the year, else the first two on the register. All signature blocks use it. |
The upload accepts CSV, TXT, XLSX and XLS files, including trial balance exports from Tally. A generic file needs a ledger name column and either debit and credit columns or a single closing balance column. Optional columns for group, COA head and nature are read when present. The first rows of the sample used in this document:
| Ledger Name | Debit | Credit |
| Petty Cash | 1,25,000 | |
| HDFC Bank Current A/c | 18,40,000 | |
| Trade Receivables - Domestic | 92,40,000 | |
| Inventories - Raw Materials | 22,50,000 | |
| Plant and Machinery | 1,23,00,000 | |
| Equity Share Capital | 1,00,00,000 | |
| Term Loan from HDFC Bank | 65,00,000 | |
| Trade Payables - Suppliers | 54,30,000 | |
| Sales - Domestic | 6,42,00,000 | |
| Purchase of Raw Materials | 4,38,00,000 | |
| Salaries and Wages | 72,50,000 | |
| Depreciation | 21,40,000 |
Totals must agree. Ledger names that are Tally group names (Cash-in-Hand, Sundry Debtors, Sundry Creditors) are treated as groups in a Tally export; a generic file should use the ledger names as they appear in the books.