Quick answer: Payroll reconciliation means proving that the same payroll numbers appear everywhere they should: the payroll register, the general ledger, the bank payment and the statutory filings (PF ECR, ESI, professional tax and TDS). Do it every month in four checks: explain the change from last month, match the register to the ledger, match net pay to the bank, and match each payable to its challan or return. Then do a fuller annual check against the TDS returns and Form 130 before the audit.
Payroll errors rarely announce themselves. A leaver who stays on the bank file, a PF challan short by a few hundred rupees, or a TDS return that does not match the salary in the books can sit unnoticed for months and surface only in an audit or a notice. Reconciliation is the routine that catches them early. This guide explains what to reconcile, gives a step-by-step monthly process with worked examples, sets out the year-end reconciliation for audit, and suggests a simple Excel template. It builds on our guides to payroll accounting and salary journal entries.
What is payroll reconciliation?
Payroll reconciliation is the comparison of payroll figures from two or more independent sources to confirm they agree, and the investigation of any difference. The sources are independent because each is produced by a different person or system: HR keeps employee data, payroll produces the register, accounts post the ledger, the bank records what actually left the account, and the statutory portals record what was deposited. If all of them agree, the payroll is very likely complete and accurate.
In HR, "reconciliation" also covers matching HR data with payroll: headcount, joiners, leavers, salary revisions and attendance. That check comes first, because a wrong input produces a register that is internally consistent but still wrong.
What to reconcile: the five checks
| Check | Compare | With | When |
|---|---|---|---|
| 1. HR to payroll | Headcount, joiners, leavers, revisions, attendance | Payroll register | Before processing |
| 2. Month-on-month | This month's gross and each deduction | Last month's register | Before approval |
| 3. Register to ledger | Register column totals | Ledger accounts for the month | Month end |
| 4. Net pay to bank | Net pay per register | Bank transfer file and bank statement | On payment |
| 5. Statutory | PF, ESI, PT and TDS payables | ECR, challans and returns | On each payment and filing |
Monthly payroll reconciliation process
- Lock the inputs: agree headcount with HR, list joiners and leavers, and confirm revisions, arrears, loss-of-pay days and recoveries.
- Explain the movement: reconcile this month's gross salary to last month's, item by item, before the register is approved.
- Post and match the journal: post the payroll journal and check that every ledger account equals the matching register total.
- Match the bank: agree the bank file with net pay, employee by employee, and later agree the bank statement with the file.
- Match the statutory payments: agree the PF ECR, ESI challan, professional tax payment and TDS challan with the payables, and check each payable clears to nil.
- Investigate and correct: record every difference, its cause and the correcting entry, and get the reconciliation signed off by someone other than the preparer.
Example 1: month-on-month salary reconciliation
A company's gross salary was ₹5,20,000 in September 2026 and ₹5,46,000 in October 2026. Before approving October payroll, the payroll team explains the ₹26,000 increase:
| Item | Headcount | Amount (₹) |
|---|---|---|
| Gross salary, September 2026 | 20 | 5,20,000 |
| Add: new joiner (full month) | +1 | 30,000 |
| Less: leaver in September | −1 | (25,000) |
| Add: increments effective 1 August, first paid in October | 8,000 | |
| Add: arrears of increments for August–September | 16,000 | |
| Less: loss of pay in October | (3,000) | |
| Gross salary, October 2026 | 20 | 5,46,000 |
Every rupee of change is explained, so the register can be approved. If the reconciliation had left, say, ₹25,000 unexplained, that would point to a leaver who was not removed, or an employee paid twice. One-off items such as arrears should be flagged, because they will reverse next month. Our salary arrears calculator helps check arrears before they go into the register.
Run the same comparison for each deduction and employer contribution. PF, ESI and TDS should move broadly in line with gross pay; a large change with no matching change in gross, such as TDS doubling, usually means a changed tax declaration or a calculation error.
Example 2: payroll register to general ledger
Using the October 2026 payroll from our salary journal entry guide, the accountant compares the register totals with the ledger balances for the month:
| Ledger account | Payroll register (₹) | General ledger (₹) | Difference (₹) |
|---|---|---|---|
| Salary expense | 58,000 | 58,000 | – |
| Contribution to PF (employer) | 4,800 | 4,800 | – |
| EDLI and PF administration charges | 700 | 200 | 500 |
| Contribution to ESI (employer) | 585 | 585 | – |
| Salary payable | 51,365 | 51,365 | – |
| PF payable | 10,300 | 9,800 | 500 |
| ESI payable | 720 | 720 | – |
| Professional tax payable | 200 | 200 | – |
| TDS on salary payable | 1,500 | 1,500 | – |
The ₹500 difference is the PF administration charge minimum: the register included PF administration charges of ₹500 (the establishment minimum), but the journal was posted with EDLI of ₹200 only and no administration charge. When the PF challan of ₹10,300 is paid, PF payable would go ₹500 into debit. The fix is a correcting entry: debit EDLI and PF administration charges ₹500, credit PF payable ₹500. After it, both columns agree and PF payable clears to nil on payment.
Example 3: net pay to bank
Net pay in the register is ₹51,365. Before releasing the payment, compare the bank upload file with the register employee by employee: name, account number, IFSC and amount. Then, when the bank statement arrives, check that the debit equals the file total and that no transfer bounced. A returned payment (for example, a closed account) should be credited back to salary payable, not to salary expense, because the salary is still owed. Our guide to salary payment rules covers the payment deadlines.
Statutory reconciliations: PF, ESI, PT and TDS
| Payable | Match with | What to check |
|---|---|---|
| PF payable | ECR and challan | Employee and employer shares, EPS split, EDLI and administration charges; member-wise wages in the ECR agree with the register; payment by the 15th |
| ESI payable | ESI challan and contribution details | Employee-wise contributions for covered employees, including joiners and anyone crossing the wage limit; payment by the 15th |
| Professional tax payable | State PT return and challan | Employee count by slab and the amount for each slab, by the State's due date |
| TDS on salary payable | TDS challan and quarterly Form 138 | Monthly deposit by the 7th (30 April for March); challan amounts and deductee-wise TDS in Form 138 agree with the register |
The PF portal and ECR rules are explained in our PF ECR filing guide (see also EPFO), and ESI payments in the ESIC challan guide. A payable that does not clear to nil after payment is the clearest sign of a problem: a short or excess payment, a challan booked to the wrong month, or a deduction that was never deposited.
Year-end payroll reconciliation for audit
At the year end, reconcile the year's salary in the books with the TDS records, because the auditor and the Income Tax Department will look at both. The TDS return for the last quarter (Form 138, formerly Form 24Q) carries each employee's salary details for the full year, (Income Tax Department Form 138 FAQs), and Form 130 (formerly Form 16) is issued from the same data.
| Reconciling item | Effect |
|---|---|
| Salary and wages as per books | Starting point |
| Employer's PF and ESI contributions booked as expense | Not part of salary in Form 138, except employer PF above 12% of salary, or employer PF, NPS and superannuation together above ₹7.5 lakh, which is taxable |
| Reimbursements booked under other expense heads | May be in Form 138 if taxable, not in salary in the books |
| Perquisites (for example, a company car or rent-free accommodation) | Included in Form 138 as salary, booked under other heads in the books |
| Provisions for bonus, leave or gratuity not yet paid | In the books, not in Form 138 until paid; prior-year provisions paid this year are in Form 138 but not in this year's expense |
| Salary capitalised to an asset | In Form 138, not in salary expense |
| Salary as per Form 138 | Should agree after these items |
Do the same for PF: total employee and employer contributions for the year in the books should agree with the ECRs filed for April to March. Also confirm that every payable at 31 March relates to March and was paid in April; any older balance needs an explanation. Keep the reconciliations, challans and returns together for the auditor.
Who should reconcile payroll?
The person who prepares the payroll should not be the only one who reconciles it. In a small business, the payroll preparer can do the reconciliation and the owner or finance head reviews and signs it; in a larger one, accounts reconcile the ledger and statutory payables, and payroll or HR explains the movements. Whatever the size, the reviewer should see the supporting challans, the bank statement and the movement report, not just a summary, and should ask about every unexplained or recurring difference. Reconciling within a few days of the month end keeps differences small and easy to trace.
Payroll reconciliation template (Excel)
A simple workbook with one sheet per check is enough for most businesses:
- Movement sheet: last month's gross, each reason for change (joiners, leavers, increments, arrears, loss of pay, one-offs), this month's gross, and an "unexplained" line that must be nil.
- Ledger sheet: one row per ledger account, with columns for register total, ledger balance, difference and explanation.
- Bank sheet: register net pay, bank file total, bank statement debit, returned payments.
- Statutory sheet: one row per payable, with columns for opening balance, this month's credit, payment, challan or return reference, payment date and closing balance.
- Sign-off: preparer, reviewer and date.
Payroll software and the Excel workbook below can produce the register totals automatically; the reconciliation itself still needs a person to investigate the differences.
Common payroll reconciliation differences and fixes
- Leaver still paid: the exit date was not passed to payroll. Recover the payment and tighten the HR-to-payroll exit notice.
- Joiner missed: pay the arrears next month with PF, ESI and TDS on them.
- Payable not clearing: compare the challan with the journal line by line; typical causes are administration charges, rounding of ESI to the next rupee, or a challan booked to the wrong month.
- Bank total differs from net pay: look for a manual payment outside the file, a held salary or a returned transfer.
- TDS return differs from books: check perquisites, reimbursements, arrears paid in a different month and salary of employees who left during the year.
- Deduction taken but not deposited: deposit it at once with interest (and damages for PF); employee PF and ESI deducted but not paid are among the most serious payroll defaults (see payroll penalties).
Start every reconciliation from a clean register. The Complete Indian Payroll Excel Workbook calculates salary, PF, ESI, PT and TDS and gives you monthly totals ready to match with your ledger, bank and challans.
Frequently asked questions
What is payroll reconciliation?
Payroll reconciliation is the process of checking that payroll figures agree across every record that holds them: the payroll register, the general ledger, the bank payment file and bank statement, and statutory filings such as the PF ECR, ESI challan, professional tax return and TDS return. Any difference is investigated and corrected before the books are closed.
What is reconciliation in HR?
In HR, reconciliation usually means matching employee data across systems: headcount, joiners and leavers, salary revisions and attendance in the HR system against the payroll register for the month. It makes sure that everyone who should be paid is paid the right amount, and that no one who has left is still on the payroll.
How do you reconcile payroll to the general ledger?
Total each column of the payroll register, such as gross salary, each deduction, net pay and employer contributions, and compare each total with the matching ledger account for the month. Salary expense should equal gross pay, salary payable should equal net pay, and each statutory payable should equal the related deductions plus any employer contributions and charges. Then check that each payable is cleared to nil by its payment.
How often should payroll be reconciled?
Payroll should be reconciled every month before the books are closed, with the statutory reconciliations done when each challan and return is filed. A fuller annual reconciliation of salary in the books with the TDS returns, Form 130 and PF records should be done at the year end and before the audit.
What is a salary reconciliation format?
A salary reconciliation format is a table that starts with last month's gross salary, adds and subtracts each reason for change, such as joiners, leavers, increments, arrears and loss of pay, and ends with this month's gross salary. It explains every change between two payroll months.
Position as of 15 November 2026. Due dates as they apply to private-sector employers; examples are simplified. Follow your accounting policies and your auditor's guidance. General information, not accounting, tax or legal advice.