{% extends "ui/templates/base/layout.html" %} {% block content %}

Tools · Accounting

Trial Balance & Financial Statements

Presentation view from the registered Client/FY Accounting Mirror. Zero-value rows are suppressed only when both current and comparative years are nil; the underlying Trial Balance remains complete and read-only.

Back to Tally Accounting {% if selected_client and report %}Download Formula Excel{% endif %}
{% if message %}
{{ message }}
{% endif %} {% if command_error %}
{{ command_error }}
{% endif %}
{% if selected_client and report %}
Mirror FY
{{ financial_year }}
Version {{ report.current_payload.mirror_version_no or report.current_payload.version_no or '-' }}
Ledgers
{{ report.current.count }}
{{ report.current.group_count }} Tally groups loaded
Comparative
{{ previous_fy }}
{{ 'Previous-year mirror loaded' if previous_available else 'No registered comparative mirror' }}
Mapping Review
{{ statements.unmapped|length }}
Unmapped ledgers
{% if report.current.hierarchy_warning %}
The full Tally group hierarchy was not returned by the Local Agent. The standard Tally fallback hierarchy and ledger rules are active; custom-group hierarchy will improve automatically when the latest Local Agent is available.
{% endif %} {% if statements.balance_sheet_difference|abs > 1 %}
Balance Sheet review required: Assets and Equity/Liabilities differ by ₹ {{ '{:,.2f}'.format(statements.balance_sheet_difference) }} after mapped finalisation. Review classification/abnormal balances before final use.
{% elif statements.profit_transfer_applied %}
Current-year profit/loss was not yet reflected in source capital balances, so the ERP applied a read-only finalisation transfer. The mirror itself was not changed.
{% endif %}

Statement of Balance Sheet

Only comparative headings with a value in at least one year are shown.

₹ · Comparative presentation
{{ selected_client.client_name }}
Statement of Balance Sheet for the Year Ended 31st March {{ financial_year[:4]|int + 1 }}
{% for code in statements.visible_bs_liability_codes %}{% set meta=schedules.get(code) %}{% endfor %} {% for code in statements.visible_bs_asset_codes %}{% set meta=schedules.get(code) %}{% endfor %}
ParticularsNote31 March {{ financial_year[:4]|int + 1 }}31 March {{ financial_year[:4] }}
I  EQUITY AND LIABILITIES
{{ meta.label }}{{ statements.presentation_notes.get(code,'') }}{{ '{:,.0f}'.format(statements.current_bs.get(code,0)) }}{{ '{:,.0f}'.format(statements.previous_bs.get(code,0)) }}
Total Liabilities{{ '{:,.0f}'.format(statements.current_liabilities) }}{{ '{:,.0f}'.format(statements.previous_liabilities) }}
II  ASSETS
{{ meta.label }}{{ statements.presentation_notes.get(code,'') }}{{ '{:,.0f}'.format(statements.current_bs.get(code,0)) }}{{ '{:,.0f}'.format(statements.previous_bs.get(code,0)) }}
Total Assets{{ '{:,.0f}'.format(statements.current_assets) }}{{ '{:,.0f}'.format(statements.previous_assets) }}

The accompanying notes are an integral part of the financial statements.

Statement of Profit & Loss

Nil rows are hidden only when both years are nil.

₹ · Formula-driven in Excel
{% set cp=statements.current_pl %}{% set pp=statements.previous_pl %}
{{ selected_client.client_name }}
Statement of Profit and Loss for the Year Ended 31st March {{ financial_year[:4]|int + 1 }}
{% if cp.REVENUE|abs >= 0.005 or pp.REVENUE|abs >= 0.005 %}{% endif %} {% if cp.OTHER_INCOME|abs >= 0.005 or pp.OTHER_INCOME|abs >= 0.005 %}{% endif %} {% for label,key,ncode in [('Cost of goods sold','COST_OF_GOODS_SOLD','COST_OF_GOODS_SOLD'),('Direct Expenses','DIRECT_EXPENSES','DIRECT_EXPENSES'),('Employee benefits expense','EMPLOYEE_BENEFITS','EMPLOYEE_BENEFITS'),('Finance Cost','FINANCE_COST','FINANCE_COST'),('Depreciation and amortization expense','DEPRECIATION','DEPRECIATION'),('Other expenses','OTHER_EXPENSES','OTHER_EXPENSES')] %}{% if cp.get(key,0)|abs >= 0.005 or pp.get(key,0)|abs >= 0.005 %}{% endif %}{% endfor %}
ParticularsNote31 March {{ financial_year[:4]|int + 1 }}31 March {{ financial_year[:4] }}
I  Revenue from operations{{ statements.presentation_notes.get('REVENUE','') }}{{ '{:,.0f}'.format(cp.REVENUE) }}{{ '{:,.0f}'.format(pp.REVENUE) }}
II  Other Income{{ statements.presentation_notes.get('OTHER_INCOME','') }}{{ '{:,.0f}'.format(cp.OTHER_INCOME) }}{{ '{:,.0f}'.format(pp.OTHER_INCOME) }}
III  Total Income (I+II){{ '{:,.0f}'.format(cp.TOTAL_INCOME) }}{{ '{:,.0f}'.format(pp.TOTAL_INCOME) }}
IV  Expenses
{{ label }}{{ statements.presentation_notes.get(ncode,'') }}{{ '{:,.0f}'.format(cp.get(key,0)) }}{{ '{:,.0f}'.format(pp.get(key,0)) }}
Total expenses{{ '{:,.0f}'.format(cp.TOTAL_EXPENSES) }}{{ '{:,.0f}'.format(pp.TOTAL_EXPENSES) }}
V  Profit/(Loss) for the year{{ '{:,.0f}'.format(cp.PROFIT) }}{{ '{:,.0f}'.format(pp.PROFIT) }}

The accompanying notes are an integral part of the financial statements.

{% if is_partnership %}

Partnership Profit Allocation

Ratios are Client/FY-specific. When they total 100%, the year's profit/loss is allocated to partner funds for the final Balance Sheet without changing the mirror.

Configured ratio: {{ '%.2f'|format(statements.profit_share_total) }}%
{% for row in partner_rows %}{% endfor %}{% if not partner_rows %}{% for i in range(2) %}{% endfor %}{% endif %}
PartnerProfit Share %Capital / Current Ledger (optional)
{% if statements.partnership_allocations %}
{% for row in statements.partnership_allocations %}
{{ row.partner_name }} · {{ row.profit_share_percent }}%
₹ {{ '{:,.0f}'.format(row.amount) }}
{% endfor %}
{% endif %}
{% endif %}

Trial Balance & Ledger Mapping

Review mode retains the complete ledger master, including zero-balance ledgers, so mappings are not lost between years.

Open Review
{% for line in current_lines %}{% endfor %}
LedgerTally GroupRoot GroupScheduleClosing DrClosing CrMapping
{{ line.ledger_name }}{{ line.parent_group }}{{ line.root_group }}{{ line.schedule_label }}{{ '{:,.0f}'.format(line.closing_debit) }}{{ '{:,.0f}'.format(line.closing_credit) }}
{% endif %}
{% endblock %}