Spreadsheets

Expense claim tracker for employees in Excel with approval status

An expense claim tracker for employees in Excel: date, category, bill attached, amount, submitted, approved and paid, with money fronted and not yet returned.

Editorial illustration for Expense claim tracker for employees in Excel with approval status

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?

ColumnHeadingNotes
ADateDate of the expense
BCategoryClient meal, cab, courier, stay
CDescriptionWho or where, in a few words
DBill attached?Yes or No
EAmount (₹)What you paid
FSubmitted onDate you submitted the claim
GApproved (₹)Amount approved; blank until decided
HPaid onDate the money reached you
IStatus=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.

ExpenseAmountBillApprovedPaid
Client lunch₹1,450Yes₹1,450Yes
Client dinner₹2,200Yes₹2,200Yes
Cab to client office₹380Yes₹380Yes
Cab back₹520Yes₹520Yes
Auto, no bill₹640No₹0No
Team coffee₹1,100YesPendingNo

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?

  1. 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
SPENDIXAI JOURNAL

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

Explore your reports