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": "form26q_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "payer_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "payer_list",
"@entity": "list",
"items": [
[
"name",
"Acme Pvt Ltd"
],
[
"tan",
"AHMA00000C"
],
[
"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"
],
"rows": [
[
1,
"XXXCX1234A",
"Aarav Sharma"
],
[
2,
"XXXPX3456A",
"Kavya Patel"
],
[
3,
"XXXCX7890A",
"Arjun Singhania"
],
[
4,
"XXXCX1111A",
"Priya Gupta"
],
[
5,
"XXXCX2222A",
"Siddharth Mehta"
],
[
6,
"XXXPX3333A",
"Ananya Khanna"
],
[
7,
"XXXPX4444A",
"Vikram Desai"
],
[
8,
"XXXPX5555A",
"Naina Reddy"
],
[
9,
"XXXCX6666A",
"Rohan Kapoor"
],
[
10,
"XXXCX7777A",
"Sanjana Choudhury"
],
[
11,
"XXXPX8888A",
"Aditya Joshi"
],
[
12,
"XXXPX9999A",
"Meera Verma"
],
[
13,
"PANINVALID",
"Rajiv Malhotra"
],
[
14,
"XXXPX0000A",
"Shruti Rao"
],
[
15,
"XXXPZ1111A",
"Mohan Iyer"
],
[
16,
"PANNOTAVBL",
"Preeti Sharma"
],
[
17,
"XXXPZ1111A",
"Rahul Chatterjee"
],
[
18,
"XXXPZ2222A",
"Divya Singh"
],
[
19,
"XXXPZ3333A",
"Karthik Krishnan"
],
[
20,
"XXXPZ4444A",
"Sonali Banerjee"
]
]
}
]
},
{
"name": "challan_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "challan_table",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date_epoch",
"minor_head",
"tds_amount",
"surcharge",
"heath_and_education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"23486",
"1234567",
1699209000000,
"tds_payable",
110000,
0,
0,
0,
0,
0
],
[
"34567",
"1234567",
1701369000000,
"tds_payable",
110000,
0,
0,
0,
0,
0
],
[
"45688",
"1234567",
1704565800000,
"tds_payable",
420000,
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_epoch",
"tds_amount",
"surcharge",
"health_and_education_cess",
"deduction_date_epoch",
"reason_for_lower_or_higher_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,
"23486",
"1234567",
"sponsorship_fees",
87999,
1697740200000,
17600,
0,
0,
1697740200000
],
[
2,
"23486",
"1234567",
"sales_and_marketing_services",
35000,
1697740200000,
7000,
0,
0,
1697740200000
],
[
3,
"23486",
"1234567",
"advertisement_fee",
45823,
1697740200000,
9164.6,
0,
0,
1697740200000
],
[
4,
"23486",
"1234567",
"sponsorship_fees",
76000,
1697740200000,
1500,
0,
0,
1697740200000
],
[
5,
"23486",
"1234567",
"fees_for_technical_service",
105000,
1697740200000,
2100,
0,
0,
1697740200000
],
[
6,
"23486",
"1234567",
"consulting_services",
80000,
1697740200000,
8000,
0,
0,
1697740200000
],
[
7,
"23486",
"1234567",
"directors_fees",
125000,
1697740200000,
25000,
0,
0,
1697740200000
],
[
8,
"23486",
"1234567",
"payments_to_sports_person_and_artists",
150000,
1697740200000,
15000,
0,
0,
1697740200000
],
[
9,
"23486",
"1234567",
"sales_and_marketing_services",
50000,
1697740200000,
10000,
0,
0,
1697740200000
],
[
10,
"23486",
"1234567",
"sales_and_marketing_services",
110000,
1697740200000,
11000,
0,
0,
1697740200000
],
[
1,
"34567",
"1234567",
"sales_and_marketing_services",
87999,
1700418600000,
17600,
0,
0,
1700418600000
],
[
2,
"34567",
"1234567",
"sales_and_marketing_services",
35000,
1700418600000,
7000,
0,
0,
1700418600000
],
[
3,
"34567",
"1234567",
"advertisement_fee",
45823,
1700418600000,
9164.6,
0,
0,
1700418600000
],
[
4,
"34567",
"1234567",
"sponsorship_fees",
76000,
1700418600000,
1500,
0,
0,
1700418600000
],
[
5,
"34567",
"1234567",
"fees_for_technical_service",
105000,
1700418600000,
2100,
0,
0,
1700418600000
],
[
6,
"34567",
"1234567",
"consulting_services",
80000,
1700418600000,
8000,
0,
0,
1700418600000
],
[
7,
"34567",
"1234567",
"directors_fees",
125000,
1700418600000,
25000,
0,
0,
1700418600000
],
[
8,
"34567",
"1234567",
"payments_to_sports_person_and_artists",
150000,
1700418600000,
15000,
0,
0,
1700418600000
],
[
9,
"34567",
"1234567",
"sales_and_marketing_services",
50000,
1700418600000,
10000,
0,
0,
1700418600000
],
[
10,
"34567",
"1234567",
"sales_and_marketing_services",
110000,
1700418600000,
11000,
0,
0,
1700418600000
],
[
1,
"45688",
"1234567",
"sales_and_marketing_services",
87999,
1703010600000,
17600,
0,
0,
1703010600000
],
[
2,
"45688",
"1234567",
"sales_and_marketing_services",
35000,
1703010600000,
7000,
0,
0,
1703010600000
],
[
3,
"45688",
"1234567",
"advertisement_fee",
45823,
1703010600000,
9164.6,
0,
0,
1703010600000
],
[
4,
"45688",
"1234567",
"sponsorship_fees",
76000,
1703010600000,
1500,
0,
0,
1703010600000
],
[
5,
"45688",
"1234567",
"fees_for_technical_service",
105000,
1703010600000,
2100,
0,
0,
1703010600000
],
[
6,
"45688",
"1234567",
"consulting_services",
80000,
1703010600000,
8000,
0,
0,
1703010600000
],
[
7,
"45688",
"1234567",
"directors_fees",
125000,
1703010600000,
25000,
0,
0,
1703010600000
],
[
8,
"45688",
"1234567",
"payments_to_sports_person_and_artists",
150000,
1703010600000,
15000,
0,
0,
1703010600000
],
[
9,
"45688",
"1234567",
"sales_and_marketing_services",
50000,
1703010600000,
10000,
0,
0,
1703010600000
],
[
10,
"45688",
"1234567",
"sales_and_marketing_services",
110000,
1703010600000,
11000,
0,
0,
1703010600000
],
[
11,
"45688",
"1234567",
"winnings_from_online_games",
150000,
1703010600000,
45000,
0,
0,
1703010600000
],
[
12,
"45688",
"1234567",
"winnings_from_online_games",
200000,
1703010600000,
60000,
0,
0,
1703010600000
],
[
13,
"45688",
"1234567",
"winnings_from_online_games",
80000,
1703010600000,
24000,
0,
0,
1703010600000,
"deduction_of_tax_at_higher_rate_due_to_non_availability_of_pan"
],
[
14,
"45688",
"1234567",
"winnings_from_online_games",
120000,
1703010600000,
30000,
0,
0,
1703010600000
],
[
15,
"45688",
"1234567",
"winnings_from_online_games",
50000,
1703010600000,
10000,
0,
0,
1703010600000
],
[
16,
"45688",
"1234567",
"winnings_from_online_games",
90000,
1703010600000,
25000,
0,
0,
1703010600000,
"deduction_of_tax_at_higher_rate_due_to_non_availability_of_pan"
],
[
17,
"45688",
"1234567",
"winnings_from_online_games",
40000,
1703010600000,
10000,
0,
0,
1703010600000
],
[
18,
"45688",
"1234567",
"winnings_from_online_games",
110000,
1703010600000,
35000,
0,
0,
1703010600000
],
[
19,
"45688",
"1234567",
"winnings_from_online_games",
100000,
1703010600000,
40000,
0,
0,
1703010600000
],
[
20,
"45688",
"1234567",
"winnings_from_online_games",
60000,
1703010600000,
28000,
0,
0,
1703010600000
]
]
}
]
}
]
}