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
- GSTIN of supplier/E-commerce should be a valid one. State code of supplier GSTIN and E-Commerce GSTIN should be the same.
- 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.
- Amount should be only up to 2 decimal digits
- Ensure that filling of excel should be strictly as per sample data to avoid errors.
- Copy paste data from the excel template not including the header rows 1 to 4 will throw an error.
- 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.
- 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 ...