To generate the TXT file, you must pass the deduction-related details in a sheet JSON format. A sample payload is mentioned for your reference. Note that you can refer to the sample payload in the form of a workbook.
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",
"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
]
]
}
]
}
]
}