General
Yes, it does. The format is in line with the Guidance Note on Financial Statements of Non-Corporate Entities issued by the Institute of Chartered Accountants of India (ICAI).
This Add-on is designed for:
-
Sole Proprietors
-
Hindu Undivided Families (HUFs)
-
Partnership Firms
Other non-corporate entities like Association of Persons, Trusts, Societies and Statutory Corporations may require specific formats and are not currently supported.
Yes, it is applicable only for Indian non-corporate entities (other than Companies under the Companies Act and Limited Liability Partnerships (LLPs) under the LLP Act).
The smart Excel template designed to work with this add-on is compatible with Microsoft Excel on Windows 2016 and later versions.
No, it is not compatible with Mac systems.
This add-on is available from TallyPrime Release 6.0 onwards. To use it, you’ll need to update your TallyPrime to Release 6.0 or later.
To use this add-on, it must be enabled for your TallyPrime license. Additionally, the Export menu in TallyPrime will be available only to users who have access rights to the Balance Sheet, Profit & Loss Account, and Trial Balance.
No, this Add-on is designed exclusively for single Indian companies. It does not support the consolidation of Group Companies.
No, it will be available as an Add-On starting from TallyPrime Release 6.0 and above.
Currently, the Excel template only supports the English language.
Currently, this Excel template only supports Indian Rupees.
Export XML Data from TallyPrime
No, financial data can be exported only in XML format, as currently the Excel template is designed to work with XML data only.
Yes, you can extract previous year’s data from a different company.
To do this:
- Load the company from which previous year data is needed.
- Return to the active company.
- Press Alt+E (Export) > Financial Statements for NCE.
- Press C (Configure) > set Previous Year data is in a separate Company to Yes and select the previous year’s company from the List of Companies.
If this option is set to No, the Stock Summary for both years will not be exported. However, the balances of stock ledgers (created under the Stock-in-Hand group) will still appear as Opening and Closing Stock in the Stock CY/PY sheet.
In cases where access is restricted, any associated data—such as stocks, receivables or payables—will not be exported.
However, the ledger balances for Opening and Closing Stocks will still be included as part of the Trial Balance values
Data Mapping in the Excel Template
Yes, you can. Simply click the Clear Data button located on the Basic Info sheet to clear data, mapping from all the worksheets and saved mapping as well.
Yes, you can copy the mapping from the current year to the previous year.
After completing the mapping in the TB CY sheet, navigate to the TB PY sheet and click Copy Mapping from Current Year. This will copy the entire mapping—except for the Bifurcate Balance column, which will need to be updated manually.
Make sure to review the TB PY sheet after copying. Any ledgers that aren’t common between the two years will remain unmapped and must be mapped manually.
Yes, you can create a new group tailored to your needs.
-
In Classification Level 4, select specify nature.
-
In Classification 5, enter custom descriptions to further categorise financial data as per your reporting requirements.
-
Click Update Notes with Classification 5 to apply the custom descriptions across relevant Notes sections.
The newly added custom description will automatically appear in the relevant notes along with the associated amount.
Yes, you can enhance your mapping experience by copying and pasting responses into multiple cells for quicker processing.
It is recommended that you review the copied mapping before proceeding.
As per the ICAI-prescribed format, certain closing balances need to be bifurcated into Current and Non-Current.
In the Excel template, these balances are pre-filled as Current by default. If any part of the balance qualifies as Non-Current, you must manually enter that value in the Non-Current column.
The template will then automatically adjust the Current value and reflect the bifurcated balances correctly in the relevant Notes.
The Excel template employs colour-coded fields to clearly indicate where your input is necessary. Fields marked in yellow require manual entry, while unmapped fields are highlighted with text in amber.
-
These classifications help group ledgers in the Trial Balance so that financial data can be accurately auto-mapped to the Notes.
-
Classification 1: Identifies whether a ledger belongs to the Balance Sheet or Profit & Loss A/c.
-
Classification 2: Based on Classification 1, it further categorises the ledger as:
-
Liabilities or Assets (for Balance Sheet), or
-
Income or Expenses (for Profit & Loss).
-
-
Classification 3: Defines the next broad classifications of the previous category. for example – Liabilities further classified as Owners Capital Account, Reserves & Surplus, Borrowings, Trade Payables etc
-
Classification 4: Defines the next broad classification of the previous classification. For instance, under Trade Payables, the options could be MSME or Non-MSME.
-
Classification 5: Appears only when specify nature is selected in Classification 4. You’ll need to manually enter a custom group name for inclusion in the Notes.
If your ledgers are created with a proper parent and main group structure, Classifications 1 to 3 are auto-mapped.
Otherwise, you’ll need to complete the mapping manually.
-
Yes, the values from the Trial Balance will be automatically populated in the Balance Sheet, Profit & Loss Statement, and Notes once the mapping (both Auto and Manual) in all relevant worksheets (Trial Balance, Stock, Trade Receivables and Trade Payables is completed.
If historical data is not available, you can still proceed with mapping by selecting the Net Block option.
To do this, go to the Basic Info sheet > Entity Details > PPE and IA, and ensure that Net Block is selected. After this step, you will be able to map the PPE and IA closing balances to a clear and concise PPE Note.
Print or Export Financial Statements
You can easily export the financial statements to MS Excel and customise the layout according to your preferences.
Yes, the financial statements will be printed with perfect margins that are tailored for A4-sized sheets.
Will the extra rows (containing zeros in CY and PY) be removed when I print my financial statements?
Yes, when you click the Print Current Sheet button, the current sheet is converted into a PDF. During this process, any extra rows will be removed, and the numbering will be adjusted to ensure it is sequential.