Govt has release an offline utility tool to upload b2b, b2cl and b2cs sheet in GSTN portal. But challenge is how to generate data into these sheets. What values shall correspond to which sheet. For this user have to have knowledge of GST Act. Most of the users are new to GST. Therefore to make your work extra easy we have released a Master Excel sheet. In this sheet enter invoice details like

a. GSTIN of recipient if any

b. Place of supply

c. Invoice value

d. Taxable Value

e. HSN

f. Rate


With these values all the 3 sheets shall be generated easily. Use this sheet for your client or self use it.

Video is attached.

Author Bio

More Under Goods and Services Tax

Posted Under

Category : Goods and Services Tax (6037)
Type : Articles (16005)
Tags : goods and services tax (4548) GST (4142)

2 responses to “Video : Demo of GSTR 1 ver 1.3 master excel sheet to create instant b2b, b2cl and b2cs sheet”

  1. Basavaraj Hiremath says:

    Sir we have URD purchases of Paddy and Cotton.
    Paddy is exempt for RD sale where we to enter the details? only in exempt coloum or in B2B coloum. And cotton is 5% URD Purchases in gstr 1 or gstr 2 where we have to show ? where we have to enter invoice details of URD purchases.
    In your XL sheet we can upload the tally data.

  2. Narendra Kumar Dash says:

    Nice master sheet

Leave a Reply

Your email address will not be published. Required fields are marked *