File Format for Form 24G version 1.

0
General Notes -
1 File should be generated in ASCII Format with "txt" as filename extension.
2 Each Record (including last record) must start on new line and must end with a newline characte
3 All
Theamount
constantfields
values as mentioned
should in the file
have a decimal format
value withbelow (values
precision of 2.of fields viz.portion
Fractional 'RecordisType', 'Up
not allow
etc.) need
should
4 This ^to be decimal
is acontain mentioned
delimited Infield
point
variable BLOCK
followed
widthletters
twoonly.
byfile. i.e.
e.gvalue
zeromeans
This thatofinfield
1000.00 case'Record Type'
of empty in case
spaces ofis'File
there no Hn
5 in
provide leading '0'
the respective for numerals
record. and trailing
For example the totalspaces
numberforof
character
fields infields.
"File Header record" is 14, henc
6 of delimiters in 'File Header record' would be 13.
7 The 'AO' stands for 'PAY & Accounts Office'/DTO and 'DDO' stands for 'Drawing & Disburseme

File Header Record

Mandat
Data ory (M)/
Field Field Optiona
Sr. No Name Type Length l (O)
1 Line INTEGE 9 M
Number R

2 Record CHAR 2 M
Type

3 File CHAR 4 M
Type
4 File DATE 8 M
Creation
Date

5 Type of CHAR 1 M
Stateme
nt

6 Uploade CHAR 1 M
d By

7 Account CHAR 7 M
s Office
Identific
ation
No.
(AIN)
 8 Number INTEGE 9 M
of R
Batches

9 FH NA NA NA
Record
Hash

10 FVU NA NA NA
Version

11 FVU NA NA NA
File
Level
Hash

12 SAM NA NA NA
Version

13 SAM NA NA NA
File
Level
Hash
 14 SCM NA NA NA
Version

15 SCM NA NA NA
File
Level
Hash

Batch Header Record

Sr. No Field Data Field
Name Type Length
Mandat
ory (M)/
Optiona
l (O)
1 Line INTEGE 9 M
Number R

2 Record CHAR 2 M
Type

3 Batch INTEGE 9 M
Number R
4 Transact NA NA NA
ion
Type

5 Account CHAR 7 M
s Office
Identific
ation
No.
(AIN)

6 Last NA NA NA
Account
s Office
Identific
ation
No.
(AIN)
7 AO_Na CHAR 75 M
me

8 AO_Ad CHAR 25 M
dress
Line 1

9 AO_Ad CHAR 25 O
dress
Line 2

10 AO_Ad CHAR 25 O
dress
Line 3

11 AO_Ad CHAR 25 O
dress
Line 4

12 AO_Cit CHAR 25 M
y
13 AO_Stat CHAR 2 M
e

14 AO_PIN CHAR 6 M
15 STD CHAR 5 M
Code

16 Phone CHAR 10 M
No.
17 Email CHAR 75 M
ID

18 Respons CHAR 75 M
ible
Person
Name
19 Respons CHAR 25 M
ible
Person
Designa
tion

20 Financia CHAR 4 M
l Year
21 Last NA NA NA
Financia
l Year

22 AO CHAR 2 M
Categor
y

23 Last AO NA NA NA
Categor
y

24 Filler 1 NA NA NA

25 Filler 2 NA NA NA
26 Filler 3 NA NA NA

27 Filler 4 NA NA NA

28 No. of INTEGE 9 M
Transact R
ions
29 Total DECIM 15,2 M
TDS/T AL
CS
amount
reported
(Sum of
BAS_TA
X, SUR,
EDU_C
ESS)

30 Original NA NA NA
RRR
No.

31 Previou NA NA NA
s RRR
No.
32 Provisio NA NA NA
nal
Receipt
Number

33 Provisio NA NA NA
nal
Receipt
Date

34 Month INTEGE 2 M
of R
Transfer
voucher
35 Respons CHAR 25 M
ible
person
Address
Line 1

36 Respons CHAR 25 O
ible
person
Address
Line 2

37 Respons CHAR 25 O
ible
person
Address
Line 3

38 Respons CHAR 25 O
ible
person
Address
Line 4

39 Respons CHAR 25 M
ible
person_
City
40 Respons CHAR 2 M
ible
person_
State

41 Respons CHAR 6 M
ible
person_
PIN

42 Respons CHAR 5 O
ible
person
STD
Code
43 Respons CHAR 10 O
ible
person
Phone
No.

44 Respons CHAR 75 M
ible
person
E-mail
id
45 Mobile INTEGE 10 O
no. of R
Respons
ible
person

46 Filer 5 NA NA NA

47 State CHAR 2 O
name
48 Ministry CHAR 3 O
/
Depart
ment
name
49 Sub CHAR 3 O
Ministry
name
50 Sub CHAR 150 O
Ministry
name
(Others)

51 Count INTEGE 9 M
of 24Q R
transacti
on
52 Control DECIM 15 M
total of AL
tax
deducte
d/collec
ted
(Sum of
BAS_TA
X, SUR,
EDU_C
ESS) for
24Q
53 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA)
for 24Q
54 Count INTEGE 9 M
of 26Q R
transacti
on
55 Control DECIM 15 M
total of AL
tax
deducte
d/collec
ted
(Sum of
BAS_TA
X, SUR,
EDU_C
ESS) for
26Q
56 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA)
for 26Q
57 Count INTEGE 9 M
of 27Q R
transacti
on
58 Control DECIM 15 M
total of AL
tax
deducte
d/collec
ted
(Sum of
BAS_TA
X, SUR,
EDU_C
ESS) for
27Q
59 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA)
for 27Q
60 Count INTEGE 9 M
of 27EQ R
transacti
on
61 Control DECIM 15 M
total of AL
tax
deducte
d/collec
ted
(Sum of
BAS_TA
X, SUR,
EDU_C
ESS) for
27EQ
62 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA)
for
27EQ

63 PAO INTEGE 7 O
registrat R
ion no.
64 Count INTEGE 9 M
of R
Distinct
DDOs
65 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA)

66 Count INTEGE 9 M
of DDO R
records
added
67 Count INTEGE 9 M
of DDO R
records
updated

68 Count INTEGE 9 M
of DDO R
records
deleted

69 Receipt NA NA NA
no.

70 Batch NA NA NA
Header
Record
Hash

DDO Transaction Detail Record

Sr. No Field Data Field
Name Type Length
Mandat
ory (M)/
Optiona
l (O)
1 Line INTEGE 9 M
Number R

2 Record CHAR 2 M
Type

3 Batch INTEGE 9 M
Number R

4 Revisio NA NA NA
n Mode
5 Serial INTEGE 9 M
No. R

6 Filler 6 NA NA NA

7 TAN of CHAR 10 M
the
DDO
8 Name of CHAR 75 M
the
DDO

9 DDO_A CHAR 25 M
ddress
Line 1

10 DDO_A CHAR 25 O
ddress
Line 2

11 DDO_A CHAR 25 O
ddress
Line 3

12 DDO_A CHAR 25 O
ddress
Line 4

13 DDO_Ci CHAR 25 M
ty
14 DDO_St CHAR 2 M
ate

15 DDO_A CHAR 6 M
ddress
PIN
16 TDS/T DECIM 15 M
CS AL
deducte
d
Amount
(in `)

17 Filler 7 NA NA NA
18 DDO CHAR 10 O
registrat
ion no.
(provide
d by
central
record
keeping
agency)
19 DDO CHAR 20 O
code

20 E-mail CHAR 75 O
ID of
DDO
21 Total DECIM 15 M
TDS/T AL
CS
remitted
to
Govern
ment
account
(AG/Pr
CCA) (`)
22 Nature CHAR 4 M
of
deducti
on

23 DDO CHAR 1 O
Mappin
g/
update

24 DDO NA NA NA
serial
no.

25 Filler 8 NA NA NA
26 Filler 9 NA NA NA

27 Filler 10 NA NA NA

28 Filler 11 NA NA NA

29 Filler 12 NA NA NA

30 Filler 13 NA NA NA
31 Filler 14 NA NA NA

32 Filler 14 NA NA NA

33 Transact NA NA NA
ion
Detail
Record
Hash
 e Format for Form 24G version 1.0

n ASCII Format with "txt" as filename extension.

st record) must start on new line and must end with a newline character.
ntioned
have in the file
a decimal format
value withbelow (values
precision of 2.of fields viz.portion
Fractional 'RecordisType', 'Upload
not allowed, Type'
the value
Infield
int
ble BLOCK
followed
widthletters
twoonly.
byfile. i.e.
e.gvalue
zeromeans
This thatofinfield
1000.00 case'Record Type'
of empty in case
spaces ofis'File
there no Header'
need to should
merals and trailing
or example the totalspaces
numberforof
character
fields infields.
"File Header record" is 14, hence the total no.
er record' would be 13.
& Accounts Office'/DTO and 'DDO' stands for 'Drawing & Disbursement Officer'

File Header Record

Remarks
Running sequence number for each line in the file.

Value should be "FH" signifying "File Header" record.

Value should be "24G".

Date should be in DDMMYYYY format
It should not be future date.

Value should be "O" (Original).

Value should be "D".

Indicates the AIN allotted to the Accounts Office. Value should be 7 digit
Indicates the number of batches that the file contains. Value must always be
1.

No value should be specified.

No value should be specified.

No value should be specified.

No value should be specified.

No value should be specified.

No value should be specified.

No value should be specified.

Batch Header Record

Remarks

Running sequence number for each line in the statement

Value should be "BH" signifying the Batch Header Record.

Value should always be 1.

No value should be specified. For future use

Value should be same as AIN allotted to the Accounts Office. Must be same
as mentioned in Field No. 7 of File Header (FH).

No value should be specified. For future use

Mention Name of Accounts Office.
Example: 'PAO, Chief Labour Commissioner'

Mention address of AO

Mention address of AO

Mention address of AO

Mention address of AO

Mention City/District of AO
Mention numeric code for State/UT of AO office. For list of state code refer
Annexure 1.

Mention PIN Code of AO

Value must be >= 110001.
Value should not be equal to 000000 & 999999
Mention STD Code of AO.
In case mobile no. is mentioned, then STD Code should be '91'.

Mention Phone Number. Only Numeric values allowed.

Mention Email ID. 1. @ and '.'
should be mentioned.
2. Both @ and '.' should be preceded and succeeded by atleast one character.
3. At least one '.' should come after '@'.
4. All printable characters allowed except '^' and space.

Mention name of person responsible furnishing 24G statement.

Mention designation of person responsible, furnishing 24G statement.

Mention financial year for which Form 24G is submitted. Must be >= 2005.
E.g for Financial Year 2005-06 value should be 2005, for Financial Year 2006-
07 value should be 2006, etc. (value should be less than or equal to current
year)
No value should be specified. For future use

Mention DDO Category as per annexure 2

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

Mention Number of transactions (should be equal to total no. of DDO

records) pesent in the statement. Count should be >= 1
Mention the total tax deducted/collected. The value should be sum of
values in field "Tax Deducted/Collected (Sum of Bas_Tax,Sur, Edu_Cess)"
across all Transaction Detail (DDO) records of the statement. Value should
be in Decimal. Must be > = 0.00

No value should be specified. For future use

No value should be specified. For future use

No value should be specified.

No value should be specified.

Month in which tax has been paid to government through transfer voucher
should be provided.
Value should be between 1 to 12 and value should be less than or equal to
current month (Refer Annexure 7)
Mention address of Responsible person

Mention address of Responsible person

Mention address of Responsible person

Mention address of Responsible person

Mention City/District of AO
Numeric code for State/UT of AO office. For list of state code refer
Annexure 1.

PIN Code of Responsible person adress. Value must be >= 110001

STD Code for phone number should be of 5 digits

STD Code for mobile should be '91'.
Mention Phone Number. Only Numeric values allowed. Either Phone no.
or mobile no is mandatory.

Mention Email ID. 1. @ and '.'

should be mentioned.
2. Both @ and '.' should be preceded and succeeded by atleast one character.
3. At least one '.' should come after '@'.
4. All printable characters allowed except '^' and space.
10 digit mobile number of responsible person to be mentioned. Either
Phone no. or mobile no is mandatory.

No value should be specified. For future use

Numeric code of state should be provided for state government, refer

Annexure 1
Numeric code for Ministry name should be provided.
Refer Annexure 3 for list of Ministry name codes Mandatory for AO
category central government
Numeric code for sub ministry name should be provided.
Refer Annexure 4, for list of sub ministry name codes
Mandatory for AO category central government
If numeric code '99' (i.e. Other) is provided in Ministry Name field then
value in sub ministry name "Other" field should be provided

Total number of DDO transactions for Form 24Q.

If there are no transcation for Form 24Q, then value 0 should be provided in
the field
Total tax deducted/collected for Form 24Q.
Value should be sum of values in field "Tax Deducted/collected Amount"
across all Transaction Detail (DDO) records of the statement for Form 24Q.
Value should be in Decimal. Must be > = 0.00
Total amount of TDS/TCS remitted to Government account (AG/Pr. CCA)
for 24Q.
Value should be sum of values in field "Total TDS/TCS remitted to
Government account (AG/Pr CCA)" across all Transaction Detail (DDO)
records of the statement for 24Q. Value should be in Decimal. Must be > =
0.00
Total number of DDO transaction for Form 26Q.
If there are no transcations for Form 26Q, then value 0 should be provided
in the field.
Total tax deducted/collected for Form 26Q.
Value should be sum of values in field "Tax Deducted/collected Amount"
across all Transaction Detail (DDO) records of the statement for Form 26Q.
Value should be in Decimal. Must be > = 0.00
Total amount of TDS/TCS remitted to Government account (AG/Pr. CCA)
for 26Q.
Value should be sum of values in field "Total TDS/TCS remitted to
Government account (AG/Pr CCA)" across all Transaction Detail (DDO)
records of the statement for 26Q. Value should be in Decimal. Must be > =
0.00
Total number of DDO transaction for Form 27Q.
If there are no transcations for Form 27Q, then value 0 should be provided
in the field.
Total tax deducted/collected for Form 27Q.
Value should be sum of values in field "Tax Deducted/collected Amount"
across all Transaction Detail (DDO) records of the statement for Form 27Q.
Value should be in Decimal. Must be > = 0.00
Total amount of TDS/TCS remitted to Government account (AG/Pr. CCA)
for 27Q.
Value should be sum of values in field "Total TDS/TCS remitted to
Government account (AG/Pr CCA)" across all Transaction Detail (DDO)
records of the statement for 27Q. Value should be in Decimal. Must be > =
0.00
Total number of DDO transaction for Form 27EQ.
If there are no transcations for Form 27EQ, then value 0 should be provided
in the field.
Total tax deducted/collected for Form 27EQ.
Value should be sum of values in field "Tax Deducted/collected Amount"
across all Transaction Detail (DDO) records of the statement for Form
27EQ. Value should be in Decimal. Must be > = 0.00
Total amount of TDS/TCS remitted to Government account (AG/Pr. CCA)
for 27EQ.
Value should be sum of values in field "Total TDS/TCS remitted to
Government account (AG/Pr CCA)" across all Transaction Detail (DDO)
records of the statement for 27EQ. Value should be in Decimal. Must be > =
0.00

PAO registration no. allotted by the CRA system should be stated.

Number of distinct TANs pesent in the Transaction Detail (TD) across
nature of deduction. Count should be >= 1 (Count will be 0, if TAN of all
the DDOs is Invalid i.e. TANINVALID, TANNOTABVL or TANAPPLIED)
Total amount of tax deducted/collected to be provided. Value should be
sum of values in field "Total TDS/TCS remitted to Government account
(AG/Pr. CCA)" across all Transaction Detail (DDO) records of the
statement. Value should be in Decimal. Must be > = 0.00

Number of DDO records pesent in the AIN-DDO mapping with mode 'A'
in the file
 Number of DDO records pesent in the AIN-DDO mapping with mode 'U'
in the file

Number of DDO records pesent in the AIN-DDO mapping with mode 'D'
in the file

No value should be specified.

No value should be specified.

DDO Transaction Detail Record

 Remarks

Running sequence number for each line in the file.

Value should be 'TD' signifying the Transaction Detail (DDO) Record.

Value should be same as "Batch Number" field in "Batch Header" record.

No value should be specified. For future use

Serial no. should start with '1' and in increasing order.

No value should be specified. For future use

Mention TAN of DDO. Should be in Capital. If DDO TAN is not available

in that case allowed value is 'TANAPPLIED’, 'TANINVALID' and
‘TANNOTAVBL’.
Mention Name of DDO
example Asstt. Labour Commissioner

Mention Address of DDO

Mention Address of DDO

Mention Address of DDO

Mention Address of DDO

City/District of DDO.
Mention State/UT of DDO. Mention numeric code for the state as per
annexure 1

Pin Code of DDO. Value must be >= 110001

Provide total TDS/TCS amount (sum of TDS/TCS, education cess and
surcharge) under the head 'Nature of Deduction' for each DDO for each
month . Must be >= 0.00

No value should be specified. For future use

DDO registration number provided by Central Record Keeping Agency.
Mandatory to provide DDO registration no. or DDO code in case 10 digit
TAN is not provided.
DDO code should be provided. Mandatory to provide DDO registration no.
or DDO code in case 10 digit TAN is not provided.

Mention e-mail id of DDO

Provide total TDS/TCS amount (sum of TDS/TCS, education cess and
surcharge) remitted to Government account (AG/PR.CCA) under the head
'Nature of Deduction' for each DDO for each month . Value should be in
Decimal. Must be > = 0.00
Nature of Deduction / Collection. Mention values as per the annexure 5.
Values allowed are 24Q, 26Q, 27Q and 27EQ.

Value should be as per Annexure 6

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified. For future use

No value should be specified.