Health and family

Attendant pay and advances: a monthly record for a patient at home

An attendant salary advance record for a patient at home: monthly pay, advances taken and days worked, so the final settlement is clear to both sides.

Editorial illustration for Attendant pay and advances: a monthly record for a patient at home

An attendant salary advance record needs one row per month with the agreed pay, days worked, each advance with its date, and a running balance. When the month closes, the amount payable is simply pay minus any absence deduction minus advances. Written down and acknowledged each month, this prevents the awkward final-settlement conversation.

When someone helps look after a patient at home, a monthly salary often comes with advances for a festival, a family event or an emergency. Without a record, both sides remember different figures. A sheet that you both look at is fair to the attendant too.

What should the record show?

  • Agreed monthly pay, and the date it is normally paid.
  • Days worked, days of leave and whether leave is paid or unpaid under your arrangement.
  • Each advance: date, amount and how it was paid.
  • Repayments or deductions, with the month each applies to.
  • Balance of advances still outstanding.
  • A signed or messaged acknowledgement from the attendant for each payment.

Agree the leave and deduction rules at the start and note them on the sheet. Wage and employment rules for domestic and care workers can vary, so if you are unsure about notice, leave or final dues, check with a local professional or the relevant authority.

How is a month's payment worked out?

Say the monthly pay is ₹18,000 for a 30-day month. A day is worth 18,000 divided by 30, which is ₹600. The attendant is absent for two unpaid days, so the deduction is 2 times 600, or ₹1,200, leaving ₹16,800. Advances taken that month were ₹5,000 on the 8th and ₹2,000 on the 20th, totalling ₹7,000.

LineWorkingAmount (₹)
Agreed payMonthly18,000
Unpaid absence2 days at 600-1,200
Pay for the month18,000 - 1,20016,800
Advances taken5,000 + 2,000-7,000
Paid at month end16,800 - 7,0009,800

If you agreed to recover advances in instalments instead, the sheet shows the instalment, not the full amount, and the balance carried forward.

How do you build the sheet?

  1. Column A: month. Column B: agreed pay. Column C: days of unpaid leave. Column D: advances taken that month.
  2. Column E, deduction for absence: =B2/30*C2 for a 30-day month, or divide by the actual days in the month if that is what you agreed.
  3. Column F, payable: =B2-E2-D2.
  4. Column G, advances outstanding: previous balance plus new advances minus recovered amounts.

Keep a separate small table for the advances themselves, with a date and amount per row, and use =SUMIFS on the month to bring them into column D.

What about the final settlement?

When the work ends, the record gives you the last month's pay, any unpaid leave, advances still outstanding and anything you agreed to pay for notice or a gift. Add them, subtract what is owed back, and share the sheet before paying. If something is disputed, you both have the same dated figures to discuss. For anything beyond that, such as dues the law may require, speak to a local professional.

If the attendant is paid through the bank, upload the statement to SpendixAI and the payments land in your own care category, each reviewed before saving. Cash advances can be added by hand. The advance balance itself stays in your sheet, since SpendixAI is an expense tracker.

A monthly checklist

  • Count days worked and leave on the last day of the month.
  • Update advances, with dates.
  • Work out the payable amount and share it before paying.
  • Record the payment and keep the acknowledgement.
SPENDIXAI JOURNAL

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

Explore your reports