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": "form27q_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",
"tax_identification_number",
"street",
"area",
"city",
"state",
"postal_code",
"country",
"email",
"isd_code",
"mobile"
],
"rows": [
[
1,
"XXCX1234A",
"Aarav Sharma",
true,
"INTERNATIONAL01",
"Maple Avenue",
"Whispering Pines",
"Midway",
"Midway",
"000000",
"MIDWAY ISLANDS",
"[email protected]",
"1",
999999999
],
[
2,
"XXPX3456A",
"Kavya Patel",
false,
"INTERNATIONAL02",
"Elm Street",
"Meadowbrook Heights",
"Monte Carlo",
"Monte Carlo",
"000001",
"MONACO",
"[email protected]",
"377",
999999999
],
[
3,
"XXCX7890A",
"Arjun Singhania",
true,
"INTERNATIONAL03",
"Oak Lane",
"Sunflower Valley",
"Ulaanbaatar",
"Ulaanbaatar",
"000002",
"MONGOLIA",
"[email protected]",
"976",
999999999
],
[
4,
"XXCX1111A",
"Priya Gupta",
false,
"INTERNATIONAL04",
"Pine Terrace",
"Lakeside Terrace",
"Casablanca",
"Casablanca",
"000003",
"MOROCCO",
"[email protected]",
"212",
999999999
],
[
5,
"XXCX2222A",
"Siddharth Mehta",
true,
"INTERNATIONAL05",
"Cedar Court",
"Pleasant Grove",
"Maputo",
"Maputo",
"000004",
"MOZAMBIQUE",
"[email protected]",
"258",
999999999
],
[
6,
"XXPX3333A",
"Ananya Khanna",
false,
"INTERNATIONAL06",
"Birch Road",
"Stonebridge Park",
"Asunción",
"Asunción",
"000005",
"PARAGUAY",
"[email protected]",
"595",
999999999
],
[
7,
"XXPX4444A",
"Vikram Desai",
true,
"INTERNATIONAL07",
"Willow Way",
"Pinecrest Heights",
"Dubai",
"Dubai",
"000006",
"UNITED ARAB EMIRATES",
"[email protected]",
"971",
999999999
],
[
8,
"XXPX5555A",
"Naina Reddy",
false,
"INTERNATIONAL08",
"Sycamore Drive",
"Willowbrook Meadows",
"London",
"London",
"000007",
"UNITED KINGDOM",
"[email protected]",
"44",
999999999
],
[
9,
"XXCX6666A",
"Rohan Kapoor",
true,
"INTERNATIONAL09",
"Magnolia Boulevard",
"Harborview Estates",
"New York City",
"New York City",
"000008",
"UNITED STATES OF AMERICA",
"[email protected]",
"1",
999999999
],
[
10,
"PANNOTAVBL",
"Sanjana Choudhury",
false,
"INTERNATIONAL10",
"Chestnut Lane",
"Riverbend Gardens",
"Harare",
"Harare",
"000009",
"ZIMBABWE",
"[email protected]",
"263",
999999999
]
]
}
]
},
{
"name": "challan_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "challan_table",
"@entity": "table",
"header": [
"challan_serial",
"bsr_code",
"paid_date",
"minor_head",
"tds_amount",
"surcharge",
"heath_and_education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1693506600000,
"tds_payable",
120000,
0,
0,
0,
0,
0
],
[
"23486",
"1234567",
1699554600000,
"tds_payable",
120000,
0,
0,
0,
0,
0
],
[
"45688",
"1234567",
1704565800000,
"tds_payable",
120000,
0,
0,
5000,
1000,
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",
"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",
"fees_for_technical_service",
87999,
1696098600000,
19000,
0,
0,
1696098600000,
false,
"fees_for_technical_services_or_included_services"
],
[
2,
"12345",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
35000,
1696444200000,
8000,
0,
0,
1696444200000,
false,
"investment_income"
],
[
3,
"12345",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
45823,
1696876200000,
2383,
0,
0,
1696876200000,
false,
"interest_payment"
],
[
4,
"12345",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
76000,
1697308200000,
3500,
0,
0,
1697308200000,
false,
"dividend"
],
[
5,
"12345",
"1234567",
"fees_for_technical_service",
105000,
1697740200000,
21800,
0,
0,
1697740200000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"12345",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
80000,
1698172200000,
16500,
0,
0,
1698172200000,
false,
"investment_income"
],
[
7,
"12345",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
125000,
1698345000000,
6500,
0,
0,
1698345000000,
false,
"interest_payment"
],
[
8,
"12345",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
150000,
1698431400000,
15600,
0,
0,
1698431400000,
false,
"dividend"
],
[
9,
"12345",
"1234567",
"income_by_way_of_interest",
50000,
1698431400000,
10400,
0,
0,
1698431400000,
false,
"interest_payment"
],
[
10,
"12345",
"1234567",
"income_by_way_of_interest",
110000,
1698431400000,
15600,
0,
0,
1698431400000,
false,
"interest_payment"
],
[
1,
"23486",
"1234567",
"income_by_way_of_interest",
87999,
1698777000000,
19000,
0,
0,
1698777000000,
false,
"fees_for_technical_services_or_included_services"
],
[
2,
"23486",
"1234567",
"fees_for_technical_service",
35000,
1699122600000,
8000,
0,
0,
1699122600000,
false,
"investment_income"
],
[
3,
"34567",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
45823,
1699554600000,
2383,
0,
0,
1699554600000,
false,
"interest_payment"
],
[
4,
"34567",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
76000,
1699986600000,
3500,
0,
0,
1699986600000,
false,
"dividend"
],
[
5,
"23486",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
105000,
1700418600000,
21800,
0,
0,
1700418600000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"23486",
"1234567",
"fees_for_technical_service",
80000,
1700850600000,
16500,
0,
0,
1700850600000,
false,
"investment_income"
],
[
7,
"34567",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
125000,
1701023400000,
6500,
0,
0,
1701023400000,
false,
"interest_payment"
],
[
8,
"34567",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
150000,
1701109800000,
15600,
0,
0,
1701109800000,
false,
"dividend"
],
[
9,
"23486",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
50000,
1701109800000,
10400,
0,
0,
1701109800000,
false,
"interest_payment"
],
[
10,
"23486",
"1234567",
"income_by_way_of_interest",
110000,
1701109800000,
15600,
0,
0,
1701109800000,
false,
"interest_payment"
],
[
1,
"45688",
"1234567",
"income_by_way_of_interest",
87999,
1701369000000,
19000,
0,
0,
1701369000000,
false,
"fees_for_technical_services_or_included_services"
],
[
2,
"45688",
"1234567",
"income_by_way_of_interest",
35000,
1701714600000,
8000,
0,
0,
1701714600000,
false,
"investment_income"
],
[
3,
"45688",
"1234567",
"fees_for_technical_service",
45823,
1702146600000,
2383,
0,
0,
1702146600000,
false,
"interest_payment"
],
[
4,
"45688",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
76000,
1702578600000,
3500,
0,
0,
1702578600000,
false,
"dividend"
],
[
5,
"45688",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
105000,
1703010600000,
21800,
0,
0,
1703010600000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"45688",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
80000,
1703442600000,
16500,
0,
0,
1703442600000,
false,
"investment_income"
],
[
7,
"45688",
"1234567",
"fees_for_technical_service",
125000,
1703615400000,
6500,
0,
0,
1703615400000,
false,
"interest_payment"
],
[
8,
"45688",
"1234567",
"income_by_way_of_interest",
150000,
1703701800000,
15600,
0,
0,
1703701800000,
false,
"dividend"
],
[
9,
"45688",
"1234567",
"income_by_way_of_interest",
50000,
1703701800000,
10400,
0,
0,
1703701800000,
false,
"interest_payment"
],
[
10,
"45688",
"1234567",
"income_by_way_of_interest",
110000,
1703701800000,
15600,
0,
0,
1703701800000,
false,
"interest_payment"
]
]
}
]
}
]
}