Tax and GST

Reimbursement tracker: submitted, approved and paid in one sheet

Build a reimbursement tracker with submission date, approver, status and credit date, plus a way to link each claim to its receipt file.

Editorial illustration for Reimbursement tracker: submitted, approved and paid in one sheet

A reimbursement tracker is a sheet with one row per claim that shows when you submitted it, who approves it, its status and the date the money reached your account, with a link to the receipt. It stops you from paying for office expenses and then losing track of the repayment. Here is a layout and a filled example.

Why keep a sheet of claims?

Office expenses you pay and claim later are, in effect, small loans to your employer. Three claims of ₹1,200 each can drift for weeks, and then you cannot remember whether the cab receipt was ever submitted. A tracker answers three questions at a glance: what have I claimed, what is still pending and what has been paid.

What columns should it have?

  • Claim number, your own running number.
  • Expense date, which is when you paid.
  • Description, in a few words.
  • Amount claimed, in rupees.
  • Submission date.
  • Approver's name.
  • Status: draft, submitted, approved, queried, paid or rejected.
  • Amount approved, which may be lower than claimed.
  • Credit date, from your bank statement.
  • Receipt file name or link.

Use a drop-down list for the status column. In Excel or Google Sheets, select the column, open Data validation and choose a list of items, entering the statuses separated by commas.

A filled example

All hypothetical. Say a consultant claims four expenses in a month.

ClaimDescriptionClaimed (₹)Approved (₹)StatusCredit date
1Client visit cab1,1501,150Paid8 Aug
2Team lunch2,4002,000Paid8 Aug
3Software subscription3,5003,500Approvedpending
4Courier charges6500Queriedpending

Claimed in total: 1,150 + 2,400 + 3,500 + 650 = ₹7,700. Approved: 1,150 + 2,000 + 3,500 + 0 = ₹6,650. Paid so far: 1,150 + 2,000 = ₹3,150. Approved but unpaid: ₹3,500. Difference between claimed and approved: 7,700 minus 6,650 = ₹1,050, made up of ₹400 trimmed from the lunch and ₹650 under query. All of it is visible in the sheet.

Which formulas help?

Assume claimed amounts are in column D, approved in column H, status in column G and rows 2 to 200. These work in Excel and Google Sheets.

  • Total claimed: =SUM(D2:D200)
  • Total approved: =SUM(H2:H200)
  • Still waiting for payment: =SUMIFS(H2:H200,G2:G200,"Approved")
  • Number of open queries: =COUNTIF(G2:G200,"Queried")

Save every receipt as a photo or PDF in a folder called Claims, named by claim number and date, for example 003_2025-08-05_software.pdf. In the sheet, type the same file name in the last column. If your sheet lives in cloud storage, you can paste a share link instead, but a file name survives a change of storage much better.

How do you check the credit?

Reimbursements often arrive combined with salary or as a separate transfer. Look at your statement, find the credit, and copy its date into the sheet. If a credit covers several claims, write the same date against each and note the combined amount. When the statement is in SpendixAI, you can search the credit by amount and keep the receipt with the original expense, which helps you see which spend has been repaid.

If your employer pays claims through a payroll portal, take a screenshot of the status page each time it changes, and save it beside the receipt. When a claim is queried, you can point to exactly what you submitted and when. A short note of what the approver asked, and your reply, makes any later conversation calmer.

A monthly check

  1. Filter the status column for Submitted and Approved.
  2. Follow up on anything older than your usual payment cycle.
  3. Confirm paid claims against your statement.
  4. Archive the month's rows once everything is paid.
SPENDIXAI JOURNAL

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

Explore your reports