Gst and Tax Expert


GSTR4 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 inv_typ Invoice Type
5 idt Supplier Invoice Date
6 val Supplier Invoice Value  
7 pos Place of supply
8 updby Uploaded by R/S (supplier, reciever)
9 chksum Invoice Check sum value
10 rchrg Reverse Charge Y/N
11 cflag Counter Party Flag A-Accepted ,R-Rejected, M-Modified,N-No action, P-Pending
12 opd Original Period
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

5  Table Name: B2BA Documents

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 inv_typ Invoice Type
6 idt Supplier Invoice Date
7 oidt Original Invoice Date
8 val Supplier Invoice Value  
9 pos Place of supply
10 chksum Invoice Check sum value
11 rchrg Reverse Charge Y/N
12 sply_ty Supply type
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: B2BUR Invoice Data

Table Code: b2bur

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 inum Number Invoice
2 idt Supplier Invoice Date
3 sply_ty Supply Type
4 val Supplier Invoice Value  
5 pos Place of supply
6 chksum Invoice Check sum value
7 item_det Items ITEM
8 num Serial no
9 rt Tax Rate  
10 txval Taxable value of Goods or Service as per invoice  
11 iamt Amount   IGST
12 camt Amount   CGST
13 samt Amount   SGST
14 csamt Amount   CESS

7  Table Name: B2BURA Invoice Data

Table Code: b2bura

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 oinum Number Invoice
2 inum Number
3 oidt Original Invoice Date
4 idt Invoice Date
5 sply_ty Supply Type
6 val Invoice Value  
7 pos Place of supply
8 chksum Invoice Check sum value
9 item_det Items ITEM
10 num Serial no
11 rt Tax Rate  
12 txval Taxable value of Goods or Service as per invoice  
13 iamt Amount   IGST
14 camt Amount   CGST
15 samt Amount   SGST
16 csamt Amount   CESS

8  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 cfs counter party Filing Status
3 nt Credit Debit Note details Invoice
4 nt_num Credit note/debit note / Refund Voucher Number
5 ntty Credit/debit note type/ Refund Voucher
6 nt_dt Credit Note/Debit Note/ Refund Voucher date
7 inum Invoice Number
8 idt Invoice Date  
9 updby Invoice Uploader S/ R
10 sply_ty Nature of Supply(INTER / INTRA) INTRA
11 cflag Supplier action flag A-Accepted ,R-Rejected, M-Modified,N-No action , P-Pending
12 opd Original period
13 val Note Value
14 rchrg Reverse Charge Y/N
15 chksum Invoice Check sum value
16 itm_det Item Details ITEM
17 num item number ITEM
18 rt Tax Rate  
19 txval Taxable value of Goods or Service as per invoice  
20 igst Amount   IGST
21 cgst Amount   CGST
22 sgst Amount   SGST
23 cess Amount   CESS

9  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 p_gst Pre GST Regime Dr./ Cr. Notes
12 val Total Note Value
13 pos Place of supply
14 inv_typ Invoice type
15 d_flag delink flag
16 rchrg Reverse Charge Y/N
17 chksum Invoice Check sum value
18 itm_det Item Details ITEM
19 num item number ITEM
20 rt Tax Rate  
21 txval Taxable value of Goods or Service as per invoice  
22 igst Amount   IGST
23 cgst Amount   CGST
24 sgst Amount   SGST
25 cess Amount   CESS

10  Table Name: CDN Unregistered Response Data

Table Code: cdnur

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ntty Credit/debit note type/ Refund Voucher Invoice
2 nt_num Credit note/debit note / Refund Voucher Number
3 nt_dt Credit Note/Debit Note/ Refund Voucher date
4 idt Invoice Date
5 inum Invoice Number
6 val Invoice Value  
7 typ Invoice Type
8 sply_ty Nature of Supply(INTER / INTRA)
9 chksum Invoice Check sum value
10 item_det Items ITEM
11 num Serial no
12 rt Tax Rate  
13 txval Taxable value of Goods or Service as per invoice  
14 iamt Amount   IGST
15 camt Amount   CGST
16 samt Amount   SGST
17 csamt Amount   CESS

11  Table Name: CDNURA Data

Table Code: cdnura

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ntty Credit/debit note type/ Refund Voucher Invoice
2 nt_num Credit note/debit note / Refund Voucher Number
3 ont_num Original Credit note/debit note / Refund Voucher Number
4 ont_dt Original Credit Note/Debit Note/ Refund Voucher date
5 nt_dt Credit Note/Debit Note/ Refund Voucher date
6 idt Invoice Date
7 inum Invoice Number
8 val Invoice Value  
9 typ Invoice Type
10 sply_ty Nature of Supply(INTER / INTRA)
11 chksum Invoice Check sum value
12 item_det Items ITEM
13 num Serial no
14 rt Tax Rate  
15 txval Taxable value of Goods or Service as per invoice  
16 iamt Amount   IGST
17 camt Amount   CGST
18 samt Amount   SGST
19 csamt Amount   CESS

12  Table Name: IMPS Invoices

Table Code: IMPS

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 inum Invoice No. Invoice
2 idt Invoice Date
3 val Invoice Value  
4 pos Point of sale
5 sply_ty Nature of Supply(INTER / INTRA)
6 chksum Invoice Check sum value
7 item_det Items ITEM
8 num Serial no
9 rt Tax Rate  
10 txval Taxable value of Goods or Service as per invoice  
11 iamt Amount   IGST
12 csamt Amount   CESS

13  Table Name : IMPSA Data

Table Code: IMPSA

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 inum Invoice Number Invoice
2 oinum Original Invoice Number
3 oidt Original Invoice Date
4 idt Invoice Date
5 val Invoice Value  
6 pos Place of supply
7 sply_ty Nature of Supply(INTER / INTRA)
8 chksum Invoice Check sum value
9 item_det Items ITEM
10 num Serial no
11 rt Tax Rate  
12 txval Taxable value of Goods or Service as per invoice  
13 iamt Amount   IGST
14 csamt Amount   CESS