Martin Lewis Budget Spreadsheet: Find or Build One

How-to basics · Updated November 21, 2026

If you’re looking for a Martin Lewis budget spreadsheet, the official MoneySavingExpert (MSE) option is its free online Budget Planner, rather than a file you should assume is a downloadable Excel workbook. For a spreadsheet you can edit yourself, use the MSE planner’s current instructions or make a simple Excel budget with monthly income, spending and a calculated balance.

What people mean by a Martin Lewis budget spreadsheet

Martin Lewis founded MoneySavingExpert, and people often use his name when searching for the site’s budgeting tools. The phrase “Martin Lewis budget spreadsheet” can therefore mean several different things: the MSE online Budget Planner, a printable budget sheet, or an Excel file someone has made using the same general budgeting approach. Those are not necessarily the same product.

MSE’s Budget Planner is a tool on the MoneySavingExpert website. Its purpose is to help you list money coming in and money going out so you can see your budget more clearly. Website features and instructions can change, so visit MoneySavingExpert directly and check the planner page for the current options. A page that lets you print or save information is not automatically a downloadable .xlsx spreadsheet that you can open and edit in Excel.

Be wary of search results or social posts offering a file under Martin Lewis’s name. Check that a link really leads to MoneySavingExpert before entering information or downloading anything. The name in a filename or webpage heading, by itself, does not establish that a spreadsheet is official.

What the MSE Budget Planner is for

A budget planner is a way to organise your own figures, not a decision about what you should spend. The useful starting point is to record income and spending over a representative period, then compare them. Listing costs that arrive less often than monthly—such as an annual insurance premium—can make the comparison more realistic. Without those costs, a budget may appear to have more spare money than it actually does.

For a useful picture, include take-home income rather than salary before deductions, and include regular bills, everyday spending, debt repayments and irregular expenses. If income varies, it can help to use a cautious estimate rather than relying on an unusually good month. A planner will only be as informative as the figures and categories you put into it.

The result is a snapshot, not a forecast or a guarantee. Prices, household circumstances and income can change. Revisit the figures when a bill changes, a payment ends or your circumstances shift, and use actual bank or bill records to check estimates where possible.

What to include in your budget

Before opening Excel, gather a few months of statements, payslips and bills if they are available. This helps uncover spending that is easy to forget, such as annual renewals or occasional travel. Sort costs into categories that make sense to you; a very detailed list is not useful if it becomes too difficult to maintain.

  • Income: take-home pay, pensions, benefits, or other regular income. Record variable income separately if it is uncertain.
  • Housing and household bills: rent or mortgage payments, council tax, energy, water, broadband and phone costs.
  • Everyday and transport spending: groceries, travel, fuel, parking and other recurring purchases.
  • Commitments: debt repayments, insurance, childcare and subscriptions.
  • Irregular costs and plans: annual premiums, repairs, gifts, holidays and any planned savings contribution.

Keep categories consistent. For example, if groceries are listed as a household cost, do not also include the same supermarket purchases under a general “spending” total. If you include a transfer to savings as a budget allocation, do not count it again as money spent when reviewing your bank transactions.

Build a basic budget in Excel

In Microsoft Excel for Microsoft 365 on Windows, a plain worksheet is enough for a starter budget. Put income labels in column A and their monthly amounts in column B. Put expense labels in column D and monthly amounts in column E. Use a separate cell for costs that need converting from another period. Keep the headings clear, and label the amounts as monthly equivalents so you do not mistake an annual figure for a monthly one.

For an illustrative example, enter net salary of £2,400 and other monthly income of £300 in B2 and B3. Put expenses in E2:E8: housing £900, household bills £220, groceries £350, transport £180, debt repayments £150, subscriptions £35 and a savings allocation of £200. These figures are examples only; they are not a recommended budget.

With those income amounts in B2:B3, put the following formula in B4 to total monthly income. It returns £2,700.

=SUM(B2:B3)

Suppose an annual insurance premium of £600 is entered in E9. With that annual amount in E9, enter this formula in E10 to calculate its monthly equivalent. The result is £50.

=E9/12

For the example, the expense amounts in E2:E8 total £2,035. With E2:E8 holding those monthly expenses and E10 holding the £50 monthly insurance provision, put this formula in E11. The total is £2,085.

=SUM(E2:E8,E10)

With B4 holding total income and E11 holding total expenses, enter this formula in B5 to show the amount left after the listed allocations. It returns £615: £2,700 minus £2,085.

=B4-E11

That £615 is not automatically “spare” money: it only reflects the items entered. Check whether you have missed costs, and decide how to treat any unplanned spending before interpreting the result. You can add rows for more categories and widen the ranges in the total formulas to include them.

Convert weekly and irregular costs to monthly figures

It is tempting to multiply a weekly amount by four to estimate a monthly cost. That understates the annual total because a year has 52 weeks, not 48. For an average monthly equivalent, multiply the weekly amount by 52 and divide by 12. For instance, if weekly groceries average £80 and that amount is in F2, use the following formula in G2. It returns about £346.67 per month.

=F2*52/12

For a payment made every four weeks, use 13 payments per year, then divide by 12 to get its monthly equivalent. If a four-weekly amount of £200 is in F3, enter this formula in G3; it returns about £216.67 per month.

=F3*13/12

For quarterly costs, divide the payment by three; for an annual cost, divide by 12. These conversions spread a cost across the year for budgeting purposes. They do not change when the actual payment leaves your account, so keep enough accessible money for the bill when it falls due. If your spending varies, use a reasonable average based on records rather than treating one unusual week as typical.

How to read the result and keep it useful

A positive balance means the listed monthly income is greater than the listed monthly allocations. A negative balance means the listed costs exceed that income. Neither result identifies the cause by itself: inspect the categories and check for missing or duplicated figures before making changes. If a cost is shared with someone else, enter only the portion that belongs in your own budget, and use the same approach consistently for income and expenses.

Update the sheet when important figures change, then compare estimates with actual transactions periodically. You might add a “last checked” date and a notes column for costs that fluctuate. In Excel, save the file with Ctrl+S on Windows; on a Mac, use Command+S. If you use a shared or public computer, take care not to leave a personal budget file behind.

A spreadsheet is a record-keeping aid, not financial, tax or legal advice. If you need help with debt, benefits, taxes or a financial decision, check the relevant official information or speak to a suitably qualified professional. For borrowing costs or repayment terms, confirm the actual figures with the lender rather than relying on an estimate in a budget sheet.

Common mistakes to avoid

  • Using gross pay: a household budget normally needs the amount that reaches your account, not pay before deductions.
  • Forgetting annual bills: include a monthly provision for them, while remembering that the real payment is still due on its actual date.
  • Underestimating weekly costs: multiplying by four misses four weeks of spending over a year; use 52 divided by 12 for an average month.
  • Counting the same item twice: check category boundaries and avoid adding a savings transfer as both an allocation and an additional expense.
  • Assuming a formula validates the input: Excel totals the cells you specify; it cannot tell whether an amount is correct or whether a bill has been omitted.

Another common misunderstanding is that a budget showing money left over proves that amount is safe to spend. The calculation only covers the entries and assumptions in the worksheet. Irregular costs, changing income and unexpected bills can all affect the real position.

Online planner or your own spreadsheet?

The MSE online planner may suit someone who wants a guided budgeting tool without setting up formulas. A personal Excel sheet is more flexible: you control the categories, layout and calculations, and can adapt it to household or weekly tracking. The trade-off is that you are responsible for setting it up correctly and keeping it current. A printed worksheet can be useful if you prefer to collect figures away from a screen, but you will need to do or transfer the totals yourself.

Choose based on how you will actually use the budget. If you want the official MSE tool, start from MoneySavingExpert’s own website and follow its current instructions. If you want an editable workbook, create your own or use a reputable template whose source and formulas you can inspect. Do not assume a third-party download is endorsed by Martin Lewis or MSE just because it uses their name.

Frequently Asked Questions

Does Martin Lewis have a free budget spreadsheet?
The MoneySavingExpert site has a free online Budget Planner associated with Martin Lewis’s name. Check the official page for current print, save or download options; an online planner is not automatically an Excel workbook.

Where can I find the official Martin Lewis budget planner?
Go directly to MoneySavingExpert and find its Budget Planner page. Using the official site helps you distinguish the planner from unrelated templates or downloads that use similar wording.

Can I use the MSE Budget Planner in Excel?
A web-based planner and an Excel file are different formats. Check the planner’s current instructions for whether it offers an export or printable option. If you need an editable workbook, you can build one in Excel using the monthly totals shown above.

How do I convert weekly spending into a monthly budget?
Multiply the weekly amount by 52 and divide by 12. For example, £80 a week averages about £346.67 a month. Multiplying by four would give £320 and understate the annualised monthly average.

Is a budget spreadsheet financial advice?
No. It organises figures you provide, but it does not assess your full circumstances or recommend a financial decision. Check real product terms with the lender, and ask a qualified professional about advice specific to your situation.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.