A sinking funds spreadsheet tracks money you set aside each month for bills that arrive once or twice a year. Give each goal one row with its amount, due date and monthly target. Add each month's transfer to the saved column, and when the bill appears on your bank statement, subtract it from that goal's balance.
What goes on a sinking funds spreadsheet?
A sinking funds spreadsheet needs one row per goal and six columns: the goal name, the expected amount, the due date, the monthly target, the amount saved so far, and the balance left to save. A sinking fund is money saved in small pieces for a known future cost.
Good candidates are costs that are certain but not monthly: car insurance, car registration, the annual software or club membership, holiday gifts, school fees, a vet visit, and replacing tyres. Leave out true emergencies, which belong in an emergency fund, because you cannot put a due date on them.
Here is an example sheet in October, after one drawdown. The goals and amounts are made up for illustration.
| Goal (example) | Amount | Due | Monthly target | Saved so far | Left to save |
|---|---|---|---|---|---|
| Car insurance | 876.00 | Jan 2027 | 146.00 | 438.00 | 438.00 |
| Holiday gifts | 600.00 | Dec 2026 | 100.00 | 400.00 | 200.00 |
| Car registration | 210.00 | Jun 2027 | 17.50 | 70.00 | 140.00 |
| Tyres | 640.00 | Sep 2027 | 53.33 | 53.33 | 586.67 |
| Annual memberships | 180.00 | Oct 2027, renewed Oct 2026 | 15.00 | 0.00 | 180.00 |
The last row shows a drawdown. The membership renewed in October, the payment came off the saved column, and the goal starts again from zero for next year.
Monthly targets for each sinking fund goal
The monthly target for a sinking fund goal is the amount still needed divided by the months left before it is due. A $600 gift budget due in six months needs $100 a month. If you start late, the target rises, so the formula should read from today rather than from a fixed start date.
In a spreadsheet, put the amount in B, the due date in C and saved so far in E. The target cell is =IFERROR(MAX(0,(B2-E2)/MAX(1,DATEDIF(TODAY(),C2,"m"))),0). DATEDIF counts whole months between today and the due date, and the inner MAX stops a division by zero in the due month itself. The outer MAX keeps the target at zero once a goal is fully funded, and IFERROR returns zero after the due date has passed, which is your cue to move the date forward a year.
Add the monthly targets for all rows and you get one figure: the transfer to make every payday. In the example table that is $331.83. If the total feels too large, look at the dates first. Stretching a goal to its real due date costs nothing, while cutting the amount means you are short later. When your pay changes from month to month, base the transfer on a low month, as described in budgeting on variable income from past bank statements.
Drawing down sinking funds with statement rows
Statement rows draw down a sinking fund when the bill it was saving for gets paid. Each month, scan the new statement for payments that match a goal, copy their amounts into a drawdown tab with the goal name, and let a SUMIF subtract them from that goal's saved total. The statement proves the money was spent.
A simple layout uses two tabs. The goals tab holds the table above. The movements tab holds dated rows with the goal, the amount and a type: "in" for monthly transfers and "out" for payments. Saved so far becomes =SUMIFS(Movements!C:C,Movements!B:B,A2,Movements!D:D,"in")-SUMIFS(Movements!C:C,Movements!B:B,A2,Movements!D:D,"out"). Nothing is typed into the goals tab after setup.
Getting the payment rows is quick if your bank offers a CSV download. If you only have PDF statements and plan to use an online converter, check the site before you upload a file with your account details; how to check if a converter site is legit lists what to look for. CheapBankConvert, not yet open, describes encrypting statements and deleting them after download, and its early price is $2.99 for a statement up to 10 pages, as the homepage shows.
Where does sinking fund money sit between bills?
Sinking fund money can sit in one savings account for all goals, with the spreadsheet tracking how much of the balance belongs to each, or in separate accounts per goal. One account is simpler and the spreadsheet does the splitting. Separate accounts make each goal visible in your banking app but multiply the transfers.
With one account, the spreadsheet must agree with the bank. Add up the saved column for every goal and compare it with the savings account balance on the latest statement. Interest makes the bank a little higher; a large gap means a transfer or a drawdown was not recorded.
Couples who share some goals and not others often keep a joint sinking fund for shared bills and separate ones for personal goals. A budget for couples spreadsheet with joint and separate accounts shows how to split shared categories fairly, and the same split works for sinking fund transfers.
Sinking fund shortfall: when the bill beats the balance
A sinking fund shortfall happens when the bill is larger than the money saved for it, usually because the price rose or the goal started late. Pay the bill, record the full amount as a drawdown, and let the goal go negative. Then raise next year's amount to the new price, and cover the gap from that month's budget.
Do not quietly borrow from another goal to hide the shortfall. Moving $120 from the tyre fund to cover insurance looks tidy, but the tyre goal is now behind and will surprise you later. If you must move money between goals, record it as an "out" on one and an "in" on the other so the sheet shows what happened.
Review the amounts once a year, when renewal notices arrive. Insurance, memberships and registration fees change, and a sinking fund saving for last year's price is the most common reason for a shortfall. Updating the amount column is the only change needed; the targets recalculate on their own.