To track joint pain treatment costs, give the condition one label and file everything under it: consultations, scans, medicines, injections, physiotherapy sessions and supports like braces. Add a month column, and after three months you will see what the problem really costs, not just what the last chemist bill said.
Why joint problems are hard to see in your spending
A long-term joint problem rarely arrives as one big bill. It shows up as a consultation here, an X-ray there, a strip of tablets every month, a block of physio sessions paid in cash, and a brace bought from a medical store. Each payment lands in a different place, so each looks small. Added up over a quarter, they usually do not feel small at all.
The fix is a condition tag. Whatever the payment method, if it is for the knee (or the shoulder, or the back), it carries the same label, say "Knee". Then your normal categories still work, and you can ask one more question: what did this condition cost?
What goes under the condition label?
- Doctor visits: first consultation, follow-ups, and any second opinion
- Tests and scans: X-ray, MRI, blood tests, and the lab or centre that did them
- Medicines: the monthly strips, creams and sprays from the prescription
- Procedures: an injection in the joint, a drain, a minor procedure, and the clinic fee
- Physiotherapy: each session or package, plus any home-visit charge
- Supports and aids: knee cap, brace, walking stick, hot pack
- Travel to appointments: auto, cab or fuel if you want the full picture (keep this as its own sub-line so it can be left out)
Keep the sub-types separate. A single "Knee: ₹9,550" line tells you nothing next quarter, but "physio 4,000, injection 3,500, medicines 1,450, follow-up 600" tells you where the money goes.
A worked example across three months
Say someone with knee pain logs the following. These numbers are made up to show the layout, not typical prices.
| Month | Consults and tests | Medicines | Injection | Physio | Aids | Total |
|---|---|---|---|---|---|---|
| Month 1 | 1,400 | 1,450 | 0 | 3,000 | 0 | 5,850 |
| Month 2 | 600 | 1,450 | 3,500 | 4,000 | 0 | 9,550 |
| Month 3 | 0 | 1,200 | 0 | 2,000 | 1,100 | 4,300 |
| Three months | 2,000 | 4,100 | 3,500 | 9,000 | 1,100 | 19,700 |
The three-month total is ₹19,700, which is about ₹6,567 a month on average. But the average hides the shape: Month 2 was more than double Month 3 because of a one-off injection. If you budgeted from Month 3 alone you would be short next time the doctor suggests a procedure.
In Month 1, the consult (₹800) and X-ray (₹600) make ₹1,400. Physio was six sessions at ₹500 each, so ₹3,000. Check your own sums the same way: sessions multiplied by the per-session fee, then compare with the receipt.
How do I set this up in a spreadsheet?
Use one row per payment with these columns: A Date, B Condition, C Type (Consult, Test, Medicine, Procedure, Physio, Aid), D Amount, E Month. To total physio for the knee in one cell in Excel or Google Sheets:
- =SUMIFS($D$2:$D$500, $B$2:$B$500, "Knee", $C$2:$C$500, "Physio")
- For one month, if column E holds a text label such as Nov-2026 and G1 holds the label you want: =SUMIFS($D$2:$D$500, $B$2:$B$500, "Knee", $E$2:$E$500, $G$1)
Keep Type values spelled identically every time, because the formula matches text exactly. A dropdown list on column C avoids the "Physio" versus "Physiotherapy" trap.
Where does an expense tracker help?
If you already import bank and card statements, the doctor and lab payments are in there waiting to be categorised. In SpendixAI you can create a custom category with sub-categories such as Physio and Medicines, add the cash visits by hand, and use the Report builder to filter and group by category and month. A sheet works too; the point is the one label, not the tool.
Is it worth keeping a record after the pain settles?
Yes, for a simple reason: joint problems come back. A record of what was prescribed, when, and what it cost makes the next appointment shorter and the next budget realistic. It also lets you show a doctor the dates of earlier injections or scans without searching through old messages.
A short routine to follow
- Photograph each bill or receipt on the day and file it under the condition name.
- Add one row per payment, with type and amount, at the end of each week.
- At month end, total each type and write one line comparing it to last month.
- After three months, decide on a monthly figure for the condition and keep a separate small buffer for procedures.
If any of these costs are being claimed from an insurer or your employer, keep the original bills and ask them in writing what they need. Rules differ between policies and change over time, so check the current position with them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


