To check a sinking fund, list the annual bills it should cover, work out for each one how much should have been set aside since it was last paid, add those up, and divide your actual balance by that total. The result is your coverage percentage. At 100% or above the fund is on schedule; below that, you have a shortfall to make up before the bills fall due.
What is a sinking fund, in this context?
It is a pot of money you build up gradually for bills that arrive once or twice a year, such as insurance premiums, school fees, society charges and festival costs. Instead of finding ₹36,000 in the month the fee is due, you set aside ₹3,000 each month. The check below tells you whether that habit has kept pace.
How do you list the bills ahead?
Write down every annual bill you know about for the next twelve months, with the amount and the month you last paid it. Take a hypothetical list, with today as the 1st of November.
| Bill | Amount | Last paid | Months since | Should have saved |
|---|---|---|---|---|
| Health insurance premium | ₹24,000 | January | 10 | ₹20,000 |
| Two-wheeler insurance | ₹6,500 | March | 8 | ₹4,333 |
| Society annual charge | ₹12,000 | April | 7 | ₹7,000 |
| Appliance service contract | ₹3,500 | May | 6 | ₹1,750 |
| School fees and books | ₹36,000 | June | 5 | ₹15,000 |
| Festival and gifts | ₹30,000 | October | 1 | ₹2,500 |
| All six | ₹1,12,000 | Various | Various | ₹50,583 |
Each "should have saved" figure is amount × months since last paid ÷ 12. For example, ₹24,000 × 10 ÷ 12 = ₹20,000 and ₹36,000 × 5 ÷ 12 = ₹15,000. The six figures add to about ₹50,583.
How do you read the coverage percentage?
Say the sinking fund balance is ₹42,000. Coverage = ₹42,000 ÷ ₹50,583 = about 83%. The shortfall is ₹50,583 − ₹42,000 = ₹8,583. The next big bill is the health premium in January, about two months away. Spreading ₹8,583 over the two months before it adds ₹4,292 a month to your normal ₹9,333 contribution (₹1,12,000 ÷ 12). If that is too steep, spread the top-up over more months, but write down the date by which the gap must close.
- 100% or more: on schedule. Keep contributing.
- About 80% to 100%: a small top-up will do. This is my own rule of thumb, not a standard.
- Below about 80%: a catch-up plan is needed, or a bill may have to be paid from other money.
Do you need to look at the nearest bills separately?
Yes. Overall coverage can look fine while the next bill is exposed. In the example, the health premium of ₹24,000 is due in about two months, and the balance of ₹42,000 covers it comfortably. If the nearest bill were ₹50,000 and the balance ₹42,000, a healthy-looking 83% would still leave you short on the day. So check two things: overall coverage, and whether the balance covers everything due in the next three months.
How do you do the sum in a sheet?
With amounts in B2:B7 and months since last paid in D2:D7, the "should have saved" figure for a row is =B2*D2/12, and the total is =SUMPRODUCT($B$2:$B$7,$D$2:$D$7)/12. Coverage is the balance divided by that total. SUMPRODUCT works the same in Excel and Google Sheets.
Where can a tracker help?
It helps with the list, because last year's payments are in your records. Import the statements into SpendixAI, filter for the merchants behind your annual bills and note the date and amount of each. It does not set up the fund itself, so keeping it in a separate account or labelled pot is up to you.
Your check in three steps
- List the bills, amounts and last-paid months.
- Compute what should have been saved, and divide your balance by it.
- If coverage is low, choose a top-up amount and a date.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

