Life events

Tracking work-from-home reimbursements from your employer

Track employer reimbursements for work-from-home costs with a status sheet: log each claim and its date, then match the credit when it lands.

Editorial illustration for Tracking work-from-home reimbursements from your employer

Give each expense one row with a status: pending, submitted, approved or paid. Record the claim date when you submit, and when money arrives in your account, match it to the rows it covers. Anything still unpaid after a month shows up as a short list you can chase, which is how employer reimbursements stay tracked.

What columns does a reimbursement tracker need?

Open a sheet in Excel or Google Sheets with these columns, starting in row 1 as headings.

  1. A: Date spent
  2. B: Description (for example broadband bill for August)
  3. C: Amount in rupees
  4. D: Paid through (UPI, card, cash)
  5. E: Receipt kept (Yes or No)
  6. F: Claim submitted on (date)
  7. G: Status (Pending, Submitted, Approved, Paid)
  8. H: Amount received
  9. I: Date received

Which formulas show what is still owed?

Assume your data runs from row 2 to row 200. To total everything not yet paid out, use the first formula below; the sign in quotes means not equal to.

  • Amount still outstanding: =SUMIFS($C$2:$C$200, $G$2:$G$200, "<>Paid")
  • Amount in Pending only (not yet claimed): =SUMIFS($C$2:$C$200, $G$2:$G$200, "Pending")
  • Days since a claim was submitted, in row 2 for an unpaid claim: =IF($G2="Paid", "", TODAY()-$F2)
  • Difference between claimed and received, row 2: =$C2-$H2

Fill the days formula down. A claim sitting at 30 or more days is worth a polite follow-up. Format column F and column I as dates so the subtraction works.

How do I match the credit when it arrives?

Employers often pay in one lump, sometimes together with salary or as a separate transfer. Open your statement, find the credit, and note its date and amount in column I and H. If one transfer covers several claims, split it across rows. Say your credit is ₹3,150 and your open claims are ₹1,200 for broadband, ₹1,450 for the electricity share and ₹500 for data. ₹1,200 + ₹1,450 + ₹500 = ₹3,150, so all three rows become Paid. If the credit is ₹2,650, one row is short: look for the item the finance team rejected or held back.

What if the employer pays less than I claimed?

Keep the difference visible rather than silently dropping it. Mark the row Approved with a note such as "partly paid, balance ₹300 queried on" with the date. If your company has a policy document, save a copy so you know which costs it covers. Do not assume a claim will be paid just because you submitted it.

How do I keep the paperwork tidy?

Name each bill file with the month and the item, for example 2025-08 broadband, and keep them in one folder or in one chat with yourself. Do not wait for the claim deadline to find them. If a bill is addressed to a family member, note that in the description so you are ready for the question. Photograph paper bills the same day, because thermal-print receipts fade quickly. At month end, scan your sheet from the top: any row with Pending and an old date is either a claim you forgot to submit or one you decided not to make. Decide which, and write it down.

Where does SpendixAI fit?

SpendixAI is a personal expense tracker, not a reimbursement or approvals tool, so claim status stays in your sheet. What it can do is hold the expenses themselves: import your statement, tag the work-related rows with a category of your own, and keep the bill with the transaction. When a sheet stops being enough for the expense side, that is the moment to use it for those parts.

Before you submit the next claim

  • Is the receipt or bill in a readable form, with the right month?
  • Is the amount the same as on your statement?
  • Have you written the claim date in your sheet?
  • Have you read your company's policy for this type of cost?
SPENDIXAI JOURNAL

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

Explore your reports