How to Use the OVELDA Bills & Sinking Funds Planner
Sinking funds turn irregular expenses into planned monthly amounts. This guide explains what the planner tracks, how each tab works, and how to avoid the entry mistakes that make totals unreliable.
Key takeaways
- A sinking fund spreads an irregular expense into a monthly reserve you set aside in advance.
- Enter each bill and savings target once, then record deposits and withdrawals as they happen.
- The Dashboard and 12-Month Outlook show progress and what is coming; they are planning estimates, not bank balances.
- Use correct due dates and matching Fund IDs, and enter all amounts in one currency to keep calculations meaningful.
- The planner has no bank integration and no automatic payments — you enter and verify your own figures.
Why plan for irregular expenses?
Monthly bills are visible every month. Irregular ones are not. An annual insurance premium, a car service, a holiday or a yearly subscription can be out of mind until the payment is due, and then it competes with everything else that month.
A sinking fund is money set aside gradually for a known future expense. Instead of finding $600 in one month, you reserve a smaller amount each month until the due date. The total cost is the same, but the monthly impact is smaller and planned.
The OVELDA Bills & Sinking Funds Planner is a spreadsheet that organises this process: one place for your irregular expenses, what you have already saved, and what is coming next.
What the planner does
The planner is organised around a few simple records:
- Bills: the recurring and one-time expenses you expect, each with an amount and a due date.
- Savings targets: how much each bill or fund needs in total.
- Monthly reserves: the suggested amount to set aside each month, based on the target, what is already saved and the time remaining.
- Deposits and withdrawals: money moving into or out of each fund, recorded as it happens.
- Future expenses: a 12-month view of what is coming, so you can see busy months before they arrive.
The planner calculates from the figures you enter. It does not connect to your bank and it does not move any money.
Getting started in four steps
You can set up the planner in one sitting:
- 1. Add your bills. List the irregular expenses you expect, with amounts and due dates.
- 2. Set what is already saved. Enter the amount you have put aside for each fund so far.
- 3. Record deposits and withdrawals. Log money going into or out of each fund as it happens.
- 4. Review the Dashboard and 12-Month Outlook. Check monthly reserves, progress and the months ahead.
After setup, the ongoing habit is short: record activity when it happens and review the outlook periodically.
Tab-by-tab instructions
The workbook is organised into six tabs. Each has one job.
Start Here
The orientation tab. Read it first: it explains the structure of the workbook and the order in which to set things up.
Dashboard
The summary view. It brings your funds, progress and monthly reserves together so you can check the overall picture at a glance. Use it for your regular review rather than editing figures there.
Bills
Where you list your expenses. Enter each recurring or one-time bill with its amount and due date. Use one row per expense and keep names consistent so other tabs can reference them correctly.
Savings Funds
Where each fund's target and progress live. The target amount and the linked bill are populated automatically from the Bills tab, so you do not enter them there. Only two fields are manually editable: Opening Saved (what you have already put aside for each fund) and Your Plan / Month (the monthly amount you intend to save). The difference between the target and what is saved, spread over the time remaining, is the basis for the suggested monthly reserve.
Activity Log
Where you record deposits and withdrawals. Add an entry whenever money moves into or out of a fund. Each transaction links to a fund by its Fund ID (B01–B30), not by the fund's name: select the matching Fund ID from the workbook's dropdown and record the deposit or withdrawal as a positive amount. The log is the running history that keeps progress figures current.
12-Month Outlook
The forward view. It shows upcoming expenses across the next twelve months so you can see concentrated months early and adjust your reserves before they arrive.
Worked example
The following is illustrative. The figures are chosen to show the arithmetic, not to represent typical expenses.
| Item | Amount |
|---|---|
| Bill | $600 |
| Already saved | $100 |
| Remaining target | $500 |
| Months remaining | 6 |
| Suggested monthly reserve | $83.33 |
The arithmetic: subtract what is already saved from the bill ($600 − $100 = $500), then divide by the months remaining ($500 ÷ 6 ≈ $83.33 per month).
Rounding may require a small final adjustment. Six deposits of $83.33 total $499.98, so the last deposit may need to be slightly larger — $83.35 in this example — to reach exactly $500. Check your fund total before the due date rather than assuming the rounded monthly amount is exact.
Common mistakes and how to avoid them
Most planner problems come from inconsistent entries. Four to watch for:
- Incorrect dates. A wrong due date shifts the months-remaining calculation and can place an expense in the wrong month of the outlook. Use the actual due date, and update it if the bill changes.
- Duplicate entries. Entering the same bill twice inflates your totals and reserves. If you edit an expense, update the existing row rather than adding a new one.
- Wrong or missing Fund ID. Transactions link to funds by Fund ID (B01–B30), not by name. A deposit logged with the wrong Fund ID — or left blank — will not appear in that fund's progress. Select the Fund ID that matches the fund you are depositing into or withdrawing from, and enter the amount as a positive figure; the workbook determines whether it is a deposit or a withdrawal.
- Inconsistent currency inputs. Entering some amounts in one currency and some in another makes totals meaningless. Use one currency throughout; track other currencies separately with the conversion rate and date noted.
If a total ever looks wrong, check these four first before assuming the workbook is miscalculating.
Important limitations
The planner is deliberately simple. It does not do the following:
- No bank integration. Nothing is imported automatically; you enter and update your own figures.
- No automatic payments. The planner never moves money. A suggested reserve is a plan, not a payment instruction.
- No macros. The workbook contains no macro code.
- No personalised financial advice. The planner organises your own numbers; it does not recommend what you should save or spend.
- Planning estimates are not bank balances. The figures in the planner reflect what you have entered, which can drift from your actual account if you forget to record activity. Verify against your bank account before relying on any total.
Get the planner
Prefer to start with the spreadsheet already set up?
OVELDA Bills & Sinking Funds Planner
Free download · Excel (.xlsx) + PDF guide · No sign-up
The planner gives you the six tabs described in this guide, ready for your own bills and funds. It is an optional starting point; you can build the same system in a blank spreadsheet if you prefer.
Dealing with recurring subscriptions specifically? Read How to Audit Your Subscriptions and Recurring Expenses for a review process you can run before deciding what to keep.
Educational purpose and limitations
This guide is for education, not personal financial advice. It explains how the planner works and how sinking funds are calculated; it does not recommend how much you should save. Figures in the planner are planning estimates based on your own entries, not bank balances or guarantees.
Frequently asked questions
What file format does the planner use?
The planner is an Excel workbook (.xlsx). A separate user guide is included as a PDF.
Which spreadsheet software do I need?
The planner is built as an Excel .xlsx file, so Microsoft Excel is the intended way to use it. Other spreadsheet programs, such as LibreOffice, can open .xlsx files, but layout and formulas may behave differently from Excel. Compatibility with every spreadsheet program has not been verified.
Can I use it for recurring expenses as well as irregular ones?
Yes. You can list recurring bills and irregular expenses in the same planner and set a savings target for each. A recurring expense still benefits from a reserve if you want its monthly cost visible as a planned amount rather than a surprise.
Can I use it for one-time bills?
Yes. A one-time future expense works like any other bill: enter the amount and due date, record what you have already saved, and the planner suggests a monthly reserve for the time remaining.
How does the planner handle different currencies?
Enter amounts in one currency and use it consistently. Mixing currencies in the same fund makes totals and reserves meaningless. If you track expenses in more than one currency, keep separate records for each and note any conversion rate and date you apply.
Where do I get help if something is unclear?
Start with the PDF user guide included in the download. If you still need help, contact OVELDA at contact@ovelda.com, the contact address listed on the OVELDA website.