A medical emergency fund withdrawal log is a table with one row per withdrawal or refill: date, reason, matching bill, amount, any reimbursement expected and the plan to refill. A balance column below it, and a simple line chart, show how far the fund has dipped and how long it takes to recover. Without the log, a fund quietly shrinks and nobody can say why.
What does each log row need?
- Date of the withdrawal or refill.
- Reason in a few words, such as 'diagnostic scan for Mother'.
- Matching bill: bill number or the file name of the scanned bill.
- Amount, entered as a negative number for a withdrawal and a positive one for a refill.
- Expected reimbursement, if an insurance claim is pending, with the expected date.
- Refill plan: how much per month and from when.
- Balance after the entry.
How do you calculate the running balance?
Keep the signed Amount in column C. In the first Balance cell (D2) enter =SUM($C$2:C2) and copy the formula down. The range grows one row at a time, so each balance includes every earlier entry. This works the same in Excel and Google Sheets.
Say the fund holds ₹48,000 and a hospital advance of ₹30,000 is taken from it. The balance after is ₹48,000 minus ₹30,000 = ₹18,000. If the insurer later reimburses ₹20,000, you add a refill row of ₹20,000 and the balance is ₹18,000 plus ₹20,000 = ₹38,000. The real net use of the fund in this case is ₹30,000 minus ₹20,000 = ₹10,000.
How should the refill plan work?
Write the refill plan on the same row as the withdrawal, while the emergency is fresh. A simple way is to divide the gap by the number of months you can manage. Using the invented figures above, if no reimbursement was expected and the fund needed ₹30,000 back, ₹2,500 a month would take ₹30,000 divided by ₹2,500 = 12 months. If a reimbursement of ₹20,000 is pending, the remaining ₹10,000 at ₹2,500 a month takes 4 months.
| Date | Reason | Bill reference | Amount | Refill plan | Balance |
|---|---|---|---|---|---|
| 2 Jun | Hospital advance, Father | Advance receipt 1 | -₹30,000 | ₹2,500 a month from July | ₹18,000 |
| 20 Jul | Insurer reimbursement | Settlement letter | ₹20,000 | Pending amount ₹10,000 | ₹38,000 |
| 1 Aug | Monthly refill | Not applicable | ₹2,500 | 3 more months | ₹40,500 |
How do you stop the fund being used for non-medical things?
Define in one line at the top what qualifies: for example doctor, tests, medicines, hospital, ambulance, and costs the family agrees are medical. Anything else needs a second person's approval, or goes elsewhere. If your spouse or a sibling shares the fund, ask them to read and agree on the rule once.
What should the chart show?
Insert a line chart with the Date column on the horizontal axis and the Balance column on the vertical axis. Add a horizontal line at your target balance. Each dip is a withdrawal and each climb a refill. If the line takes too long to recover, you have a clear reason to raise the monthly refill or review whether the fund's target is enough.
In SpendixAI, a withdrawal appears as a transaction on the fund's account, so you can see the account's activity in reports next to the sheet's log.
What if a withdrawal is only a loan to a family member?
Sometimes a sibling or parent needs a payment from the fund and will return it. Record it as a withdrawal with the word 'loan' in the reason and add the date it is expected back. When the money returns, enter it as a refill with the same words, so the pair of rows can be matched. If a loan stays unpaid for months, bring it to the review conversation instead of letting the balance quietly fall.
Habits that keep the log honest
- Log the withdrawal the same day, before the details blur.
- Attach or name the bill that matches it.
- Write the refill plan before you leave the hospital desk.
- Review the log twice a year, say in April and October.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
