Salary Payments

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.

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

{
    "name": "form24q_workbook",
    "@entity": "workbook",
    "sheets": [
        {
            "name": "payer_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "payer_list",
                    "@entity": "list",
                    "items": [
                        [
                            "name",
                            "Acme Pvt Ltd"
                        ],
                        [
                            "tan",
                            "AHMA09719B"
                        ],
                        [
                            "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",
                        "employee_category"
                    ],
                    "rows": [
                        [
                            1,
                            "XXXPX5678A",
                            "BRUCE",
                            true,
                            "Senior Citizen"
                        ],
                        [
                            2,
                            "XXXPX7643A",
                            "TOM",
                            false,
                            "Senior Citizen"
                        ],
                        [
                            3,
                            "XXXPX4958A",
                            "SHAWN",
                            false,
                            "Senior Citizen"
                        ],
                        [
                            4,
                            "XXXPX2345A",
                            "JOHN",
                            true,
                            "General"
                        ],
                        [
                            5,
                            "XXXPX3456A",
                            "TONY",
                            false,
                            "General"
                        ],
                        [
                            6,
                            "XXXPX4567A",
                            "XAVIER",
                            false,
                            "General"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "challan_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "challan_table",
                    "@entity": "table",
                    "header": [
                        "challan_serial",
                        "bsr_code",
                        "paid_date_epoch",
                        "minor_head",
                        "tds_amount",
                        "surcharge",
                        "health_and_education_cess",
                        "interest",
                        "late_filing_fees",
                        "other_penalty"
                    ],
                    "rows": [
                        [
                            "12345",
                            "1234567",
                            1706788800000,
                            "tds_payable",
                            100000,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "23486",
                            1234567,
                            1709294400000,
                            "tds_payable",
                            100000,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "34567",
                            1234567,
                            1711972800000,
                            "tds_payable",
                            100000,
                            0,
                            0,
                            0,
                            0,
                            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_epoch",
                        "tds_amount",
                        "surcharge",
                        "heath_and_education_cess",
                        "deduction_date_epoch",
                        "reason_for_lower_deduction",
                        "certificate_number"
                    ],
                    "rows": [
                        [
                            1,
                            "12345",
                            "1234567",
                            "deduction_for_specified_senior_citizens",
                            40000,
                            "1704888000000",
                            4000,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            2,
                            "12345",
                            "1234567",
                            "deduction_for_specified_senior_citizens",
                            50000,
                            "1704888000000",
                            7500,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            3,
                            "12345",
                            "1234567",
                            "deduction_for_specified_senior_citizens",
                            60000,
                            "1704888000000",
                            12000,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            4,
                            "12345",
                            "1234567",
                            "payout_to_employees",
                            70000,
                            "1704888000000",
                            17500,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            5,
                            "12345",
                            "1234567",
                            "payout_to_employees",
                            80000,
                            "1704888000000",
                            24000,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            6,
                            "12345",
                            "1234567",
                            "payout_to_employees",
                            90000,
                            "1704888000000",
                            31500,
                            0,
                            0,
                            "1704888000000",
                            null,
                            null
                        ],
                        [
                            1,
                            "23486",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            40000,
                            "1707566400000",
                            4000,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            2,
                            "23486",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            50000,
                            "1707566400000",
                            7500,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            3,
                            "23486",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            60000,
                            "1707566400000",
                            12000,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            4,
                            "23486",
                            1234567,
                            "payout_to_employees",
                            70000,
                            "1707566400000",
                            17500,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            5,
                            "23486",
                            1234567,
                            "payout_to_employees",
                            80000,
                            "1707566400000",
                            24000,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            6,
                            "23486",
                            1234567,
                            "payout_to_employees",
                            90000,
                            "1707566400000",
                            31500,
                            0,
                            0,
                            "1707566400000",
                            null,
                            null
                        ],
                        [
                            1,
                            "34567",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            40000,
                            "1710072000000",
                            4000,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ],
                        [
                            2,
                            "34567",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            50000,
                            "1710072000000",
                            7500,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ],
                        [
                            3,
                            "34567",
                            1234567,
                            "deduction_for_specified_senior_citizens",
                            60000,
                            "1710072000000",
                            12000,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ],
                        [
                            4,
                            "34567",
                            1234567,
                            "payout_to_employees",
                            70000,
                            "1710072000000",
                            17500,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ],
                        [
                            5,
                            "34567",
                            1234567,
                            "payout_to_employees",
                            80000,
                            "1710072000000",
                            24000,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ],
                        [
                            6,
                            "34567",
                            1234567,
                            "payout_to_employees",
                            90000,
                            "1710072000000",
                            31500,
                            0,
                            0,
                            "1710072000000",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "salary_detail_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "salary_detail_table",
                    "@entity": "table",
                    "header": [
                        "payee_sr_no",
                        "employment_from_date",
                        "employment_to_date",
                        "gross_salary_from_previous_employers",
                        "tds_by_previous_employers",
                        "income_tax_payable",
                        "surcharge",
                        "health_and_education_cess",
                        "tds_on_salary",
                        "salary_as_per_provisions_contained_in_section_17_1",
                        "value_of_perquisites_us_17_2",
                        "profits_in_lieu_of_salary_us_17_3",
                        "travel_concession_or_assistance_us_10_5",
                        "death_cum_retirement_gratuity_us_10_10",
                        "commuted_value_of_pension_us_10_10_a",
                        "cash_equivalent_of_leave_salary_encashment_us_10_10_aa",
                        "house_rent_allowance_us_10_13_a",
                        "other_special_allowances_under_section_10_14",
                        "landlord_1_name",
                        "landlord_1_pan",
                        "landlord_2_name",
                        "landlord_2_pan",
                        "landlord_3_name",
                        "landlord_3_pan",
                        "landlord_4_name",
                        "landlord_4_pan",
                        "total_amount_of_any_other_exemption_us_10",
                        "standard_deduction_us_16_ia",
                        "entertainment_allowance_us_16_ii",
                        "tax_on_employment_us_16_iii",
                        "income_from_house_property_reported_by_employee_offered_for_tds",
                        "lender_1_name",
                        "lender_1_pan",
                        "lender_2_name",
                        "lender_2_pan",
                        "lender_3_name",
                        "lender_3_pan",
                        "lender_4_name",
                        "lender_4_pan",
                        "income_under_the_head_other_sources_offered_for_tds",
                        "gross_amount_us_80_c",
                        "deductible_amount_us_80_c",
                        "gross_amount_us_80_ccc",
                        "deductible_amount_us_80_ccc",
                        "gross_amount_us_80_ccd_1",
                        "deductible_amount_us_80_ccd_1",
                        "gross_amount_us_80_ccd_1_b",
                        "deductible_amount_us_80_ccd_1_b",
                        "gross_amount_us_80_ccd_2",
                        "deductible_amount_us_80_ccd_2",
                        "gross_amount_us_80_ccg",
                        "deductible_amount_us_80_ccg",
                        "gross_amount_us_80_cch",
                        "deductible_amount_us_80_cch",
                        "gross_amount_us_80_d",
                        "deductible_amount_us_80_d",
                        "gross_amount_us_80_dd",
                        "deductible_amount_us_80_dd",
                        "qualifying_amount_us_80_dd",
                        "gross_amount_us_80_e",
                        "deductible_amount_us_80_e",
                        "gross_amount_us_80_ee",
                        "deductible_amount_us_80_ee",
                        "qualifying_amount_us_80_ee",
                        "gross_amount_us_80_eea",
                        "deductible_amount_us_80_eea",
                        "qualifying_amount_us_80_eea",
                        "gross_amount_us_80_g",
                        "deductible_amount_us_80_g",
                        "qualifying_amount_us_80_g",
                        "gross_amount_us_80_gg",
                        "deductible_amount_us_80_gg",
                        "qualifying_amount_us_80_gg",
                        "gross_amount_us_80_ggc",
                        "deductible_amount_us_80_ggc",
                        "qualifying_amount_us_80_ggc",
                        "gross_amount_us_80_tta",
                        "deductible_amount_us_80_tta",
                        "qualifying_amount_us_80_tta",
                        "gross_amount_us_80_ttb",
                        "deductible_amount_us_80_ttb",
                        "qualifying_amount_us_80_ttb",
                        "gross_amount_us_80_u",
                        "deductible_amount_us_80_u",
                        "qualifying_amount_us_80_u",
                        "gross_amount_for_other_deductions",
                        "deductible_amount_for_other_deductions",
                        "qualifying_amount_for_other_deductions",
                        "relief_us_87_a",
                        "relief_us_89",
                        "payments_from_super_annuation_fund",
                        "name_of_fund",
                        "fund_contribution_from",
                        "fund_contribution_to",
                        "average_rate_of_deduction_of_tax",
                        "tds_on_repayment_from_super_annuation_fund",
                        "gross_pension_under_194p",
                        "interest_income_by_bank_under_194p",
                        "net_tax_payable_under_194p"
                    ],
                    "rows": [
                        [
                            1,
                            null,
                            null,
                            null,
                            null,
                            15000,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            10000,
                            10000,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            10000,
                            0,
                            0
                        ],
                        [
                            2,
                            null,
                            null,
                            null,
                            null,
                            15000,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            50000,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            180000,
                            150000,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            12000,
                            15000,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            75000,
                            70000,
                            0
                        ],
                        [
                            3,
                            null,
                            null,
                            null,
                            null,
                            15000,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            50000,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            22000,
                            22000,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            12000,
                            15000,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            75000,
                            20000,
                            0
                        ],
                        [
                            4,
                            1680350400000,
                            1711886400000,
                            0,
                            0,
                            15000,
                            0,
                            0,
                            210000,
                            420000,
                            210000,
                            210000,
                            null,
                            0,
                            0,
                            2000,
                            null,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            20000,
                            50000,
                            null,
                            null,
                            0,
                            "THAKUR",
                            "LXXPX1234B",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            2500,
                            2500,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            12000,
                            0,
                            31800,
                            "LIC",
                            1648771200000,
                            1648166400000,
                            3,
                            954,
                            null,
                            null,
                            null
                        ],
                        [
                            5,
                            1680350400000,
                            1711886400000,
                            0,
                            0,
                            15000,
                            0,
                            0,
                            288000,
                            480000,
                            240000,
                            240000,
                            2500,
                            0,
                            0,
                            0,
                            25000,
                            0,
                            "BABU",
                            "JXXPX1234C",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            50000,
                            0,
                            0,
                            200,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            150000,
                            150000,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            20000,
                            20000,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            null,
                            null,
                            null,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            100000,
                            10000,
                            80000,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            12000,
                            0,
                            20000,
                            "LIC",
                            1648771200000,
                            1648166400000,
                            4,
                            800,
                            null,
                            null,
                            null
                        ],
                        [
                            6,
                            1704110400000,
                            1711886400000,
                            405000,
                            50000,
                            15000,
                            0,
                            0,
                            94500,
                            135000,
                            67500,
                            67500,
                            2500,
                            0,
                            0,
                            0,
                            0,
                            0,
                            "LAXMI",
                            "JXXPX1234D",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            50000,
                            0,
                            0,
                            -200,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            20000,
                            12000,
                            12000,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            null,
                            null,
                            null,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            0,
                            0,
                            0,
                            12000,
                            0,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ]
                    ]
                }
            ]
        }
    ]
}