A £600 annual bill is much easier to plan for when it becomes six £100 contributions. But an Excel budget can accidentally count both the £100 savings transfer and the final bill as spending.
This guide builds two connected views: a plan for money reserved and a record of money actually spent. You will know how much each annual bill still needs without inflating your household expenses.
Reviewed on 1 November 2026. All amounts are fictional GBP examples. This is a tracking method, not a recommendation for a savings product.
Three numbers with different meanings
| Number | What it means |
|---|---|
| Target | The expected cost you want to cover |
| Reserved | Existing cash assigned to that purpose |
| Spent | The actual payment to the supplier |
Start with bills you can name
List annual or irregular costs such as an insurance renewal, school uniform or a planned appliance replacement. Record an estimated amount, the date it is needed and the number of paydays remaining before that date. A goal is more useful when the next contribution has a clear deadline.
MoneyHelper's savings-pot guide describes dividing money by purpose, after understanding income and essential spending. Your Excel plan can represent those purposes whether the cash sits in separate accounts or one account.
Do not assume the workbook creates bank pots or moves money. It records your decisions. BankSync's UK connection is read-only, as explained in the UK bank guide.
A starting plan for three annual costs
| Fund | Target | Already reserved | Paydays left | Needed per payday |
|---|---|---|---|---|
| Insurance | £600 | £200 | 4 | £100 |
| School costs | £240 | £60 | 3 | £60 |
| Appliance replacement | £900 | £300 | 6 | £100 |
| Next payday total | — | — | — | £260 |
Build the plan in Excel
Create a sheet called Funds. Use columns A to E for Fund, Target, Reserved, Paydays remaining and Contribution needed. Enter numbers as numeric values and apply currency formatting separately.
For the first fund in row 2, the following formula checks that the payday count is positive, then spreads the remaining gap across those paydays. ROUNDUP avoids a fractional penny leaving the target slightly short; MAX prevents an already-funded target asking for a negative contribution. Use numeric inputs and review any invalid values.
=IF(D2<=0,"Review due date",ROUNDUP(MAX(0,B2-C2)/D2,2))
For the insurance example, (600 − 200) ÷ 4 gives £100. Copy the formula down. Your local Excel settings may use semicolons instead of commas.
Count paydays that occur before the money is needed. A bill due before the next payday cannot be funded by that payday. If the amount or due date changes, update the plan and keep a note of why.
Connect the evidence without mixing it into the plan
Create a separate Transactions sheet
Keep imported bank movements distinct from your fund targets and contribution assumptions.
Connect Excel in BankSync
Authorise the correct Microsoft account and choose the OneDrive workbook and destination worksheet.
Map useful fields
Retain date, account, amount, currency, description and source identity where available.
Classify internal transfers
Review both sides of transfers between accounts you include in the household scope.
Record the fund allocation
Update your reserved-money plan only once for the contribution.
Record the supplier payment
Count the actual bill once in the spending report and reduce the fund's reserved amount.
The Excel integration guide covers the Microsoft connection, workbook selection and field mapping. Use a supported OneDrive workbook rather than a local-only file. Check the destination contains the expected rows before relying on any report.
UK bank coverage depends on the institution and account type. BankSync documents roughly 60 days of initial UK history, so an older annual bill may need a separately reviewed statement entry. A missing older payment is not evidence that the bill never existed.
One insurance bill, three different events
| Event | Fund record | Household spending |
|---|---|---|
| Move £100 to your own savings account | Increase insurance reserve by £100 if newly allocated | £0: internal transfer |
| Move £600 back to pay the bill | Keep £600 assigned until the bill is paid | £0: internal transfer |
| Pay the insurer £600 | Reduce insurance reserve by £600 | £600: insurance expense |
Make the reserve agree with real cash
Suppose the savings account contains £1,000, but the Funds sheet assigns £600 to insurance, £300 to school costs and £250 to an appliance. The £1,150 plan over-allocates the same cash by £150. Correct that before calling any fund fully covered.
Define which accounts back the funds and compare the total assigned reserve with the cash available for those purposes. If one current account also covers this month's bills, exclude those commitments before assigning the remainder to annual costs.
A bank's named pots may not appear as separate accounts or transactions through the connection. Inspect what your actual connection exposes; do not assume each virtual pot has its own feed.
If only one side of a transfer is in your workbook, preserve its transfer classification but explain the missing account scope. The household-spending view and the individual account's cash movement answer different questions.
Five checks for the next payday
| Check | Action |
|---|---|
| Target changed | Update the estimate and explain the change |
| Contribution affordable | Compare with essential commitments |
| Cash really reserved | Reconcile allocations to their backing accounts |
| Transfer counted twice | Remove internal movement from expense totals |
| Bill paid | Record actual cost and release any excess reserve |
Frequently asked questions
Formula reference
Microsoft documents ROUNDUP and MAX. The contribution formula above is a suggested workbook calculation, not a BankSync-generated field.