No, you need to upgrade to TallyPrime Release 7.1 or later releases and have a valid TSS.

MS Excel 2016 or later is supported.

No, you cannot use the Add-on in TallyPrime Educational mode, Remote Access, TallyPrime on Cloud Access, or Mac systems.

No, there is no additional cost to use this Add-on. It is available if you are using TallyPrime Release 7.1 or later and have a valid Tally Software Services (TSS) subscription while enabling the Add-on.

Yes, you can export current-year data for the selected company and previous-year data from another company.

1. Open the Export screen in TallyPrime.
2. Press F12 (Configure) and select the company for previous-year data.
3. Export the data.

If Integrate Accounts with Inventory is set to No, the stock item details are not exported. However, stock ledger balances are included.

Yes, you can export data as long as you have access to Balance Sheet, Profit & Loss, or Trial Balance.

Yes, if MSME details are maintained in ledgers, they are exported and classified automatically.

Yes. In the Basic Info worksheet, go to Details Imported from TallyPrime > Round off the Amount to Nearest, and select the required display scale, such as Thousands, Lakhs, or Crores.

Yes. If your current and previous year’s data are split into separate companies, load both companies in TallyPrime.

While exporting data,

1. Set Previous Year data is in a separate Company to Yes.
2. Select the company that contains the previous year’s data.

The Add-on will export data from both companies into the Excel template.

No, the exported Trial Balance includes only the transactions recorded for the selected period. Transactions recorded using Optional Vouchers are not included.

Yes. To prepare Financial Statements with comparative figures, export data by selecting both the current year’s and previous year’s company data.

Export the data to a copy of the existing Excel template so that the ledger mapping is retained. The current year’s figures are then presented along with the previous year’s comparative figures in the Financial Statements.

No, the Signatory Details and UDIN are not fetched automatically. You need to enter them manually in the Basic Info worksheet in the Excel template.

You can add or hide sheets. However, deleting sheets is not recommended, as it may affect the functionality.

Yes, you can save and reuse mapping for another company as the Mapping is automatically saved in the Excel template.

When you export data for a different company using an existing Excel template, the existing mapping is reused, so you do not need to map the common ledgers again unless you have added new ledgers that require mapping.

Yes, you can.

To copy mapping from one year to another:

1. Go to the TB PY worksheet.
2. Click Update Mapping from TB CY.
3. Review the updated mapping.
4. Identify and complete any unmapped ledgers or fields, if required.

Yes, you can copy and paste mappings across cells.

Yes, you can add a new classification in C2 and C3 columns, and press Enter.

A confirmation message appears to add the new classification, and once confirmed, it is saved for further use.

No, the Ageing brackets cannot be modified as they are fixed as per the Schedule III disclosure requirements.

You can identify pending actions in the following ways:

1. Unmapped status: Items that are not yet mapped are clearly marked, helping you identify what needs attention.
2. Differences with Trial Balance (TB): Any differences are highlighted in the input sheets for quick review.
3. Uncertain/FS Impact sheet: All such items are summarised in a dedicated sheet, making it easier to track and resolve pending actions.

Cells highlighted in yellow indicate fields where you can optionally provide additional inputs, and do not necessarily represent pending issues.

Yes, you can export the output sheets to a separate Microsoft Excel workbook and make the required changes. However, the exported workbook is no longer linked to the original Schedule III Financial Statements template.

No, ledger mapping is a one-time activity. Once you map the ledgers, the mapping is saved in the Excel template and is retained when you export data to the same file. You only need to map newly created ledgers.

If you click Update Input Sheets to refresh the mapping, any data entered manually in the cells highlighted in yellow of the input sheets will be cleared. Therefore, complete the mapping before entering manual details, or note down the required information before updating the input sheets.

After changing the stock valuation method in TallyPrime, export the company data again. The updated closing stock balances are exported to the Excel template along with the other financial data.

The Add-on does not calculate Deferred Tax Assets, Deferred Tax Liabilities, or Deferred Tax Expenses. These calculations must be done separately. The balances of Deferred Tax ledgers are automatically mapped to the relevant input sheet, where you can enter the required workings and disclosure details.

If your company maintains Fixed Assets at their net value instead of using separate Gross Block and Accumulated Depreciation ledgers, the Add-on supports this reporting format.

In the Basic Info worksheet, select Net Block for the PPE Block and IA Block options. The balances of the Fixed Assets ledgers are then mapped to the PPE Net (Input) sheet, where you can enter the required details. Based on this information, the Add-on generates the PPE schedule in the Net Block format.

No, classification depends on your reporting requirements and must be defined manually.
However, balances are initially placed under Current, by default. Any amount added in the Non-Current column will be adjusted from the Current amount.

Yes, the Credit Balances in the Debtor’s sheets have default mapping to classify the negative balances in Trade Receivables as Advances from Customers under Current Liabilities.

• Review the mapping carefully.
  

The Excel template provides dedicated sections to capture Related Party disclosures for Borrowings, Loans and Advances, and other applicable disclosure notes in Additional Notes Input sheet.

Rate of Depreciation is not a mandatory disclosure under Schedule III. Therefore, it is not included in the PPE schedule.

Yes, if receivables and payables are maintained using Bill-wise Details, the required ageing schedules are generated automatically.

Whereas when the data is exported Party-wise, the details will be posted in the relevant sheets, and you need to enter the ageing schedule manually.

1. Close the Excel template before exporting the data again.
2. Select the same folder and template file.
3. Export the data again.

The data in Excel will be overwritten with new exported data. However, the mappings will be retained, so you do not need to map the data again unless you have added new ledgers that require mapping.

Yes, the reports are formatted for A4-size printing.

Yes, you can export the reports to MS Excel and customise them as needed.

Yes, empty rows are automatically removed while generating the notes, ensuring that the final output is clean and does not include blank rows.

No, to make any formatting changes, export the data to a new Excel file and make the required changes there.

• Go to Index, click the Excel icon on the top-right corner.