Payroll Reconciliation: Complete Process, Checklist & Journal Entries

What is payroll reconciliation? Payroll reconciliation is the process of comparing payroll calculations with employee master data, attendance, deductions, the payroll register, general ledger, bank payments and statutory liabilities so that every material difference is identified and explained before the period is closed.

It is an important month-end control because payroll involves several connected records—including attendance, salary structure, payroll register, general ledger, bank payments, PF, ESI, professional tax and TDS.

A difference between any of these records may result in incorrect employee payments, statutory liabilities, accounting errors or unexplained balances in the general ledger.

In this guide, we will understand the complete payroll reconciliation process with a practical example, accounting entries, common reconciliation differences and a month-end checklist.

What Is Payroll Reconciliation?

Payroll reconciliation means comparing the payroll calculated by the HR/payroll system with the corresponding accounting, banking and statutory records.

A typical reconciliation can be represented as:

Employee Master → Attendance → Payroll Calculation → Gross Salary → Deductions → Net Salary → Payroll Journal → Bank Payment → Statutory Payments → General Ledger Reconciliation

The objective is not simply to confirm that employees received their salaries.

The objective is to ensure that:

differences are identified, investigated and documented.

gross salary is correctly calculated;

employee deductions are correctly recorded;

employer contributions are accounted for;

net salary agrees with the bank payment;

statutory liabilities are correctly recorded and subsequently cleared;

payroll expenses agree with the general ledger; and

Practical Payroll Reconciliation Example

Suppose a company processes payroll for a month with the following figures:

The amounts above are illustrative examples only and are not intended to represent statutory rates or thresholds.

The payroll team should not stop after confirming that the payroll system shows net salary of ₹4,40,000. The amount needs to be reconciled with the accounting records and actual payment.

For example:

Payroll Register Gross Salary: ₹5,00,000
Gross Salary recorded in General Ledger: ₹5,00,000
Difference: ₹0

Next:

Payroll Register Net Salary: ₹4,40,000
Salary Payable in General Ledger: ₹4,40,000
Bank Salary Payment: ₹4,40,000
Difference: ₹0

If the bank statement instead shows a payment of ₹4,35,000, there is a ₹5,000 difference that needs to be investigated.

Possible reasons may include an employee payment being held, incorrect bank details, a rejected bank transfer, an adjustment made after payroll processing, or an amount paid separately.

This illustrates the main purpose of payroll reconciliation: every material difference should have an explanation and supporting documentation.

Employee-Level Payroll Exception Example

Assume Employee A has a net salary of ₹42,500 in the payroll register, but the bank file shows only ₹40,000 paid. The ₹2,500 difference should be traced to the employee-level payment file. Common causes include a rejected transfer, salary hold, late adjustment, or an amount paid separately. The exception should remain open until the reason and supporting evidence are documented.

For the bank-payment side of this control, you can also use our Bank Reconciliation guide and BRS template.

You can also download our ready-to-use Payroll Reconciliation Excel template with employee-level checks, statutory reconciliation and a worked example.

It’s advisable to perform payroll reconciliation regularly—ideally on a monthly basis—to capture any issues promptly. Additionally, utilizing payroll software can significantly streamline this process, allowing businesses to efficiently manage data and reduce the likelihood of errors.

Complete Payroll Reconciliation Process

Payroll reconciliation should follow a structured process so that salary expenses, deductions, liabilities and payments can be traced from the payroll system to the accounting records.

1. Verify Employee Master Data

Start by reviewing important employee information used for payroll processing.

This may include employee ID, department, designation, salary structure, bank details, joining or relieving date and applicable deduction information.

Changes such as new joiners, resignations, salary revisions and bank-account updates should be properly authorised before payroll is processed.

2. Reconcile Attendance and Payroll Inputs

Payroll calculations may depend on attendance, leave, overtime, incentives, arrears and other monthly inputs.

The payroll team should therefore compare approved attendance and payroll inputs with the data used in the payroll system.

For example, if an employee has two days of unpaid leave but payroll was calculated using full attendance, the salary may be overstated.

3. Reconcile Gross Salary

Compare the total gross salary in the payroll register with the salary expense recorded in the General Ledger.

For example:

Payroll Register Gross Salary: ₹5,00,000
Salary Expense in GL: ₹5,00,000
Difference: ₹0

Any difference should be investigated before the month-end payroll reconciliation is signed off.

4. Verify Employee Deductions

Next, reconcile deductions appearing in the payroll register.

Depending on the employee and applicable requirements, these may include PF, ESI, TDS, professional tax, loan recovery, salary advance recovery or other authorised deductions.

Each deduction should agree with the corresponding liability or recovery account in the General Ledger.

Statutory rates, limits and eligibility conditions can change, so applicable requirements should be checked against current official guidance.

5. Verify Employer Contributions

Certain payroll costs may include employer contributions in addition to employee deductions.

These expenses should be separately recorded and reconciled with the relevant liability accounts and supporting payroll schedules.

The important control is to ensure that the amount calculated by payroll agrees with the amount recorded in the accounting system.

6. Reconcile Net Salary Payable

After all applicable deductions, the resulting net salary should agree with the Salary Payable account.

Using our example:

Gross Salary: ₹5,00,000
Total Employee Deductions: ₹60,000
Net Salary Payable: ₹4,40,000

The ₹4,40,000 should be traceable from the payroll register to the General Ledger.

7. Match Salary Payment With Bank Records

Once salaries are paid, compare the bank payment report or bank statement with the payroll register.

Do not investigate only the total amount. Rejected transfers, duplicate payments, held salaries or incorrect employee bank details may create differences even when most employees have been paid correctly.

Any unsuccessful salary payment should remain identifiable until it is corrected or paid.

8. Reconcile Statutory Liabilities

Payroll-related statutory liabilities should be reconciled separately.

This can include applicable PF, ESI, TDS and professional-tax liabilities.

The process should generally compare:

Payroll calculation → General Ledger liability → Return/Challan → Actual payment

A liability should not simply disappear from the accounting records without appropriate supporting documentation.

9. Review Payroll Journal Entries

Verify that payroll journal entries correctly classify salary expenses, employee deductions, employer contributions and payable balances.

The total debit and credit amounts should balance, and the amounts should agree with the payroll reconciliation schedule.

We will show the journal entries separately below.

10. Review Month-on-Month Variances

Compare the current month’s payroll with the previous month.

Significant changes may arise because of new employees, resignations, increments, bonuses, overtime, unpaid leave, incentives or one-time adjustments.

Large or unusual movements should have a reasonable explanation.

11. Review Payroll Accruals and Provisions

At month-end, review expenses that may relate to the current accounting period but have not yet been paid or finally processed.

Depending on company policy and applicable accounting requirements, this could include unpaid salary, incentives, bonus-related amounts, leave-related obligations or other payroll accruals.

The objective is to record expenses in the appropriate accounting period.

12. Document and Sign Off the Reconciliation

Finally, prepare and retain the reconciliation with supporting documents.

Any differences should show the reason, responsible person, corrective action and status.

A reviewer should verify the reconciliation according to the company’s approval and internal-control process.

Payroll Journal Entries with Example

Using the practical example above, assume the following monthly payroll:

The entries below are simplified examples for understanding the accounting flow. Actual payroll accounting can vary depending on the organisation’s salary structure, statutory applicability and chart of accounts.

1. Entry for Salary Booking

When monthly payroll is recognised:

Journal Entry:

Salary Expense A/c Dr. ₹5,00,000
    To Employee PF Payable A/c ₹30,000
    To ESI Payable A/c ₹4,000
    To TDS Payable A/c ₹20,000
    To Other Deductions Payable A/c ₹6,000
    To Salary Payable A/c ₹4,40,000

This entry records the gross salary expense and creates liabilities for the employee deductions and net salary payable.

2. Entry When Net Salary Is Paid

When ₹4,40,000 is transferred to employees:

Journal Entry:

Salary Payable A/c Dr. ₹4,40,000
    To Bank A/c ₹4,40,000

After successful payment, the Salary Payable balance relating to these payments should be cleared.

3. Employer Contribution Entry

Employer contributions are normally recorded separately from employee deductions.

For illustration, assume the applicable employer contribution calculated by the payroll system is ₹35,000.

Journal Entry:

Employer Contribution Expense A/c Dr. ₹35,000
    To Statutory Contribution Payable A/c ₹35,000

The ₹35,000 amount is only an illustration. Actual employer contributions should be calculated according to the applicable statutory provisions and employee eligibility.

4. Entry When Statutory Liabilities Are Paid

When applicable payroll liabilities are remitted to the relevant authorities:

Statutory Payable A/c Dr.
    To Bank A/c

The amount paid should be reconciled with the payroll records, General Ledger, applicable return or challan, and bank payment. If the bank-side balance or transaction does not agree, use a bank reconciliation to identify timing differences, rejected transfers or posting errors.

Payroll Reconciliation Control

After posting the journal entries, confirm that:

Gross Payroll → Salary Expense GL
Net Payroll → Salary Payable GL → Bank Payment
Employee Deductions → Liability Accounts
Employer Contributions → Expense + Liability Accounts
Statutory Liabilities → Challans/Returns → Bank Payment

Any unexplained difference should be investigated and documented before the payroll reconciliation is closed.

Important: The figures used above are illustrative examples and should not be treated as current PF, ESI, TDS or other statutory rates or thresholds.

Common Payroll Reconciliation Differences

Payroll reconciliation often identifies differences between the payroll register, General Ledger, statutory records and actual bank payments. The important part is not only finding the difference but also understanding its cause and documenting the correction.

Example of a Payroll Difference

Suppose the payroll register shows net salary payable of ₹4,40,000, but the bank statement shows only ₹4,35,000 paid.

Difference = ₹5,000

The payroll team should not simply adjust the ₹5,000 difference to make the accounts match. First investigate the reason.

For example, one employee’s ₹5,000 payment may have been rejected because of incorrect bank details. In that case, the unpaid amount should remain appropriately recorded as a liability until the payment is successfully processed.

This creates a clear audit trail:

Payroll Register ₹4,40,000 → Bank Payment ₹4,35,000 → Unpaid/Rejected ₹5,000 → Difference Explained

Every material reconciliation difference should have supporting documentation, an identified reason and, where required, corrective action.

Month-End Payroll Reconciliation Checklist

Before closing payroll for the month, the HR, Payroll and Finance teams should complete the following checks:

☐ Verify new joiners, resignations and employee master changes.

☐ Reconcile attendance, leave, overtime, incentives, arrears and other payroll inputs.

☐ Match gross salary in the payroll register with the General Ledger.

☐ Reconcile employee deductions and employer contributions with the payroll records.

☐ Verify net salary payable with the salary payment file and bank statement.

☐ Investigate rejected, returned or unpaid salary transactions.

☐ Reconcile PF, ESI, professional tax, TDS and other applicable statutory liabilities.

☐ Verify statutory payments and applicable challans/returns.

☐ Review salary payable and other payroll liability accounts for old outstanding balances.

☐ Review payroll accruals and provisions.

☐ Compare current-month payroll with the previous month and investigate significant variances.

☐ Verify that payroll journal entries are complete and correctly posted.

☐ Document all reconciliation differences and corrective actions.

☐ Attach supporting reports and schedules to the reconciliation.

☐ Obtain reviewer/manager sign-off before closing the reconciliation.

Final Payroll Reconciliation Check

A completed payroll reconciliation should establish a clear trail:

Employee Master → Attendance & Payroll Inputs → Gross Salary → Deductions → Net Salary → Payroll Journal → Bank Payment → Statutory Payments → General Ledger

The reconciliation is complete only when material differences have been investigated, explained and appropriately documented.