Whether your family has one floater policy or several individual ones, the record-keeping goal is the same: one clear line per policy, and a rule that splits each premium across the members it covers. With that, your reports show what each person's health cover costs, and you can compare the two set-ups fairly. This article is about records, not about which type of policy to buy.
What does each set-up look like in your ledger?
A floater is one policy with one premium that covers several members under a shared sum insured. Individual policies each have their own premium and their own sum insured. For a family of four, say the adults hold individual policies and the two children share a small floater. That is three policies for four people, and your ledger needs three policy lines.
| Policy line | Covers | Premium for the year (made up) |
|---|---|---|
| Individual policy, father | Father | ₹11,000 |
| Individual policy, mother | Mother | ₹10,000 |
| Children's floater | Both children | ₹9,000 |
| Total, three policies | Four people | ₹30,000 |
For comparison, say a single family floater for all four would cost ₹32,000. The numbers are invented, so they prove nothing about which is cheaper in real life. They only show how to set the records.
How do you split a floater premium per member?
Pick one rule and write it down. The simplest is an equal split: ₹32,000 divided by four members is ₹8,000 each. A fairer-looking rule might weight by age, for example parents counting more than children, but it adds work and the weights are a guess. For the children's floater of ₹9,000, an equal split gives ₹4,500 per child.
| Member | Three policies (allocated) | One floater (equal split) |
|---|---|---|
| Father | ₹11,000 | ₹8,000 |
| Mother | ₹10,000 | ₹8,000 |
| Child one | ₹4,500 | ₹8,000 |
| Child two | ₹4,500 | ₹8,000 |
| Total | ₹30,000 | ₹32,000 |
Both columns add up to the actual premium, which is the test of a good allocation: the member amounts must always sum to what left your bank account.
Why keep an allocation at all?
Without one, a floater looks like a single lump in the household and the individual policies look like personal costs. Year-on-year or person-by-person comparisons become muddled. With an allocation, you can see that a family member's cover rose when they aged into a new band, or that adding a child to the floater moved the total. Record the allocation rule once, in a note at the top of the sheet, and do not change it mid-year.
What else belongs on each policy line?
- Policy name or insurer, and the policy number.
- Members covered, and the sum insured as printed in the policy.
- Renewal date and the date the premium was paid.
- Payment mode, such as net banking or UPI, and the receipt reference.
- Any claim made in the year, so the premium and the claims can be seen together.
Where do you track it?
In a spreadsheet, use one row per policy with a column per member and an equal-split formula, for example =D2/COUNTA(E1:H1) if the member names sit in E1:H1. In SpendixAI, you can create a health insurance category with a sub-category per policy and record the premium from the imported statement, then add the allocation in a note. Receipts can be kept with their transactions.
Keep the same layout from year to year. If this year's table has one row per policy and one column per member, next year's should too, so that you can lay the two years side by side. When a member joins or leaves, add or remove a column and write the date in a note, rather than rewriting the old rows.
A quick review at renewal
- Do the allocated amounts add up to the premium paid?
- Is the same rule being used as last year?
- Has anyone been added or removed?
- Is the policy still the right type for the family? Take that question to a licensed adviser.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


