How to export GSTR-1 in excel format for return filing /uploading to gst portal

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.

How to export GSTR-1 in excel format for return filing /uploading to gst portal
4.4 (88.13%) 32 votes
Filed in: GST

Share this post

One thought on “How to export GSTR-1 in excel format for return filing /uploading to gst portal

Post Comment