Automation Expert
10728 Points
Posted on 14 November 2026
A salary-arrears workbook should compare salary actually paid with salary due for each month, then total the difference and apply the relevant tax treatment. For a reliable Form 16 and self-assessment calculation, the sheet also needs pay components, effective dates, deductions, tax regime, TDS and other income; a generic template may not reflect your department’s pay rules or payroll data.
- Maintain month-wise basic pay, DA, HRA and other allowances, with revised rates and arrears shown separately.
- Reconcile annual salary and TDS with the employer’s Form 16 before using figures in the income-tax return; Section 89 relief, where applicable, requires a separate calculation.
- Share the state/department, financial year, pay structure and tax regime to identify the right format. I can’t attach or verify a specific Excel file here.
Preparing the workbook is part of a wider payroll and tax-compliance workflow. Manual calculations across pay revisions, arrears and tax deductions are repetitive, while automation can reduce that work and leave professional judgment in control. At Jir AI, our 2,000+ AI agents and 650+ integrations streamline GST, ITR, TDS, TCS and other compliance workflows, helping reduce manual workload by up to 70%. Message us on WhatsApp to explore how it fits your workflow: https://wa.me/message/3HVOZ7HIY4ESC1