How to Reconcile Payroll with Bank Payments and the Ledger

Choose the payroll month and the bank statement cut-off first. Keep the salary month separate from the payment date: a payment this month may settle an earlier month's salary. Use one approved payroll version, and retain approval for any later correction.

• ✓Approved payroll register showing employee reference, gross earnings, deductions, recoveries and net salary payable.
• ✓Salary payment files and bank processing reports, including rejected, pending and returned transactions.
• ✓Statements for every bank account used to pay salaries, plus supporting records for any other payment method.
• ✓Salary expense, salary payable, employee advance and payroll clearing ledgers, wherever used.
• ✓Opening unpaid salary schedule and approvals for off-cycle payments, recoveries and payroll corrections.

Use employee references in the reconciliation and restrict access to the underlying records. Mask bank account details in review copies. Keep this schedule alongside the month-end close checklist and the bank reconciliation monthly routine.

Start with employee-level amounts, then compare totals. Equal totals can hide one omitted employee and one duplicate payment. Match employee reference, salary month and net amount; investigate changed bank details separately through your payment approval process.

Bridge approved net salary to the payment file by listing amounts held back, payments already made separately and approved corrections. Record the reason and approval for each difference. If payroll changes after the file is prepared, check whether the file also needs replacing.

Give every payment instruction a traceable outcome: successful, rejected, pending or returned. Where the statement shows one bulk debit, use the bank's batch report to connect it to individual employees. If the report does not explain the debit, keep the difference open for investigation.

Check a retry against the original instruction before releasing it. Record both references together so the reviewer can see why two instructions exist and whether only one settled the salary.

Prepare a roll-forward: opening unpaid salaries, plus approved net salary recognised, plus or minus supported adjustments, less salary settlements, equals closing unpaid salaries. Define adjustments clearly so a returned payment or correction appears once in the calculation.

Compare that closing figure with the salary payable ledger and the employee-wise unpaid schedule. Separately match the payroll posting to expense and deduction accounts. A payment may include an advance or reimbursement, so identify each component before allocating the bank debit.

If you use a payroll clearing account, explain its remaining balance by transaction. Do not move an unexplained difference into salary expense simply to make the account balance. Give every unresolved item an owner, supporting record and next action.

Illustrative example only: opening unpaid salaries are Rs 20,000 and approved net salaries for the month are Rs 5,00,000. A regular payment file contains Rs 4,70,000; Rs 30,000 is held back. Of the file total, Rs 10,000 is rejected before debit and Rs 15,000 is debited but later returned.

Separate successful payments settle the opening Rs 20,000 and Rs 10,000 of the current month's held salary. All figures below are illustrative, and the return occurs before the chosen bank cut-off.

The bank shows salary debits of Rs 4,90,000 and a return credit of Rs 15,000: net settlements are Rs 4,75,000. Opening dues plus current payroll total Rs 5,20,000, leaving Rs 45,000 unpaid. The ledger and employee schedule should explain that same balance.

For an off-cycle payment, establish what it settles before posting it: an existing unpaid salary, an additional approved earning, an advance or a reimbursement. Link it to the employee and approval. Include additional earnings in an approved supplementary register so they are not omitted or recognised twice.

For an approved advance recovery deducted through payroll, match the recovery to the employee's advance balance and check that net salary reflects it once. For money repaid directly by an employee, trace the bank receipt separately. Identify the original transaction before deciding which ledger balance to reduce.

List each unpaid amount by employee, salary month, reason, payment status and next action. Distinguish a rejected transfer from a pending instruction or an approved hold. Check subsequent bank activity to resolve uncertain outcomes, while preserving the position at the month-end cut-off.

Carry supported unpaid amounts forward rather than treating the close as a reason to clear them. Where salary expense has not yet entered payroll, review it separately using the accrued expenses supporting schedule so the same amount is not recognised twice.

• Treating a file upload or approval as proof that every employee was paid.
• Comparing only batch totals and missing employee-level duplicates or omissions.
• Retrying an uncertain payment before checking its final outcome.
• Leaving returned salaries marked as settled in the ledger.
• Recording an advance recovery twice or overlooking a separate payment.
• Clearing unpaid salaries or payroll clearing differences without support.

Before signing off, check that payroll agrees with the ledger posting, every payment has an explained outcome, bank movements agree with the books, and closing unpaid salaries agree with the employee schedule. Record exceptions and review actions explicitly. This routine excludes statutory deduction calculations and remittance reconciliation.