Life events

Hiring a home attendant for a parent: salary, food and leave record

A home attendant record for an elderly parent: duty days, replacements, advances, festival gifts and monthly pay, in a sheet siblings can share.

Editorial illustration for Hiring a home attendant for a parent: salary, food and leave record

A home attendant record is a one-page sheet with a row for each day of duty, a column for who came (the attendant or a replacement), and running notes for advances, gifts and food. At month end the sheet tells you the pay due, so there is no argument and the siblings who share the cost see the same numbers.

What should the daily sheet contain?

DateStatusWho cameNote
1PRegular attendantPresent full day
2PRegular attendantPresent full day
3RReplacementRegular attendant ill; replacement paid daily
4LNoneUnpaid leave, family informed

Use short codes: P for present, R for a replacement day, L for leave. Fill it in the same evening, ideally by the parent or a family member at home, so it does not depend on memory at month end.

How do you work out the month's pay?

Agree the terms in plain words at the start: monthly pay, how many days off are paid, what happens on extra days, and whether food is provided. Keep what was agreed in writing, even as a message. Terms and legal obligations towards domestic workers can differ by place, so check with someone who knows the local rules if you are unsure.

If statuses sit in B2:B32 and the agreed monthly pay is in E1, with a daily rate in E2 (monthly pay divided by 30), these formulas work in Excel and Google Sheets:

  • Days present: =COUNTIF($B$2:$B$32,"P")
  • Days on leave: =COUNTIF($B$2:$B$32,"L")
  • Pay after unpaid leave: =$E$1-COUNTIF($B$2:$B$32,"L")*$E$2
  • Replacement cost: =COUNTIF($B$2:$B$32,"R")*$E$3 where E3 holds the replacement's daily rate

Say the monthly pay is ₹15,000, so the daily rate is ₹500. With 3 days of unpaid leave, pay is ₹15,000 minus ₹1,500, which is ₹13,500. If an advance of ₹5,000 is being recovered in five instalments of ₹1,000, the amount handed over this month is ₹12,500. A Diwali gift of ₹3,000 is recorded separately, not mixed into pay.

How should advances and gifts be handled?

Write each advance in its own table with the date, amount, reason and the agreed recovery plan, and tick off each instalment when it is deducted. A festival gift or a bonus goes in a separate line, so that nobody later says it was meant to be part of salary or the opposite. When money is handed over, get a short acknowledgement: a signed line in a notebook, or a message from the attendant confirming receipt.

What about food and other small costs?

If you provide meals or tea, note it as a line with a rough monthly cost, even if you do not deduct it. It helps when you compare a hired attendant with other care options later. Note extras such as extra hours on a festival day, a taxi for a night duty, or a uniform, each with the date.

How do siblings who are far away see this?

Put the sheet in a shared spreadsheet that each sibling can view, and update it on a fixed day each month. Send the payment total and each person's share in a single message. Anyone who contributes by transfer should add the amount and date in a contributions tab, so the payer is not left reconstructing it.

When a sheet stops being enough

For a single attendant, a sheet is enough. If you also pay the attendant by bank transfer or UPI, SpendixAI can take the account statement as PDF, CSV or Excel, let you review the rows before saving, and keep them in a custom category so the yearly total is easy to see. It does not run payroll or calculate leave.

A month-end routine

  1. Count present, replacement and leave days.
  2. Work out pay after unpaid leave.
  3. Deduct the advance instalment.
  4. Add any agreed extra, then pay by transfer or against a signed note.
  5. Send the month's total to the siblings.
SPENDIXAI JOURNAL

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

Explore your reports