Non-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": "form26q_worbook",
    "@entity": "workbook",
    "sheets": [
        {
            "name": "payer_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "payer_list",
                    "@entity": "list",
                    "items": [
                        [
                            "name",
                            "Acme Pvt Ltd"
                        ],
                        [
                            "tan",
                            "AHMA00000C"
                        ],
                        [
                            "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"
                    ],
                    "rows": [
                        [
                            1,
                            "XXXCX1234A",
                            "Aarav Sharma"
                        ],
                        [
                            2,
                            "XXXPX3456A",
                            "Kavya Patel"
                        ],
                        [
                            3,
                            "XXXCX7890A",
                            "Arjun Singhania"
                        ],
                        [
                            4,
                            "XXXCX1111A",
                            "Priya Gupta"
                        ],
                        [
                            5,
                            "XXXCX2222A",
                            "Siddharth Mehta"
                        ],
                        [
                            6,
                            "XXXPX3333A",
                            "Ananya Khanna"
                        ],
                        [
                            7,
                            "XXXPX4444A",
                            "Vikram Desai"
                        ],
                        [
                            8,
                            "XXXPX5555A",
                            "Naina Reddy"
                        ],
                        [
                            9,
                            "XXXCX6666A",
                            "Rohan Kapoor"
                        ],
                        [
                            10,
                            "XXXCX7777A",
                            "Sanjana Choudhury"
                        ],
                        [
                            11,
                            "XXXPX8888A",
                            "Aditya Joshi"
                        ],
                        [
                            12,
                            "XXXPX9999A",
                            "Meera Verma"
                        ],
                        [
                            13,
                            "PANINVALID",
                            "Rajiv Malhotra"
                        ],
                        [
                            14,
                            "XXXPX0000A",
                            "Shruti Rao"
                        ],
                        [
                            15,
                            "XXXPZ1111A",
                            "Mohan Iyer"
                        ],
                        [
                            16,
                            "PANNOTAVBL",
                            "Preeti Sharma"
                        ],
                        [
                            17,
                            "XXXPZ1111A",
                            "Rahul Chatterjee"
                        ],
                        [
                            18,
                            "XXXPZ2222A",
                            "Divya Singh"
                        ],
                        [
                            19,
                            "XXXPZ3333A",
                            "Karthik Krishnan"
                        ],
                        [
                            20,
                            "XXXPZ4444A",
                            "Sonali Banerjee"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "challan_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "challan_table",
                    "@entity": "table",
                    "header": [
                        "challan_serial",
                        "bsr_code",
                        "paid_date_epoch",
                        "minor_head",
                        "tds_amount",
                        "surcharge",
                        "heath_and_education_cess",
                        "interest",
                        "late_filing_fees",
                        "other_penalty"
                    ],
                    "rows": [
                        [
                            "23486",
                            "1234567",
                            1699209000000,
                            "tds_payable",
                            110000,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "34567",
                            "1234567",
                            1701369000000,
                            "tds_payable",
                            110000,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "45688",
                            "1234567",
                            1704565800000,
                            "tds_payable",
                            420000,
                            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",
                        "health_and_education_cess",
                        "deduction_date_epoch",
                        "reason_for_lower_or_higher_deduction",
                        "certificate_number",
                        "amount_of_cash_withdrawal_more_than_1_crore_us_194N",
                        "amount_of_cash_withdrawal_between_20_lakhs_and_1_crore_us_194N_for_non_filers",
                        "amount_of_cash_withdrawal_more_than_1_crore_us_194N_for_non_filers",
                        "amount_of_cash_withdrawal_more_than_3_crore_us_194N_for_co-operative_societies",
                        "amount_of_cash_withdrawal_between_20_lakhs_and_3_crore_us_194N_for_non_filers",
                        "amount_of_cash_withdrawal_more_than_3_crore_us_194N_for_non_filers"
                    ],
                    "rows": [
                        [
                            1,
                            "23486",
                            "1234567",
                            "sponsorship_fees",
                            87999,
                            1697740200000,
                            17600,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            2,
                            "23486",
                            "1234567",
                            "sales_and_marketing_services",
                            35000,
                            1697740200000,
                            7000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            3,
                            "23486",
                            "1234567",
                            "advertisement_fee",
                            45823,
                            1697740200000,
                            9164.6,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            4,
                            "23486",
                            "1234567",
                            "sponsorship_fees",
                            76000,
                            1697740200000,
                            1500,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            5,
                            "23486",
                            "1234567",
                            "fees_for_technical_service",
                            105000,
                            1697740200000,
                            2100,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            6,
                            "23486",
                            "1234567",
                            "consulting_services",
                            80000,
                            1697740200000,
                            8000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            7,
                            "23486",
                            "1234567",
                            "directors_fees",
                            125000,
                            1697740200000,
                            25000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            8,
                            "23486",
                            "1234567",
                            "payments_to_sports_person_and_artists",
                            150000,
                            1697740200000,
                            15000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            9,
                            "23486",
                            "1234567",
                            "sales_and_marketing_services",
                            50000,
                            1697740200000,
                            10000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            10,
                            "23486",
                            "1234567",
                            "consulting_services",
                            110000,
                            1697740200000,
                            11000,
                            0,
                            0,
                            1697740200000
                        ],
                        [
                            1,
                            "34567",
                            "1234567",
                            "sales_and_marketing_services",
                            87999,
                            1700418600000,
                            17600,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            2,
                            "34567",
                            "1234567",
                            "sales_and_marketing_services",
                            35000,
                            1700418600000,
                            7000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            3,
                            "34567",
                            "1234567",
                            "advertisement_fee",
                            45823,
                            1700418600000,
                            9164.6,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            4,
                            "34567",
                            "1234567",
                            "sponsorship_fees",
                            76000,
                            1700418600000,
                            1500,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            5,
                            "34567",
                            "1234567",
                            "fees_for_technical_service",
                            105000,
                            1700418600000,
                            2100,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            6,
                            "34567",
                            "1234567",
                            "consulting_services",
                            80000,
                            1700418600000,
                            8000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            7,
                            "34567",
                            "1234567",
                            "directors_fees",
                            125000,
                            1700418600000,
                            25000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            8,
                            "34567",
                            "1234567",
                            "payments_to_sports_person_and_artists",
                            150000,
                            1700418600000,
                            15000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            9,
                            "34567",
                            "1234567",
                            "sales_and_marketing_services",
                            50000,
                            1700418600000,
                            10000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            10,
                            "34567",
                            "1234567",
                            "consulting_services",
                            110000,
                            1700418600000,
                            11000,
                            0,
                            0,
                            1700418600000
                        ],
                        [
                            1,
                            "45688",
                            "1234567",
                            "sales_and_marketing_services",
                            87999,
                            1703010600000,
                            17600,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            2,
                            "45688",
                            "1234567",
                            "sales_and_marketing_services",
                            35000,
                            1703010600000,
                            7000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            3,
                            "45688",
                            "1234567",
                            "advertisement_fee",
                            45823,
                            1703010600000,
                            9164.6,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            4,
                            "45688",
                            "1234567",
                            "sponsorship_fees",
                            76000,
                            1703010600000,
                            1500,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            5,
                            "45688",
                            "1234567",
                            "fees_for_technical_service",
                            105000,
                            1703010600000,
                            2100,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            6,
                            "45688",
                            "1234567",
                            "consulting_services",
                            80000,
                            1703010600000,
                            8000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            7,
                            "45688",
                            "1234567",
                            "directors_fees",
                            125000,
                            1703010600000,
                            25000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            8,
                            "45688",
                            "1234567",
                            "payments_to_sports_person_and_artists",
                            150000,
                            1703010600000,
                            15000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            9,
                            "45688",
                            "1234567",
                            "sales_and_marketing_services",
                            50000,
                            1703010600000,
                            10000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            10,
                            "45688",
                            "1234567",
                            "consulting_services",
                            110000,
                            1703010600000,
                            11000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            11,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            150000,
                            1703010600000,
                            45000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            12,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            200000,
                            1703010600000,
                            60000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            13,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            80000,
                            1703010600000,
                            24000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            14,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            120000,
                            1703010600000,
                            30000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            15,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            50000,
                            1703010600000,
                            10000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            16,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            90000,
                            1703010600000,
                            25000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            17,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            40000,
                            1703010600000,
                            10000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            18,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            110000,
                            1703010600000,
                            35000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            19,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            100000,
                            1703010600000,
                            40000,
                            0,
                            0,
                            1703010600000
                        ],
                        [
                            20,
                            "45688",
                            "1234567",
                            "winnings_from_online_games",
                            60000,
                            1703010600000,
                            28000,
                            0,
                            0,
                            1703010600000
                        ]
                    ]
                }
            ]
        }
    ]
}