PUT Request

To generate the potential notice report, you must pass the collection-related details in a sheet JSON format. A sample payload is mentioned for your reference.

Important Links

View Entity View 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
                        ]
                    ]
                }
            ]
        }
    ]
}