In order to generate series wise GSTR1 Report in Marg Software, 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 s to view GSTR 1.

• Then click on ‘Show’.

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

• Now user will click on 'More Options' .

• A 'GSTR1' Series window will appear.

• The user will select series as per the requirement.

• Suppose user select 'RT01 Wholesale'.

• Then click on 'Okay'.

• Now only 'RT01 Wholesale' series data will be Displayed.

• Click on 'GSTR1 Returns'.

• Now, Click on 'GSTN Excel Template'.

a) B2B/B2C/CDN Nill entries in Exemp : Select, if the user needs to export separate details of nil rated entries in excel.

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

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

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

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

• 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. 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 will get opened.