Your Cart
Loading

UK Budget Spreadsheet 2027 – Monthly Planner, Pay Dates & Council Tax

On Sale
£4.99
£4.99
Added to cart

A calm place to plan 2027 in pounds. Type what you expect to come in and go out each month. The spreadsheet adds it up, shows what would be left, and maps UK pay dates around weekends and bank holidays.


Built for a UK household: £ throughout, 2027 bank holidays from GOV.UK, and a council tax helper you can set to 10 or 12 payments.


Pair it with the dated 2027 Goals & Habit Tracker: https://payhip.com/b/t0m1c


WHAT'S INCLUDED

• One Excel workbook (.xlsx) with 9 tabs: Start Here, Settings, Annual Overview, Monthly Budget, Monthly Actuals, Pay Dates 2027, Bank Holidays 2027, Spending Log and Savings Goals

• No macros. Works in Excel, Google Sheets (free) and LibreOffice Calc


UK DETAILS

• Choose England and Wales, Scotland or Northern Ireland for the matching 2027 bank holiday list (from https://www.gov.uk/bank-holidays)

• Monthly payday rules: last working day, last Friday, last calendar day, or a date you choose, with an option to move a date that falls on a weekend or bank holiday

• Weekly, fortnightly and four-weekly payers can type a first payday and see the rest of the year’s dates

• Council tax: GOV.UK says the yearly bill is usually split into 10 monthly payments, and you can ask your council for 12. This file’s 10-payment option skips February and March (a common pattern — always follow your own bill) and lets you enter separate 2026/27 and 2027/28 instalment amounts


THE SHEETS

• Monthly Budget: income, bills, spending and savings for each month, with leftover totals

• Annual Overview: yearly totals and a simple chart of planned leftover

• Monthly Actuals: record what really happened

• Spending Log: optional day-by-day list

• Savings Goals: named pots with “still to go” and a percentage


A few yellow cells contain clearly labelled example figures so you can see the totals move. Replace them with your own numbers before you rely on the file. Bank holiday dates are not examples.


PLEASE NOTE

• This is a digital download. Nothing is posted.

• A personal budgeting spreadsheet. It is not tax, benefits, debt, payroll, legal or financial advice, and it does not calculate income tax, National Insurance or your official pay.

• Type net amounts from a payslip or statement. Your employer’s own payday rules may differ from the working-day assumption used here.

• Use the dates and amounts on your own council tax bill.


COMPATIBLE WITH

Microsoft Excel, Google Sheets (free; upload the file to Google Drive) and LibreOffice Calc. A computer is easiest for Settings.


If the file is faulty or doesn't open, message me and I'll fix it or refund you.


Designed by me with help from AI tools; every page checked by hand.

You will get a XLSX (36KB) file