Payroll reporting · 3 MIN READ
How to reconcile payroll with the accounting journal and bank file
The salary register, payroll journal and bank payment file should reconcile, but they should not always show the same total. They describe different parts of the transaction. Confusing them is a common reason payroll appears correct while finance cannot close the monthly accounts.
Gross earnings describe employee remuneration before employee deductions. Net pay is the amount payable after those deductions. Employer contributions and other employer costs may create additional expense and liabilities. A bank file normally contains the amounts selected for salary payment, which may differ again if a payment has failed or requires separate handling.
Start with a small example
Assume a fictional payroll has gross earnings of ₹10,00,000 and employee deductions totalling ₹1,20,000. Net salary payable is ₹8,80,000. Assume separately that employer contributions add ₹70,000 of cost for this example.
The illustrative journal debits salary expense of ₹10,00,000 and employer-contribution expense of ₹70,000. It credits employee net-pay liability of ₹8,80,000, employee-deduction liabilities of ₹1,20,000 and employer-contribution liabilities of ₹70,000. The debits and credits both total ₹10,70,000. These are example figures, not prescribed contribution rates or a universal accounting policy.
Reconcile each liability separately
Break employee deductions into their actual destinations, such as tax, statutory contributions and approved recoveries. An employee-loan recovery may reduce a receivable rather than create a fresh statutory liability. Finance should approve the chart-of-accounts mapping.
Keep employer contributions out of employee net pay. Also separate an accrual, such as an employer benefit provision, from a cash payment due this month. The ledger treatment depends on the underlying item and the organisation’s accounting policy, not just its label in a CTC worksheet.
Explain differences in the bank file
If ₹20,000 of the ₹8,80,000 net-pay liability is not in the current bank instruction, the bank file may total ₹8,60,000. Retain an employee-level explanation and a resolution owner. The excluded amount has not ceased to be owed merely because it is absent from the payment file.
After payment, compare the bank’s successful transactions with the salary liability, failed transactions and authorised follow-up payments. Use the bank’s execution evidence rather than the upload confirmation alone.
Match statutory payment evidence
Reconcile statutory liabilities to the correct period’s return and deposit evidence. EPFO’s revamped ECR process separates filing and payment, so an approved return is not the final proof that the liability has been settled. [3]
Track outstanding differences as reconciliations, with a period and owner. Avoid clearing an unexplained balance to miscellaneous expense simply to make the control total zero.
Agree the output before the first cycle
Payroll Advisor’s published plan includes payroll JV accounting, and its reporting scope covers agreed reporting dimensions. Confirm the accounts, cost centres, entity split and file format your finance team needs. [1] [2]
Ask for one complete sample tying the salary register to the journal, statutory liabilities and bank advice. That agreement will reduce recurring manual adjustments and make the monthly handover easier to verify.
Sources & further reading
- Payroll Advisor published pricing and inclusions Company source
- Payroll Advisor reporting and insights scope Company source
- EPFO circular on revamped ECR dated 26 September 2025 Official circular
This article is general information, not individual legal or tax advice. Applicable rules depend on the financial year, state, employment terms and your circumstances. Have a correction? Contact hello@payrolladvisor.in.