GSTR-1 ATA - Entity - Google Sheets

	A	B	C	D	E	F
1	S No	Parameter Name	Description	Field Specifications	Sample Value
2	1	List{ata}	ATA Invoices	Refer A 1.1
3
4	A 1.1 ATA Invoices
5	S No	Parameter Name	Description	Field Specifications	Sample Value
6	1	flag	Invoice Status	One Character(N)	N-No action
7	2	chksum	Invoice chksum value	String(Max length:64)	INVOICECHECKSUMVALUE
8	3	omon	Original Month	String(MMYYYY)	032017
9	4	pos	Original Place of Supply	String(Max length:2)	04
10	5	sply_ty	Original Supply Type	String (Length - 5)	INTER / INTRA
11	6	diff_percent	Differential percentage	Decimal (3,2)	.65 (65%)	If the attribute is present then the value should be only 0.65
12	7	List {itms}	Item Details	Refer A 1.1.2
13
14	A 1.1.2 Item Details
15	S No	Parameter Name	Description	Field Specifications	Sample Value
16	1	rt	Rate of Invoice	Decimal(3, 2)	10.00
17	2	ad_amt	Advance received	Decimal(11, 2)	10001.00
18	3	camt	CGST Rate as per invoice	Decimal(11, 2)	650.00
19	4	samt	SGST Rate as per invoice	Decimal(11, 2)	650.00
20	5	csamt	Cess Rate as per invoice	Decimal(11, 2)	650.00
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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