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 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"
]
]
}
]
}
]
}