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.
- A: Date spent
- B: Description (for example broadband bill for August)
- C: Amount in rupees
- D: Paid through (UPI, card, cash)
- E: Receipt kept (Yes or No)
- F: Claim submitted on (date)
- G: Status (Pending, Submitted, Approved, Paid)
- H: Amount received
- 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?
Useful ideas start with a clearer picture of your own spending.
Explore your reports

