Gst and Tax Expert


GSTR2A CSV format definition

4  Table Name: From Registered Taxable Persons including supplies received from unregistered person in case of reverse charge

Table Code: b2b

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN/UID   GSTIN/UID of the Receiver taxpayer/UN, Govt Bodies
2 cfs Y counter party Filing Status
3 dtcancel Date of cancellation of supplier
4 cfs3b GSTR3B filing status
5 fldtr1 Date of filing GSTR1/5 of supplier
6 flprdr1 Filing period of GSTR1/5 of supplier
7 inum Number Invoice
8 idt Date
9 val Value
10 pos Place of supply  
11 rchrg Reverse Charge Y/N
12 diff_percent Differential Percentage
13 aspd Return period in which invoice is amended
14 atyp flag to determine type of amendment R- Receiver GSTIN Amended N- Invoice Number Amended D- Details Amended
15 srctyp Source Type of IRN
16 irn IRN number
17 irngendate IRN generation Date
18 inv_typ flag to determine invoice type R- Regular B2B Invoices DE – Deemed Exports SEWP – SEZ Exports with payment SEWOP – SEZ exports without payment.
19 itm_det Item Details ITEM
20 num item number
21 rt Tax Rate  
22 txval Taxable value of Goods or Service as per invoice  
23 iamt Amount   IGST
24 camt Amount   CGST
25 samt Amount   SGST
26 csamt Amount   CESS

5  Table Name: From Registered Taxable Persons including supplies received from unregistered person in case of reverse charge

Table Code: b2ba

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN/UID   GSTIN/UID of the Receiver taxpayer/UN, Govt Bodies
2 cfs Y counter party Filing Status
3 dtcancel Date of cancellation of supplier
4 cfs3b GSTR3B filing status
5 fldtr1 Date of filing GSTR1/5 of supplier
6 flprdr1 Filing period of GSTR1/5 of supplier
7 oinum Original invoice no Invoice
8 oidt Original date
9 inum Number
10 idt Date
11 val Value
12 pos Place of supply  
13 rchrg Reverse Charge Y/N
14 inv_typ flag to determine invoice type
15 diff_percent Differential Percentage
16 aspd Return period in which original invoice is visible
17 atyp flag to determine type of amendment R- Receiver GSTIN Amended N- Invoice Number Amended D- Details Amended
18 itm_det Item Details ITEM
19 num item number
20 txval Taxable value of Goods or Service as per invoice  
21 rt Rate  
22 iamt Amount   IGST
23 camt Amount   CGST
24 samt Amount   SGST
25 csamt Amount   CESS

6  Table Name: Details of Credit/Debit Notes

Table Code: cdn

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   Counter party GSTIN
2 cfs   Y counter party Filing Status
3 dtcancel Date of cancellation of supplier
4 cfs3b GSTR3B filing status
5 fldtr1 Date of filing GSTR1/5 of supplier
6 flprdr1 Filing period of GSTR1/5 of supplier
7 ntty Note type C/D  
8 chksum Invoice Check sum value
9 nt_num Number Debit/Credit Note number
10 nt_dt Date Credit date
11 inum Number INVOICE
12 idt Date
13 diff_percent Differential Percentage
14 p_gst Reason for Issuing Dr./ Cr. Notes
15 val Note Value
16 updby Invoice Uploader S/R
17 itms Items
18 cflag Supplier action flag A-Accepted ,R-Rejected,N-No action ,U-Uploaded, P-Pending
19 pos Place of supply  
20 rchrg Reverse Charge Y/N
21 d_flag delink flag Y
22 inv_typ Invoice type (R/SEWP/SEWOP/DE/CBW)
23 aspd Return period in which invoice is amended
24 atyp flag to determine type of amendment
25 srctyp Source Type of IRN
26 irn IRN number
27 irngendate IRN generation Date
28 itm_det Item Details   ITEMS
29 num Item Number  
30 txval Taxable value of Goods or Service as per invoice  
31 rt tax rate  
32 iamt Amount   IGST
33 camt Amount   CGST
34 samt Amount   SGST
35 csamt Amount   CESS

7  Table Name: Details of Credit/Debit Notes

Table Code: cdna

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   Counter party GSTIN
2 cfs   Y counter party Filing Status
3 dtcancel Date of cancellation of supplier
4 cfs3b GSTR3B filing status
5 fldtr1 Date of filing GSTR1/5 of supplier
6 flprdr1 Filing period of GSTR1/5 of supplier
7 ntty Note type C/D  
8 chksum Invoice Check sum value
9 nt_num Number Debit/Credit Note number
10 nt_dt Date Credit date
11 inum Number INVOICE
12 idt Date
13 diff_percent Differential Percentage
14 p_gst Reason for Issuing Dr./ Cr. Notes
15 val Note Value
16 ont_num Original Debit/Credit Note number
17 ont_dt Original Debit/Credit Note date
18 itms Items
19 pos Place of supply  
20 rchrg Reverse Charge Y/N
21 d_flag delink flag Y
22 inv_typ Invoice type (R/SEWP/SEWOP/DE/CBW)
23 aspd Return period in which invoice is amended
24 atyp flag to determine type of amendment
25 itm_det Item Details   ITEMS
26 num Item Number  
27 txval Taxable value of Goods or Service as per invoice  
28 rt tax rate  
29 iamt Amount   IGST
30 camt Amount   CGST
31 samt Amount   SGST
32 csamt Amount   CESS

8  Table Name: Overseas imports Bill of entry details

Table Code: IMPG

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 refdt Reference Date of the Bill of Entry
2 portcd Port Code C/D  
3 benum Bill of Entry Number Debit/Credit Note number
4 bedt Date when Bill of Entry was created Credit date
5 txval Taxable value of the imported goods
6 iamt IGST amount for the imported goods IGST
7 csamt Cess Amount foe the imported goods CESS
8 amd Flag to indicate that Bill of entry is Amended

9  Table Name: Overseas imports Bill of entry details

Table Code: IMPGSEZ

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 sgstin GSTN of the SEZ supplier
2 tdname Trade name of the supplier
3 refdt Reference Date of the Bill of Entry
4 portcd Port Code C/D  
5 benum Bill of Entry Number Debit/Credit Note number
6 bedt Date when Bill of Entry was created Credit date
7 txval Taxable value of the imported goods
8 iamt IGST amount for the imported goods IGST
9 csamt Cess Amount foe the imported goods CESS
10 amd Flag to indicate that Bill of entry is Amended

10  Table Name: ISD Response

Table Code: ISD

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN/UID of the ISD taxpayer
2 cfs GSTR6 Filing Status Y/N
3 doclist isd doc details Doc
4 chksum Invoice Check sum value
5 docnum Document Number
6 docdt Document Date
7 isd_docty Document Type ISD/ISDCN
8 itc_elg ITC eligible
9 iamt IGST Amount as ISD IGST
10 camt CGST Amount asISD CGST
11 samt SGST Amount as ISD SGST
12 cess CESS Amount as ISD CESS
13 aspd For ISD-Return period in which invoice is amended For ISDA- Original Period in which Reported
14 atyp flag to determine type of amendment R- Receiver GSTIN Amended N- Invoice/Note Number Amended D- Details Amended

11  Table Name : TCS Credit Response

Table Code: TCS

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 chksum Invoice Check sum value
2 etin GSTIN of E-commerce Portal
3 m_id Merchant ID allocated by e-commerce portal
4 sup_val Gross Value of Supplies
5 tx_val Taxable Value on which TCS has been deducted
6 irt Rate TCS_IGST
7 iamt Amount TCS_IGST
8 crt Rate TCS_CGST
9 camt Amount TCS_CGST
10 srt Rate TCS_SGST
11 samt Amount TCS_SGST
12 csrt Rate TCS_Cess
13 csamt Amount TCS_Cess

12  Table Name : TDS Response

Table Code: TDS

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 gstin_ded gstin of the deductee  
2 amt_ded Amount deducted
3 iamt Integrated tax amount
4 camt Central tax amount  
5 samt State tax amount

13 Table Name : AMDHIST Response

Table Code: AMDHIST

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 gstin GSTIN of he taxpayer  
2 portcd Port Code
3 benum Bill of Entry Number
4 bedt Date when Bill of Entry was created
5 amddtl List of overseas amended import data history
6 sgstin GSTN of the SEZ supplier
7 tdname Trade name of the supplier
8 refdt Reference Date of the Bill of Entry
9 txval Taxable value of the imported goods CESS
10 iamt IGST amount for the imported goods IGST
11 csamt Cess Amount foe the imported goods Cess