PUT Request

๐Ÿ“˜

PUT Request on Presigned URL

Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More

JSON Payload

You can refer to the sample payload in workbook format

View Workbook

๐Ÿ‘

Click here to know more about this JSON payload

{
  "@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",
            "minor_head",
            "tcs_amount",
            "surcharge",
            "health_and_education_cess",
            "interest",
            "late_filing_fees",
            "other_penalty"
          ],
          "rows": [
            [
              12345,
              1234567,
              1706873943000,
              "200_tcs_payable_by_tax_payer",
              138000,
              7500,
              4310,
              0,
              0,
              0
            ],
            [
              "23486",
              1234567,
              1706873943000,
              "200_tcs_payable_by_tax_payer",
              10,
              0,
              0,
              0,
              100,
              0
            ],
            [
              "34567",
              1234567,
              1709379543000,
              "200_tcs_payable_by_tax_payer",
              389800,
              12500,
              10346,
              0,
              0,
              0
            ],
            [
              "45688",
              1234567,
              1709379543000,
              "200_tcs_payable_by_tax_payer",
              10,
              0,
              0,
              100,
              0,
              0
            ],
            [
              "56789",
              1234567,
              1714370943000,
              "200_tcs_payable_by_tax_payer",
              208033,
              0,
              4221,
              1000,
              1200,
              1000
            ],
            [
              "23456",
              1234567,
              1706873943000,
              "200_tcs_payable_by_tax_payer",
              0,
              0,
              0,
              0,
              0,
              0
            ],
            [
              "45678",
              1234567,
              1709379543000,
              "200_tcs_payable_by_tax_payer",
              0,
              0,
              0,
              0,
              0,
              0
            ],
            [
              "67890",
              1234567,
              1714370943000,
              "200_tcs_payable_by_tax_payer",
              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",
            "section",
            "total_value_of_purchase",
            "amount_received",
            "purchase_date",
            "tcs_amount",
            "surcharge",
            "health_and_education_cess",
            "collection_date",
            "reason_for_lower_or_higher_collection",
            "certificate_number"
          ],
          "rows": [
            [
              1,
              12345,
              1234567,
              "alcoholic_liquor_for_human_consumption",
              1000000,
              500000,
              1704434943000,
              5000,
              0,
              100,
              1704434943000
            ],
            [
              2,
              12345,
              1234567,
              "collection_at_source_for_purchase_of_overseas_tour_program_package",
              2100000,
              700000,
              1704434943000,
              35000,
              0,
              700,
              1704434943000
            ],
            [
              3,
              12345,
              1234567,
              "collection_at_source_on_remittance_under_lrs_from_educational_loan_taken_from_financial_institution_mentioned_in_section_80e",
              3000000,
              500000,
              1704866943000,
              2500,
              0,
              100,
              1704866943000
            ],
            [
              4,
              12345,
              1234567,
              "collection_at_source_on_remittance_under_lrs_except_for_education_or_medical_treatment",
              100000,
              100000,
              1704866943000,
              20000,
              0,
              400,
              1704866943000
            ],
            [
              5,
              12345,
              1234567,
              "collection_at_source_on_sale_of_goods",
              10000000,
              1500000,
              1705298943000,
              75000,
              7500,
              3000,
              1705298943000,
              "collection_of_tax_at_a_higher_rate_in_view_of_section_206cca"
            ],
            [
              6,
              "23456",
              1234567,
              "collection_at_source_on_sale_of_goods",
              750000,
              750000,
              1705298943000,
              0,
              0,
              0,
              1705298943000,
              "no_collection_on_account_of_the_second_proviso_to_sub-section_ih_of_section_206c"
            ],
            [
              7,
              12345,
              1234567,
              "alcoholic_liquor_for_human_consumption",
              50000,
              50000,
              1706162943000,
              500,
              0,
              10,
              1706162943000
            ],
            [
              1,
              "34567",
              1234567,
              "alcoholic_liquor_for_human_consumption",
              1000000,
              200000,
              1707113343000,
              2000,
              0,
              40,
              1707113343000
            ],
            [
              2,
              "34567",
              1234567,
              "collection_at_source_for_purchase_of_overseas_tour_program_package",
              2100000,
              700000,
              1707113343000,
              140000,
              0,
              2800,
              1707113343000
            ],
            [
              3,
              "34567",
              1234567,
              "collection_at_source_on_remittance_under_lrs_from_educational_loan_taken_from_financial_institution_mentioned_in_section_80e",
              3000000,
              500000,
              1707545343000,
              2500,
              0,
              100,
              1707545343000
            ],
            [
              4,
              "34567",
              1234567,
              "collection_at_source_on_remittance_under_lrs_except_for_education_or_medical_treatment",
              600000,
              600000,
              1707545343000,
              120000,
              0,
              2400,
              1707545343000
            ],
            [
              5,
              "34567",
              1234567,
              "collection_at_source_on_sale_of_goods",
              10000000,
              2500000,
              1707977343000,
              125000,
              12500,
              5000,
              1707977343000,
              "collection_of_tax_at_a_higher_rate_in_view_of_section_206cca"
            ],
            [
              6,
              "45678",
              1234567,
              "collection_at_source_on_sale_of_goods",
              1500000,
              1500000,
              1707977343000,
              0,
              0,
              0,
              1707977343000,
              "no_collection_on_account_of_the_second_proviso_to_sub-section_ih_of_section_206c"
            ],
            [
              7,
              "34567",
              1234567,
              "alcoholic_liquor_for_human_consumption",
              30000,
              30000,
              1708841343000,
              300,
              0,
              6,
              1708841343000
            ],
            [
              1,
              "56789",
              1234567,
              "alcoholic_liquor_for_human_consumption",
              1000000,
              300000,
              1709618943000,
              3000,
              0,
              60,
              1709618943000
            ],
            [
              2,
              "56789",
              1234567,
              "collection_at_source_for_purchase_of_overseas_tour_program_package",",
              2100000,
              700000,
              1709618943000,
              140000,
              0,
              2800,
              1709618943000
            ],
            [
              3,
              "56789",
              1234567,
             "collection_at_source_on_remittance_under_lrs_from_educational_loan_taken_from_financial_institution_mentioned_in_section_80e",
              3000000,
              500000,
              1710050943000,
              2500,
              0,
              100,
              1710050943000
            ],
            [
              4,
              "56789",
              1234567,
              "collection_at_source_on_remittance_under_lrs_except_for_education_or_medical_treatment",
              300000,
              300000,
              1710050943000,
              60000,
              0,
              1200,
              1710050943000
            ],
            [
              5,
              "67890",
              1234567,
              "collection_at_source_on_sale_of_goods",
              10000000,
              1000000,
              1710482943000,
              0,
              0,
              0,
              1710482943000,
              "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"
            ],
            [
              6,
              "56789",
              1234567,
              "sale_in_cash_of_any_goods_other_than_bullion_and_jewelry",
              500000,
              500000,
              1710482943000,
              0,
              0,
              0,
              1710482943000,
              "no_collection_on_account_of_form_27c"
            ],
            [
              7,
              "56789",
              1234567,
              "alcoholic_liquor_for_human_consumption",
              253231,
              253231,
              1711346943000,
              2533,
              0,
              51,
              1711346943000
            ]
          ]
        }
      ]
    }
  ]
}