
Payroll reconciliation is the check between the payroll calculation and the records that support it. Before salaries are released, the payroll total should agree with employee master data, attendance inputs, approved changes, deductions, the bank payment file and the accounting entry.
A short review before payout is usually easier than correcting an employee's pay, a tax deduction or a ledger posting later. This monthly payroll reconciliation checklist gives small finance and HR teams a repeatable process.
1. Lock the payroll period and inputs
Set a clear cut-off date for attendance, leave, incentives, reimbursements and employee changes. Record any item received after the cut-off for authorised handling in the current or next cycle.
Confirm that the payroll period and payment date are correct. A duplicated or missing day can affect every employee in the run.
Create an input register with:
- the source of each input;
- the person who approved it;
- the date it was received;
- the payroll period it belongs to;
- any exception that still needs a decision.
This register makes late changes visible and gives the reviewer a list to work through.
2. Reconcile the employee master
Compare the current employee list with the previous month's final payroll. Every addition, removal or change should have supporting approval.
Review new joiners for their start date, salary terms, bank details, PAN and other required records. For employees who left, check the last working date, unpaid days, recoveries and the items included in the final settlement.
Pay particular attention to changed bank accounts, revised salary structures, transfers and status changes. These fields can alter the amount paid or where it is sent. Restrict who can edit them and retain an audit trail.
A useful control is a change report that shows the old value, new value, effective date and approver.
3. Match attendance and leave
Reconcile payable days to the approved attendance source. Review absences, unpaid leave, overtime, shift information and attendance corrections separately.
For joiners and leavers, test the proration calculation against the organisation's documented payroll policy. If the payroll system uses calendar days, working days or another basis, apply the method consistently.
Investigate unusual results rather than accepting the system output. Examples include an employee with zero attendance but full pay, overtime without approval, or an unpaid-leave deduction that is much larger than normal.
4. Recalculate gross pay and deductions
For a sample of employees, independently recalculate gross pay from the approved salary structure and current-period inputs. Include fixed earnings and any approved variable items.
Then review each deduction. Depending on the employer and employee, payroll may include tax deducted at source, provident fund, employee state insurance, professional tax, loan recovery or other authorised deductions. Applicability and calculation rules are not identical for every business or state, so the payroll setup should reflect the rules that apply to the organisation.
Check that reimbursements are classified correctly and supported by approvals. Keep salary, reimbursement and recovery items distinct in the payroll register and ledger mapping.
5. Compare totals with the previous month
A month-on-month variance report is one of the quickest ways to find errors. Compare:
- employee count;
- gross payroll;
- each major earning and deduction category;
- net pay;
- employer contributions;
- the value of new-joiner, exit and arrears items.
Explain material changes at employee level. A higher payroll total may be correct because of new hires or bonuses, but the reason should be documented before the payment is approved.
Also scan for duplicate bank accounts, duplicate employee IDs, negative net pay, unusually large payments and round-number adjustments.
6. Tie net pay to the bank file
The total net pay in the approved payroll register should equal the total in the bank upload file. If they differ, stop and identify the cause.
Confirm that the bank file includes only authorised employees and approved final settlements. Review failed or returned payments separately. Do not mark salary as paid until the bank result supports that status.
Use maker-checker access where the bank permits it. The person who prepares payroll should not be the only person who approves the payment file.
7. Review salary TDS records
Reconcile salary TDS in the payroll register to the amount scheduled for deposit and to the accounting entry. Check employee identifiers, the applicable tax-year setup and any approved declarations or evidence used in the calculation.
For transactions from 1 April 2026, the Income Tax Department states that salary withholding falls under section 392 of the Income Tax Act, 2025. Its tax-payment guidance says TDS is generally deposited by the seventh day of the following month, with specified exceptions.
The Department's Form 138 user manual describes Form 138, previously Form 24Q, as the quarterly statement for reporting salary TDS. The listed filing dates are 31 July, 31 October, 31 January and 31 May for the four quarters respectively. Confirm the live portal instructions and current calendar before filing.
Monthly reconciliation helps the quarterly statement start from reviewed data instead of a rushed reconstruction.
8. Post payroll to the books
Map gross salary, reimbursements, employee deductions, employer contributions and payroll liabilities to the correct ledger accounts. The payroll journal should balance, and the net-pay clearing amount should agree with the bank file.
After payment and statutory remittances, clear the relevant liabilities against bank entries. Investigate old balances instead of rolling them forward without explanation.
Keep the final payroll register, approval evidence, bank confirmation, challans, return acknowledgements and reconciliation notes in a controlled folder for the period.
A practical sign-off record
A monthly sign-off can be brief. It should identify who prepared the payroll, who reviewed it, the version approved, total gross pay, total deductions, net pay, unresolved exceptions and the date of bank authorisation.
If the same exception returns each month, fix the source process. Common examples are late attendance data, missing employee documents, manual salary adjustments and inconsistent ledger coding.
When payroll support helps
As the employee count grows, payroll errors often come from hand-offs between HR, attendance, finance, tax and banking systems. ProTax's TDS & Payroll Compliance service can help organise the monthly payroll cycle, reconcile TDS records and prepare recurring compliance work. The scope should be agreed around the employer's workforce, systems and applicable obligations.
Frequently asked questions
What is the difference between payroll validation and payroll reconciliation?
Validation checks whether individual inputs and calculations are correct. Reconciliation confirms that totals agree across payroll, bank, tax and accounting records. A sound monthly review uses both.
Who should review the payroll?
Use a reviewer with enough access to verify source records but independent from the person who prepared the final file. Small businesses can document compensating checks when staffing makes full separation difficult.
Should payroll be reconciled before or after payment?
Do the main reconciliation before payment. Complete a second check after payment to match bank results, record failed transactions and clear payroll liabilities.
How long should payroll records be kept?
Retention depends on the type of record and the laws that apply to the employer. Set a written schedule with professional advice, protect sensitive employee data and do not delete records solely because a payroll cycle has closed.
