Student Budget Template

By Jamie Hartwell · Updated 3 October 2026

What's in the workbook

You only type into Monthly. Summary reads from it, and Categories and How to use are there for reference.

• SummaryYear totals for income, fixed costs and variable costs, what you've saved, your savings rate and your biggest variable category. One line at the top says "On track" or "Over budget" with the figure.
• Monthly18 category rows (five income, six fixed, seven variable), Sep to Aug across the top, Year total on the right. Subtotals and Net remaining are formulas, so there's nothing to add up by hand.
• CategoriesThe same 18 categories with a blank notes column. Copy a row across if you want to split Groceries from Takeaways, or Going out into pubs and gigs.
• How to useThree setup steps, what the colours mean, and a short list of things that get missed, starting with entering the whole house's bills when you pay a quarter of them.

How to set it up

Give it ten minutes, with your Student Finance payment schedule and your accommodation contract open, because those two hold the dates.

1. Put the loan in the months it arrives.Copy the amounts and dates off your Student Finance England payment schedule. If you haven't got it yet, divide your award by three as a placeholder and swap in the real numbers when they show up.
2. Put rent in the months it leaves.Halls usually bill in instalments on fixed dates. Your contract has them. Don't spread rent evenly across 12 months if it doesn't come out that way.
3. Fill one normal month of the other fixed costs, then copy across.Use the direct-debit amount, not the advertised price, and only your share of anything split with housemates.
4. Log the variable stuff once a week.Five minutes on a Sunday. Rough is fine, and the spending I'd watch hardest is the small stuff that renews itself.

It opens in Google Sheets (upload the .xlsx to Drive) and Numbers (double-click it in Finder), and the formulas and red formatting carry over. If a total stays blank after you type, you've probably pasted over a SUM formula. Not on Student Finance? Leave the loan row empty and use Parental support, Part-time job and Bursary instead; the student money hub has the grant and bursary guides. If you'd rather answer questions than fill a grid, the student budget calculator does the same sums.

Why October goes red

Your loan arrives three times a year, and rent, food and your phone contract come out on their own timetables. Put a real year into the Monthly sheet and the Net row goes green in loan months and red in nearly every other month. That's normal.

Run Sheffield's real 2026/27 numbers through it. An en-suite room at Endcliffe on the 42-week contract is £195.72 a week, £8,220.24 for the year, and that covers bills, contents insurance and free laundry credits for the Washpoint machines (University of Sheffield Ranmoor and Endcliffe price page, read 2 October 2026). Set that against the full £10,830 maintenance loan for living away from home outside London (gov.uk, same day).

Sheffield takes rent in three goes. They're due on 1 October, 20 January and 14 April. Its 2026/27 fees guide says the first payment covers 20 September to 6 January, the second 6 January to 21 April and the third 21 April to 11 July. The periods run 108, 105 and 81 days. If the bill follows the days, the three payments come to £3,019.68, £2,935.80 and £2,264.76. That's my arithmetic, not Sheffield's. Your payment plan will have the real figures.

Gov.uk says the loan is paid "at the start of each term" once you've registered. Your own amounts and dates sit on your Student Finance payment schedule, so the table uses a third of £10,830, £3,610, as a stand-in.

£2,609.76 across 42 weeks is £62.14 a week for food, phone, travel, books and any kind of life. Autumn is the squeeze. Even if the January payment landed on 6 January, when the second rent period starts, £590.32 would have to cover the 97 days from 1 October, which is £42.60 a week, and it drops for every week the money's later.

So October, November and December all go red on the sheet even if you live on beans. The How to use sheet says "two reds in a row" means something structural is wrong. We wrote that line. On a termly loan it fires every autumn, and the fix is the row below.

The room you pick shifts all of this more than any amount of Sunday logging, by £1,861.02 a year in Sheffield's case, because a shared-bathroom room in Crescent Flats, listed on the same price page with the same bills, insurance and Wi-Fi in the rent, is £151.41 a week, £6,359.22 for 42 weeks, which leaves £4,470.78 of the same loan, or £106.45 a week.

Add a running balance row

On the Monthly sheet, type Running balance in A32. Type =B31 in B32. Type =B32+C31 in C32, then drag that cell right to M32. Nothing else in the sheet changes.

Row 32 now shows what's left of the money at the end of each month. Row 31 can go red in October and you're fine. Row 32 going below zero before a loan month is the warning that counts (it won't turn red on its own, so add a less-than-zero rule in conditional formatting if you want it to).

My rule for the lumpy months is short. The day a loan payment lands, move the next rent instalment into a separate pot before you buy anything. At Sheffield, autumn teaching starts on Monday 28 September and the first rent goes on Thursday 1 October. If your loan arrives with the start of term, that's three days in which £3,610 looks like yours.

The same-day version catches people too. On 14 August 2026 a Kent offer-holder wrote on The Student Room, "I've noticed that the accommodation fees are due the 5th of October and my first maintenance loan is due to come on the 5th of October... however student finance says that it could take up to 3 working days for the payment to come through, what do I do if the money doesn't come in time?" The most useful answer came from another student, AmeAme, on 23 September. "Usually you tell the accom and they'll adjust the payment dates. You just need proof of when you're recieving the payments". That's the move I'd make the day the schedule appears, with a screenshot, not the week rent's due.

January is the date I'd check now. Sheffield wants its second payment on 20 January, but spring teaching doesn't start until 8 February, and I can't tell you which date Student Finance England will use for your January payment. Your schedule can. If it's dated after the 20th, you'd owe £2,935.80 with only what's left of October's £590.32 in the account, which means either an overdraft or that same email to the fees team (residencefees@sheffield.ac.uk, per the guide). Sheffield's 52-week contracts, mostly family flats, take their first payment on 19 August, weeks before any loan exists.

What goes in the other rows

For Groceries, we priced a basic week on Aldi's website on 2 October 2026. It was 1kg of Cucina fusilli (£1.19), four tins of Everyday Essentials chopped tomatoes (43p each), 2.27 litres of semi-skimmed (£1.65), six free-range eggs (99p), a Village Bakery white loaf (55p), a kilo of chicken thighs (£2.99), a kilo of long grain rice (52p), a kilo of brown onions (69p, on offer from 95p), five bananas (78p), a kilo of porridge oats (85p), 400g of mature cheddar (£2.45) and a kilo of frozen mixed veg (99p). That comes to £15.37. The pasta, rice and oats last longer than a week. A top-up week costs less. There's no coffee, no snacks and nothing nice in it, and you should budget a bit for those or you'll stop opening the sheet by week three.

The Travel pass / railcard row is where the 16-25 Railcard goes. It's £35 for a year or £80 for three, for a third off fares, with a £12 minimum fare on weekdays between 04:30 and 09:59 (16-25 Railcard site, 2 October 2026). That floor lands squarely on the Friday-morning train home, which feels a bit personal. The template suggests spreading one-offs across the year, but I'd put the whole £35 in the month you buy it, because £2.92 a month tells you less about where September went.

Halls make two rows easy. Bills and Contents insurance are both £0 in Sheffield's Endcliffe halls, because they're in the rent. A private house in second year won't work like that. Travel insurance for a trip in the Easter break isn't covered anywhere, and it goes in Clothes / personal or its own row.

For Emergencies / buffer, the template suggests £20 to £40 a month, and anything you don't use rolls into the Net saved figure on the Summary sheet.

The April payment and the summer

April looks like the best month on the sheet, and it's the one I'd trust least. In the Sheffield example, £1,345.24 is left after the 14 April rent, and that one sum has to carry you through exams, the end of the contract on 11 July, the move out, the train home with everything you own in a bag for life, and whatever the summer costs before a job or the next loan turns up. If you're coming back for second year, the next loan payment is the start of next autumn's term, so the loan row reads zero from May to August, including the seven weeks after 11 July.

Editorial standards

Written by

Jamie Hartwell

Jamie Hartwell writes the student money guides: loans, payment dates, bank accounts, overdrafts, budgeting. He's been at it since September 2025 and has a soft spot for the dull question of which day the money turns up. jamie@unisorted.co.uk