post https://api.sandbox.co.in/tds-reporting/deductors//tdsrs//async
API to prepare TDS return by generating TXT file
Important Links
Endpoints
| Environment | Host URL |
|---|---|
| Test | https://test-api.sandbox.co.in |
| Production | https://api.sandbox.co.in |
PUT Request on Presigned URL
Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More
Testing Data
| TAN | Form | Quarter | Remarks |
|---|---|---|---|
| AHMA09719B | 26Q | - | The job will be successful |
| AHMA09719B | 27Q | - | The job will be successful |
| AHMA09719B | 24Q | - | The job will be successful |
| AHMA09719B | 24Q | Q4 | The job will be successful |
| BLRC23456F | - | - | Job failed with Validation report |
| DABC2345DD | - | - | Invalid TAN Pattern |
| EABC23456N | - | - | Invalid Form |
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",
"health_and_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",
"health_and_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": [
{
"entity": "sheet",
"name": "Payer",
"blocks": [
{
"entity": "list",
"name": "Payer",
"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"
]
]
},
{
"entity": "list",
"name": "Responsible Person",
"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"
]
]
}
]
},
{
"entity": "sheet",
"name": "Payee",
"blocks": [
{
"entity": "table",
"name": "Payee",
"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"
]
]
}
]
},
{
"entity": "sheet",
"name": "Challan",
"blocks": [
{
"entity": "table",
"name": "Challan",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"health_and_education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1679356800000,
"(200) TDS Payable by Tax Payer",
100000,
0,
0,
0,
0,
0
]
]
}
]
},
{
"entity": "sheet",
"name": "Payment",
"blocks": [
{
"entity": "table",
"name": "Payment",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"section",
"credit_amount",
"credit_date",
"tds_amount",
"surcharge",
"heath_and_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,
1680220800000,
4000,
0,
0,
1680220800000,
null,
null
],
[
2,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
50000,
1680220800000,
7500,
0,
0,
1680220800000,
null,
null
],
[
3,
"12345",
"1234567",
"194P - Deduction of tax in case of specified senior citizens",
60000,
1680220800000,
12000,
0,
0,
1680220800000,
null,
null
],
[
4,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
70000,
1680220800000,
17500,
0,
0,
1680220800000,
null,
null
],
[
5,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
80000,
1680220800000,
24000,
0,
0,
1680220800000,
null,
null
],
[
6,
"12345",
"1234567",
"192 - Payment to Employees other than Government Employees",
90000,
1680220800000,
31500,
0,
0,
1680220800000,
null,
null
]
]
}
]
},
{
"entity": "sheet",
"name": "Salary details",
"blocks": [
{
"entity": "table",
"name": "Salary details",
"header": [
"payee_sr_no",
"employment_from_date",
"employment_to_date",
"gross_salary_from_previous_employers",
"tds_by_previous_employers",
"income_tax_payable",
"surcharge",
"health_and_education_cess",
"tds_on_salary",
"salary_as_per_provisions_contained_in_section_17_1",
"value_of_perquisites_us_17_2",
"profits_in_lieu_of_salary_us_17_3",
"travel_concession_or_assistance_us_10_5",
"death_cum_retirement_gratuity_us_10_10",
"commuted_value_of_pension_us_10_10_a",
"cash_equivalent_of_leave_salary_encashment_us_10_10_aa",
"house_rent_allowance_us_10_13_a",
"other_special_allowances_under_section_10_14",
"landlord_1_name",
"landlord_1_pan",
"landlord_2_name",
"landlord_2_pan",
"landlord_3_name",
"landlord_3_pan",
"landlord_4_name",
"landlord_4_pan",
"total_amount_of_any_other_exemption_us_10",
"standard_deduction_us_16_ia",
"entertainment_allowance_us_16_ii",
"tax_on_employment_us_16_iii",
"income_from_house_property_reported_by_employee_offered_for_tds",
"lender_1_name",
"lender_1_pan",
"lender_2_name",
"lender_2_pan",
"lender_3_name",
"lender_3_pan",
"lender_4_name",
"lender_4_pan",
"income_under_the_head_other_sources_offered_for_tds",
"gross_amount_us_80_c",
"deductible_amount_us_80_c",
"gross_amount_us_80_ccc",
"deductible_amount_us_80_ccc",
"gross_amount_us_80_ccd_1",
"deductible_amount_us_80_ccd_1",
"gross_amount_us_80_ccd_1_b",
"deductible_amount_us_80_ccd_1_b",
"gross_amount_us_80_ccd_2",
"deductible_amount_us_80_ccd_2",
"gross_amount_us_80_ccg",
"deductible_amount_us_80_ccg",
"gross_amount_us_80_cch",
"deductible_amount_us_80_cch",
"gross_amount_us_80_d",
"deductible_amount_us_80_d",
"gross_amount_us_80_dd",
"deductible_amount_us_80_dd",
"qualifying_amount_us_80_dd",
"gross_amount_us_80_e",
"deductible_amount_us_80_e",
"gross_amount_us_80_ee",
"deductible_amount_us_80_ee",
"qualifying_amount_us_80_ee",
"gross_amount_us_80_eea",
"deductible_amount_us_80_eea",
"qualifying_amount_us_80_eea",
"gross_amount_us_80_g",
"deductible_amount_us_80_g",
"qualifying_amount_us_80_g",
"gross_amount_us_80_gg",
"deductible_amount_us_80_gg",
"qualifying_amount_us_80_gg",
"gross_amount_us_80_ggc",
"deductible_amount_us_80_ggc",
"qualifying_amount_us_80_ggc",
"gross_amount_us_80_tta",
"deductible_amount_us_80_tta",
"qualifying_amount_us_80_tta",
"gross_amount_us_80_ttb",
"deductible_amount_us_80_ttb",
"qualifying_amount_us_80_ttb",
"gross_amount_us_80_u",
"deductible_amount_us_80_u",
"qualifying_amount_us_80_u",
"gross_amount_for_other_deductions",
"deductible_amount_for_other_deductions",
"qualifying_amount_for_other_deductions",
"relief_us_87_a",
"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",
"net_tax_payable_under_194p"
],
"rows": [
[
1,
1680340245000,
1710321045000,
null,
null,
15000,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
0,
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,
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,
10000,
null,
null,
null,
null,
null,
null,
10000,
0,
0
],
[
2,
1680340245000,
1710321045000,
null,
null,
15000,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
50000,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
180000,
150000,
0,
0,
0,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
12000,
15000,
null,
null,
null,
null,
null,
null,
75000,
70000,
0
],
[
3,
1680340245000,
1710321045000,
null,
null,
15000,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
50000,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
22000,
22000,
0,
0,
0,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
12000,
15000,
null,
null,
null,
null,
null,
null,
75000,
20000,
0
],
[
4,
1648771200000,
1648166400000,
0,
0,
15000,
0,
0,
210000,
420000,
210000,
210000,
null,
0,
0,
2000,
null,
0,
0,
null,
null,
null,
null,
null,
null,
null,
20000,
null,
null,
null,
0,
"THAKUR",
"LXXPX1234B",
null,
null,
null,
null,
null,
null,
0,
null,
null,
null,
null,
null,
null,
null,
null,
2500,
2500,
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,
null,
null,
12000,
0,
31800,
"LIC",
1648771200000,
1648166400000,
3,
954,
null,
null,
null
],
[
5,
1648771200000,
1648166400000,
0,
0,
15000,
0,
0,
288000,
480000,
240000,
240000,
2500,
0,
0,
0,
25000,
0,
"BABU",
"JXXPX1234C",
null,
null,
null,
null,
null,
null,
0,
50000,
0,
0,
200,
null,
null,
null,
null,
null,
null,
null,
null,
0,
150000,
150000,
0,
0,
0,
0,
0,
0,
20000,
20000,
null,
null,
null,
null,
0,
0,
null,
null,
null,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
100000,
10000,
80000,
null,
null,
null,
null,
null,
null,
0,
0,
0,
12000,
0,
20000,
"LIC",
1648771200000,
1648166400000,
4,
800,
null,
null,
null
],
[
6,
1672531200000,
1648166400000,
405000,
50000,
15000,
0,
0,
94500,
135000,
67500,
67500,
2500,
0,
0,
0,
0,
0,
"LAXMI",
"JXXPX1234D",
null,
null,
null,
null,
null,
null,
0,
50000,
0,
0,
-200,
null,
null,
null,
null,
null,
null,
null,
null,
20000,
12000,
12000,
0,
0,
0,
0,
0,
0,
0,
0,
null,
null,
null,
null,
0,
0,
null,
null,
null,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
12000,
0,
null,
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",
"health_and_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",
"health_and_education_cess",
"deduction_date",
"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",
"amount_of_cash_withdrawal_more_than_3_crore_us_194N_for_co-operative_societies",
"amount_of_cash_withdrawal_between_20_lakhs_and_3_crore_us_194N_for_non_filers",
"amount_of_cash_withdrawal_more_than_3_crore_us_194N_for_non_filers"
],
"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",
"opting_new_regime",
"tax_identification_number",
"street",
"area",
"city",
"state",
"postal_code",
"country",
"email",
"isd_code",
"mobile"
],
"rows": [
[
1,
"COWPR1618C",
"Aarya Stark",
true,
"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",
"health_and_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",
"health_and_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",
"amount_of_cash_withdrawal_more_than_3_crore_us_194N_for_co-operative_societies",
"amount_of_cash_withdrawal_between_20_lakhs_and_3_crore_us_194N_for_non_filers",
"amount_of_cash_withdrawal_more_than_3_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"
]
]
}
]
}
]
}