• Go to GST > GSTR-1.

• A 'Marg GST Summary' window will appear.

• The user will select the Period i.e. from which month till which month the user needs to view GSTR 1.

• Then click on ‘Show’.

• The GSTR 1 Report will get generate for the selected period, the user will select 'GST Summary'. 

• A 'GSTR 1 Summary' window will appear.

• The user will select 'Tax Rate wise Summary'.

• A 'Tax Summary' window will appear in which the user can view the 'Tax Rate wise Sale Summary'.

• Also, if the user needs to generate the report in Excel format then click on 'Excel' tab.

After following the above steps, the user can view the Tax Rate wise Sale Summary will get generate in Excel format.