To keep an allergy treatment cost log, record the first test, every immunotherapy session, each follow-up consultation and every medicine as separate rows, and add a running total beside the clinic's quoted plan. That one balance column tells you, at any visit, how much has been spent and how much of the plan is left.
Why this treatment needs its own log
Allergy testing is often a single payment. Immunotherapy is different: it can run for many months, with visits spaced out, a series of doses or injections, medicines for symptoms in between, and a doctor's fee every few visits. Because the cost is spread so thinly, it is easy to forget what the clinic quoted at the start and to lose track of what you have paid.
What should each row capture?
- Date of payment
- Item: Test, Consultation, Session, Medicine, or Other
- Amount
- Receipt kept (yes or no)
- Running total of everything spent
- Plan used and plan balance, for sessions that belong to the quoted course
Ask the clinic at the first visit for the quote in writing, with the number of sessions it covers, what the fee includes, and what is billed separately. If your child or parent is the patient, write the patient's name on the log as well so the records do not get mixed up in a household.
A worked example with running totals
Say the clinic quotes ₹27,000 for a course of 18 monthly sessions at ₹1,500 each. The numbers below are hypothetical, to show the layout.
| Date | Item | Amount (Rs) | Running total (Rs) | Plan balance (Rs) |
|---|---|---|---|---|
| 5 Jan | Skin-prick test | 3,500 | 3,500 | 27,000 |
| 5 Jan | Consultation | 700 | 4,200 | 27,000 |
| 20 Jan | Session 1 | 1,500 | 5,700 | 25,500 |
| 20 Feb | Session 2 | 1,500 | 7,200 | 24,000 |
| 20 Feb | Symptom medicines | 600 | 7,800 | 24,000 |
| 20 Mar | Session 3 | 1,500 | 9,300 | 22,500 |
By March the family has spent ₹9,300, but only ₹4,500 of the ₹27,000 plan, which is three sessions at ₹1,500. Fifteen sessions are left, worth ₹22,500. The remaining cost of the quoted plan is therefore ₹22,500, and everything else (test, consultations, medicines) is outside the quote and will keep growing.
How do I make the sheet do the sums?
Put Date in column A, Item in B, Amount in C, and Running total in D. The quoted plan amount goes in cell H1, and the item type for plan sessions is "Session". In Excel or Google Sheets:
- Running total, in D2 and copied down: =SUM($C$2:C2)
- Plan balance, in E2 and copied down: =$H$1-SUMIFS($C$2:C2, $B$2:B2, "Session")
- Sessions done so far: =COUNTIF($B$2:$B$500, "Session")
The first part of the ranges is locked with dollar signs while the second grows as you copy down, which is what makes the running total work. Note that the session rows must read exactly "Session", or the balance will not move. If your clinic names the sessions differently, change the text in the formula to match.
What if the bills do not match the quote?
Compare each session fee with what was quoted, and ask the clinic about any difference at the time, not months later. A short note in the row, such as "fee included dose adjustment", is enough. If a charge was not in the quote, you can then see exactly how much was added.
Where does an app fit in?
If clinic payments go through UPI or a card, they will already appear in a bank statement. SpendixAI lets you import that statement, categorise the payments, and attach the receipts to each transaction. The quoted-plan balance is not something it tracks, so many people keep that one small column in a sheet and let the app hold the rest.
Checklist for each visit
- Pay, then ask for a receipt that names the item.
- Add the row within a day, before the receipt is lost.
- Update the plan balance and note any difference from the quote.
- Once every three months, total tests, sessions, consultations and medicines separately.
Medical questions about the treatment belong with your doctor. This log only keeps the money side in order.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


