Tax and GST

A staff salary register: attendance, pay and advances

A one-line-per-person monthly salary register that links attendance, pay, advances and balance, with notes for UPI and cash payments and a small worked example.

Editorial illustration for A staff salary register: attendance, pay and advances

A staff salary register is one page per month with one line per person: agreed salary, days present, amount payable, advances recovered, amount paid, how it was paid and the balance of any advance. Fill it on payday and file it, and the question of whether someone has been paid is answered in seconds.

The columns to use

  1. Name and designation.
  2. Agreed monthly salary, written the day the person joined and updated only with a dated note.
  3. Days in the month and days absent, from your attendance sheet.
  4. Salary payable after any deduction for absence, using the rule you have agreed.
  5. Advance outstanding at the start of the month, advance given this month and amount recovered this month.
  6. Net amount paid, the date, and the mode: cash, UPI or bank transfer, with a reference for UPI and bank payments.
  7. Advance balance carried forward, and a signature or acknowledgement.

Write down your absence rule once and apply it to everyone. For this example, assume salary is divided by 30 for each day of absence. Your rule may be different, and it should match what you told the person at the start.

A small example with three people

Say a shop has three staff. All figures are invented to show how the columns connect.

NameSalary in rupeesAbsent daysPayable in rupeesAdvance recoveredPaidModeAdvance balance
Meena15,000214,0001,00013,000UPI2,000
Raju12,000012,000012,000Cash0
Anil18,000117,400017,400Bank transfer0

Meena's payable amount is 15,000 minus two days at 500 a day, which is 14,000 rupees. Her earlier advance was 3,000 rupees, and 1,000 is recovered this month, so she is paid 13,000 rupees and 2,000 rupees of advance remains. Anil's one absent day is 18,000 divided by 30, which is 600, so payable is 17,400. Total paid is 13,000 plus 12,000 plus 17,400, which is 42,400 rupees.

How do I handle cash and UPI payments differently?

  • Cash: get a signature or a thumb impression in the register at the time of payment.
  • UPI or bank transfer: write the reference and keep the screenshot, filed in the month's folder.
  • If one person receives part cash and part UPI, write two lines for the same person, so each movement matches one record.
  • Never pay salary from an account you use for personal spending without noting it, as that blurs your records.

How do I check the register against the bank?

At the end of the month, add the amounts paid by transfer and by UPI, and compare them with the debits on your bank statement. In the example, only Meena and Anil were paid digitally, so the statement should show 13,000 plus 17,400, that is 30,400 rupees, as salary debits. The cash paid, 12,000 rupees, should match the cash you took from the drawer or withdrew, with its own entry.

Where does a tracker help?

If you use SpendixAI, you can import the statement, review the rows and put salary debits in a Salaries category you create, then add the cash portion by hand as an expense. Pro is for one personal workspace and is not a payroll or HR tool, so it will not compute attendance or pay. Keep the register as the detailed record and let the tracker hold the totals.

What should I ask my CA?

Statutory deductions, payroll registers, payslips and any obligations as an employer depend on the size of your business, your state and the type of work. This register is a record of what you actually paid and recovered. Ask your CA which additional records you need, and whether they want a particular format.

Keep each month's register with the proof of payment in the same folder, in month order from April. If a dispute arises, the signed line and the UPI reference are the first things anyone will ask for.

SPENDIXAI JOURNAL

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

Explore your reports