Payroll reconciliation: match payroll to PF, ESI, PT and TDS
Reconcile payroll with statutory records and payment proof each month, then review quarterly totals and resolve every difference with evidence.
DonkeyHR Team · 2026-10-27 · 6 min read
Match each month’s payroll register with the corresponding PF ECR, ESI contribution records, professional tax records and salary TDS payment records. Compare the amounts recorded as payable with both the amounts reported and the payments confirmed. Each quarter, review the monthly reconciliations together and match salary TDS reporting with the underlying payroll and payment records.
What records should you keep together?
Create a reconciliation folder for each payroll month. Keep the approved payroll register, employee-level statutory calculations, relevant contribution records, payment references and evidence of successful payment together.
A payment instruction alone does not show that payment succeeded. Keep the confirmation that lets you identify the payment, its amount and the period it covers.
Save the payroll version used for the comparison. If someone changes payroll afterwards, preserve the original and record the adjustment separately. Otherwise, a later download may no longer explain the amount already reported or paid.
Use the same employee identifiers across your working records wherever possible. Names alone can make joiners, exits and corrections harder to trace.
How should you reconcile payroll each month?
Start with the payroll register. Extract separate totals for PF, ESI, PT and salary TDS. Do not combine them into a single deductions total: a difference in one category could hide an opposite difference elsewhere.
For PF and ESI, identify which employee and employer contribution amounts your payroll total contains. Compare matching components across records. An employee deduction total should not be compared with a payment total containing additional components without explaining the difference.
Then compare each payroll amount with the corresponding reported amount and confirmed payment. Record the period covered by each document. A payment made this month may relate to an earlier payroll month.
Use this monthly checklist:
- Save the approved payroll register and employee-level calculations.
- Separate PF, ESI, PT and salary TDS totals.
- Confirm that each comparison covers the same payroll period.
- Match payroll PF amounts with the ECR and payment evidence.
- Match payroll ESI amounts with contribution records and payment evidence.
- Match PT amounts with records for the relevant state.
- Match salary TDS deductions with payment records.
- Record every difference, its owner and the next action.
- Attach evidence before marking a difference resolved.
Complete this review early enough to act before the applicable payment deadline. Reconciliation after payment still matters, but it leaves less room to correct an error beforehand.
What should you check for each statutory payment?
For PF, compare the employees included, their contribution amounts and the ECR total with the payroll working. Then match the ECR with the confirmed payment. PF ECR filing and payment are due by the 15th of the next month.
For ESI, compare the employee-level contribution records with payroll, then check the payment amount and period. ESI is payable within 15 days of the month end.
PT is a state levy. Keep state-wise workings where relevant, and compare each with the corresponding payment record. Check the current state notification for applicable rules and due dates.
For salary TDS, reconcile the payroll deduction total with the payment records for the relevant period. Keep adjustments visible so that a later payment does not make an earlier month appear settled without explanation.
Rules can change as labour codes and related requirements develop. Check the current notification or official portal for applicable rates, limits, payment instructions and other due dates.
What does a matched month and a mismatch look like?
Illustrative worked example: the payroll PF total is Rs 24,000. The corresponding ECR total is Rs 24,000, and the confirmed challan payment is Rs 24,000.
The difference is Rs 24,000 minus Rs 24,000, which equals Rs 0. This amount comparison matches. You should still confirm that the employees, contribution components and payroll period agree.
In another illustrative month, payroll shows PF of Rs 24,000, but the ECR and confirmed challan payment show Rs 23,400.
The difference is Rs 24,000 minus Rs 23,400, which equals Rs 600.
An employee-level comparison shows that a joiner’s Rs 600 contribution amount appears in payroll but was omitted from the contribution working used for the ECR. That explains the difference; it does not resolve it.
Check the applicable correction process on the official portal. Keep the corrected record and any further payment evidence with the reconciliation. These example amounts are illustrative, not statutory rates or limits.
How should you investigate a difference?
First, check whether the records are comparable. Confirm the payroll month, employee population and contribution components. A wrong-period comparison can look like a payment shortfall.
Next, compare employee-level amounts. Start with joiners, exits, changed pay and manual adjustments. Look for missing employees, duplicate entries and figures copied from an older payroll version.
If reported amounts match payroll but payment differs, inspect the payment evidence. Check whether the transaction succeeded and whether the reference belongs to the correct period and statutory account.
Describe the finding precisely. “Joiner omitted from contribution working” gives the next person something to act on. “Payroll issue” does not.
Assign someone to resolve it. Keep the item open until the correction is supported by evidence. If the treatment is unclear, check the current notification or official portal and get appropriate payroll or tax advice.
What should the quarterly review add?
The quarterly review should connect the monthly records, rather than replace them with a fresh total.
Add the monthly payroll amounts, reported amounts and confirmed payments separately for each statutory category. Review unresolved differences and check whether corrections have been counted twice or placed against the wrong month.
Salary TDS is reported quarterly in Form 138. Form 24Q applies to salary paid before April 2026. Check the current notification for reporting and payment deadlines.
From April 2026, the Income-tax Act 2025 applies and the year is called the tax year. Use the relevant tax year consistently in salary TDS workings.
Check that quarterly salary TDS reporting agrees with payroll deductions and payment records. Investigate differences at employee level before treating the quarter as reconciled.
Common mistakes
Matching only the bank debit misses whether the correct employees and period were reported.
Treating a prepared challan as proof of successful payment leaves the payment status unverified.
Comparing only grand totals can hide employee-level errors that cancel each other out.
Moving an unexplained difference into the next month makes both months harder to reconcile. Keep the original period visible and document any correction.
Closing an item because someone promises to fix it leaves no evidence that the correction happened.
FAQ
Does a matching total mean reconciliation is complete?
No. Check the employees, contribution components, period and payment status too. Equal totals can still contain omissions and duplicate entries.
Should we wait until the quarter ends?
No. Reconcile monthly so differences are found while the records are fresh. Use the quarterly review to connect those reconciliations and check salary TDS reporting.
What if payroll changes after payment?
Preserve the version used for payment. Record what changed, compare the revised amounts and check the applicable correction process. Keep the supporting records together.
Can we close a difference after finding its cause?
Finding the cause is only part of the work. Close it after the required correction is complete and the evidence explains how the records now agree.
How can software support this routine?
DonkeyHR is an Indian payroll and HR product in beta that computes PF, ESI, professional tax and TDS in payroll runs and provides payroll register CSV exports. Use the payroll register as a starting record, then compare it with the relevant statutory records and confirmed payments.