Health and family

Reimbursement claim deadlines: a tracker counting from discharge day

Build a spreadsheet that takes your discharge date, adds the days from your own policy and shows the last submission date with a reminder column.

Editorial illustration for Reimbursement claim deadlines: a tracker counting from discharge day

A deadline tracker needs only a discharge date and the number of days your own policy allows for submission. Add the two and you have the last date. A few more columns turn it into a reminder that shows how many days are left. Read the days from your policy wording, not from memory or from a forum.

Which dates does the sheet need?

Policies differ on when the clock starts and how many days you have, so find the line in your policy that talks about submitting claim documents, and copy it in words next to the first row. Then build these columns from row 2, with headings in row 1:

ColumnHeadingWhat goes in it
AClaimName or claim ID
BMemberWho was admitted
CDischarge dateDate from the discharge summary
DDays allowedNumber printed in your own policy
ELast date=C2+D2
FReminder date=E2-7
GDays left=E2-TODAY()
HSubmitted onDate you posted or uploaded, blank until then

Format columns C, E, F and H as dates. Excel and Google Sheets both store dates as numbers, which is why adding days to a date works.

Can the sheet tell me what to do next?

Add a status column I with this formula in I2: =IF(H2<>"","Submitted",IF(G2<0,"Overdue",IF(G2<=7,"Urgent","Open"))). It reads left to right: if there is a submission date, show Submitted; otherwise, if the days left are below zero, Overdue; otherwise, if a week or less remains, Urgent; otherwise, Open. Drag it down for every claim.

Hypothetical example: discharge on 12 November 2026, with 30 days allowed by the policy. The last date is 12 December 2026, because November has 30 days. The reminder date is 5 December 2026.

What if the policy counts pre- and post-hospital bills differently?

Then give them their own rows, with their own start dates and day counts. A medicine bill from three weeks after discharge may follow a different timeline from the stay itself. Do not merge them just to keep the sheet tidy.

How early should I really submit?

Well before the last date. Allow for the time needed to gather originals, get a doctor's stamp, make copies and send by post or upload. If you plan to send by courier, add a few days for transit and log the courier receipt number. The reminder column is deliberately a week ahead, which you can change.

When a sheet stops being enough

If you handle several claims across family members, the sheet will stay useful for dates, but the costs belong in your expense records. SpendixAI can hold the receipts and payments, and a custom category for medical costs awaiting claim keeps them separate from everyday spending.

What if my policy gives the days differently for different documents?

Then record each rule in its own column and let the sheet calculate each separately. For example, one rule for the main claim documents and another for a later bill. Add a Rule note column holding the exact wording you copied from the policy, with the page number. When someone from the insurer quotes a number on the phone, write it down but verify it against the printed wording before relying on it.

Weekly routine

  1. Open the sheet every Sunday.
  2. Scan column I for Urgent and Overdue.
  3. For each Urgent row, list the missing documents and who will get them.
  4. If something is Overdue, contact the insurer and ask in writing what can still be done, and note the reply.
SPENDIXAI JOURNAL

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

Explore your reports