How to Enable Schedule III Balance Sheet Reporting in TallyPrime

All registered Indian companies (Private Limited, Public Limited, One Person Companies, and LLPs) must prepare and present their annual financial statements in the formats prescribed under Schedule III of the Companies Act, 2013. These reports are submitted to the Ministry of Corporate Affairs (MCA) and form the basis of statutory audits by Chartered Accountants.

Traditionally, accounts teams spent days manually mapping TallyPrime ledger accounts into separate PDF templates to match Schedule III groupings. TallyPrime Release 7.1 introduces a built-in Schedule III Reporting module that compiles these compliance-ready statements in minutes. This comprehensive guide walks through setting up, configuring, and verifying your Schedule III Balance Sheet and Profit and Loss statements in TallyPrime.

1. Understanding the Schedule III Structural Mapping

Unlike standard accounting balance sheets that organize ledgers alphabetically or by raw asset groups, a Schedule III Balance Sheet strictly partitions accounts into Equity and Liabilities and Assets. It further categorizes elements based on their liquidity cycle:

2. Step-by-Step: Enabling & Mapping Schedule III in TallyPrime

To generate a compliant report, you must map your existing chart of accounts to the Schedule III categories:

1. From the Gateway of Tally, navigate to Display More Reports > Statutory Reports > Schedule III.
2. Select the report you wish to configure: Balance Sheet or Profit & Loss A/c.
3. Press F5 (Ledger Mapping). TallyPrime displays your ledger accounts grouped in two panels: your local ledger tree on the left, and the predefined Schedule III categories on the right.
4. Select the ledgers or groups you wish to map. Use the Spacebar to select multiple entries.
5. Press Alt + M (Map Ledgers).
6. Select the correct target Schedule III head from the list. For example, map your "Sundry Creditors for Capex" group to Non-Current Liabilities > Other Long-term Liabilities instead of the default Trade Payables.
7. Press Ctrl + A to save the mapped configuration.

3. Resolving Unclassified Ledger Exceptions

A common compilation error in TallyPrime is the presence of unmapped ledger accounts:

• If a new ledger account was created during the financial year and not classified under Schedule III, TallyPrime places it under the Unclassified Ledgers tab in the Statutory Reports menu.
• A balance sheet generated with unclassified ledgers is incomplete and will show a warning banner on print outputs.
• To resolve this, navigate to Statutory Reports > Schedule III > Unclassified Ledgers. TallyPrime highlights all affected accounts. Select them, press Alt + M, and assign them to the correct Schedule III category.

4. Exporting Schedule III Reports for Audit

Once ledger classification is complete, the financial statements can be exported:

1. Open the final Schedule III report screen in TallyPrime.
2. Press Alt + E (Export) and select File from the dropdown menu.
3. Set the file format to Excel Spreadsheet. This preserves the layout cells and font formatting.
4. Configure the export options:
   • Set Show Notes to Accounts to Yes if you want the breakdown details exported.
   • Set Show Previous Year Figures to Yes. Schedule III requires comparative data for the preceding financial period.
5. Click Export to generate the spreadsheet. The file is ready for submission to your statutory auditor or upload to the MCA portal.

5. Best Practices for Audit Compliance

To ensure your Schedule III balance sheet passes statutory audit verification:

• Review Trade Payables Ageing: Schedule III requires trade payables aging in specific buckets (Less than 1 year, 1–2 years, 2–3 years, and more than 3 years). Ensure you have enabled the bill-wise detail feature in TallyPrime for all vendor accounts to automate this report.
• Disclose MSME Payables: Outstanding amounts due to Micro, Small, and Medium Enterprises must be shown separately from other trade payables. Check your vendor profile classifications (F11 > MSME details) before compiling.
• Comparative Year Validation: Verify that the opening balances of the current financial year match the audited final balances of the previous fiscal period. TallyPrime copies this comparative data automatically if you run a continuous database.

6. Advanced Ledger Grouping Rules

For companies with multiple lines of business or holding-subsidiary relationships, advanced ledger mapping is required. For instance, long-term loans advanced to subsidiary entities must be shown under Non-Current Loans & Advances rather than standard Trade Receivables or Short-Term Loans.

Similarly, bank deposits with more than 12 months maturity must be reclassified from Cash and Cash Equivalents to Other Non-Current Assets. Ensure your accounts team maintains a detailed mapping index sheet indicating where each sub-ledger falls within the Schedule III hierarchy to prevent audit-time correction cycles.

7. Common Schedule III Mapping Audit Questions

During statutory audits, CAs will verify the following configurations to ensure there are no formatting violations:

• Classification of Provisions: Short-term provisions (like provision for tax or employee bonuses) must not be mixed with trade payables. Verify that all provision ledgers are grouped under Current Liabilities > Short-term Provisions.
• Revaluation Reserves: If fixed assets were revalued during the year, ensure the increase is mapped to Revaluation Reserves under Reserves & Surplus, rather than general Profit & Loss accounts.
• Borrowings Disclosure: Secured loans must list the specific assets pledged as security. Ensure these notes are configured in TallyPrime's ledger description fields to export along with the balance sheet notes.

8. Frequently Asked Questions Regarding Schedule III Grouping

When compiling company balance sheets under the Schedule III rules, accountants must verify if debit balances in sundry creditors are correctly classified under loans and advances instead of negative liabilities. Additionally, interest accrued on investments must be grouped under other current assets rather than cash balances. Maintaining a clean chart of accounts throughout the year in Tally is essential to avoid manual adjustments during audits.