Payroll reconciliation: register vs bank payments vs statutory dues
Reconcile Indian payroll three ways: register net pay to bank credits, deductions to PF, ESI, PT and TDS challans, and gross pay to the general ledger.
Payroll is usually the largest single outflow a mid-size company makes each month, and it touches four records that are kept by different people: the payroll register from HR or the payroll provider, the salary file and bank statement from treasury, the statutory challans for PF, ESI, professional tax and TDS, and the salary journal in the general ledger. Each pair can drift apart. A proper payroll reconciliation ties all of them together every month, before the PF and ESI due dates, not at year end when Form 16 questions arrive. This post walks through the three legs and the differences each one usually finds.
The three legs
Think of the payroll register as the centre. Each line is one employee: gross pay, each deduction, net pay. From it, three reconciliations run outwards.
- Net pay against salary payments. Every employee in the register was paid exactly their net pay, once, into the right account.
- Deductions against statutory payments. Every rupee deducted for PF, ESI, professional tax and TDS was deposited, on time, under the right head.
- Register totals against the general ledger. The salary journal in Tally, Zoho Books or SAP matches the register's gross pay, deductions and net pay.
Leg 1: net pay against the bank
Match per employee, not just in total
The bank's bulk upload file and the statement give you one debit per employee. Match each against the register line. Use the strongest key first:
- Employee code. Many companies put it in the beneficiary reference of the salary file, so it appears in the bank's narration (
SAL OCT26 EMP0412). It is unique and does not change when someone changes banks. - Bank account number. Useful when the narration carries no code. Strip spaces and leading zeros.
- Employee name. The weakest key, because bank names are truncated and spelt differently (
R SUBRAMANIANagainstRamesh Subramanian). Use it only with an exact amount and have someone confirm each pair.
The amount must agree exactly. Payroll has no rounding tolerance worth allowing per employee; a difference of ₹1 means the register and the file were prepared from different versions.
What leg 1 usually finds
- Payments on hold. Full and final settlements, employees under notice, or salary withheld pending documents. They are in the register but not in the bank file.
- Returned credits. A wrong IFSC or a closed account. The bank debits the full file and later credits the rejected amount back, often days later with a narration like
RTN SAL EMP0377. - Paid twice. Usually a manual re-payment of a returned credit, done before the return actually came back. Look for the same employee code and amount twice in the bank file.
- Employees without bank details in the register. They cannot be paid by transfer, and if they were paid in cash, there should be a voucher.
Leg 2: deductions against statutory dues
Each deduction in the register is money held in trust. Reconcile each one to the challan that deposited it.
| Item | What the register shows | What to compare with | Due date |
|---|---|---|---|
| Provident Fund | Employee share, usually 12% of PF wages | ECR and challan on the EPFO portal (employee share plus employer share, split into EPF and EPS) | 15th of the next month |
| ESI | Employee share of 0.75% of gross, for employees earning up to ₹21,000 a month | ESIC contribution challan (with employer share of 3.25%) | 15th of the next month |
| Professional tax | State-wise slab, for example ₹200 a month in Maharashtra above ₹10,000, with ₹300 in February | State PT challan and return | Varies by state |
| TDS on salary | Tax deducted per employee | Challan paid on the income-tax portal | 7th of the next month; 30 April for March |
A few points that catch people out:
- The employer's share is not in net pay, but it is in the challan. When you compare the PF challan with the register, compare the employee share with the employee share, and the employer's share with your own calculation from PF wages. The EPS part of the employer's share is capped on a wage ceiling, so the split is not simply 3.67% and 8.33% of everyone's wages. Check the ceiling in force for the month.
- The definition of wages changed. The four labour codes came into force on 21 November 2025, with a uniform definition of wages under which allowances above half of total pay are added back. If your salary structures were not revised, your PF wages in the register may not be what the law now expects. Ask your payroll provider which definition the register uses.
- TDS is now under a new law. From 1 April 2026 the Income-tax Act, 2025 replaced the 1961 Act, and TDS on salary moved from section 192 to section 392. The deposit timelines stayed the same. If your register or challan mapping still labels things by old section numbers, update the labels so your reconciliation and your quarterly return agree.
- Professional tax is per state. An employee transferred from Pune to Bengaluru mid-year changes PT slab and challan. Reconcile PT per state registration, not as one number.
A worked example
An illustrative October 2026 payroll for 120 employees.
| Register totals | ₹ |
|---|---|
| Gross pay | 68,40,000 |
| PF, employee share | (4,10,400) |
| ESI, employee share | (6,750) |
| Professional tax | (23,400) |
| TDS on salary | (5,12,300) |
| Salary advance recovery | (45,000) |
| Net pay | 58,42,150 |
Leg 1. The bank shows 120 salary debits totalling ₹58,28,650 and one return of ₹31,200, so ₹57,97,450 actually left. The difference of ₹44,700 against the register's net pay breaks down as:
| Item | ₹ |
|---|---|
| EMP0291, full and final on hold, not paid | 38,000 |
| EMP0377, credit returned (account closed) | 31,200 |
| EMP0118, paid twice (manual re-payment on 1 Nov) | (24,500) |
| Explained difference | 44,700 |
The double payment of ₹24,500 needs recovery. The returned ₹31,200 still has to be paid, so the employee is owed money even though "salary is done".
Leg 2.
| Deduction | Register (₹) | Challan (₹) | Difference (₹) | Cause |
|---|---|---|---|---|
| PF, employee share | 4,10,400 | 4,10,400 | 0 | |
| ESI, employee share | 6,750 | 6,525 | 225 | One new joiner not yet registered on the ESIC portal |
| Professional tax | 23,400 | 23,400 | 0 | |
| TDS on salary | 5,12,300 | 5,02,300 | 10,000 | Arrears TDS for one employee added after the challan was prepared |
Both differences need action before the due dates: register the joiner and pay the ₹225 with the employer share, and pay the ₹10,000 TDS by 7 November to avoid interest.
Leg 3: register against the ledger
The salary journal should carry the same totals as the register: gross pay to salary expense (split by cost centre if you report that way), each deduction to its liability ledger, net pay to salaries payable. Then:
- Salaries payable should go to zero when the bank payments are booked, except for amounts on hold, which should be listed.
- Each statutory liability ledger should go to zero when the challan is booked. A PF payable ledger with a balance three months old means a challan was missed or booked to the wrong ledger.
- Gross pay per the register for the year should agree with the salary figures in your quarterly TDS returns and the annual salary certificates.
Make it a monthly habit
Run leg 1 on pay day, leg 2 before the 7th (TDS) and the 15th (PF, ESI), and leg 3 at month end. Carry held payments and returns forward and confirm they clear next month.
How RefinePoint does it
RefinePoint's built-in Payroll against salary payments template covers leg 1. It has two sides, Payroll register and Salary payments, and matches in three passes: employee code found in the bank reference or narration with the exact net pay, then bank account (ignoring spaces and punctuation) with the exact net pay, then employee name by Jaro-Winkler similarity with the exact net pay, which is proposed for a person to confirm. Its checks flag anyone paid twice, compare total net pay within ₹1, and list employees in the register without an employee code or bank account. Legs 2 and 3 can be set up from scratch in the same workspace, using its Totals agree check and a calculated field per deduction, and the results can feed the month-end close.
To try it on last month's payroll, request a demo at refinepoint.com or start free at app.refinepoint.com.
Sources
- PF and ESI rates and due dates: Zoho Payroll, statutory components, Paybooks, PF, ESI, PT and LWF guide
- Professional tax slabs and the ₹2,500 annual cap under Article 276: Tally Solutions, state-wise professional tax
- Labour codes in force from 21 November 2025 and the new definition of wages: ClearTax, SCC Online
- TDS on salary under section 392 of the Income-tax Act, 2025: ClearTax, section 392, Zoho Payroll, new Income Tax Act
- TDS deposit due dates under the Income-tax Rules, 2026: TaxGuru