Report Studio

Financial statements

Generate a Schedule III Balance Sheet, Profit and Loss, Cash Flow and Notes from a mapped trial balance.

Updated October 7, 2026

Workflow

The Financial Statements workspace has four tabs that follow the natural order
of work:

  1. Trial Balance — pick the financial year and period month, then upload a
    single-month or multi-month closing-balance export (.xlsx, .xls or .csv)
    from Tally or your ERP. Uploaded periods appear as chips; select one to
    inspect its ledgers with closing debit/credit amounts.
  2. Account Mapping — every ledger must map to a Schedule III line. Use
    AI map unmapped to let FireAI map everything at once (it runs in
    batches and shows progress), then review the rows flagged AI and change
    any line from the dropdown. Confirm all locks the mappings in.
  3. Generate — choose the period, the statements to include (Balance Sheet,
    Profit & Loss, Cash Flow, Notes to Accounts) and whether to include
    comparative previous-period figures, then generate. Progress is shown live;
    ledgers that are still unmapped are excluded and called out with a warning.
  4. Reports — every generated pack is listed with its period and statement
    types. Download the Excel workbook, expand a row for an inline preview per
    statement, or delete old runs.

Unmapped ledgers

Statements only include mapped ledgers. The workspace header and the Account
Mapping tab badge both show how many ledgers still need mapping, so resolve
those before generating final statements.

GST and TDS reconciliation

The GST and TDS pages reconcile books against portal data:

  • GST — upload the books/ERP GST ledger, GSTR-2B and GSTR-3B (GSTR-1
    optional), preview the combined sheets, then Reconcile ITC to build the
    reconciliation workbook.
  • TDS — upload the books TDS ledger, Challan 281 and TRACES Form 26AS
    (Form 16A optional), then Reconcile 26AS.

Past reconciliation workbooks stay available for download on each page.

Schema mapping

The Schema Mapping page shows the Schedule III line tree per report type.
Select a line to see the ledgers rolling into it and unlink wrong ones. Hover a
line to add a custom entity line beneath it when Schedule III lacks the
granularity you need; custom lines can be renamed or deleted at any time, and
deleting one unlinks any ledgers mapped to it.