GSTR3B - Offset Liability GSTR3B data attributes.xlsx

	A	B	C	D	E
1	Offset Liability GSTR3B Request(data)
2	S No	JSON attribute	Description	Format	Sample Value
3	1	List{pdcash}	List of Paid Through Cash	Refer Tax Paid A Cash
4	2	pditc	List of Paid Through Credit	Refer Tax Paid A Credit
5	3	List{pdnls}	List of Paid Through NLS	Refer Tax Paid A NLS
6	4	List{nettaxpay}	Net tax pay details	Net Tax Pay
7		Tax Paid A(Paid by Cash)
8	1	liab_ldg_id	Liability Ledger ID		12313
9	2	trans_typ	Transaction type		30002/30003
10	3	ipd	Igst paid	Decimal(15,2)	10002.00
11	4	cpd	Cgst paid	Decimal(15,2)	100.00
12	5	spd	Sgst paid	Decimal(15,2)	789.00
13	6	cspd	Cess paid	Decimal(15,2)	524.00
14	7	i_intrpd	Interest Paid against IGST	Decimal(15,2)	524.00
15	8	c_intrpd	Interest Paid against CGST	Decimal(15,2)	524.00
16	9	s_intrpd	Interest Paid against SGST	Decimal(15,2)	524.00
17	10	cs_intrpd	Interest Paid against CESS	Decimal(15,2)	524.00
18	12	c_lfeepd	Late Fee Paid against CGST	Decimal(15,2)	524.00
19	13	s_lfeepd	Late Fee Paid against SGST	Decimal(15,2)	524.00
20
21
22		Tax Paid A(Paid by Credit- ITC)
23	1	i_pdi	IGST paid using igst	Decimal(15,2)	100.00
24	2	i_pdc	IGST paid using Cgst	Decimal(15,2)	2003.00
25	3	i_pds	IGST paid using Sgst	Decimal(15,2)	789.12
26	4	c_pdi	CGST paid using igst	Decimal(15,2)	415.00
27	5	c_pdc	CGST paid using cgst	Decimal(15,2)	124.00
28	6	s_pdi	SGST paid using igst	Decimal(15,2)	45.00
29	7	s_pds	SGST paid using sgst	Decimal(15,2)	147.00
30	8	cs_pdcs	Cess paid using cess	Decimal(15,2)	58.00
31				Interest offset details
32		Tax Paid A(Paid by NLS)
33	1	liab_ldg_id	Liability Ledger ID	Interest offset details	12313
34	2	trans_typ	Transaction Type		30002/30003
35	3	ipd	Igst paid	Decimal(15,2)	10002.00
36	4	spd	Sgst paid	Decimal(15,2)	100.00
37	5	cpd	Cgst paid	Decimal(15,2)	789.00
38	6	cspd	Cess paid	Decimal(15,2)	524.00
39		Net Tax Pay
40	1	trans_typ	transaction type		30002/30003
41	2	liab_ldg_id	Liability ledger Id		121342
42	3	trans_desc	transaction description		Liability arising due to mismatch of ITC (reversal)
43	4	sgst	SGST details	Details 4
44	5	igst	IGST details	Details5
45	6	cgst	CGST details	Details4
46	7	cess	CESS details	Details5
47	Details 4
48	1	intr	Interest payable	Decimal(15,2)	1000.00
49	2	tx	Tax Payable	Decimal(15,2)	900.00
50	3	fee	Fee payable	Decimal(15,2)	800.00
51	Details 5
52	1	intr	Interest payable	Decimal(15,2)	1000.00
53	2	tx	Tax Payable	Decimal(15,2)	900.00
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100