Tax and GST

Matching payslip net pay to the salary credit in your bank

Payslip net pay not matching the bank credit? Reconcile salary slip with bank statement month by month, using a sample table and a notes column.

Editorial illustration for Matching payslip net pay to the salary credit in your bank

The net pay on your payslip and the salary credit in your bank often differ, and the reason is usually ordinary: a reimbursement paid separately, an advance recovered, or a credit that landed a day later. The way to explain them is a small month-by-month table with a notes column. Build it once, and each month takes a couple of minutes.

What should the two numbers be?

The net pay on a payslip is the amount your employer says it is paying you for that month, after deductions. The bank credit is the amount that actually arrived. In a clean month they are equal. In other months, something sits between them, and the sheet's job is to name it.

A worked example with invented numbers

Say your April payslip shows gross earnings of ₹90,000. Deductions are provident fund ₹5,400, professional tax ₹200 and tax deducted ₹6,400, a total of ₹12,000. Net pay is 90,000 minus 12,000 equals ₹78,000. Your bank shows a salary credit of ₹78,000, so April matches. Now look at three months:

MonthNet on payslipBank salary creditGapNote
April₹78,000₹78,000₹0Matches
May₹78,000₹75,000₹3,000Advance recovered, shown below net pay on the slip
June₹80,500₹78,000₹2,500Reimbursement paid separately on 4 July

In May, the slip lists a recovery after the net line, so the bank credit is ₹3,000 lower. In June, the net figure includes a ₹2,500 reimbursement that the employer paid in a separate transfer on 4 July, so you check the July statement for a ₹2,500 credit and note it. If the credit is not there, you have a question for payroll.

Why would they differ?

  • A reimbursement shown in net pay but paid in a separate credit
  • An advance, loan instalment or other recovery listed below the net line
  • A bonus or arrears paid in a separate transfer on a different date
  • Salary credited on the last day of the month or the first of the next, so it falls in a different statement month
  • A correction from an earlier month netted into this one
  • A transfer charge or rounding difference, which you should check against your own statement rather than assume

How do I build the sheet?

  1. Make columns: Month, Net on payslip, Bank salary credit, Gap, Note.
  2. Type the net pay from each payslip and the credit from your bank statement.
  3. In the Gap column, type =B2-C2 and copy it down, where B is net on payslip and C is the bank credit.
  4. In the Note column, write the reason for every non-zero gap in a few words.
  5. Add a total row, such as =SUM(D2:D13), to see the year's gap at a glance.

The formulas work the same way in Excel and Google Sheets. If a gap appears with no note you can write, mark it with a question and take it to payroll.

Build the habit of filling the row within a few days of the credit arriving, while the payslip email is still near the top of your inbox. A row left until December means searching through eight months of messages for one number, and the explanation for a small gap is far harder to remember than the gap itself.

What should I ask payroll?

Quote the month, the payslip net, the credit you saw and the date, and ask which component explains the difference. Keep the reply with the month's folder. If the answer is that something was paid separately, ask for the date so you can find the credit.

When does a sheet stop being enough?

A twelve-row sheet is perfect for salary. If you also want your spending, other accounts and categories next to it, SpendixAI can import statements in PDF, CSV or Excel, let you review rows before saving, and keep each transaction with its account, so the salary credits are easy to find without retyping them.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports