Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Gst Register Return > How to Generate GSTR1 Excel Template in Marg Software ?

How to Generate GSTR1 Excel Template in Marg Software ?


  • 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/B2C/CDN Nill entries in Exemp : Select, if the user wants to export separate details of nil rated entries in excel.

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

c) Include -ve figures in HSN Sheet : Select, if the user wants to include -ve value of HSN in HSN summary details.

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

e) Exclude Misc. Expenses from bill : Select, if the user wants to exclude misc. expenses from the bill in excel.

Then click on 'Start' button.

  • Thereafter, 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. Click on 'Ok'.

  • In order to view the excel sheet, open the Marg folder > Enter on "GSR Return folder, so the user can view the excel file that has been generated.


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

2. A 'GST Summary' window appears. Feed date range. Click on 'Show'.

3. Click on 'Excel'.

4. A 'GSTR1' window will appear. Select 'Summary/Detail' as per the requirement.

5. Now, click on 'Okay'.

So, in this way the user can generate GSTR 1 in Excel format in Marg ERP Software.

Add Feedback