Lewis Donnovan Monthly Budget Spreadsheet Method

Last updated: 13 October 2026

By applying this method, a user can allocate every pound of their monthly income across bills, debt, savings, investments, and personal spending in under 30 minutes — leaving a controlled buffer and a clear visual breakdown of where their money goes.

// TL;DR

The Lewis Donnovan Monthly Budget Spreadsheet Method is a zero-based budgeting system that allocates every pound of your monthly income across bills, debt, savings, investments, and personal spending in under 30 minutes. You start by confirming total income, then fill each category in order until the 'Left to Allocate' figure lands in a £150–200 buffer zone. Use it at the start of every month as soon as you know your salary, or when setting up a personal budget spreadsheet from scratch. It's built around UK finances, sinking funds, colour-coded status cells, and a deliberate personal allowance so you live well now while saving for early retirement.

Framework

// When should you use the Lewis Donnovan budget method?

Use this skill at the start of each month, as soon as you know your incoming salary and any variable income. Also useful when setting up a personal budget spreadsheet from scratch or reviewing whether your current spending split is healthy.

// What do you need before you start budgeting with this method?

Monthly take-home salaryrequired
Your primary net income from employment for the month
Variable / side income
Any additional earnings from side platforms, freelance work, or rollover buffer from last month
Fixed bills listrequired
All non-negotiable monthly outgoings: mortgage/rent, council tax, utilities, insurance, phone, TV licence, etc. Include your share if costs are split with a partner
Subscriptions listrequired
All recurring subscription payments (streaming, apps, memberships) with their exact monthly cost
Weekly food budgetrequired
Your household weekly grocery spend (your half if split) and how many shopping days fall in the pay period
Debt balances and monthly repayment amounts
Any credit card balances, personal loans, or informal repayments owed this month
Savings and investment targetsrequired
Planned contributions to ISAs, emergency fund, pot savings / sinking funds, and any collectibles or alternative assets
Personal allowance budgetrequired
The fixed amount you choose to spend on yourself this month for discretionary enjoyment
Active sinking fund targets
Named pots you are saving toward (e.g. car service, Christmas, travel, health, vet bills) and the target balance for each

// What are the core principles behind this budgeting method?

Income-First Sequencing

Always begin with the total money coming in before touching any outgoing. Combine salary, side-hustle earnings, and any rollover buffer into one confirmed income figure. You cannot allocate what you have not counted.

Rolling Buffer

Keep a small rolling amount (Lewis uses ~£150–200) in the account at month-end rather than zeroing out. This carries forward as part of next month's income and acts as a micro safety net without requiring a separate emergency withdrawal.

Left to Allocate Target Zone

After assigning money to every category, the 'Left to Allocate' figure should land in the £150–200 range. A number in this zone means the budget is set. A negative number means you must rejig — reduce a category — because you must never plan to spend more than you earn.

Colour-Coded Allocation Logic

Each budget category cell signals its status: white = exactly allocated (healthy), red = underallocated (danger — you haven't covered the cost), green = overallocated (surplus in that bucket). The goal for most categories is white; green on the personal allowance is acceptable.

Pot Savings / Sinking Funds

Rather than saving vaguely, assign named pots to specific future costs (travel, car service, Christmas, health, vet, birthday gifts). Give each pot a target balance and contribute a portion each month. Knowing the money is ringfenced removes financial anxiety about irregular expenses.

Annual-Cost Monthly Budgeting

For costs paid annually (car insurance, TV licence, car service), divide the annual cost by 12 and budget that amount every month. This makes large bills painless because the money is already set aside — and paying annually on car insurance saves a considerable amount versus monthly payments.

Proportional Split with a Partner

Shared household costs (mortgage, council tax, utilities, groceries, pet costs) are tracked as your 50% share only. This prevents double-counting and gives an honest picture of your personal financial position.

Balance vs. Maximisation

The goal is not to squeeze every penny into savings. The budget should leave you feeling like you are living in the now as well as saving for your future. A personal allowance that makes life enjoyable is a feature, not a flaw, of the system.

Bridge Account Thinking

For early retirement planning, a Stocks and Shares ISA serves as a bridge — a pool of accessible money to fund the gap between your planned retirement date and the age at which you can draw on your pension. Contributions should be consistent and long-term.

// How do you apply the Lewis Donnovan budget method step by step?

1
Confirm and total your income
Add: (a) net salary, (b) any active side-income earned this month (freelance apps, services rendered), (c) your rollover buffer from last month. This single total is your starting 'Left to Allocate' number. Do not proceed until this figure is locked.
2
Allocate your Essential Bills block
List every fixed, non-negotiable cost: mortgage/rent (your share), council tax (your share), water, gas & electric (your share), broadband (your share), mobile phone, TV licence (monthly portion of annual cost). Sum them. Enter the total into the bills budget cell and confirm it turns white, not red. Note any recent cost increases — remortgaging, council tax rises — so you are not surprised.
3
Allocate your Subscriptions block
List every recurring subscription: streaming services, fitness or running apps, cloud storage, any other memberships. For subscriptions billed annually, divide by 12 and budget the monthly portion. Enter the total and confirm the cell is white. Consider whether each subscription would exist in your life without the budget prompting you to justify it.
4
Allocate your Food block
Count the number of weekly shopping days (e.g. Mondays) between now and next payday. Multiply your weekly food budget (your half if split) by that count. Adjust for known absences (holidays away = minus one shop). Add a small food emergency buffer (e.g. £10–20) for unplanned needs. Add a separate lunch allowance if you commute to an office. Enter the total and confirm white.
5
Allocate your Car and Travel Insurances block
Include: car insurance (monthly portion of annual premium), home insurance (monthly portion), any other insurance policies (pet, life, health). For annually paid policies, use the divide-by-12 method. Add monthly fuel based on known journeys. Add DVLA road tax monthly amount. Add any train or public transport costs expected. Enter total and confirm white.
6
Allocate your Pets block (if applicable)
List food, medications, litter, vet club subscriptions, and any one-off pet needs. Apply your 50% share if costs are split. Enter total and confirm white.
7
Allocate your Debt Payments block
List every active debt repayment: informal loans (e.g. repaying a partner or family member), credit card balances to clear this month, buy-now-pay-later amounts due. Note: use 0% interest credit cards as a timing tool — charge an expense that falls early so you pay it in the intended budget month. Zero-balance lines stay visible as a motivating record. Enter total and confirm white.
8
Allocate your Savings and Investments block
This block has two sub-components: (a) Investment contributions — e.g. Stocks and Shares ISA (your bridge account toward early retirement). Set a consistent monthly amount. (b) Pot Savings / Sinking Funds — distribute across your named pots based on urgency and targets (see Step 9 for pot detail). Also include emergency fund top-ups if needed. Enter the total and confirm white.
9
Distribute the Pot Savings across your named sinking funds
In your pots/sinking funds tab, assign the month's pot savings total across each named pot: travel, car maintenance, Christmas, health, vet bills, birthdays, collectibles, or whatever applies to your life. Each pot has a target balance. Prioritise pots with imminent needs (e.g. upcoming holiday = heavy travel pot contribution). Record balances so you can track progress month-on-month.
10
Allocate your Personal Allowance
Set a fixed monthly personal allowance — the same amount each month — that covers everything you spend on yourself for enjoyment and discretionary living. Lewis uses £500 as his anchor. This cell is intentionally allowed to go green (overallocated means surplus). Do not eliminate this category in pursuit of maximum savings; it is the mechanism that makes the system sustainable long-term.
11
Check the Left to Allocate figure
Scroll to the summary box. The Left to Allocate number should sit between £150–200 (scale proportionally to your income). If it is negative: identify one or more categories to reduce and reallocate. If it is significantly over £200: consider increasing savings contributions or pot savings rather than leaving money unassigned. If it is in the target zone: the budget is set — no further changes needed.
12
Review the Outgoing Breakdown percentages
Check that your fixed costs (bills + subscriptions + food + insurance) do not exceed ~50% of income. Confirm your savings and investments percentage feels proportionate to your retirement timeline. Review your personal allowance percentage — around 14% is Lewis's benchmark. Use these percentages as a sense-check against rules like the 50/30/20 framework. Update your debt tracker wheel to reflect remaining debt and total paid off to date.

// What are real examples of this budgeting method in action?

A single earner on £2,500/month net wants to start monthly budgeting for the first time.

Begin with Step 1: confirm take-home salary plus any side income or rollover. Work through each block in order. For bills, list only their own costs (no partner split needed). Use the annual-cost monthly budgeting principle for car insurance and any annual subscriptions. Set a personal allowance that feels liveable — perhaps £300 — and name at least three sinking fund pots (e.g. car, Christmas, emergency top-up). Aim for Left to Allocate of £100–150 given the lower income base. The outgoing breakdown wheel should show fixed costs under 50%.

A couple sharing finances wants to integrate a joint account into their personal budget without double-counting.

Calculate your exact 50% contribution to all shared costs (mortgage/rent, council tax, utilities, groceries, pet costs). Enter only your half into each budget block. Confirm with your partner what subscriptions each of you individually covers so there is no overlap. The joint account contribution becomes a single line in your Essential Bills block. Your personal budget then reflects only your share of household costs and your solo discretionary spending.

Someone with a holiday in the current budget month needs to handle variable food and travel spend.

On the Food block: count shopping days, subtract the week(s) you will be away, add a small buffer (e.g. £10) for partial weeks on return. On the Pot Savings block: direct a larger-than-normal amount into your Travel sinking fund this month to cover spending money abroad. On the Debt Payments block: if any trip costs landed on a credit card last month, include the payoff amount here. The Left to Allocate target zone remains the same — the system absorbs the holiday by redistributing pot savings, not by blowing the budget.

// What mistakes should you avoid when using this budgeting method?

Starting with outgoings before confirming total income — always lock the income figure first or the Left to Allocate number is meaningless.
Leaving the Left to Allocate box in negative territory without adjusting — this means you are planning to spend more than you earn, which the system explicitly prohibits.
Paying for insurance, car tax, or annual subscriptions monthly rather than annually when you can afford the annual lump sum — this costs considerably more over a year.
Zeroing out your account each month instead of maintaining a rolling buffer — without the buffer, any unexpected cost immediately blows the budget.
Eliminating the personal allowance entirely in pursuit of maximum savings — this makes the system unsustainable and removes the 'living in the now' balance the method is designed to protect.
Tracking shared costs at full value rather than your 50% share — this overstates your outgoings and gives a distorted picture of your financial position.
Leaving sinking fund pots unnamed and untargeted — without named pots and target balances, savings become an undifferentiated lump and irregular costs feel like emergencies.
Only budgeting when something goes wrong — the method works because it is done at the start of every single month, not reactively.

// What do the key budgeting terms in this method mean?

Left to Allocate: The running total of income not yet assigned to a budget category. The target end-state is £150–200 (adjust proportionally to income). A negative number requires the budget to be rejigged before the month begins.
Pot Savings: Named, ringfenced savings buckets for specific future costs (e.g. travel, car service, Christmas, health, vet bills). Equivalent to what others call sinking funds. Each pot has a target balance and receives a monthly contribution.
Sinking Fund: Lewis's alternate term for pot savings — a dedicated savings bucket for a known future expense, funded incrementally each month so the cost never arrives as a surprise.
Rolling Buffer: A small amount of money (Lewis uses ~£195) intentionally left in the current account at month-end, carried forward as income into the next month's budget rather than zeroed out.
Bridge Account: A Stocks and Shares ISA used specifically to fund the gap between a planned early retirement date and the age at which pension funds become accessible. It 'bridges' the two income phases.
Annual-Cost Monthly Budgeting: The practice of dividing an annually paid cost (car insurance, TV licence, car service) by 12 and setting aside that monthly portion in a sinking fund pot so the lump sum is ready when due.
Outgoing Breakdown Wheel: A visual pie chart generated by the spreadsheet showing each spending category as a percentage of total income. Used to sense-check proportions against rules like the 50/30/20 framework.
Personal Allowance: A fixed monthly budget — the same amount every month — reserved for discretionary personal spending and enjoyment. Treated as a protected line item, not the first thing cut when savings targets increase.
Debt Tracker Wheel: A visual chart on the budget overview tab showing total debt paid off versus remaining balance, updated automatically each month as debt payments are entered.
Rejig: Lewis's term for the corrective action taken when Left to Allocate goes negative — reviewing each category and reducing allocations until the budget returns to a positive target zone.

// FREQUENTLY ASKED QUESTIONS

What is the Lewis Donnovan monthly budget spreadsheet method?

It's a zero-based UK budgeting system that assigns every pound of your monthly income to a category — bills, subscriptions, food, insurance, debt, savings, and a personal allowance — until a 'Left to Allocate' figure lands in a £150–200 buffer zone. It uses named sinking fund pots, colour-coded cells, and proportional partner splits to give a clear visual breakdown of where your money goes.

What is Left to Allocate in a budget spreadsheet?

Left to Allocate is the running total of income you haven't yet assigned to a category. In this method, the target end-state is £150–200 (scaled to your income). A negative number means you're planning to overspend and must rejig; a figure well over £200 means you should push more into savings rather than leaving money unassigned.

How do I start budgeting my monthly salary from scratch?

Start by confirming your total income — net salary plus any side income and last month's rollover buffer — before touching any outgoing. Then work through each block in order: bills, subscriptions, food, insurance, pets, debt, savings, and personal allowance. Check that Left to Allocate lands between £150–200. Never list an outgoing before locking your income figure.

How do I budget for annual costs like car insurance monthly?

Divide the annual cost by 12 and set aside that amount every month in a sinking fund pot. When the lump sum is due, the money is already ringfenced. Paying car insurance annually rather than monthly also saves a considerable amount, so this method lets you capture that discount without the bill arriving as a shock.

How does this method compare to the 50/30/20 budgeting rule?

The 50/30/20 rule is a rough percentage split; this method is a detailed zero-based spreadsheet that assigns every pound to a named category. It still uses percentages as a sense-check via the Outgoing Breakdown Wheel — fixed costs under 50%, personal allowance around 14% — but it goes further with sinking funds, rolling buffers, and colour-coded status cells for precise monthly control.

When should I use this budgeting method?

Use it at the start of every month, as soon as you know your incoming salary and any variable income. It's also ideal when setting up a personal budget spreadsheet from scratch or reviewing whether your current spending split is healthy. The method works because it's proactive and repeated monthly — not reactive when something goes wrong.

What are sinking funds and how do I use them in a budget?

Sinking funds — called pot savings here — are named, ringfenced savings buckets for specific future costs like travel, car service, Christmas, or vet bills. You give each pot a target balance and contribute a portion monthly, prioritising pots with imminent needs. Because the money is earmarked, irregular expenses never feel like emergencies.

What results can I expect from this budgeting method?

You'll allocate your entire monthly income in under 30 minutes, with a clear visual breakdown of where every pound goes and a £150–200 buffer protecting against surprises. Expect fewer financial surprises from irregular costs, consistent savings and investment contributions, and a protected personal allowance so you enjoy life now while building toward early retirement.

How do I split a budget with a partner without double-counting?

Track only your 50% share of all shared costs — mortgage or rent, council tax, utilities, groceries, and pet costs. Enter just your half into each budget block. Confirm which subscriptions each of you individually covers so there's no overlap. This gives an honest picture of your personal financial position instead of overstating your outgoings.

What is a rolling buffer in budgeting?

A rolling buffer is a small amount — Lewis uses around £195 — intentionally left in your current account at month-end rather than zeroing out. It carries forward as part of next month's income and acts as a micro safety net, absorbing unexpected costs without needing a separate emergency withdrawal.

How do I use a Stocks and Shares ISA for early retirement?

Treat a Stocks and Shares ISA as a bridge account — a pool of accessible money to fund the gap between your planned early retirement date and the age you can draw a pension. Contribute a consistent monthly amount long-term. It 'bridges' the two income phases so you're not stuck waiting for pension access.

// GET THIS SKILL — FREE