post https://api.sandbox.co.in/tds-reporting/deductors//tdsrs//async
API to prepare TDS return by generating TXT file
Important Links
PUT Request on Presigned URL
Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More
Sample Payload
{
"name": "Form 24Q",
"sheets": [
{
"name": "Payer",
"blocks": [
{
"name": "Payer",
"@entity": "list",
"items": [
[
"name",
"Acme Pvt Ltd"
],
[
"tan",
"AHMA09719B"
],
[
"pan",
"AAACA1234Z"
],
[
"branch",
"HQ"
],
[
"gstin",
"24AAACA1234Z1ZP"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380015"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
},
{
"name": "Responsible Person",
"@entity": "list",
"items": [
[
"designation",
"FINANCE MANAGER"
],
[
"name",
"TONY STARK"
],
[
"pan",
"DKLPT3483J"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380015"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
}
]
},
{
"name": "Payee",
"blocks": [
{
"name": "Payee",
"@entity": "table",
"header": [
"sr_no",
"pan",
"name",
"opting_new_regime",
"employee_category"
],
"rows": [
[
1,
"XXXPX5678A",
"BRUCE",
true,
"Senior Citizen"
],
[
2,
"XXXPX7643A",
"TOM",
false,
"Senior Citizen"
],
[
3,
"XXXPX4958A",
"SHAWN",
false,
"Senior Citizen"
],
[
4,
"XXXPX2345A",
"JOHN",
true,
"General"
],
[
5,
"XXXPX3456A",
"TONY",
false,
"General"
],
[
6,
"XXXPX4567A",
"XAVIER",
false,
"General"
]
]
}
]
},
{
"name": "Challan",
"blocks": [
{
"name": "Challan",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1702622887000,
"(200) TDS Payable by Tax Payer",
100000,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "Payment",
"blocks": [
{
"name": "Payment",
"@entity": "table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"section",
"credit_amount",
"credit_date",
"tds_amount",
"surcharge",
"education_cess",
"deduction_date",
"reason_for_lower_deduction",
"certificate_number"
],
"rows": [
[
1,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
40000.00,
1702536487000,
4000.00,
0,
0,
1702536487000
],
[
2,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
50000.00,
1702536487000,
7500.00,
0,
0,
1702536487000
],
[
3,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
60000.00,
1702536487000,
12000.00,
0,
0,
1702536487000
],
[
4,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
70000.00,
1702536487000,
17500.00,
0,
0,
1702536487000
],
[
5,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
80000.00,
1702536487000,
24000.00,
0,
0,
1702536487000
],
[
6,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
90000.00,
1702536487000,
31500.00,
0,
0,
1702536487000
]
]
}
]
}
]
}
{
"name": "Form 24Q",
"sheets": [
{
"name": "Payer",
"blocks": [
{
"name": "Payer",
"@entity": "list",
"items": [
[
"name",
"Acme Pvt Ltd"
],
[
"tan",
"AHMA09719B"
],
[
"pan",
"AAACA1234Z"
],
[
"branch",
"HQ"
],
[
"gstin",
"24AAACA1234Z1ZP"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380015"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
},
{
"name": "Responsible Person",
"@entity": "list",
"items": [
[
"designation",
"FINANCE MANAGER"
],
[
"name",
"TONY STARK"
],
[
"pan",
"DKLPT3483J"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380015"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
}
]
},
{
"name": "Payee",
"blocks": [
{
"name": "Payee",
"@entity": "table",
"header": [
"sr_no",
"pan",
"name",
"opting_new_regime",
"employee_category"
],
"rows": [
[
1,
"XXXPX5678A",
"BRUCE",
true,
"Senior Citizen"
],
[
2,
"XXXPX7643A",
"TOM",
false,
"Senior Citizen"
],
[
3,
"XXXPX4958A",
"SHAWN",
false,
"Senior Citizen"
],
[
4,
"XXXPX2345A",
"JOHN",
true,
"General"
],
[
5,
"XXXPX3456A",
"TONY",
false,
"General"
],
[
6,
"XXXPX4567A",
"XAVIER",
false,
"General"
]
]
}
]
},
{
"name": "Challan",
"blocks": [
{
"name": "Challan",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1679356800000,
"(200) TDS Payable by Tax Payer",
100000,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "Payment",
"blocks": [
{
"name": "Payment",
"@entity": "table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"section",
"credit_amount",
"credit_date",
"tds_amount",
"surcharge",
"education_cess",
"deduction_date",
"reason_for_lower_deduction",
"certificate_number"
],
"rows": [
[
1,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
40000.00,
1680220800000,
4000.00,
0,
0,
1680220800000
],
[
2,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
50000.00,
1680220800000,
7500.00,
0,
0,
1680220800000
],
[
3,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
60000.00,
1680220800000,
12000.00,
0,
0,
1680220800000
],
[
4,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
70000.00,
1680220800000,
17500.00,
0,
0,
1680220800000
],
[
5,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
80000.00,
1680220800000,
24000.00,
0,
0,
1680220800000
],
[
6,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
90000.00,
1680220800000,
31500.00,
0,
0,
1680220800000
]
]
}
]
},
{
"name": "Salary details",
"blocks": [
{
"name": "Salary details",
"@entity": "table",
"header": [
"payee_sr_no",
"employment_from_date",
"employment_to_date",
"gross_salary_from_previous employer",
"tds_by_previous_employer",
"income_tax_payable",
"surcharge",
"cess",
"tds_on_salary",
"basic_salary",
"perquisites",
"profit",
"travel allowance",
"retirement_gratuity",
"commuted pension",
"leave_encashment",
"house_rent_allowance",
"landlord_1_name",
"landlord_1_pan",
"landlord_2_name",
"landlord_2_pan",
"landlord_3_name",
"landlord_3_pan",
"landlord_4_name",
"landlord_4_pan",
"other_allowance",
"standard_deduction",
"entertainment_allowance",
"professional_tax",
"total_house_property_income",
"lender_1_name",
"lender_1_pan",
"lender_2_name",
"lender_2_pan",
"lender_3_name",
"lender_3_pan",
"lender_4_name",
"lender_4_pan",
"total_other_income",
"gross_amount_us_80c",
"deductible_amount_us_80c",
"gross_amount_us_80ccc",
"deductible_amount_us_80ccc",
"gross_amount_us_80ccd1",
"deductible_amount_us_80ccd1",
"gross_amount_us_80ccd1b",
"deductible_amount_us_80ccd1b",
"gross_amount_us_80ccd2",
"deductible_amount_us_80ccd2",
"gross_amount_us_80ccg",
"deductible_amount_us_80ccg",
"gross_amount_us_80d",
"deductible_amount_us_80d",
"gross_amount_us_80dd",
"deductible_amount_us_80dd",
"qualifying_amount_us_80dd",
"gross_amount_us_80e",
"deductible_amount_us_80e",
"gross_amount_us_80ee",
"deductible_amount_us_80ee",
"qualifying_amount_us_80ee",
"gross_amount_us_80eea",
"deductible_amount_us_80eea",
"qualifying_amount_us_80eea",
"gross_amount_us_80g",
"deductible_amount_us_80g",
"qualifying_amount_us_80g",
"gross_amount_us_80gg",
"deductible_amount_us_80gg",
"qualifying_amount_us_80gg",
"gross_amount_us_80ggc",
"deductible_amount_us_80ggc",
"qualifying_amount_us_80ggc",
"gross_amount_us_80tta",
"deductible_amount_us_80tta",
"qualifying_amount_us_80tta",
"gross_amount_us_80ttb",
"deductible_amount_us_80ttb",
"qualifying_amount_us_80ttb",
"gross_amount_us_80u",
"deductible_amount_us_80u",
"qualifying_amount_us_80u",
"gross_amount_for_other_deductions",
"deductible_amount_for_other_deductions",
"qualifying_amount_for_other_deductions",
"rebate_us_87a",
"relief_us_89",
"payments_from_super_annuation_fund",
"name_of_fund",
"fund_contribution_from",
"fund_contribution_to",
"average_rate_of_deduction_of_tax",
"tds_on_repayment_from_super_annuation_fund",
"gross_pension_under_194p",
"interest_income_by_bank_under_194p"
],
"rows": [
[
1,
1648771200000,
1679742780000,
0.00,
0.00,
10000.00,
0.00,
0.00,
48000.00,
240000.00,
120000.00,
120000.00,
0.00,
0.00,
0.00,
5000.00,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0.00,
0.00,
0.00,
0.00,
0.00,
"GABAR",
"LXXPX1234A",
null,
null,
null,
null,
null,
null,
0.00,
null,
null,
null,
null,
null,
null,
null,
null,
2500.00,
2500.00,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
10000.00,
10000.00,
15000.00,
"LIC",
1648771200000,
1680220800000,
2.0000,
300.00,
10000.00,
0.00
],
[
2,
1648771200000,
1679742780000,
0.00,
0.00,
15000.00,
0.00,
0.00,
90000.00,
300000.00,
150000.00,
150000.00,
2500,
0.00,
0.00,
0.00,
25000.00,
"RAM",
"JXXPX1234B",
null,
null,
null,
null,
null,
null,
20000.00,
50000.00,
0.00,
0.00,
100.00,
null,
null,
null,
null,
null,
null,
null,
null,
20000.00,
80000.00,
80000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
10000.00,
10000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
100000.00,
10000.00,
80000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
12000.00,
15000.00,
0.00,
"LIC",
1648771200000,
1680220800000,
2.0000,
200.00,
75000.00,
70000.00
],
[
3,
1672531200000,
1679742780000,
270000.00,
50000.00,
15000.00,
0.00,
0.00,
36000.00,
120000.00,
60000.00,
60000.00,
2500.00,
0.00,
0.00,
3000.00,
0.00,
"SHYAM",
"JXXPX1234A",
null,
null,
null,
null,
null,
null,
0.00,
50000.00,
0.00,
0.00,
-100.00,
null,
null,
null,
null,
null,
null,
null,
null,
20000.00,
22000.00,
22000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
12000.00,
15000.00,
null,
null,
null,
null,
null,
null,
75000.00,
20000.00
],
[
4,
1648771200000,
1679742780000,
0.00,
0.00,
15000.00,
0.00,
0.00,
210000.00,
420000.00,
210000.00,
210000.00,
0.00,
0.00,
0.00,
2000.00,
null,
null,
null,
null,
null,
null,
null,
null,
null,
20000.00,
0.00,
0.00,
0.00,
0.00,
"THAKUR",
"LXXPX1234B",
null,
null,
null,
null,
null,
null,
0.00,
null,
null,
null,
null,
null,
null,
null,
null,
2500.00,
2500.00,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
12000.00,
0.00,
31800.00,
"LIC",
1648771200000,
1680220800000,
3.0000,
954.00,
null,
null
],
[
5,
1648771200000,
1679742780000,
0.00,
0.00,
15000.00,
0.00,
0.00,
288000.00,
480000.00,
240000.00,
240000.00,
2500.00,
0.00,
0.00,
0.00,
25000.00,
"BABU",
"JXXPX1234C",
null,
null,
null,
null,
null,
null,
0.00,
50000.00,
0.00,
0.00,
200.00,
null,
null,
null,
null,
null,
null,
null,
null,
0.00,
150000.00,
150000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
20000.00,
20000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
100000.00,
10000.00,
80000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
12000.00,
0.00,
20000.00,
"LIC",
1648771200000,
1678386600000,
4.0000,
800,
null,
null
],
[
6,
1672531200000,
1679742780000,
405000.00,
50000.00,
15000.00,
0.00,
0.00,
94500.00,
135000.00,
67500.00,
67500.00,
2500.00,
0.00,
0.00,
0.00,
0.00,
"LAXMI",
"JXXPX1234D",
null,
null,
null,
null,
null,
null,
0.00,
50000.00,
0.00,
0.00,
-200.00,
null,
null,
null,
null,
null,
null,
null,
null,
20000.00,
12000.00,
12000.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
0.00,
12000.00,
0.00,
null,
null,
null,
null,
null,
null,
null,
null
]
]
}
]
}
]
}
{
"name": "Form 26Q",
"sheets": [
{
"name": "Payer",
"blocks": [
{
"name": "Payer",
"@entity": "list",
"items": [
[
"name",
"Acme Pvt Ltd"
],
[
"tan",
"AHMA09719B"
],
[
"pan",
"AAACA1234Z"
],
[
"branch",
"HQ"
],
[
"gstin",
"24AAACA1234Z1ZP"
],
[
"street",
"A-901, Stark Tower"
],
[
"area",
"Relief Road"
],
[
"city",
"Ahmedabad"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380001"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
},
{
"name": "Responsible Person",
"@entity": "list",
"items": [
[
"designation",
"Finance Manager"
],
[
"name",
"Tony Stark"
],
[
"pan",
"DKLPT3483J"
],
[
"street",
"A-901, Stark Tower"
],
[
"area",
"Relief Road"
],
[
"city",
"Ahmedabad"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380001"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
}
]
},
{
"name": "Payee",
"blocks": [
{
"name": "Payee",
"@entity": "table",
"header": [
"sr_no",
"pan",
"name"
],
"rows": [
[
1,
"COWPR1618C",
"Aarya Stark"
],
[
2,
"PANNOTAVBL",
"Marya Stark"
],
[
3,
"PANAPPLIED",
"Karya Stark"
],
[
4,
"PANINVALID",
"Barya Stark"
],
[
5,
"PANNOTAVBL",
"Sarya Stark"
]
]
}
]
},
{
"name": "Challan",
"blocks": [
{
"name": "Challan",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1656547200000,
"(200) TDS Payable by Tax Payer",
20000,
0,
800,
80,
0,
0
]
]
}
]
},
{
"name": "Payment",
"blocks": [
{
"name": "Payment",
"@entity": "table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"section",
"credit_amount",
"credit_date",
"tds_amount",
"surcharge",
"education_cess",
"deduction_date",
"reason_for_lower_deduction",
"certificate_number"
],
"rows": [
[
1,
"12345",
"1234567",
"194 - Dividend",
20000,
1680245287000,
900,
0,
36,
1680245287000
]
]
}
]
}
]
}
{
"name": "Form 27Q",
"sheets": [
{
"name": "Payer",
"blocks": [
{
"name": "Payer",
"@entity": "list",
"items": [
[
"name",
"ACME PVT LTD"
],
[
"tan",
"AHMA09719B"
],
[
"pan",
"AAACA1234Z"
],
[
"gstin",
"24AAACA1234Z1ZP"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380001"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
},
{
"name": "Responsible Person",
"@entity": "list",
"items": [
[
"designation",
"FINANCE MANAGER"
],
[
"name",
"TONY STARK"
],
[
"PAN",
"DKLPT3483J"
],
[
"street",
"A-901, STARK TOWER"
],
[
"area",
"RELIEF ROAD"
],
[
"city",
"AHMEDABAD"
],
[
"state",
"GUJARAT"
],
[
"postal_code",
"380001"
],
[
"email",
"[email protected]"
],
[
"mobile",
"9876543210"
]
]
}
]
},
{
"name": "Payee",
"blocks": [
{
"name": "Payee",
"@entity": "table",
"header": [
"sr_no",
"pan",
"name",
"tax_identification_number",
"street",
"area",
"city",
"state",
"postal_code",
"country",
"email",
"isd_code",
"mobile"
],
"rows": [
[
1,
"COWPR1618C",
"Aarya Stark",
"UAE1234567890",
"BOX NO. 24756",
"",
"Sharjah",
"Sharjah",
"24756",
"UNITED ARAB EMIRATES",
"[email protected]",
"971",
"2660839820"
]
]
}
]
},
{
"name": "Challan",
"blocks": [
{
"name": "Challan",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1680177412000,
"(200) TDS Payable by Tax Payer",
20000,
0,
800,
80,
0,
0
]
]
}
]
},
{
"name": "Payment",
"blocks": [
{
"name": "Payment",
"@entity": "table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"section",
"credit_amount",
"credit_date",
"tds_amount",
"surcharge",
"education_cess",
"deduction_date",
"applicability_of_tds_rate_under_dtaa",
"nature_of_remittance",
"form_15ca_acknowledgement_number",
"grossing_up_indicator",
"reason_for_lower_deduction",
"certificate_number",
"amount_of_cash_withdrawal_more_than_1_crore_us_194N",
"amount_of_cash_withdrawal_between_20_lakhs_and_1_crore_us_194N_for_non_filers",
"amount_of_cash_withdrawal_more_than_1_crore_us_194N_for_non_filers"
],
"rows": [
[
1,
"12345",
"1234567",
"194N - Payment of certain amount in cash",
20000,
1679748479000,
900,
0,
36,
1679748479000,
true,
"Dividend",
"123456789012",
"N",
"Lower Deduction/No Deduction on account of Certificate u/s 197",
"1234567890"
]
]
}
]
}
]
}
Endpoints
Environment | Host URL |
---|---|
Test | https://test-api.sandbox.co.in |
Production | https://api.sandbox.co.in |
Test Environment
Use test host url to test out the APIs
- You can use dummy data and converter it to sheets request structure.
- Maximum number of payments supported in UAT is 20000 records.
- Actions taken in the test mode have no consequences in your live environment.