Gst and Tax Expert


GSTR6 CSV format definition

4  Table Name: B2B Invoices

Table Code: b2b

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN/UID of the Receiver taxpayer/UN, Govt Bodies   GSTIN of the Receiver
2 cfs GSTR2 filing status of counter party
3 inum Number Invoice
4 idt Supplier Invoice Date
5 val Supplier Invoice Value  
6 updby Uploaded by R/S (supplier, reciever)
7 chksum Invoice Check sum value
8 item_det Items ITEM
9 num Serial no
10 rt Tax Rate  
11 txval Taxable value of Goods or Service as per invoice  
12 iamt Amount   IGST
13 camt Amount   CGST
14 samt Amount   SGST
15 csamt Amount   CESS

5  Table Name: B2BA Invoices

Table Code: b2ba

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin Original Counter party GSTIN   GSTIN of the Receiver
2 cfs counterparty filing status
3 inum Number Invoice
4 oinum Original Invoice Number
5 idt Supplier Invoice Date
6 oidt Original Invoice Date
7 val Supplier Invoice Value  
8 pos Place of supply
9 chksum Invoice Check sum value
10 ostin Original Invoice
11 opd filing period of the original invoice Y
12 updby Invoice Uploader
13 item_det Items ITEM
14 num Serial no
15 rt Tax Rate  
16 txval Taxable value of Goods or Service as per invoice  
17 iamt Amount   IGST
18 camt Amount   CGST
19 samt Amount   SGST
20 csamt Amount   CESS

6  Table Name: CDNR Documents

Table Code: CDNR

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   Counter party GSTIN
2 nt Credit Debit Note details Invoice
3 nt_num Credit note/debit note / Refund Voucher Number
4 ntty Credit/debit note type/ Refund Voucher
5 nt_dt Credit Note/Debit Note/ Refund Voucher date
6 inum Invoice Number
7 idt Invoice Date  
8 updby credit/debit note Uploader S/ R
9 d_flag delink flag
10 pos Place Of Supply
11 flag flag for accepting or rejecting a invoice
12 chksum Invoice Check sum value
13 itm_det Item Details ITEM
14 num item number ITEM
15 rt Tax Rate  
16 txval Taxable value of Goods or Service as per invoice  
17 igst Amount   IGST
18 cgst Amount   CGST
19 sgst Amount   SGST
20 cess Amount   CESS

7  Table Name: CDNRA Documents

Table Code: CDNRA

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   Counter party GSTIN
2 cfs counter party Filing Status
3 nt Credit Debit Note details Invoice
4 nt_num Credit note/debit note / Refund Voucher Number
5 ont_num Original Credit note/debit note / Refund Voucher Number
6 ntty Credit/debit note type/ Refund Voucher
7 nt_dt Credit Note/Debit Note/ Refund Voucher date
8 ont_dt Original Credit Note/Debit Note/ Refund Voucher date
9 inum Invoice Number
10 idt Invoice Date  
11 opd filing period of the original invoice
12 d_flag delink flag Y
13 pos Place of supply
14 rsn reason
15 d_flag delink flag
16 flag flag for accepting or rejecting a invoice A-Accepted ,R-Rejected, M-Modified,N-No action ,U-Uploaded, P-Pending
17 chksum Invoice Check sum value
18 updby Invoice Uploader
19 itm_det Item Details ITEM
20 num item number ITEM
21 rt Tax Rate  
22 txval Taxable value of Goods or Service as per invoice  
23 igst Amount   IGST
24 cgst Amount   CGST
25 sgst Amount   SGST
26 cess Amount   CESS

8  Table Name: ISD Response

Table Code: ISD

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 typ Type of user registered/unregistered R/UR
2 cpty GSTIN/State code of the recipient unit
3 statecd State Code
4 doclst Document details
5 isd_docty ISD Document Type
6 chksum Invoice Check sum value  
7 docnum Inv Document Number
8 docdt Inv Document Date
9 crdnum Credit/Debit Document Number
10 crddt Credit/Debit Document Number Document Date
11 iamti Amount IGST used as IGST
12 iamts Amount   IGST used as SGST
13 iamtc Amount   IGST used as CGST
14 samts Amount   SGST used as SGST
15 samti Amount   SGST used as IGST
16 camti Amount   CGST used as IGST
17 camtc Amount   CGST used as CGST
18 csamt Amount   CESS Amount

9  Table Name: ISDA Response

Table Code: ISDA

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 typ Type of user registered/unregistered R/UR
2 cpty GSTIN/State code of the recipient unit
3 statecd State Code
4 rcpty Revised GSTIN/UID of the Supplier taxpayer/UN, Govt Bodies
5 rstatecd Revised State Code
6 doclst Document details
7 isd_docty ISD Document Type
8 chksum Invoice Check sum value  
9 rcrdnum Revised Credit/Debit Document Number
10 rcrddt Revised Credit/Debit Document Date
11 ocrdnum Original Credit/Debit Document Number
12 ocrddt Original Credit/Debit Document Date
13 odocnum Original Document Number
14 odocdt Original Document Date
15 rdocnum Revised Document Number
16 rdocdt Revised Document Date
17 iamti Amount IGST used as IGST
18 iamts Amount   IGST used as SGST
19 iamtc Amount   IGST used as CGST
20 samts Amount   SGST used as SGST
21 samti Amount   SGST used as IGST
22 camti Amount   CGST used as IGST
23 camtc Amount   CGST used as CGST
24 csamt Amount   CESS Amount
25 cpty GSTIN/UID of the Supplier taxpayer/UN, Govt Bodies  
26 statecd State Code  

10  Table Name: ┬áITC Details

Table Code: ITC

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 TotalItc
desAmount of eligible ITC
iamttax amount for igst
camttax amount for cgst
samttax amount for sgst
csamttax amount for cess
Total ITC available for distribution
2 InelgItc
desAmount of eligible ITC
iamttax amount for igst
camttax amount for cgst
samttax amount for sgst
csamttax amount for cess
Amount of ineligible ITC
3 ElgItc
desAmount of eligible ITC
iamttax amount for igst
camttax amount for cgst
samttax amount for sgst
csamttax amount for cess
Amount of eligible ITC

11  Table Name : latefee

Table Code: latefee

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 cLamt tax amount for cgst
2 sLamt tax amount for sgst
3 debitId debit number
4 foroffset
liab_idLiability Id - Required for offsetting late fee. After offset this parameter will not come
tran_cdTransaction Code- Required for offsetting late fee. After offset this parameter will not come
Offet params for offset