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
{
"name": "form24q_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "payer_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "payer_list",
"@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_list",
"@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_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "payee_table",
"@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_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "challan_table",
"@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",
1706788800000,
"tds_payable",
100000,
0,
0,
0,
0,
0
],
[
"23486",
1234567,
1709294400000,
"tds_payable",
100000,
0,
0,
0,
0,
0
],
[
"34567",
1234567,
1711972800000,
"tds_payable",
100000,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "payment_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "payment_table",
"@entity": "table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"nature_of_payment",
"payment_amount",
"payment_date",
"tds_amount",
"surcharge",
"heath_and_education_cess",
"deduction_date",
"reason_for_lower_deduction",
"certificate_number"
],
"rows": [
[
1,
"12345",
"1234567",
"deduction_for_specified_senior_citizens",
40000,
"1704888000000",
4000,
0,
0,
"1704888000000",
null,
null
],
[
2,
"12345",
"1234567",
"deduction_for_specified_senior_citizens",
50000,
"1704888000000",
7500,
0,
0,
"1704888000000",
null,
null
],
[
3,
"12345",
"1234567",
"deduction_for_specified_senior_citizens",
60000,
"1704888000000",
12000,
0,
0,
"1704888000000",
null,
null
],
[
4,
"12345",
"1234567",
"payout_to_employees",
70000,
"1704888000000",
17500,
0,
0,
"1704888000000",
null,
null
],
[
5,
"12345",
"1234567",
"payout_to_employees",
80000,
"1704888000000",
24000,
0,
0,
"1704888000000",
null,
null
],
[
6,
"12345",
"1234567",
"payout_to_employees",
90000,
"1704888000000",
31500,
0,
0,
"1704888000000",
null,
null
],
[
1,
"23486",
1234567,
"deduction_for_specified_senior_citizens",
40000,
"1707566400000",
4000,
0,
0,
"1707566400000",
null,
null
],
[
2,
"23486",
1234567,
"deduction_for_specified_senior_citizens",
50000,
"1707566400000",
7500,
0,
0,
"1707566400000",
null,
null
],
[
3,
"23486",
1234567,
"deduction_for_specified_senior_citizens",
60000,
"1707566400000",
12000,
0,
0,
"1707566400000",
null,
null
],
[
4,
"23486",
1234567,
"payout_to_employees",
70000,
"1707566400000",
17500,
0,
0,
"1707566400000",
null,
null
],
[
5,
"23486",
1234567,
"payout_to_employees",
80000,
"1707566400000",
24000,
0,
0,
"1707566400000",
null,
null
],
[
6,
"23486",
1234567,
"payout_to_employees",
90000,
"1707566400000",
31500,
0,
0,
"1707566400000",
null,
null
],
[
1,
"34567",
1234567,
"deduction_for_specified_senior_citizens",
40000,
"1710072000000",
4000,
0,
0,
"1710072000000",
null,
null
],
[
2,
"34567",
1234567,
"deduction_for_specified_senior_citizens",
50000,
"1710072000000",
7500,
0,
0,
"1710072000000",
null,
null
],
[
3,
"34567",
1234567,
"deduction_for_specified_senior_citizens",
60000,
"1710072000000",
12000,
0,
0,
"1710072000000",
null,
null
],
[
4,
"34567",
1234567,
"payout_to_employees",
70000,
"1710072000000",
17500,
0,
0,
"1710072000000",
null,
null
],
[
5,
"34567",
1234567,
"payout_to_employees",
80000,
"1710072000000",
24000,
0,
0,
"1710072000000",
null,
null
],
[
6,
"34567",
1234567,
"payout_to_employees",
90000,
"1710072000000",
31500,
0,
0,
"1710072000000",
null,
null
]
]
}
]
},
{
"name": "salary_details_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "salary_details_table",
"@entity": "table",
"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,
null,
null,
null,
null,
15000,
0,
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,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
10000,
10000,
null,
null,
null,
null,
null,
null,
10000,
0,
0
],
[
2,
null,
null,
null,
null,
15000,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
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,
null,
null,
null,
null,
15000,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
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,
1680350400000,
1711886400000,
0,
0,
15000,
0,
0,
210000,
420000,
210000,
210000,
null,
0,
0,
2000,
null,
0,
null,
null,
null,
null,
null,
null,
null,
null,
20000,
50000,
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,
1680350400000,
1711886400000,
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,
1704110400000,
1711886400000,
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
]
]
}
]
}
]
}