Self Help Knowledgebase and Trouble Shooter

Invoice & other data upload for creation of GSTR 1

The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets.
The fields marked with asterisk or star are mandatory.

B2B

B2B Supplies > Details of invoices of Taxable supplies made to other registered taxpayers

            

B2BA
B2BA Supplies > Amended Details of invoices of Taxable supplies made to other registered taxpayers


            

B2CL

B2C Large > Invoices for Taxable outward supplies to consumers where - 
a) The place of supply is outside the state where the supplier is registered and
b) The total invoice value is more that Rs 2,50,000

            

B2CLA
Amended B2C Large > Amended Details of Invoices for Taxable outward supplies to consumers where - 

a) The place of supply is outside the state where the supplier is registered and
b) The total invoice value is more that Rs 2,50,000

            

B2CS

B2C Small > Supplies made to consumers and unregistered persons of the following nature - 
a) Intra-State: any value   b) Inter-State: Invoice value Rs 2.5 lakh or less

            

B2CSA

Amended B2C Small > Amended Details of Supplies made to consumers and unregistered persons of the following nature

a) Intra-State: any value b) Inter-State: Invoice value Rs 2.5 lakh or less

            

CDNR

Credit/ Debit Note > Credit/ Debit Notes/Refund vouchers issued to the registered taxpayers during the tax period. Debit or credit note issued against invoice will be reported here against original invoice, hence fill the details of original invoice also which was furnished in B2B,B2CL section of earlier/current period tax period.


            

CDNRA

Amended Credit/ Debit Note > Amended Credit/ Debit Notes/Refund vouchers issued to the registered taxpayers during the tax period. Debit or credit note issued against invoice will be reported here against original invoice, hence fill the details of original invoice also which was furnished in B2B,B2CL section of earlier/current period tax period.


            

CDNUR

Credit/ Debit Note for unregistered Persons > Credit/ Debit Notes/Refund vouchers issued to the unregistered persons against interstate invoice value is  more than Rs 2.5 lakh


            

cdnura

Amended Credit/ Debit Note for unregistered Persons > Amended Credit/ Debit Notes/Refund vouchers issued to the unregistered persons against interstate invoice value is  more than Rs 2.5 lakh

            

exp

Export > Exports supplies including supplies to SEZ/SEZ Developer or deemed exports

            

expa

Amended Export > Amended Exports supplies including supplies to SEZ/SEZ Developer or deemed exports

            

at

Tax liability on advances > Tax liability arising on account of receipt of consideration  for which  invoices have not been issued in the same tax period.

            

ata

Amended Tax liability on advances > Amended Tax liability arising on account of receipt of consideration  for which  invoices have not been issued in the same tax period.

            

atadj

Advance adjustments > Adjustment of tax liability for tax already paid  on advance receipt of consideration and invoices issued in the current period for the supplies. 

            

atadja

Amended Advance adjustments > Amended Adjustment of tax liability for tax already paid  on advance receipt of consideration and invoices issued in the current period for the supplies. 

            

exemp 

Nil Rated, Exempted and Non GST supplies > Details of Nil Rated, Exempted and Non GST Supplies made during the tax period

            

hsn      

HSN Summary > HSN wise summary of goods /services supplied during the tax period

            

docs

List of Documents issued > Details of various documents issued by the taxpayer during the tax period

            

Common mistakes in filling Excel template

  1. GSTIN of supplier/E-commerce  should be a valid one. State code of supplier GSTIN and E-Commerce GSTIN should be the same.
  2. Duplication of invoices with the same tax rate shouldn’t be there-otherwise System throws error as "Non duplicated invoices were added & these invoices are duplicated" at the time of import.
  3. Amount should be only up to  2 decimal digits
  4. Ensure that filling of excel should be strictly as per sample data to avoid errors.
  5. Copy  paste data from the excel template not including the header rows 1 to 4 will throw an error.
  6. The work sheet name in the excel file of return data prepared by the return prepare should be the same as mentioned in the sample excel template. 
  7. Master data sheet provides the inputs allowed in the mentioned data field. Inputs in the master data sheet have been used for the drop down lists in the worksheets.

            

    • Related Articles

    • Invoice & other data upload for creation of GSTR 2 in Express GST | GST Filing

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. b2b B2B Supplies - ...
    • How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

      Solution: Step 1: Login on GST Software Application. Step 2: Select Company, Financial Year, Filing Type as GSTR-1 and Tax Period and then Go to Proceed.              Step 3: Here Click on - Download Sample Template.              Step 4: Once the ...
    • How to Export GSTR-2 data in MS Excel?

      To export GSTR-2 returns Data in the MS Excel follow the steps below : Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2 Make sure that there are no items under the section Not included in returns due to incomplete information     ...
    • How to Export GSTR-1 Return in MS Excel?

      To export GSTR-1 returns in the MS Excel follow the steps below : Steps 1 : Gateway of Tally > Display > Statutory Reports > GST > GSTR-1. Alternatively, Press Alt+G (Go To) > Type Here or Search GSTR-1 > Press Enter. Step 2 : F2: Period: Select the ...
    • GSTR-2A Reconciliation

      GST reconciliation primarily involves matching the data uploaded by the suppliers with those of the recipient's purchase data. This basically includes comparing the GSTR-2A auto-populated from suppliers data and the purchase data recorded by the ...