• Go to GST > GSTR1.

• Select the Period i.e. from which month till which month the user wants 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'.

Now, Click on 'GSTN Excel Template'.

a) B2B/CDNR Nill entries in Exempted : Select, if the user wants to export separate details of nil rated entries in excel.

b) B2C/CDNUR Nill entries in Exempted : Select, if the user wants to export separate details of nil rated entries in excel.

c) Include HSN Summary : Select, if the user wants to export HSN Summary in excel.

d) Include Document details :  Select, If the user wants to export document details in excel.

Then click on 'Start' button.

• Thereafter, an errors found in the 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'.

• Click on 'Yes'.

• Click on 'Ok'.

• In order to view the excel sheet, open the Marg folder > select GST Return folder, so the user can view the excel file that has been generated.

After following the above steps user can easily generate GSTR1 Excel Template in Marg ERP Software.

1. Go to GST > GSTR1. Press 'Enter' key.

2. Feed date range. Click on 'Show'.

3. Click on 'Excel'.

4. Select 'Summary/Detail' as per the requirement.

5. Now, click on 'Okay'.

After following the above steps user can generate GSTR 1 in Excel format in Marg ERP Software.