To generate the TXT file, you must pass the collection-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
{
"@entity": "workbook",
"name": "form27eq_workbook",
"sheets": [
{
"@entity": "sheet",
"name": "payer_sheet",
"blocks": [
{
"@entity": "list",
"name": "payer_list",
"items": [
[
"name",
"Acme Pvt Ltd"
],
[
"tan",
"AHMA44270C"
],
[
"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"
]
]
},
{
"@entity": "list",
"name": "responsible_person_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"
]
]
}
]
},
{
"@entity": "sheet",
"name": "payee_sheet",
"blocks": [
{
"@entity": "table",
"name": "payee_table",
"header": [
"sr_no",
"pan",
"name",
"nri",
"permanent_establishment_in_india",
"opting_new_regime"
],
"rows": [
[
1,
"COWPR1618C",
"Aarya Stark",
false,
true,
true
],
[
2,
"XXXPX5678A",
"BRUCE",
false,
true,
true
],
[
3,
"XXXPX7643A",
"TOM",
true,
false,
false
],
[
4,
"XXXPX4958A",
"SHAWN",
false,
true,
false
],
[
5,
"XXXPX2345A",
"JOHN",
true,
true,
true
],
[
6,
"XXXPX3456A",
"TONY",
false,
false,
false
],
[
7,
"XXXPX4567A",
"XAVIER",
false,
false,
false
]
]
}
]
},
{
"@entity": "sheet",
"name": "challan_sheet",
"blocks": [
{
"@entity": "table",
"name": "challan_table",
"header": [
"challan_serial",
"bsr_code",
"paid_date_epoch",
"minor_head",
"tcs_amount",
"surcharge",
"health_and_education_cess",
"interest",
"late_filing_fees",
"other_penalty"
],
"rows": [
[
"12345",
"1234567",
1698863400000,
"tcs_payable",
138000,
7500,
4310,
0,
0,
0
],
[
"23486",
"1234567",
1698863400000,
"tcs_payable",
10,
0,
0,
0,
100,
0
],
[
"34567",
"1234567",
1701455400000,
"tcs_payable",
389800,
12500,
10346,
0,
0,
0
],
[
"45688",
"1234567",
1701455400000,
"tcs_payable",
10,
0,
0,
100,
0,
0
],
[
"56789",
"1234567",
1704133800000,
"tcs_payable",
208033,
0,
4221,
1000,
1200,
1000
],
[
"23456",
"1234567",
1698863400000,
"tcs_payable",
0,
0,
0,
0,
0,
0
],
[
"45678",
"1234567",
1701455400000,
"tcs_payable",
0,
0,
0,
0,
0,
0
],
[
"67890",
"1234567",
1704133800000,
"tcs_payable",
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "payment_sheet",
"blocks": [
{
"@entity": "table",
"name": "payment_table",
"header": [
"payee_sr_no",
"challan_serial",
"bsr_code",
"nature_of_payment",
"total_value_of_purchase",
"amount_received",
"payment_date_epoch",
"tcs_amount",
"surcharge",
"health_and_education_cess",
"collection_date_epoch",
"reason_for_lower_or_higher_collection",
"certificate_number"
],
"rows": [
[
1,
"12345",
"1234567",
"liquour_for_human_consumption",
1000000,
500000,
1696444200000,
5000,
0,
100,
1696444200000
],
[
2,
"12345",
"1234567",
"foreign_flight_tickets",
2100000,
700000,
1696444200000,
35000,
0,
700,
1696444200000
],
[
3,
"12345",
"1234567",
"remittance_for_foreign_education_through_loan",
3000000,
500000,
1696444200000,
2500,
0,
100,
1696444200000
],
[
4,
"12345",
"1234567",
"remittance_for_foreign_education_or_medical_treatment",
100000,
100000,
1696444200000,
20000,
0,
400,
1696444200000
],
[
5,
"12345",
"1234567",
"sale_of_goods",
10000000,
1500000,
1696444200000,
75000,
7500,
3000,
1696444200000,
"collection_of_tax_at_a_higher_rate_in_view_of_section_206cca"
],
[
6,
"23456",
"1234567",
"sale_of_goods",
750000,
750000,
1696444200000,
0,
0,
0,
1696444200000,
"no_collection_on_account_of_the_second_proviso_to_sub-section_ih_of_section_206c"
],
[
7,
"12345",
"1234567",
"liquour_for_human_consumption",
50000,
50000,
1696444200000,
500,
0,
10,
1696444200000
],
[
1,
"34567",
"1234567",
"liquour_for_human_consumption",
1000000,
200000,
1699122600000,
2000,
0,
40,
1699122600000
],
[
2,
"34567",
"1234567",
"foreign_flight_tickets",
2100000,
700000,
1699122600000,
140000,
0,
2800,
1699122600000
],
[
3,
"34567",
"1234567",
"remittance_for_foreign_education_through_loan",
3000000,
500000,
1699122600000,
2500,
0,
100,
1699122600000
],
[
4,
"34567",
"1234567",
"remittance_for_foreign_education_or_medical_treatment",
600000,
600000,
1699122600000,
120000,
0,
2400,
1699122600000
],
[
5,
"34567",
"1234567",
"sale_of_goods",
10000000,
2500000,
1699122600000,
125000,
12500,
5000,
1699122600000,
"collection_of_tax_at_a_higher_rate_in_view_of_section_206cca"
],
[
6,
"45678",
"1234567",
"sale_of_goods",
1500000,
1500000,
1699122600000,
0,
0,
0,
1699122600000,
"no_collection_on_account_of_the_second_proviso_to_sub-section_ih_of_section_206c"
],
[
7,
"34567",
"1234567",
"liquour_for_human_consumption",
30000,
30000,
1699122600000,
300,
0,
6,
1699122600000
],
[
1,
"56789",
"1234567",
"liquour_for_human_consumption",
1000000,
300000,
1701714600000,
3000,
0,
60,
1701714600000
],
[
2,
"56789",
"1234567",
"foreign_flight_tickets",
2100000,
700000,
1701714600000,
140000,
0,
2800,
1701714600000
],
[
3,
"56789",
"1234567",
"remittance_for_foreign_education_through_loan",
3000000,
500000,
1701714600000,
2500,
0,
100,
1701714600000
],
[
4,
"56789",
"1234567",
"remittance_for_foreign_education_or_medical_treatment",
300000,
300000,
1701714600000,
60000,
0,
1200,
1701714600000
],
[
5,
"67890",
"1234567",
"sale_of_goods",
10000000,
1000000,
1701714600000,
0,
0,
0,
1701714600000,
"no_collection_on_account_of_the_second_proviso_to_sub-section_ih_of_section_206c"
],
[
6,
"56789",
"1234567",
"sale_of_goods",
500000,
500000,
1701714600000,
0,
0,
0,
1701714600000,
"no_collection_on_account_of_sub-clause_a_or_sub-clause_b_or_sub-clause_c_or_in_view_of_notification_issued_under_sub-clause_c_of_clause_a_of_the_explanation"
],
[
7,
"56789",
"1234567",
"liquour_for_human_consumption",
253231,
253231,
1701714600000,
2533,
0,
51,
1701714600000
]
]
}
]
}
]
}