Costs before admission and after discharge belong to the same claim as the stay, so give them the same claim ID. They still need their own dates and amounts, because policies usually look at them separately and measure them against a window of days. Record each bill on its own line, with a phase label of Pre, Stay or Post.
Why not just add everything into one total?
A single total hides the dates, and the dates are what decide whether a bill falls inside the period your policy covers before admission or after discharge. If you need to submit them later, you want to show each bill with its date and the reason for it. A total does not do that.
What does a clean record look like?
| Date | Bill from | Amount | Phase | Claim ID |
|---|---|---|---|---|
| 28 Sept | Diagnostic centre | ₹4,200 | Pre | HC-2026-03 |
| 10 Oct | Hospital, final bill | ₹96,000 | Stay | HC-2026-03 |
| 20 Oct | Pharmacy | ₹3,350 | Post | HC-2026-03 |
| 20 Dec | Pharmacy | ₹1,800 | Post | HC-2026-03 |
These are hypothetical figures. The sheet keeps one row per bill and uses the same claim ID on every row, so filtering on HC-2026-03 returns the whole story.
How do I check which bills fall inside the policy window?
Your policy states a number of days before admission and after discharge that it will look at. Find those two numbers in your own policy and put them in cells. Say H1 holds the admission date, H2 the days before, H3 the discharge date and H4 the days after. In F2, beside the first bill date in A2, use =IF(AND(A2>=$H$1-$H$2, A2<=$H$3+$H$4), "Inside", "Outside"). The formula works in Excel and Google Sheets.
Hypothetical case: admission on 10 October, 30 days before; discharge on 14 October, 60 days after. The window runs from 10 September to 13 December. The 28 September test is inside. The 20 December medicine bill is outside, so mark it as your own cost rather than part of the claim.
What if I am not sure a bill relates to the illness?
Ask the treating doctor to note on the prescription or bill what it is for. A line such as 'follow-up for the same condition' on the paper is worth more than your memory a month later. When doubt remains, record the bill with its claim ID anyway and add a question mark in the notes column, so you decide later with the insurer.
How do I show this in expense records?
Add each bill as an expense on the day you paid, with the same claim ID in the note. With SpendixAI you can use a medical category for the lot and put the phase and the claim ID in your own words, then use the Report builder to filter on it. The folder of originals stays your proof.
What if the bills arrive long after the stay?
Late bills are common: a pathology report billed weeks later, or a pharmacy that invoices at month end. Enter each with the date on the bill and the same claim ID, even if you are adding it long after the rest. Do not move the claim date to suit it. The original dates are what explain the sequence, and what an insurer's reader will compare against the discharge summary.
A small checklist for every claim
- Pre, Stay and Post rows all carry the same claim ID.
- Dates are the bill dates, not the dates you remembered.
- Window days are copied from your policy, not guessed.
- Outside-window bills are kept, but marked as your own cost.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


