The short version
- A working paper must show inputs, limitations, formulas and source version.
- Screen, Excel and PDF totals should reconcile.
- Sensitive employee data should remain controlled and excluded from analytics.
- A working paper is not an IRD tax-clearance certificate.
Identity and period
Record the fiscal year, calculation date, employee name and PAN, employer name and PAN, designation, joining or leaving date where relevant, and the purpose of the calculation. A figure without its fiscal year is not reviewable because tax bands and deduction ceilings can change.
PAN entry in a private worksheet should be protected appropriately. Structural validation does not mean the PAN has been verified against IRD records.
Remuneration reconciliation
Reconcile Basic salary, regular Allowances, festival allowance, bonus, overtime, taxable benefits, employer contributions and prior-employer income. Separate cash remuneration from non-cash benefits and employer cost.
Where a monthly employer package is used, show the original package, the Basic/Allowance allocation method, employer contribution and the zero reconciliation difference. State clearly if a 60/40 split is merely a planning assumption.
Deductions, credits and return-only claims
For each claim, record the amount entered, amount allowed and the limitation that controlled it. Keep income deductions, post-calculation tax credits and annual-return-only claims in separate sections.
A payroll estimate should not silently reduce monthly TDS for a donation or another return-only claim that the employer is not using. Instead, show the possible annual-return difference separately.
Review controls
Show slab-wise tax, rebate or waiver conditions, tax already deducted, monthly TDS, annual take-home and employer cost. Have the preparer, checker and authorizer sign or otherwise record review where the worksheet is used operationally.
Retain the official source link, law status, calculation version and correction history. Reperform representative calculations after every annual law update.
Privacy and document status
Do not upload employee salary or PAN data merely to create an estimate. Where possible, calculate and export locally. Exclude sensitive values from analytics, error logs and public URLs.
Label the output as a calculation working paper. Only the relevant authority can issue an official assessment or tax-clearance certificate.
Where to check the details
For an important payroll, filing or financial decision, open the source itself and check whether anything has changed since this guide was updated.
- Income Tax Act — IRD
Primary income-tax framework.
- Income Tax Rules — IRD
Supporting rules for calculation claims.