Salary Arrears Tracker in Excel: Free Template and How to Use It

Salary revisions do not always reach payroll in the month they are approved. An increment may be effective from July but signed off in September. A promotion may come through after payroll is closed. The calculation itself is not usually the difficult part. Keeping track of who is owed what, for which months, and whether the amount has been checked is where mistakes happen.

That is why I prefer a running tracker over separate calculations saved in different folders. You can see the pending revisions together, and the next person handling payroll can understand what has been done without starting again.

Why Arrears Need an Excel Tracker and Not Just a Formula

The arithmetic of an arrear is easy. Revised pay minus old pay, multiplied by the number of months, is the whole idea. The difficulty is that arrears are almost never one employee and one clean date. An increment letter is signed in September for a July effective date. A promotion is approved for three people in the same week. Someone resigns before their arrear is paid. And every one of these needs to be remembered at the next payroll run, by a person who may not have been in the meeting.

That is the job a tracker does. It does not replace the calculation, which I have explained separately in our guide to the salary arrears calculation. What it adds is a record: who is owed what, from which date, how far salary has been paid, and whether anyone has reviewed the number.

What the Salary Arrears Tracker Contains

Each row is one employee. You enter an employee ID and name, the old monthly pay, the revised monthly pay, the date the revision takes effect, and the date through which salary has been paid. The grey columns then fill themselves: the number of full months, the monthly difference, the base arrear and, after any manual adjustment you add, the estimated arrear. A review status and a notes column sit at the end, so you can mark a row as pending or reviewed.

Two sample rows are already in the file so you can see how it behaves. The sheet has an instructions tab as well, and the formula cells are separated from the input cells by colour so that nobody types over a formula by accident.

The workbook includes two sample rows and an instructions tab. Input fields are visually separated from formula cells. I would still ask the reviewer to check the dates against the original salary approval, rather than relying only on the spreadsheet.

When to Use It

Reach for the tracker the moment a revision is approved with an effective date that is earlier than the payroll month you are about to run. That covers back-dated increments, promotions, correction of a wrongly entered salary, and revisions that were approved in one month and processed in another.

It is also useful in the other direction, as a reminder. If you keep one tracker open through the year, you can see at a glance which arrears have been calculated and which are still waiting for approval, and you are less likely to find out in March that an increment from June was never paid.

How to Fill It, Step by Step

Take the first sample row. Asha earns ₹40,000 and her pay is revised to ₹44,000 from 1 July 2026. Salary has been paid through 30 September 2026. Enter those four values and the tracker reads three full months, July, August and September, with a monthly difference of ₹4,000. The arrear comes to ₹12,000.

The second sample is where care is needed. Rahul moves from ₹35,000 to ₹37,000 from 15 August 2026. The tracker works in full calendar months, so a revision starting on the 15th is not something the formula counts. It shows REVIEW DATES in the month-count column instead of a number, which is your signal to step in. You work out the partial month separately, using whichever method your policy follows, whether calendar days or a fixed 30-day month, and add the amount in the Manual Adjustment column. The estimated arrear then includes it, and your note records how you got there.

Once the numbers are in, mark the row for review. A second person should check the old pay, the effective date and the paid-through date, because a wrong date is the most common reason an arrear goes wrong.

What about a mid-month increment?

The second sample is where care is needed. Rahul moves from ₹35,000 to ₹37,000 effective 15 August 2026. The template works in complete calendar months, so it flags a mid-month date for review rather than treating August as a full month.

Calculate the partial period separately using your company’s applicable payroll method-calendar days, fixed 30-day method or another documented policy-and enter the appropriate amount in Manual Adjustment. Record the method and the supporting approval in Notes. A reviewer should check the calculation before the arrear enters payroll.

Common Mistakes With Arrears Sheets

The first is counting the wrong months, usually because the paid-through date was copied from the wrong payroll. The second is paying the full difference without checking whether the employee had loss of pay in those months, which changes the base. The third is leaving partial months out entirely because the formula returned nothing, so the employee is underpaid and nobody notices until they ask.

A fourth, quieter one: keeping a separate arrears file for every revision cycle. By the next year no one knows which file is current. One running tracker with a review status is easier to audit.

What the Tracker Does Not Do

This matters, so I will be clear. The sheet gives an estimated gross salary difference. It does not automatically determine PF contributions, TDS, tax relief, or the correct treatment of every historical attendance change. PF depends on the nature of the salary component and the applicable rules; tax treatment depends on the employee’s circumstances and relevant financial year.

Use the tracker to prepare and review the calculation, then confirm statutory treatment with your payroll or tax adviser before finalising payment. Our EPF calculator can help with a separate estimate, but it is not a substitute for checking PF applicability on arrears.

Salary Arrears Calculator vs Salary Arrears Excel Tracker

Both can be useful, but they solve slightly different problems. I would use a calculation guide to understand the method and the tracker to manage the work across employees.

When Is Excel Enough, and When Should HR Use Payroll Software?

For a small number of salary revisions each year, an Excel tracker may be perfectly adequate. It keeps calculations organized and gives HR a simple way to record pending work. The challenge grows when several employees receive revisions, when effective dates differ, or when arrears need to be reconciled with attendance, deductions and monthly payroll.

At that point, payroll software is required and Runtime HRMS brings employee salary records and payroll processing into one system. If your team is handling frequent revisions, ask for a walkthrough of the exact salary-revision and arrears workflow before deciding whether it fits your process.

FAQs

What is a salary arrears tracker?

It is a spreadsheet for recording backdated pay revisions, estimating salary differences and tracking review or approval.

How do I handle an increment that starts mid-month?

Use the applicable company payroll method to calculate the partial period, enter it as a manual adjustment and record the basis in the notes column.

Is PF deducted on salary arrears?

It depends on whether the relevant salary component forms part of PF wages and on applicable EPF rules. Verify before processing.

Our Other Helpful Resources

Official references: Income Tax Department | EPFO | Ministry of Labour and Employment

Disclaimer

This template and guide are for general use. Payroll, PF and tax treatment of arrears depends on your policy, salary structure and the law in force at the time. Verify figures and confirm treatment with your CA before relying on them.