Spreadsheets

Domestic help salary and attendance sheet in Excel

A domestic help salary and attendance sheet for Excel: monthly grid for maid, cook and driver, per-day deduction formula, advances and net payable.

Editorial illustration for Domestic help salary and attendance sheet in Excel

A salary sheet for domestic help needs a monthly attendance grid, a per-day amount, a leave deduction and a running balance for any advance. For each helper, net payable is the monthly salary minus leave deduction minus the advance instalment recovered that month. Written down, it also settles the usual doubt about how many days were missed.

How do I set up the attendance grid?

Make one tab per month, or one per helper if you prefer. Put names down column A (maid, cook, driver) and dates 1 to 31 across columns D to AH. Mark each day with a single letter: P for present, A for absent, H for holiday you agreed to give.

ColumnHeadingPurpose
AHelperName and role
BMonthly salaryThe agreed amount
CFree leavesLeaves agreed without deduction
D to AHDays 1 to 31P, A or H
AILeaves taken=COUNTIF(D2:AH2, "A")
AJPer-day amountSee below
AKDeductionSee below
ALNet before advance=B2-AK2

What is the per-day deduction formula?

Decide with the helper which method you use, and write it in the sheet: divide the salary by the actual days in the month, or always by 30. Both are common, so agree and stick to one.

  • Days in month in a cell such as B1: =DAY(EOMONTH(DATE(2026,11,1),0))
  • Per-day amount in AJ2: =B2/$B$1
  • Deduction in AK2: =MAX(0, AI2-C2)*AJ2

Say the maid earns ₹4,500 for a 31-day month and was absent on 3 days, with no free leaves. Per day is 4,500 / 31 = ₹145.16 and the deduction is 3 x 145.16 = ₹435.48, so net before advance is about ₹4,064.52, which you may round to ₹4,065. If you divide by 30, the day rate is ₹150 and the deduction is ₹450. The difference is small, but the written method prevents an argument.

How do I carry an advance across months?

Advances are where memory fails. Create a small table beside the grid with columns for opening advance, agreed monthly recovery, recovered this month and closing advance.

  • Recovered this month: =MIN(opening advance, agreed recovery, net before advance)
  • Closing advance: =opening advance - recovered
  • Net payable: =net before advance - recovered

The MIN stops you recovering more than is left, more than agreed, or more than the month's pay. Suppose the cook took ₹6,000 as an advance and agreed to repay ₹1,500 a month. Month one closes at ₹4,500, month two at ₹3,000 and month four at zero. Copy each closing figure into next month's opening cell so the balance carries over.

What if a helper works for several months without any record?

Start from today. Ask the helper what advance they believe is pending, write that as the opening balance with the date, and ask them to agree. Resist rebuilding old months from memory; a clear start date serves both sides better than a long dispute.

How do I record payment and keep it fair?

  1. Add Paid on and Mode columns, with UPI, cash or bank transfer.
  2. Pay on the same date each month and record it the same day.
  3. Share a photo of the month's grid with the helper if they would like to see it.
  4. Note festival gifts or bonuses on a separate line so they are not mistaken for salary.
  5. Keep each year's files so you can answer "how much did we pay in total last year".

Where can an app fit in?

Salary sent by UPI appears in your statement, and a cash payment does not. SpendixAI lets you import the statement and add the cash payments by hand in one go, so domestic help ends up as one category across the year instead of scattered notes.

Month-end checklist

  • Attendance grid filled for every helper
  • Per-day method written at the top of the sheet
  • Advance balances copied forward
  • Payment date and mode recorded
SPENDIXAI JOURNAL

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

Explore your reports