To generate the potential notice report, you must pass the deduction-related details in a sheet JSON format. A sample payload is mentioned for your reference.
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",
"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",
"opting_new_regime",
"tax_identification_number",
"street",
"area",
"city",
"state",
"postal_code",
"country",
"email",
"isd_code",
"mobile"
],
"rows": [
[
1,
"XXXCX1234A",
"Aarav Sharma",
true,
"INTERNATIONAL01",
"Maple Avenue",
"Whispering Pines",
"Midway",
"Midway",
"000000",
"MIDWAY ISLANDS",
"[email protected]",
"1",
"999999999"
],
[
2,
"XXXPX3456A",
"Kavya Patel",
false,
"INTERNATIONAL02",
"Elm Street",
"Meadowbrook Heights",
"Monte Carlo",
"Monte Carlo",
"000001",
"MONACO",
"[email protected]",
"377",
"999999999"
],
[
3,
"XXXCX7890A",
"Arjun Singhania",
true,
"INTERNATIONAL03",
"Oak Lane",
"Sunflower Valley",
"Ulaanbaatar",
"Ulaanbaatar",
"000002",
"MONGOLIA",
"[email protected]",
"976",
"999999999"
],
[
4,
"XXXCX1111A",
"Priya Gupta",
false,
"INTERNATIONAL04",
"Pine Terrace",
"Lakeside Terrace",
"Casablanca",
"Casablanca",
"000003",
"MOROCCO",
"[email protected]",
"212",
"999999999"
],
[
5,
"XXXCX2222A",
"Siddharth Mehta",
true,
"INTERNATIONAL05",
"Cedar Court",
"Pleasant Grove",
"Maputo",
"Maputo",
"000004",
"MOZAMBIQUE",
"[email protected]",
"258",
"999999999"
],
[
6,
"XXXPX3333A",
"Ananya Khanna",
false,
"INTERNATIONAL06",
"Birch Road",
"Stonebridge Park",
"Asunción",
"Asunción",
"000005",
"PARAGUAY",
"[email protected]",
"595",
"999999999"
],
[
7,
"XXXPX4444A",
"Vikram Desai",
true,
"INTERNATIONAL07",
"Willow Way",
"Pinecrest Heights",
"Dubai",
"Dubai",
"000006",
"UNITED ARAB EMIRATES",
"[email protected]",
"971",
"999999999"
],
[
8,
"XXXPX5555A",
"Naina Reddy",
false,
"INTERNATIONAL08",
"Sycamore Drive",
"Willowbrook Meadows",
"London",
"London",
"000007",
"UNITED KINGDOM",
"[email protected]",
"44",
"999999999"
],
[
9,
"XXXCX6666A",
"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",
1698815264000,
"tds_payable",
120000,
0,
0,
0,
0,
0
],
[
"23486",
"1234567",
1702184864000,
"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,
1696444200000,
19000,
0,
0,
1696444200000,
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,
1696444200000,
2383,
0,
0,
1696444200000,
false,
"interest_payment"
],
[
4,
"12345",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
76000,
1696444200000,
3500,
0,
0,
1696444200000,
false,
"dividend"
],
[
5,
"12345",
"1234567",
"fees_for_technical_service",
105000,
1696444200000,
21800,
0,
0,
1696444200000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"12345",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
80000,
1696444200000,
16500,
0,
0,
1696444200000,
false,
"investment_income"
],
[
7,
"12345",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
125000,
1696444200000,
6500,
0,
0,
1696444200000,
false,
"interest_payment"
],
[
8,
"12345",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
150000,
1696444200000,
15600,
0,
0,
1696444200000,
false,
"dividend"
],
[
9,
"12345",
"1234567",
"income_by_way_of_interest",
50000,
1696444200000,
10400,
0,
0,
1696444200000,
false,
"interest_payment"
],
[
10,
"12345",
"1234567",
"income_by_way_of_interest",
110000,
1696444200000,
15600,
0,
0,
1696444200000,
false,
"interest_payment",
null,
null,
"deduction_of_tax_at_higher_rate_due_to_non_availability_of_pan"
],
[
1,
"23486",
"1234567",
"fees_for_technical_service",
87999,
1699122600000,
19000,
0,
0,
1699122600000,
false,
"fees_for_technical_services_or_included_services"
],
[
2,
"23486",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
35000,
1699122600000,
8000,
0,
0,
1699122600000,
false,
"investment_income"
],
[
3,
"23486",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
45823,
1699122600000,
2383,
0,
0,
1699122600000,
false,
"interest_payment"
],
[
4,
"23486",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
76000,
1699122600000,
3500,
0,
0,
1699122600000,
false,
"dividend"
],
[
5,
"23486",
"1234567",
"fees_for_technical_service",
105000,
1699122600000,
21800,
0,
0,
1699122600000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"23486",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
80000,
1699122600000,
16500,
0,
0,
1699122600000,
false,
"investment_income"
],
[
7,
"23486",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
125000,
1699122600000,
6500,
0,
0,
1699122600000,
false,
"interest_payment"
],
[
8,
"23486",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
150000,
1699122600000,
15600,
0,
0,
1699122600000,
false,
"dividend"
],
[
9,
"23486",
"1234567",
"income_by_way_of_interest",
50000,
1699122600000,
10400,
0,
0,
1699122600000,
false,
"interest_payment"
],
[
10,
"23486",
"1234567",
"income_by_way_of_interest",
110000,
1699122600000,
15600,
0,
0,
1699122600000,
false,
"interest_payment",
null,
null,
"deduction_of_tax_at_higher_rate_due_to_non_availability_of_pan"
],
[
1,
"45688",
"1234567",
"fees_for_technical_service",
87999,
1701714600000,
19000,
0,
0,
1701714600000,
false,
"fees_for_technical_services_or_included_services"
],
[
2,
"45688",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
35000,
1701714600000,
8000,
0,
0,
1701714600000,
false,
"investment_income"
],
[
3,
"45688",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
45823,
1701714600000,
2383,
0,
0,
1701714600000,
false,
"interest_payment"
],
[
4,
"45688",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
76000,
1701714600000,
3500,
0,
0,
1701714600000,
false,
"dividend"
],
[
5,
"45688",
"1234567",
"fees_for_technical_service",
105000,
1701714600000,
21800,
0,
0,
1701714600000,
false,
"fees_for_technical_services_or_included_services"
],
[
6,
"45688",
"1234567",
"income_from_the_investment_made_by_nri_citizen",
80000,
1701714600000,
16500,
0,
0,
1701714600000,
false,
"investment_income"
],
[
7,
"45688",
"1234567",
"interest_payment_on_infrastructure_debt_fund",
125000,
1701714600000,
6500,
0,
0,
1701714600000,
false,
"interest_payment"
],
[
8,
"45688",
"1234567",
"dividend_payment_from_units_of_a_business_trust",
150000,
1701714600000,
15600,
0,
0,
1701714600000,
false,
"dividend"
],
[
9,
"45688",
"1234567",
"income_by_way_of_interest",
50000,
1701714600000,
10400,
0,
0,
1701714600000,
false,
"interest_payment"
],
[
10,
"45688",
"1234567",
"income_by_way_of_interest",
110000,
1701714600000,
15600,
0,
0,
1701714600000,
false,
"interest_payment",
null,
null,
"deduction_of_tax_at_higher_rate_due_to_non_availability_of_pan"
]
]
}
]
}
]
}