RefinePoint

Blog · · 7 min read

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.

  1. Net pay against salary payments. Every employee in the register was paid exactly their net pay, once, into the right account.
  2. Deductions against statutory payments. Every rupee deducted for PF, ESI, professional tax and TDS was deposited, on time, under the right head.
  3. 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 SUBRAMANIAN against Ramesh 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

Filed under Payroll

Reconcile it in RefinePoint

Templates for bank, vendor, GST, payroll, card and payment reconciliations. Upload two files and see the matches, the differences and why.

Request a demoStart free