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

Sample Payload

{
    "name": "Form 24Q",
    "sheets": [
        {
            "name": "Payer",
            "blocks": [
                {
                    "name": "Payer",
                    "@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",
                            "380015"
                        ],
                        [
                            "email",
                            "[email protected]"
                        ],
                        [
                            "mobile",
                            "9876543210"
                        ]
                    ]
                },
                {
                    "name": "Responsible Person",
                    "@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",
                            "380015"
                        ],
                        [
                            "email",
                            "[email protected]"
                        ],
                        [
                            "mobile",
                            "9876543210"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "Payee",
            "blocks": [
                {
                    "name": "Payee",
                    "@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",
            "blocks": [
                {
                    "name": "Challan",
                    "@entity": "table",
                    "header": [
                        "challan_serial",
                        "bsr_code",
                        "paid_date",
                        "minor_head",
                        "tds_amount",
                        "surcharge",
                        "health_and_education_cess",
                        "interest",
                        "late_filing_fees",
                        "other_penalty"
                    ],
                    "rows": [
                        [
                            "12345",
                            "1234567",
                            1702622887000,
                            "(200) TDS Payable by Tax Payer",
                            100000,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "name": "Payment",
            "blocks": [
                {
                    "name": "Payment",
                    "@entity": "table",
                    "header": [
                        "payee_sr_no",
                        "challan_serial",
                        "bsr_code",
                        "section",
                        "credit_amount",
                        "credit_date",
                        "tds_amount",
                        "surcharge",
                        "health_and_education_cess",
                        "deduction_date",
                        "reason_for_lower_deduction",
                        "certificate_number"
                    ],
                    "rows": [
                        [
                            1,
                            "12345",
                            "1234567",
                            "194P - Deduction of tax in case of specified senior citizens",
                            40000.00,
                            1702536487000,
                            4000.00,
                            0,
                            0,
                            1702536487000
                        ],
                        [
                            2,
                            "12345",
                            "1234567",
                            "194P - Deduction of tax in case of specified senior citizens",
                            50000.00,
                            1702536487000,
                            7500.00,
                            0,
                            0,
                            1702536487000
                        ],
                        [
                            3,
                            "12345",
                            "1234567",
                            "194P - Deduction of tax in case of specified senior citizens",
                            60000.00,
                            1702536487000,
                            12000.00,
                            0,
                            0,
                            1702536487000
                        ],
                        [
                            4,
                            "12345",
                            "1234567",
                            "192 - Payment to Employees other than Government Employees",
                            70000.00,
                            1702536487000,
                            17500.00,
                            0,
                            0,
                            1702536487000
                        ],
                        [
                            5,
                            "12345",
                            "1234567",
                            "192 - Payment to Employees other than Government Employees",
                            80000.00,
                            1702536487000,
                            24000.00,
                            0,
                            0,
                            1702536487000
                        ],
                        [
                            6,
                            "12345",
                            "1234567",
                            "192 - Payment to Employees other than Government Employees",
                            90000.00,
                            1702536487000,
                            31500.00,
                            0,
                            0,
                            1702536487000
                        ]
                    ]
                }
            ]
        }
    ]
}

{
  "name": "Form 24Q",
  "sheets": [
    {
      "entity": "sheet",
      "name": "Payer",
      "blocks": [
        {
          "entity": "list",
          "name": "Payer",
          "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"
            ]
          ]
        },
        {
          "entity": "list",
          "name": "Responsible Person",
          "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",
      "blocks": [
        {
          "entity": "table",
          "name": "Payee",
          "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"
            ]
          ]
        }
      ]
    },
    {
      "entity": "sheet",
      "name": "Challan",
      "blocks": [
        {
          "entity": "table",
          "name": "Challan",
          "header": [
            "challan_serial",
            "bsr_code",
            "paid_date",
            "minor_head",
            "tds_amount",
            "surcharge",
            "health_and_education_cess",
            "interest",
            "late_filing_fees",
            "other_penalty"
          ],
          "rows": [
            [
              "12345",
              "1234567",
              1679356800000,
              "(200) TDS Payable by Tax Payer",
              100000,
              0,
              0,
              0,
              0,
              0
            ]
          ]
        }
      ]
    },
    {
      "entity": "sheet",
      "name": "Payment",
      "blocks": [
        {
          "entity": "table",
          "name": "Payment",
          "header": [
            "payee_sr_no",
            "challan_serial",
            "bsr_code",
            "section",
            "credit_amount",
            "credit_date",
            "tds_amount",
            "surcharge",
            "heath_and_education_cess",
            "deduction_date",
            "reason_for_lower_deduction",
            "certificate_number"
          ],
          "rows": [
            [
              1,
              "12345",
              "1234567",
              "194P - Deduction of tax in case of specified senior citizens",
              40000,
              1680220800000,
              4000,
              0,
              0,
              1680220800000,
              null,
              null
            ],
            [
              2,
              "12345",
              "1234567",
              "194P - Deduction of tax in case of specified senior citizens",
              50000,
              1680220800000,
              7500,
              0,
              0,
              1680220800000,
              null,
              null
            ],
            [
              3,
              "12345",
              "1234567",
              "194P - Deduction of tax in case of specified senior citizens",
              60000,
              1680220800000,
              12000,
              0,
              0,
              1680220800000,
              null,
              null
            ],
            [
              4,
              "12345",
              "1234567",
              "192 - Payment to Employees other than Government Employees",
              70000,
              1680220800000,
              17500,
              0,
              0,
              1680220800000,
              null,
              null
            ],
            [
              5,
              "12345",
              "1234567",
              "192 - Payment to Employees other than Government Employees",
              80000,
              1680220800000,
              24000,
              0,
              0,
              1680220800000,
              null,
              null
            ],
            [
              6,
              "12345",
              "1234567",
              "192 - Payment to Employees other than Government Employees",
              90000,
              1680220800000,
              31500,
              0,
              0,
              1680220800000,
              null,
              null
            ]
          ]
        }
      ]
    },
    {
      "entity": "sheet",
      "name": "Salary details",
      "blocks": [
        {
          "entity": "table",
          "name": "Salary details",
          "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,
              1680340245000,
              1710321045000,
              null,
              null,
              15000,
              0,
              0,
              0,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              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,
              10000,
              10000,
              null,
              null,
              null,
              null,
              null,
              null,
              10000,
              0,
              0
            ],
            [
              2,
              1680340245000,
              1710321045000,
              null,
              null,
              15000,
              0,
              0,
              0,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              0,
              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,
              1680340245000,
              1710321045000,
              null,
              null,
              15000,
              0,
              0,
              0,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              0,
              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,
              1648771200000,
              1648166400000,
              0,
              0,
              15000,
              0,
              0,
              210000,
              420000,
              210000,
              210000,
              null,
              0,
              0,
              2000,
              null,
              0,
              0,
              null,
              null,
              null,
              null,
              null,
              null,
              null,
              20000,
              null,
              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,
              1648771200000,
              1648166400000,
              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,
              1672531200000,
              1648166400000,
              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
            ]
          ]
        }
      ]
    }
  ]
}