An expense claim tracker for an employee is a table with one row per expense: date, category, whether the bill is attached, the amount, the date you submitted it, the amount approved and the date you were paid. A summary cell then shows the money you have fronted and not yet got back, which is the number worth knowing.
What columns should the claims table have?
| Column | Heading | Notes |
|---|---|---|
| A | Date | Date of the expense |
| B | Category | Client meal, cab, courier, stay |
| C | Description | Who or where, in a few words |
| D | Bill attached? | Yes or No |
| E | Amount (₹) | What you paid |
| F | Submitted on | Date you submitted the claim |
| G | Approved (₹) | Amount approved; blank until decided |
| H | Paid on | Date the money reached you |
| I | Status | =IF(H2<>"","Paid",IF(F2<>"","Submitted","Draft")) |
Add the claim to the sheet on the day you spend, before the receipt gets lost, and attach the bill digitally to whatever claim system your employer uses. The sheet is your own record and does not replace it.
How do I see what I have fronted and not recovered?
- Total claimed: =SUM($E$2:$E$200)
- Total reimbursed: =SUMIFS($G$2:$G$200, $H$2:$H$200, "<>")
- Not yet recovered: =SUM($E$2:$E$200)-SUMIFS($G$2:$G$200, $H$2:$H$200, "<>")
- Bills missing: =COUNTIF($D$2:$D$200, "No")
- Days waiting on a submitted claim in J2: =IF(AND(F2<>"", H2=""), TODAY()-F2, "")
The criterion "<>" matches non-empty cells, so only rows with a Paid on date count as reimbursed. This also catches short payments: if you claimed ₹1,000 and ₹800 was approved and paid, ₹200 shows up as not recovered.
What does a month of client lunches and cabs look like?
The amounts are invented.
| Expense | Amount | Bill | Approved | Paid |
|---|---|---|---|---|
| Client lunch | ₹1,450 | Yes | ₹1,450 | Yes |
| Client dinner | ₹2,200 | Yes | ₹2,200 | Yes |
| Cab to client office | ₹380 | Yes | ₹380 | Yes |
| Cab back | ₹520 | Yes | ₹520 | Yes |
| Auto, no bill | ₹640 | No | ₹0 | No |
| Team coffee | ₹1,100 | Yes | Pending | No |
Total claimed is 1,450 + 2,200 + 380 + 520 + 640 + 1,100 = ₹6,290. Reimbursed so far is 1,450 + 2,200 + 380 + 520 = ₹4,550. Not recovered is 6,290 - 4,550 = ₹1,740, made up of the ₹640 auto with no bill and the ₹1,100 coffee still waiting. Seeing that number each month is better than discovering it at year end.
What do I do about expenses with no bill?
Auto rides and tips often have no receipt. Many employers have a form or a limit for such items, and the rules differ by company, so check your own policy and keep a note of date, route and purpose. In the sheet, type No in the bill column and write in Description why there is no bill. Do not invent a receipt; that creates a far bigger problem than a missing one.
How do I follow up on slow reimbursements?
- Sort by days waiting, longest first.
Ask your manager or finance contact politely about the oldest claim, quoting the claim date and amount. Ask what is pending, whether it is a missing bill, an approval, or a processing cycle. Write down the reply with its date. If the policy sets a time for reimbursement, point to it; if not, ask what the expected time is.
Where does an app help?
Card and UPI spends show up in your bank statement. SpendixAI can import that statement, keep a receipt with each transaction and group work spends in a category, so your own record of what you paid is easy to find. It is not an approvals or reimbursement tool, so claims still go through your employer's process.
Monthly checklist
- Every expense entered with its category
- Bill attached marked correctly
- Submitted dates filled
- Not-recovered figure reviewed
Useful ideas start with a clearer picture of your own spending.
Explore your reports


