Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A single bulk salary NEFT for 400 employees appears as one bank debit but must align with a 400-row payroll register containing gross pay, Section 192 TDS, PF (12% employee plus 3.67% EPF plus 8.33% EPS plus EDLI plus admin), ESI (3.25% plus 0.75%), and professional tax. TDS, PF, and ESI generate three separate challan debits on three different portals with three different deadlines.
Four-way reconciliation matches (1) bulk salary NEFT debit to the sum of employee net pay using the bank bulk-payment acknowledgement file with per-employee UTR; (2) Section 192 TDS debit to Challan ITNS 281 CIN (BSR code plus date plus serial) on TRACES by the 7th; (3) PF debit to EPFO ECR portal TRRN by the 15th; (4) ESI debit to ESIC portal challan by the 15th. Off-cycle arrear payments are tagged with a distinct reference code.
Bulk-payment acknowledgement file ingestion, Challan ITNS 281 CIN tracker, EPFO TRRN tracker, ESIC employer-registration-number tracker, and off-cycle payment tagging.
Employee-level matched net pay ledger, Section 192 TDS credit aligned to Form 26AS via BSR CIN, reconciled PF contribution against EPFO ECR, reconciled ESI contribution against ESIC challan, and off-cycle arrear audit trail.
Salary payroll bank reconciliation in India involves matching three separate bank outflows — the net salary NEFT, the TDS deposit, and the statutory contribution challans — against a single itemised payroll register. Each outflow has a different timing, a different match key, and a different portal for verification. For companies with headcounts above 100, this is among the most document-intensive reconciliation tasks in the monthly cycle.
The Core Reconciliation Problem
A monthly payroll for 400 employees produces one bank debit (the bulk salary NEFT), but that single debit must align with a payroll register that contains 400 rows of gross salary, TDS deducted, PF deducted, ESI deducted, professional tax deducted, and net pay.
The bank debit equals the sum of net pay across all employees. The payroll register total equals gross pay minus all deductions. If any deduction was computed incorrectly — a salary revision applied to only part of the month, an arrear paid in the same run, a contractor incorrectly classified as an employee — the net pay total will not match the bank debit.
Beyond the salary NEFT itself, the company must separately reconcile: (1) TDS under Section 192 deposited via Challan ITNS 281; (2) PF contributions paid via EPFO’s ECR portal; and (3) ESI contributions paid via the ESIC portal. Each produces a separate bank debit, on a different date, against a different regulatory portal record.
How Bulk Salary NEFT Appears in Bank Statements
Bulk salary NEFT batches are processed through the bank’s bulk payment upload portal (HDFC NetBanking Bulk, SBI YONO Business Corporate, ICICI CIB). The narration format follows the bank’s default template: “NEFT DR BULK SALARY [MONTH][YEAR] [N] EMP” or “BULK SAL NEFT [N]EMPS REF[YYYYMMDD]”.
The bank debit in the statement represents the sum of all individual employee credits. The bank’s bulk payment acknowledgement file — downloaded separately after the batch processes — contains each employee’s account number, the credited amount, and the individual UTR. This acknowledgement file, not the single-line bank statement debit, is the document needed to reconcile at the employee level.
The Four-Component Matching Sequence
Step 1: Payroll File to Bank Debit
The payroll register’s net pay column total must equal the bank debit amount on salary day. Verify both figures before proceeding to the component-level checks. A variance at this step means either the payroll register was modified after the bank transfer was initiated, or an employee was added or removed from the run at the last stage.
Step 2: TDS Deposit to TDS Ledger
TDS deducted from salaries under Section 192 must be deposited by the 7th of the following month (30 April for March deductions). The Challan ITNS 281 generates a CIN (Challan Identification Number: 7-digit BSR code + 8-digit date + 5-digit serial number). This CIN is the match key against the TDS ledger and against TRACES, where the challan status becomes verifiable within 3–5 working days of deposit. Match the TDS bank debit against the TDS payable ledger entry and the TRACES challan status.
Step 3: PF Challan to EPFO Records
PF contributions are deposited via EPFO’s ECR (Electronic Challan cum Return) portal. The TRRN (Transaction Reference Number) generated by the portal is the match key. The bank debit narration from EPFO’s payment gateway typically carries the TRRN and the month. Total PF debit = employee PF (12% of basic) + employer EPF (3.67%) + EPS (8.33%) + EDLI (0.5%) + admin charges (0.5%). The PF challan deadline is the 15th of the following month. Match the bank debit date, TRRN, and amount against the ECR challan download.
Step 4: ESI Challan to ESIC Records
ESI contributions are deposited via esic.gov.in. The bank debit narration carries the ESIC employer registration number and challan month. Total ESI debit = employer share (3.25%) + employee share (0.75%) for all employees earning ₹21,000 or below. ESI applies only to employees below the wage ceiling — employees whose salary crossed ₹21,000 mid-year are covered until the end of the contribution period. The ESI challan deadline is also the 15th of the following month.
Payroll Reconciliation Component Reference Table
| Payroll Component | Bank Debit Type | Match Key | Timing vs Salary Date | Common Mismatch |
|---|---|---|---|---|
| Net salary (all employees) | Bulk NEFT batch debit | Bank acknowledgement file per employee UTR | Same day as payroll run (typically 28th–1st) | Off-cycle arrear payment not in main register |
| TDS Section 192 deposit | Single NEFT/OLTAS debit to government | CIN from Challan ITNS 281 via TRACES | By 7th of following month (30 April for March) | TDS computed on old salary slab after revision |
| PF contribution (employer + employee) | EPFO gateway debit | TRRN from ECR portal | By 15th of following month | Employee above ₹15,000 basic excluded from PF but still listed |
| ESI contribution (employer + employee) | ESIC portal debit | ESIC employer registration number + challan month | By 15th of following month | Employee crossed ₹21,000 mid-year, incorrectly included |
| Professional tax deduction | State treasury debit (varies by state) | PT challan reference number | Varies by state — typically monthly or quarterly | Wrong state PT slab applied after employee transfer |
Where Salary Payroll Bank Reconciliation Breaks
Salary revision mid-month. When an employee’s salary is revised effective the 15th of the month, the payroll register must carry the old salary for days 1–14 and the new salary for days 15–30. If the HRMS calculates the blended amount but the bank transfer uses the prior month’s standing instruction, the bank debit will not match the register total.
Contractor vs employee misclassification. Contractors paid through the payroll system are not subject to Section 192 (salary TDS) — they are subject to Section 194C (contractor TDS at 1% or 2%) or Section 194J (professional services at 10%). If a contractor is added to the payroll register, the TDS is computed under the wrong section, the deposit goes to the wrong TDS code, and the mismatch will surface both in the bank reconciliation and in TRACES when the quarterly TDS return is filed.
Arrear payments. Arrears paid in the current month for prior months must be tagged separately in the payroll file. They affect gross pay, TDS (arrears are taxable in the year of receipt and must be assessed under Section 89 relief if applicable), and PF (arrears increase the PF contribution for the payment month). Without a separate arrear tag, the reconciliation engine treats the higher-than-expected debit as an unexplained variance.
For companies where TDS classification between Section 192 (salary) and 194J (professional fees) creates reconciliation differences, invoice matching TDS net gross India covers the gross vs net payment matching approach in detail.
Reconciliation software India that ingests the payroll register as a structured input file — not just the bank statement — can auto-match payroll components against their respective bank debits, flag TDS deposit timing exceptions, and identify TRRN-based PF mismatches before the statutory deadlines.
For the TDS deposit component specifically, TDS reconciliation software that integrates with TRACES and validates CIN status reduces the manual effort of verifying that Section 192 deposits have been accepted before the quarterly TDS return deadline.
Payroll reconciliation control standards and salary disbursement audit evidence requirements for Indian companies are addressed in guidance published by the Institute of Chartered Accountants of India (ICAI), which sets the standard for documentation required by statutory auditors reviewing payroll processes.