If HSN wise summary does not show at the time of exporting GSTR 1 Return into Excel then this issue can easily be resolved in Marg Software.

In order to resolve this error, the user needs to follow the below steps:

• Go to GST > GSTR1.

• Select the Period i.e. from which month till which month the user needs to view GSTR 1.

• Then click on ‘Show’.

• Then Rows will be shown on the window according to GSTR-1 (GST Return form).

• Click on 'GSTR1 Returns'.

• The user needs to select 'GSTN Excel Template' and select 'Include HSN Summary'.

•  Then click on 'Start' button.

• An 'Errors Found In GST Returns' window will appear.

• In this window if the user has found any errors in GSTR1 report then those errors will be shown here.

• Click on 'Close'.

• An alert window of 'Are you sure to prepare eReturn file ?' will appear. Click on 'Yes'.

• Now, the user can view that an excel sheet has been generated with HSN Summary.

• Click on 'Ok'.

After following the above steps, the GSTR1 summary will be export in excel with HSN summary.

1. Go to Masters > Marg Setups > Control Room.

2. A 'Control Room' window will appear. The user will select ‘Search in all’.

3. The user will Search 'HSN' and click on ‘Accept’.

4. In 'E-Invoice Y-Hsn Code I-Item wise N-No (Tax% Only)' option, the user will select 'Y'.

5. The user will now press 'ESC' key twice.

6. Now click on ‘Yes’ to save the changes.

Cause:

This issue also appears due to HSN only being updated in Item Master but not updated in the bill.

Solution:

• The user needs to run a Change with Current Tax