Education

Fee reimbursement: tracking what you paid and what is still due

Fee reimbursement tracking made simple: one row per claim for the fee paid, claim sent, amount approved and credit received, with working sheet formulas.

Editorial illustration for Fee reimbursement: tracking what you paid and what is still due

When a scholarship or employer reimburses fees after you pay them, track each claim as a single row: what you paid, when you submitted, what was approved, what was credited and what is still due. One row per claim lets you see at a glance how much of the family's money is sitting with someone else.

Why one row per claim?

A reimbursement runs on a slow clock. The fee leaves your account in July, the claim goes in in August, an approval comes in October and the credit may arrive later, sometimes for less than you claimed. If each step is a separate scribble, you cannot tell which claim is stuck. One row keeps the whole story together.

What columns does the sheet need?

Set up the sheet with these columns, starting in row 2 under a header.

  • A: Claim name, for example Semester 3 tuition.
  • B: Fee paid on (a date).
  • C: Fee paid (amount).
  • D: Claim submitted on (a date).
  • E: Amount approved.
  • F: Amount credited.
  • G: Credited on (a date).
  • H: Still due.
  • I: Days waiting.

Use these formulas, written for row 2 and filled down:

  • H2: =C2-F2 gives the part of the fee not yet reimbursed.
  • I2: =IF(G2="",TODAY()-B2,G2-B2) counts days since you paid, up to the credit date if there is one.
  • Total still due: =SUM($H$2:$H$100).
  • Total fee on claims with no credit yet: =SUMIFS($C$2:$C$100,$G$2:$G$100,"").

These work in Excel and Google Sheets. Format the date columns as dates, and leave G empty until a credit arrives, since the formula in column I treats an empty G as not yet credited.

What does an example claim look like?

Say you pay a semester fee of ₹48,000 on 10 July and submit the claim on 25 July. In October the office approves ₹42,000, because some fee heads were not covered. The credit of ₹42,000 lands on 14 October.

FieldValueNote
Fee paid₹48,000Paid 10 Jul
Amount approved₹42,000Heads not covered: ₹6,000
Amount credited₹42,000Credited 14 Oct
Still due₹6,00048,000 − 42,000
Days from payment to credit9610 Jul to 14 Oct

The wait is 21 days left in July, plus 31 in August, 30 in September and 14 in October: 21 + 31 + 30 + 14 = 96 days. The ₹6,000 gap is not a delay, because it was never approved, so it moves from still due to a family cost, with a note about why.

What should you do when a claim stalls?

  1. Look at your row to see how many days have passed since submission.
  2. Check the status where the claim was filed.
  3. Ask the office that processes claims, quoting the claim date and amount.
  4. Keep a short log of calls and replies in a notes column.
  5. If the claim was rejected, record the reason and whether you can appeal.

Expect partial approvals. If you see a pattern, such as the same fee head being left out every term, note it in the sheet and plan for it in the next term's cash plan instead of being surprised again. Ask the office for the list of covered heads in writing, so that the next claim can be shaped to match.

How does the family plan the cash?

Paying first and claiming later means the family funds the fee in advance. Before each term, check how much cash the family can hold out for 3 to 4 months, and do not plan to spend the reimbursement before it arrives. A pending total in the sheet tells you how much is already out of pocket.

For the money side, SpendixAI keeps receipts with their transactions, so the fee payment and its receipt stay together, and an imported statement can bring in the reimbursement credit when it arrives. The claim status itself still belongs in your sheet.

SPENDIXAI JOURNAL

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

Explore your reports