Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Gstr 1 > How to generate GSTR 1 Plain Excel Sheet in Marg Software ?

How to generate GSTR 1 Plain Excel Sheet in Marg Software ?

2042

Ans.1
  • Go to GST > GSTR1.

  • A 'Marg GST Summary' window will appear.
  • The user will mention the period of the Gst Report as per the requirement.
  • Then click on 'Show'.

  • A 'Marg GST Summary' window will appear.
  • Click on 'GSTR1 Returns'.

A 'GSTR 1' window will appear.

The user will select 'Plain Excel Format'.

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.

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

  • 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 of 'Are you sure to prepare Plain Excel Return' window will appear.
  • Click on 'Yes'.

  • A 'Marg ERP 9+' alert will appear with the mentioned path where the file will get Saved.
  • Click on 'Ok'.

After following the above details, the user can view GSTR 1 Plain excel Sheet will get generate in Marg Software.


Submit Feedback