Step 4: Import the XML File into the Excel Template

1. Open the extracted Excel template and go to the Basic Info sheet.
   

2. In the Basic Information sheet, follow these steps:

   1. Under Import Details, click Select XML file to Import and choose the file from its saved location.
      The data exported from TallyPrime will be imported into the relevant worksheets. The fields highlighted in yellow require manual entry or selection.

   2. In the Entity Details section, the following fields will be auto-filled: Name of the Entity, Address, and PAN.
      If the PAN is not entered in TallyPrime, you will need to input it manually here.

   3. Type of Entity: Auto-filled if PAN is available. Else, you will have to manually select it.

   4. Round Off Amount to Nearest: The rounding-off scale is set to ‘Default’, but you can change it as needed based on how you want to present the financial statement.

      While manually entering values in any worksheet, make sure they align with the rounding-off scale selected here.

   5. Trade Receivables and Trade Payables: Manually select this option if you wish to use the data for notes related to bill-wise or party-wise Trade Payables and Trade Receivables worksheets. The As Per Trial Balance Closing Balance option is selected by default, but you can modify it according to your needs.

   6. PPE and IA block (Property, Plant and Equipment and Intangible Assets): Manually select an option for the PPE and IA block. Net Block is selected by default. You can change it to Gross Block, if required.
      Note: When you choose Gross Block in the Basic Info worksheet, make sure to select PPE & IA (Gross) under Classification 3 in the TB CY/PY worksheets.

   7. Under Signatory Details, all fields must be entered manually.
3. To clear data and mappings, including saved mappings from multiple sheets—especially if you’ve selected the wrong XML file—click Clear Data.

4. Click Go to Index for easy navigation within the Excel Template.

To know more about using the Excel Template, refer to the ReadMe worksheet in the Excel Template. 

Step 5: Map the Data in Excel

Once the XML file is imported, data for the current year (CY) and/or previous year (PY) is auto-populated into the following worksheets, as applicable—based on the data exported.

• Trial Balance: Contains the Trial Balance details for the current and previous years.

• Stock Summary: Displays item-wise Stock Summary along with Opening and Closing Balances for both years.

• Trade Payables: Includes party-wise and bill-wise outstanding payables.

• Trade Receivables: Includes party-wise and bill-wise outstanding receivables.

1. Select TB CY to open the worksheet for trial balance for the current year.
   

   Positive values indicate Credit balances, while negative values indicate Debit balances.

   The columns under the Data Imported from TallyPrime section will be auto-filled based on the imported data.

2. Start the mapping process by manually selecting the options in the fields highlighted in yellow.

   1. Under Bifurcate Balance, you may need to split values based on two possible categories:

      1. Current and Non-Current – Values are added under the Current column by default. You must manually enter the Non-Current portion, as applicable.

      2. Trade Receivables (More than 6 months and less than 6 months) – By default, closing balances are added under Less than 6 months. If applicable, enter the relevant amounts under More than 6 months based on ageing.
         Ensure that positive amounts are entered against positive values, and the same applies for negative values.

   2. Under Mapping Details, map Classifications 3, 4, and 5. 

      1. Map each ledger row sequentially, starting from Classification 3, then Classification 4, and finally Classification 5, if applicable.
         Mappings completed up to Classification 4 will be automatically updated in the corresponding Notes worksheets.

      2. If you select the specify nature option in Classification 4, you can proceed to map Classification 5.
         Classification 5 allows you to add custom descriptions to further categorise financial data as per your reporting or disclosure requirements.

3. After entering the details in Classification 5, click Update Notes with Classification 5 to apply the custom descriptions across relevant Notes sections.

4. If you have already mapped the current year (CY) data and want to reuse the same mapping for the previous year (PY):

   1. Go to the TB PY sheet.

   2. Click Copy Mapping from Current Year to apply the same classifications/mappings.
      
      After the mapping is complete, check for any amber-highlighted fields. These highlight issues like unmapped ledgers, imbalance in Trial Balance, or opening balance mismatches that may prevent your Balance Sheet from tallying.

5. Similarly, if you have mapped the previous year (PY) and want to reuse that mapping for the current year:

   1. Go to the TB CY sheet.

   2. Click Copy Mapping from Previous Year to apply the same classification.

6. After completing the mapping for all worksheets in the Excel Template, go to the Basic Info worksheet and click Save Mapping.
   This saved mapping can be reused if you import an updated Trial Balance for the same company.

You can always refer to the ReadMe sheet for help.

Now that mapping is done, you can proceed with printing or exporting the financial statements.

Step 6: Print or Export the Financial Statements

You can easily print or export your financial data—whether it’s a single sheet, full statements, or detailed notes.

• Print Current Sheet: Click this button to export the current worksheet as a PDF or view its print preview. This option is available on every worksheet.
• Print All Notes: Click this button to export as a PDF or preview the print version of all the Notes worksheets.

When you click any Print button, a message will appear asking if you want to export to PDF or preview the financial statements.

1. Click Yes to export to PDF.
2. Click No to view a print preview.
3. In the print preview screen, click Print or press Ctrl+P to print the statements.
4. Click Cancel to exit the print flow.

While generating the PDF or viewing the print preview, rows where both Current Year and Previous Year have nil balances will be excluded automatically, and the row numbers will be adjusted accordingly.

• Export to MS-Excel: Click this button to export the file to Excel in your current template location.
  A confirmation message will appear showing the file name and location.
  • Click OK to close the message.

The exported Excel file will be saved in your selected folder.

The Excel sheet will not include formulas or linked worksheets.

By following these steps, you can seamlessly prepare Financial Statements for NCE using data exported from TallyPrime and a structured Excel template—ensuring compliance with regulatory formats and simplifying reporting for your organisation.