Health and family

Medical fund withdrawals and refills: a log of when you dipped in

A medical emergency fund withdrawal log for each withdrawal, its reason, the matching bill, expected reimbursement and a refill plan tied to a balance chart.

Editorial illustration for Medical fund withdrawals and refills: a log of when you dipped in

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.

DateReasonBill referenceAmountRefill planBalance
2 JunHospital advance, FatherAdvance receipt 1-₹30,000₹2,500 a month from July₹18,000
20 JulInsurer reimbursementSettlement letter₹20,000Pending amount ₹10,000₹38,000
1 AugMonthly refillNot applicable₹2,5003 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

  1. Log the withdrawal the same day, before the details blur.
  2. Attach or name the bill that matches it.
  3. Write the refill plan before you leave the hospital desk.
  4. Review the log twice a year, say in April and October.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports