When income is irregular, build a medical emergency fund by moving a fixed share of every payment you receive into a separate pot, on the day the money lands. A share rule adjusts itself: a big month adds more, a thin month adds little, and you never have to find a lump sum. Track each receipt and each transfer in one sheet and total it every month.
How do you choose the share?
Start with a number you can keep even in a lean month. Five per cent is a convenient starting point to try, because it is easy to calculate, but it is only an example. Pick a share that feels comfortable and review it after three months. If you also set aside money for taxes and business costs, do that first, so that the medical share is a part of what is actually yours.
What does the calculation look like?
Say, with invented receipts, a freelancer gets ₹32,000, ₹18,500 and ₹45,000 in a month, and the rule is 5 per cent of each receipt.
- ₹32,000 x 0.05 = ₹1,600.
- ₹18,500 x 0.05 = ₹925.
- ₹45,000 x 0.05 = ₹2,250.
- Total receipts: ₹95,500. Total set aside: ₹1,600 plus ₹925 plus ₹2,250 = ₹4,775.
In Excel or Google Sheets, put the share in cell F1 as 0.05 and the amount received in column C. In D2 enter =ROUND(C2*$F$1, 0) and copy it down. The dollar signs keep the share cell fixed, and ROUND(number, 0) removes the paise. The month's total is =SUM(D2:D40).
What should the tracker columns be?
| Date | Client | Amount received | Share set aside | Transferred on |
|---|---|---|---|---|
| 3 Oct | Client A | ₹32,000 | ₹1,600 | 3 Oct |
| 14 Oct | Client B | ₹18,500 | ₹925 | 15 Oct |
| 29 Oct | Client C | ₹45,000 | ₹2,250 | 29 Oct |
The Transferred on column matters most. A share that is calculated but not moved is only an intention. Make the transfer on the same day, or the next, and fill the date.
What if a receipt is paid after deductions?
Use the amount that actually arrives in your account, not the invoice amount, since that is the money you can move. If part of a payment is withheld at source or you owe tax or GST on the work, ask your CA how to handle your records and do not mix those amounts with the medical share.
How do you handle lean months and big months?
- Set a small minimum, such as ₹500 per receipt, so that tiny receipts still add something.
- In a bumper month, add an extra top-up if you choose, and write 'extra' in the note.
- In a month with no income, the rule asks for nothing. Write zero, rather than leaving a blank.
When does the pot get used?
Spend it on medical costs only, and log each withdrawal with its bill, as in a normal emergency-fund log. Compare the balance with a target such as the co-pay and non-admissible items from your last claim, and with what your health policy leaves for you to pay.
If your payments arrive by bank transfer or UPI, SpendixAI can import the statement to the account you choose, and the report builder lets you filter and group by month. The sheet above remains enough while the number of receipts is small.
Next steps
- Choose a share and write it at the top of the sheet.
- Add every receipt the day it lands.
- Move the share the same day and note the date.
- Review the share every three months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


