The Core Narrative

The money has left the company's bank account. But has it reached every employee's account? Bank Reconciliation is the process of matching your payroll register with the actual bank transactions to ensure that every rupee went where it was supposed to go.

Think of it as balancing a checkbook at industrial scale. The payroll system says ₹2.5 Crores was disbursed to 500 employees. The bank statement shows ₹2.48 Crores debited. Where is the ₹2 Lakh difference? Maybe 5 transactions bounced due to incorrect account numbers. Maybe the bank processed a partial file. Maybe there's a timing difference between the debit and the credit.

Reconciliation happens in two phases. Pre-Disbursement Reconciliation: Before uploading the bank file, verify that the total of individual net pays matches the file total. Post-Disbursement Reconciliation: After the bank processes the file, download the transaction status report and match every individual credit against the payroll register.

In a modern payroll setup, the bank provides real-time or next-day status files (success/failure for each transaction). The payroll team must review failures immediately—a bounced salary means an employee didn't get paid, and that's an emergency.

6.5.2

Key Takeaways

The 'Three-Way Match': Payroll Register Total = Bank File Total = Bank Statement Debit. All three must agree before reconciliation is marked as complete.

Common failure reasons: Incorrect account number, closed account, IFSC code mismatch, bank server timeout, or daily transfer limit exceeded.

Re-processing Protocol: For failed transactions, define whether you re-attempt via bank transfer, issue a cheque, or hold for the next cycle.

Timing Differences: NEFT/RTGS/IMPS have different processing times. A salary file uploaded at 4 PM via NEFT may not credit until the next business day.

6.5.3

Practical Scenarios

"A payroll team discovering that 12 salary credits failed because the bank had migrated to a new CBS (Core Banking System) over the weekend and the old IFSC codes were no longer valid—highlighting the need for periodic IFSC validation."

"A company implementing 'Same-Day Reconciliation' by switching from NEFT to IMPS for salary disbursement, allowing them to verify every credit within 2 hours of upload."

Academy Pro-Tips

Never skip post-disbursement reconciliation, even if the totals match. Individual failures can hide within matching totals if there are offsetting errors.

Maintain a 'Failed Transaction Register' that tracks every bounced salary, the reason, the resolution date, and the re-processing method. This register is an audit requirement.

Automate reconciliation by integrating your payroll system with the bank's API—many banks now offer real-time transaction status feeds that eliminate manual matching.

Points to Remember

Banks typically charge per-transaction fees for salary disbursement. Negotiating a bulk salary account with zero transaction charges can save significant costs for large organizations.
Under the Wages Protection System (WPS) in the UAE, salary disbursement must be through approved channels, and the reconciliation data is shared directly with MOHRE for compliance monitoring.

6.5.1