A sinking fund splits a big planned expense into equal monthly contributions. Divide the target by the number of months left, and set that amount aside on the same day each month. If a month is missed, take the shortfall and divide it across the months that remain. Then mark the money as committed so it is not spent on something else. A worked example with made-up numbers follows.
What is the monthly contribution?
The formula is target / months. Say you want ₹3,60,000 for a family function twelve months from now. The contribution is 3,60,000 / 12 = ₹30,000 a month. In a spreadsheet, with the target in B1 and the months in B2, use =B1/B2.
Choose the date carefully, and keep it the same every month so that the habit forms. Put the contribution on the day after your salary arrives, and before rent and bills, so it is not an afterthought. Many people set a standing instruction with their bank, and others do it by hand.
What if you miss a month?
Do not panic, and do not try to make it up all at once. Work out what is left and spread it over the remaining months. Say you paid in months 1 to 4 and missed month 5. Saved so far: 4 x 30,000 = ₹1,20,000. Still needed: 3,60,000 - 1,20,000 = ₹2,40,000. Months left, from 6 to 12: 7. New contribution: 2,40,000 / 7 = ₹34,286 (rounded up).
The spreadsheet formula is =(B1-B3)/B4, where B1 is the target, B3 the amount saved so far, and B4 the number of months left. Keep this formula next to the table and update the saved amount each month.
| Month | Planned | Paid | Saved so far | Months left | Needed per month |
|---|---|---|---|---|---|
| 1 | ₹30,000 | ₹30,000 | ₹30,000 | 11 | ₹30,000 |
| 4 | ₹30,000 | ₹30,000 | ₹1,20,000 | 8 | ₹30,000 |
| 5 | ₹30,000 | ₹0 | ₹1,20,000 | 7 | ₹34,286 |
| 6 | ₹34,286 | ₹34,286 | ₹1,54,286 | 6 | ₹34,286 |
How do you stop yourself spending the fund?
The money should be visible but out of reach. Some people use a separate bank account for it, as described in our piece on a separate account for a life-event fund. Others keep it in the same account but record it as committed in their own sheet and subtract it from what they think they can spend. Either way, give the fund a name, a target and a date.
Where you keep the money and whether it earns anything are decisions for you, perhaps after talking to a bank or an adviser. Also remember that prices of venues, travel and catering tend to be quoted for a date, so revisit the target when you sign a contract and replace estimates with the contracted amounts as you go. This article only covers the recording. If the date is near, keep the money somewhere you can access it when needed.
Which costs should the fund include?
- The main bookings, such as venue, catering or travel.
- Clothes, gifts and decorations, which are easy to forget.
- A buffer for small things that were not on the first list.
- Costs that fall due earlier than the event, such as advances.
A fund of this kind works with any large planned expense. In SpendixAI, Pro includes savings goals and budgets, which you can use to show the target and the monthly contribution, and a custom category for the event to record the spending when it happens.
Monthly routine
- Move the contribution on the same day each month.
- Update the saved amount and months left.
- Recalculate the needed amount if a month was missed.
- Review the target against current quotes every quarter.
- Mark the fund as committed so it does not drift into daily spending.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


