Exporting GSTR-1

GSTR-1 return can be exported in the required excel format for any given period. All the transactions that are displayed under Included in returns section in GSTR-1 report will be exported.

The MS excel file created on export of GSTR-1 is in line with the format prescribed by the department. The file can be imported to the offline utility tool. This tool then creates the .json file that can be uploaded on the GST portal.

To export GSTR-1

1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-1.

2. Press Ctrl+E.

3. Press Enter in the Export Report screen to export.

GSTR-1 will be exported to excel format. The description of the sheet and columns in the exported file is given below:

Field Name	Description
b2b	Displays the details of vouchers captured in the table 5 B2B Invoices

GSTIN/UIN	Displays the GSTIN/UIN of the buyer selected in the sales transaction, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Invoice Number	Displays the invoice number of the outward supply transaction.
Invoice date	Displays the date of the outward supply transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Place Of Supply	Displays the state code of the buyer’s location.
Reverse Charge	Display Y if the transaction is reverse charge transaction, else N.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

B2ba	Displays the values of voucher captured in the table 5A Amendments to b2b invoices.

Original Invoice Number	Displays the invoice number of the outward supply transaction of previous period which is being amended in the current period.
Original Invoice date	Displays the invoice date of the outward supply transaction of previous period which is being amended in the current period.
Revised Invoice Number	Displays the invoice number of the outward supply transaction recorded in the current period for amending a previous period transaction.
Revised Invoice date	Displays the invoice date of the outward supply transaction recorded in the current period for amending a previous period transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Place Of Supply	Displays the state code of the buyer’s location.
Reverse Charge	Display Y if the transaction is reverse charge transaction, else N.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

B2cl	Displays the values of voucher captured in 6 B2C(Large) Invoices in GSTR-1.

Recipient State Code	Displays the state code of the buyer’s location.
Recipient Name	Displays the name of the buyer selected in the transaction, as the name specified in the ledger master.
Invoice Number	Displays the invoice number of the outward supply transaction.
Invoice date	Displays the date of the outward supply transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Place Of Supply	Displays the state code of the buyer’s location.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

B2cla	Displays the values captured in 6A Amendments to B2C(Large) Invoices table in GST-1.

Recipient State Code	Displays the state code of the buyer’s location.
Original Invoice Number	Displays the invoice number of the outward supply transaction of previous period which is being amended in the current period.
Original Invoice date	Displays the invoice date of the outward supply transaction of previous period which is being amended in the current period.
Recipient Name	Displays the name of the buyer selected in the transaction, as the name specified in the ledger master.
Revised Invoice Number	Displays the invoice number of the outward supply transaction recorded in the current period for amending a previous period transaction.
Revised Invoice date	Displays the invoice date of the outward supply transaction recorded in the current period for amending a previous period transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Place Of Supply	Displays the state code of the buyer’s location.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

B2cs	Displays the value of vouchers captured in the table 7 B2C(Small) Invoices in GSTR-1.

Type	Displays ecom for e-commerce party and non-ecom for a others.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Recipient State Code	Displays the state code of the buyer’s location.
Total Taxable Value	Displays the total value in the invoice including tax and cess.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.

B2csa	Displays the value of invoices captured in the table 7A Amendments to B2C(Small) Invoices in GSTR-1.

Month	Displays the month in which the original invoice that is being amended was recorded.
Original HSN	Displays the HSN/SAC of the item/service selected in the original outward supply transaction.
Original Category	Displays G if the Type of Supply selected is goods and S if it is Services in the original outward supply transaction.
Original State Code	Displays the state code of the buyer’s location in the original outward supply transaction.
Type	Displays ecom for e-commerce party and non-ecom for a others.
Revised HSN	Displays the HSN/SAC of the item/service selected in the revised outward supply transaction.
Revised Category	Displays G if the Type of Supply selected is goods and S if it is Services in the revised transaction.
Recipient State Code	Displays the state code of the buyer’s location in the revised transaction.
Total Taxable Value	Displays the total value in the invoice including tax and cess.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.

Cdnr	Displays the values of voucher captured in the table 8 Credit/Debit Notes in GSTR-1.

GSTIN/UIN	Displays the GSTIN/UIN of the buyer selected in the debit/credit note transaction, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Note Type	Displays credit for credit note and debit for debit note.
Reason For Issuing Note	Displays the reason for issuing the debit note as selected in the voucher.
Debit Note Number	Displays the invoice number of the debit note transaction.
Debit Note date	Displays the invoice date of the debit note transaction.
Invoice Number	Displays the invoice number of the transaction against which debit note is recorded, as recorded in the Original Invoice no. field in the voucher.
Invoice date	Displays the invoice date of the transaction against which debit note is recorded, as recorded in the Original Invoice Dt. field in the voucher.
Total Differential Value	Displays the total value in the debit note including tax and cess.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the party is an e-commerce operator.

Cdnra	Displays the values of voucher captured in the table 8A Amendments to Credit/Debit Notes in GSTR-1.

GSTIN/UIN	Displays the GSTIN/UIN of the buyer selected in the debit/credit note transaction recorded for amending a previous note, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Original Debit Note Number	Displays the invoice number of the original debit/credit note of previous period which is being amended in the current period.
Original Debit Note date	Displays the invoice date of the original debit/credit note of previous period which is being amended in the current period.
Revised Debit Note Number	Displays the invoice number of the debit/credit note recorded for amending a previous transaction.
Revised Debit Note date	Displays the invoice date of the debit/credit note recorded for amending a previous transaction.
Note Type	Displays Debit for debit note and Credit for credit note.
Reason For Issuing Note	Displays the reason for issuing the debit note as selected in the voucher.
Invoice Number	Displays the invoice number of the transaction against which the original debit note was recorded, as recorded in the Original Invoice no. field in the voucher.
Invoice date	Displays the invoice date of the transaction against which the original debit note was recorded, as recorded in the Original Invoice Dt. field in the voucher.
Total Invoice Value	Displays the total value in the revised debit note including tax and cess.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable
E-Commerce GSTIN	Displays the GSTIN/UIN of the e-commerce operator if the buyer is an e-commerce operator.

at	Displays the values of voucher captured in the table 11 Tax Liability on Advances in GSTR-1.

Customer GSTIN/UIN/Name	Displays the GSTIN/UIN of the buyer selected in the receipt transaction, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Recipient State Code	Displays the state code of the buyer’s location.
Document Number	Displays the invoice number of the receipt transaction.
Document date	Displays the date of the receipt transaction.
Total Invoice Value	Displays the total value in the receipt voucher including tax and cess.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the receipt transaction.
Total Taxable Value	Displays the taxable value in the receipt voucher on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

ata	Displays the values of voucher captured in the table 11A Amendments to Tax Liability on Advances in GSTR-1.

Original Customer GSTIN/UIN/Name	Displays the GSTIN/UIN of the buyer selected in the original receipt transaction that is being amended, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Original Document Number	Displays the invoice number of the original receipt transaction that is being amended.
Original Document date	Displays the date of the original receipt transaction that is being amended.
Revised Customer GSTIN/UIN/Name	Displays the GSTIN/UIN of the buyer selected in the revised receipt transaction recorded for amending the earlier transaction, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Revised Document Number	Displays the invoice number of the revised receipt transaction recorded for amending the earlier transaction.
Revised Document date	Displays the date of the revised receipt transaction recorded for amending the earlier transaction.
Recipient State Code	Displays the state code of the payer’s location.
Total Invoice Value	Displays the total value in the revised receipt voucher including tax and cess.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the receipt transaction.
Total Taxable Value	Displays the taxable value in the revised receipt voucher on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

Exp	Displays the values of voucher captured in the table 10 Exports Invoices in GSTR-1.

Export Type	Displays the export type based on the type of export transaction.
Invoice Number	Displays the invoice number of the export transaction.
Invoice date	Displays the date of the export transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Ship Bill Code	NA
Ship Bill Number	Displays the shipping bill number recorded in the GST Provide Details screen of the voucher.
Ship Bill Date	Displays the shipping bill Date recorded in the GST Provide Details screen of the voucher.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

Expa	Displays the values of voucher captured in the table 10A Amendments to Exports Invoices in GSTR-1.

Export Type	Displays the export type based on the type of export transaction.
Original Invoice Number	Displays the invoice number of the original export transaction that is being amended.
Original Invoice date	Displays the date of the original export transaction that is being amended.
Revised Invoice Number	Displays the invoice number of the revised export transaction.
Revised Invoice date	Displays the date of the revised export transaction.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Ship Bill Code	NA
Ship Bill Number	Displays the shipping bill number recorded in the GST Provide Details screen of the voucher.
Ship Bill Date	Displays the shipping bill Date recorded in the GST Provide Details screen of the voucher.
Provisional Assessment	Displays Y if the transaction requires provisional assessment, else N.
Category	Displays G if the Type of Supply selected is goods and S if it is Services.
HSN/SAC of Supply	Displays the HSN/SAC of the item/service selected in the outward supply transaction.
Total Taxable Value	Displays the taxable value in the invoice on which tax is calculated.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable

Txpd	Displays the values of voucher captured in the table 12 Setoff of Tax Paid against Advances in GSTR-1.

Invoice Number	Displays the invoice number of the outward supply transaction recorded against advance received in previous period.
Invoice date	Displays the date of the outward supply transaction recorded against advance received in previous period.
GSTIN/UIN	Displays the GSTIN/UIN of the buyer selected in the sales transaction, as recorded in the GSTIN/UIN field of GST Details screen in party ledger or in GSTIN/UIN field in the Party Details screen of the voucher.
Document Number	Displays the voucher number of the advance receipt transaction against which the supply is recorded.
Document Date	Displays the date of the advance receipt transaction against which the supply is recorded.
Total Invoice Value	Displays the total value in the invoice including tax and cess.
Type	Displays ecom for e-commerce party and non-ecom for a others.
IGST Rate	Displays the integrated tax rate levied in the voucher, if it is an interstate transaction.
IGST Amount	Displays the integrated tax amount levied in the voucher, if it is an interstate transaction.
CGST Rate	Displays the central tax rate levied in the voucher, if it is a local transaction.
CGST Amount	Displays the central tax amount levied in the voucher, if it is a local transaction.
SGST Rate	Displays the state tax rate levied in the voucher, if it is a local transaction.
SGST Amount	Displays the state tax amount levied in the voucher, if it is a local transaction.
CESS Rate	Displays the cess rate levied in the voucher, if cess is applicable.
CESS Amount	Displays the cess amount levied in the voucher, if cess is applicable.

Rate this article*

E-mail ID

Contact Number

Share your feedback about this page

Remaining Characters: 520

Tally.ERP 9 Topics

Exporting GSTR-1