Travel and vehicles

Claim deadlines: a submit-by tracker so you do not lose money

Build a submit-by tracker in Excel or Google Sheets for expense claims: columns, working formulas and a six-claim sample so deadlines never slip past you.

Editorial illustration for Claim deadlines: a submit-by tracker so you do not lose money

A submit-by tracker is a small sheet that lists every expense you have yet to claim, the date it must be submitted by, and how many days are left. Add one formula for days left and one for a warning flag, and the sheet tells you each morning which claim is about to expire. The deadline length comes from your own company's policy, so check it and type it into one cell.

Which columns do I need?

  1. A: Expense, a short name such as Pune client trip.
  2. B: Trip end date, or the date of the expense.
  3. C: Submit-by date, calculated from B and the company's window.
  4. D: Amount in rupees.
  5. E: Status: Pending, Submitted or Paid.
  6. F: Days left.
  7. G: Flag.

Put the number of days your company allows in cell J1. Say it is 30 days; that is a placeholder, not a rule. Check your policy and type your own number.

What are the formulas?

These work in Excel and Google Sheets, on rows 2 to 7 of the sample below.

  • Submit-by in C2: =B2+$J$1
  • Days left in F2: =IF(E2="Pending",C2-TODAY(),"")
  • Flag in G2: =IF(E2<>"Pending","",IF(F2<0,"LATE",IF(F2<=7,"Submit now","OK")))
  • Pending total in D9: =SUMIFS($D$2:$D$7,$E$2:$E$7,"Pending")
  • Pending and due within a week in D10: =SUMIFS($D$2:$D$7,$E$2:$E$7,"Pending",$F$2:$F$7,"<=7")

Copy the C2, F2 and G2 formulas down. In F2, TODAY() makes the sheet recalculate each time you open it. If F is empty text for submitted claims, SUMIFS ignores those rows, which is what you want.

What does a sample sheet look like?

Six hypothetical claims with a 30-day window in J1.

ExpenseTrip endSubmit byAmountStatus
Pune client visit28 Sep 202628 Oct 2026₹4,850Submitted
Delhi offsite2 Oct 20261 Nov 2026₹6,400Paid
Jaipur training14 Oct 202613 Nov 2026₹12,300Pending
Chennai site visit25 Oct 202624 Nov 2026₹2,150Pending
Kochi conference6 Nov 20266 Dec 2026₹18,900Pending
Local cab week11 Nov 202611 Dec 2026₹940Pending

The pending total is 12,300 + 2,150 + 18,900 + 940, which is ₹34,290. On 8 November, for instance, the Jaipur claim shows Submit now because it has five days left, and the others show OK.

How do I make it hard to ignore?

  • Add conditional formatting on column G so LATE turns red and Submit now turns amber.
  • Pin the sheet or the shortcut where you open it daily.
  • Set a calendar reminder for the first of each month to add recent expenses.

What if I miss the date?

Ask finance at once, with the dates and a short explanation, and do not assume the answer is no. Some companies treat late claims differently. Rules vary, so ask rather than guess.

Check how your company starts the clock. Some count from the date of each expense, others from the end of the trip. If it is the date of the expense, put the expense date in column B instead of the trip end. Write the policy sentence next to cell J1, so a colleague opening the sheet sees where the number came from.

You can add a column H called Sent to, with the name of the person or the portal you submitted to, so a late reply is easy to chase.

When a sheet stops being enough

The submit-by dates will always live in your sheet. If you are travelling often and want to see which of your spends were work trips, SpendixAI keeps imported statement lines by account and category, with receipts attached to each, which makes it easier to find what is still unclaimed.

Weekly check

  • Open the sheet and read the flags.
  • Submit anything marked Submit now.
  • Add new trips and set status to Pending.
  • Mark submitted claims, and later paid ones, with the date.
SPENDIXAI JOURNAL

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

Explore your reports