Salary Advance Register Format — Free Excel and App
A salary advance register records advances paid to employees and how they are recovered from later pay.
It keeps a clear trail of how much each employee owes and how much is left to recover.
Salary Advance Register format preview
| Date | Employee name | Advance amount | Reason | Recovery per month | Recovered so far | Balance |
|---|---|---|---|---|---|---|
| 12-Nov-2026 | Ramesh Kumar | ₹6,000 | Medical | ₹1,000 | ₹0 | ₹6,000 |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Employee name
Example: Ramesh Kumar
Advance amount
Example: ₹6,000
Reason
Example: Medical
Recovery per month
Example: ₹1,000
Recovered so far
Example: ₹0
Balance
Example: ₹6,000
Please note: Rules on which records you must keep, and in what layout, can differ by state and by business type. Check the requirement that applies to you with your CA or labour consultant before adopting any format.
Salary Advance Register FAQs
What is a salary advance register?
A record of advances given to staff and the recoveries made from their pay.
How is the balance calculated?
Advance amount minus the total recovered so far.
Why note the reason?
It helps review approvals and plan recovery.
Does it link to the wage register?
Yes. The recovery amount feeds the advance recovered column in your wage register.
Related registers
Running a manufacturing business? See Recordbook for manufacturing · Recordbook vs Excel