What is an 'Unclassified Ledger' exception in TallyPrime's Schedule III report?

This exception occurs when a user-defined ledger or group does not have a direct classification rule mapping it to the statutory sections specified by MCA Schedule III. TallyPrime flags these to ensure that the balance sheet total matches your Trial Balance.

How do I map a custom loan ledger under Schedule III?

Select the unclassified ledger in the Schedule III Balance Sheet exceptions view, press F5 (Reclassify), and select the appropriate category (e.g., Long-Term Borrowings for secured term loans, or Short-Term Borrowings for bank overdrafts). Save the configuration.

Why do my adjustments in the Schedule III screen reset after I close the report?

This happens if you do not have permission to write alterations to the company database, or if the reclassification changes are not saved using Ctrl+A. Ensure you are logged in with Owner or Auditor credentials before modifying statutory mappings.

Can I print a direct Excel sheet matching MCA taxonomies from TallyPrime?

Yes. Once all mappings are resolved and there are no unclassified exceptions, you can press Alt+E > Export > Statutory Report and choose the format to export your balance sheet as a pre-formatted Excel template matching MCA requirements.

How does TrulyInvoice help keep Tally books clean for Schedule III auditing?

TrulyInvoice maps incoming supplier bills directly to your pre-existing ledger masters and standard groups (e.g., Sundry Creditors). By preventing the creation of duplicate or unclassified ad-hoc ledgers during invoice data entry, TrulyInvoice ensures that your books are clean and ready for audits.

Fix Schedule III Mapping Errors in TallyPrime

Companies registered under the Companies Act in India must present their financial statements (Balance Sheet, Profit & Loss) in the format prescribed by Schedule III. TallyPrime provides a built-in module to compile these reports, but mismatched ledger structures can trigger mapping errors.

For incorporated companies, compiling the annual financial statements is a critical compliance task. The Ministry of Corporate Affairs (MCA) mandates that the Balance Sheet and Statement of Profit and Loss must adhere to the classification guidelines of Schedule III of the Companies Act, 2013. TallyPrime features a dedicated **Schedule III Balance Sheet** reporting engine to automate this process. However, if your accounting team has created custom ledger accounts or modified default groups without mapping them to the statutory categories, TallyPrime will flag these as unclassified exceptions, throwing off your balance sheet presentation.

What Causes Schedule III Mapping Mismatches?

TallyPrime organizes reports based on a hierarchical tree structure: Ledgers roll up to Subgroups, which roll up to Primary Groups. The Schedule III engine attempts to map these primary groups to standard corporate taxonomy classifications (such as Shareholders' Funds, Non-Current Liabilities, Current Assets, etc.).

A mapping error or exception occurs when:

Custom Groups: A user creates a custom group (e.g., 'Director Loan Accounts') directly under the root directory without specifying its relationship to standard liabilities.
Mismatched Assets/Liabilities: A security deposit ledger is placed under current assets, but lacks the specific 'Long-Term Loans and Advances' sub-classification.
Incorrect Debit/Credit Balances: An account shows an unexpected negative balance (e.g., a bank account with a credit balance) which has not been mapped as an overdraft.

Detailed Structure of Schedule III Balance Sheet Categories

To properly map your charts, it helps to understand the statutory vertical hierarchy defined under Schedule III:

1. Equity and Liabilities:
- Shareholders' Funds: Share Capital, Reserves & Surplus, Money received against share warrants.
- Share Application Money pending allotment: Classified separately until shares are formally issued.
- Non-Current Liabilities: Long-term borrowings, Deferred tax liabilities (net), Other long-term liabilities, Long-term provisions.
- Current Liabilities: Short-term borrowings, Trade payables, Other current liabilities, Short-term provisions.
2. Assets:
- Non-Current Assets: Property, Plant & Equipment and Intangible assets, Non-current investments, Deferred tax assets (net), Long-term loans & advances, Other non-current assets.
- Current Assets: Current investments, Inventories, Trade receivables, Cash & cash equivalents, Short-term loans & advances, Other current assets.

Ledger Classification Guide

The table below provides a reference mapping for common custom ledgers to ensure your Schedule III balance sheet resolves correctly:

Custom Ledger / Group Name	Standard Tally Group	Correct Schedule III Classification
Custom Office Security Deposit	Loans & Advances (Asset)	Non-Current Assets > Long-Term Loans & Advances
Director's Unsecured Term Loan	Unsecured Loans	Non-Current Liabilities > Long-Term Borrowings
Advance from Retail Customers	Current Liabilities	Current Liabilities > Other Current Liabilities
Provision for Statutory Audit Fees	Provisions	Current Liabilities > Short-Term Provisions

How to Reclassify Mapped Ledgers in TallyPrime

Follow these steps to access and resolve unclassified exceptions in TallyPrime:

Open the Statutory Balance Sheet Screen

Go to Gateway of Tally > Display More Reports > Statutory Reports > Schedule III Balance Sheet. Press Enter to load the statutory layout.

Access the Exceptions Panel

Click the Exception Reports button on the right-hand menu panel (or press Ctrl+J). Select Unclassified Ledgers from the list. TallyPrime will display all ledgers currently excluded from the balance sheet calculations.

Execute the Reclassification Tool

Highlight the unclassified ledger. Press the spacebar to select it, then click the F5 (Reclassify) button. Select the appropriate Schedule III group from the panel on the right, save the mapping, and repeat for all exceptions.

Auditor Verification Checklist for MCA Filing

Before finalizing your Schedule III reports and exporting data for statutory filings (such as AOC-4), CAs and corporate auditors should verify the following configurations:

Negative Asset Balances: Check for negative numbers in your bank or cash books. Credit balances in bank ledgers must be reclassified under 'Current Liabilities > Short-Term Borrowings' as overdraft accounts.
Aging of Trade Payables: Schedule III requires trade payables to be split between outstanding payments to MSME vendors and others, along with aging analysis. Run the aging report to ensure these categories are clean.
Inter-Company Balances: Loans to sister companies should not be mixed with trade payables. They must be grouped under 'Long-Term Loans and Advances' or 'Short-Term Loans and Advances'.
Reserves Reconciliation: Ensure current-year profits are correctly transferred from the Profit & Loss statement to the 'Reserves & Surplus' ledger in your Equity section.

Avoid Ad-Hoc Ledger Mapping Issues with TrulyInvoice

Many mapping errors are caused by poor ledger data hygiene. When accounts teams enter invoices manually, they often create duplicate supplier accounts or place ledgers in the wrong groups to save time during busy periods. Over the fiscal year, this creates a chaotic chart of accounts that requires hours of manual mapping before audit season.

By implementing TrulyInvoice, you can prevent these issues. TrulyInvoice extracts supplier invoices and maps them directly to your existing Tally chart of accounts. By matching supplier details to your predefined ledger groups (like Sundry Creditors or Sales), TrulyInvoice keeps your database structured and clean. This eliminates mapping exceptions and ensures your Schedule III balance sheet is always audit-ready.

How to Fix Schedule III Mapping Errors in TallyPrime Balance Sheet