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.
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.