Uni Budget Spreadsheet: Build a Student Budget in Excel

How-to basics · Updated November 21, 2026

A uni budget spreadsheet is a simple way to compare the money you expect to receive with the costs you expect to pay. In Excel for Microsoft 365 on Windows, list income and expenses by month, total each group with =SUM(B2:B4), and subtract expenses from income to see the amount left; the example below shows how to set it up and adapt it to student life.

What a uni budget spreadsheet does

A student budget spreadsheet turns a collection of dates, bills and estimates into a view of your cash flow. It can help answer practical questions: Will your student funding cover rent when it is due? How much can you plan for food each week? Are one-off costs such as a laptop or a deposit missing from your monthly estimate?

The spreadsheet is a planning tool, not a guarantee that money will arrive or costs will stay fixed. Its usefulness depends on entering realistic amounts and updating the figures when something changes. It also does not need to be elaborate. A clear list with monthly planned amounts, actual amounts and a remaining balance is often easier to maintain than a complicated workbook with many tabs.

Keep budgeting separate from tracking account balances. A budget describes expected income and costs over a period; a bank balance shows what is available at a particular moment. For example, a monthly budget can show enough income overall while still missing that rent is due before a loan payment arrives. Adding due dates or a simple weekly cash-flow view can help reveal that timing problem.

A practical spreadsheet layout

Start with one worksheet and four columns: category, planned amount, actual amount and difference. Enter all amounts in the same currency and use a consistent period, such as one academic month or one calendar month. If using Excel for Microsoft 365 on Windows, select the amount cells and choose Home > Number to apply an appropriate number format, such as Currency. The exact currency symbol depends on the format selected and your regional settings.

One workable layout is:

  • Rows 2–4: income sources, such as wages, student funding and regular support.
  • Row 5: total income.
  • Rows 9–16: expense categories, such as housing, food, transport and phone.
  • Row 17: total expenses.
  • Row 19: money remaining after expenses.

Leave a blank row between income and expenses so the two groups are easy to distinguish. Give each row a specific label rather than using a vague category such as other for most costs. If you need to record several transactions within a category, keep a separate transaction list and summarize it in the budget, or add another worksheet for those details.

Build the budget in Excel

On a blank worksheet, put Category in A1, Planned in B1, Actual in C1 and Difference in D1. Enter income labels in A2:A4, then put expense labels in A9:A16. For example, income categories might be part-time work, student funding and family support. Expense categories could include rent, groceries, transport, phone, utilities, books, personal spending and subscriptions. Put estimates in the Planned column and leave Actual blank until you have figures to record.

Use one column per month if you want a simple month-by-month view, or duplicate the worksheet for each month. A single sheet with several month columns can make comparison easier, but it becomes wider and needs clearer headings. Whichever arrangement you choose, label the period prominently, such as September, and record whether the figures cover a calendar month, a term or another period.

In Excel, enter a formula by selecting its result cell, typing the equals sign and formula, then pressing Enter. To copy a formula down, select the cell and drag its small fill handle, the square at the lower-right corner, into the cells below. The formula references adjust as they are copied. On Windows, Ctrl+C and Ctrl+V copy and paste; on Mac, use Command+C and Command+V. The formulas here use commas where a function needs argument separators, though the examples use SUM ranges and have no arguments to separate.

Formulas for totals and the remaining balance

Assuming income labels are in A2:A4, planned income is in B2:B4 and actual income is in C2:C4, enter this in B5 to total the planned income:

=SUM(B2:B4)

With the same layout, enter this in C5 to total actual income:

=SUM(C2:C4)

For expenses, assuming planned amounts are in B9:B16 and actual amounts are in C9:C16, enter this in B17:

=SUM(B9:B16)

With actual expense amounts in C9:C16, enter this in C17:

=SUM(C9:C16)

To show what is planned to remain, assuming planned income is totaled in B5 and planned expenses in B17, enter this in B19:

=B5-B17

To calculate the actual amount remaining using actual income in C5 and actual expenses in C17, enter this in C19:

=C5-C17

For a category-by-category comparison, assuming planned rent is in B9 and actual rent is in C9, enter this in D9:

=C9-B9

Copy D9 down through D16 to show the difference for each expense. A positive result means the actual expense was higher than planned; a negative result means it was lower. The same formula works for income rows if the interpretation is adjusted: a positive difference means more income arrived than planned. If you prefer the opposite sign convention, reverse the order of the cell references and label the column clearly.

Worked monthly example

Suppose a student estimates monthly income of 950 from work, 200 from student funding and 150 from regular support. In the planned income cells B2:B4, those figures total 1,300. The total is calculated in B5 by =SUM(B2:B4); the arithmetic is 950 + 200 + 150 = 1,300.

For the planned expenses, suppose rent is 550, groceries 220, transport 60, phone 25, utilities 70, books 40, personal spending 100 and subscriptions 15. Enter those amounts in B9:B16. The planned expense total in B17, calculated with =SUM(B9:B16), is 1,080: 550 + 220 + 60 + 25 + 70 + 40 + 100 + 15 = 1,080. The planned balance in B19 is 220, since 1,300 − 1,080 = 220.

That 220 is an estimate, not necessarily spare cash available to spend. It may need to cover irregular costs that are not yet in the list, such as travel home, course materials, a repair or a rent deposit. If actual groceries later total 245, the difference formula for that category shows 25 over plan. Updating the actual column makes the actual total and balance reflect what has happened, rather than leaving the worksheet as an untouched forecast.

Choosing useful categories and time periods

Useful categories are detailed enough to explain where money goes but not so detailed that updating the sheet becomes a chore. Separating rent from utilities is helpful when they are billed separately. Breaking groceries into individual products usually is not, unless there is a particular reason to track that level of detail. Categories should reflect how you receive and spend money, rather than copying a template without considering your own arrangements.

Consider including these often-overlooked costs:

  • Course supplies, printing, equipment and required software.
  • Travel between home, campus and work, including less frequent trips.
  • Household basics, laundry, toiletries and shared bills.
  • Insurance, health-related costs or other regular commitments that apply to you.
  • One-off costs, such as moving, deposits or replacing a damaged item.

For a cost that happens once or a few times a year, do not assume it disappears because it is absent from a typical month. You can list it in the month when it is due, or estimate a monthly set-aside by dividing the expected total by the number of months over which you are planning. For example, if a course cost is expected to be 240 over a 12-month planning period, 20 per month is a useful planning estimate. The actual payment still falls due at its real date, so keep that timing visible.

Student funding can arrive in installments rather than evenly each month. Avoid treating an annual or term amount as regular monthly income unless that matches when the money is paid and how you plan to use it. A month-by-month budget can show the actual expected payment dates; a separate annual overview can show the total across the academic year. The right period depends on when bills are due and when funds arrive.

Keeping the spreadsheet useful over time

Choose a regular moment to update the sheet, such as after reviewing account transactions or at the end of each week. Enter actual amounts from records rather than relying on memory when possible. If you share housing or bills, clarify whether the budget records your share or the full household amount. Mixing the two can make a spreadsheet appear to show a shortfall or surplus that does not belong to you.

Use a note column or a separate notes area for uncertain estimates. A rent figure confirmed by a contract is different from a guessed food allowance, and marking uncertainty helps you know which numbers to revisit. You can also add a due-date column for major bills. A budget does not need to predict every small purchase precisely; it should make the important commitments and likely trade-offs visible.

Keep a copy before making major structural changes. Excel for Microsoft 365 on Windows can save a workbook locally or to a cloud location, depending on your setup. If using a shared or public computer, avoid leaving personal financial details accessible to others. A basic budget normally does not need account passwords, full card numbers or other sensitive credentials.

Common problems and misconceptions

A frequent mistake is counting the same money twice. For example, if a grant is entered as income when received and then the transfer from a savings account is also recorded as income, the budget overstates available resources. Similarly, if a shared bill is recorded once as a full expense and again as a personal contribution, expenses may be duplicated. Decide what counts as income and expense for the worksheet and apply that approach consistently.

Another problem is mixing monthly costs with annual totals. If a rent figure is entered as a monthly amount but an insurance cost is entered as its whole-year amount, the monthly total is misleading. Convert irregular costs to a comparable planning period or place them in the month they occur, and label the numbers. Also distinguish gross pay from the amount actually received if deductions mean the take-home amount is what is available for spending.

A positive balance does not prove that every week will be affordable. The example’s planned remainder of 220 could be outweighed by an unlisted cost, or bills could fall due before income arrives. Conversely, a month with a large textbook or moving payment may look unusually expensive even if the academic-year plan is manageable. Reviewing both timing and the full period helps avoid treating one month’s total as the whole story.

Finally, estimates are not commitments. Costs vary by location, housing arrangement, course and personal circumstances, so a sample budget should not be copied as if it were a typical or guaranteed student cost. Use your own rent, funding schedule, bills and receipts. If a real funding, tax, lending or legal question affects your situation, check the actual terms with the relevant provider or a qualified professional rather than relying on a spreadsheet estimate.

Excel spreadsheet or budgeting app?

Excel works well when you want to control the categories, see the formulas and adjust the layout. It can also combine a monthly budget with an academic-year plan, provided you maintain it. A budgeting app may be more convenient for automatic transaction imports or notifications, but its features, data handling and costs vary. A paper planner or notes app can be enough for someone who prefers a very small number of categories.

There is no need to move every transaction into Excel to make a useful budget. You might record monthly totals by category rather than copying every purchase, or use a bank’s own categorization as a reference and check its classifications. Consider privacy, ease of access and how consistently you will update a method. The best format is one you understand and can keep current; a sophisticated workbook with stale figures can be less useful than a short, regularly reviewed list.

Frequently Asked Questions

What should a uni budget spreadsheet include?

At minimum, include expected income, regular expenses, irregular costs, totals and the amount remaining. Planned and actual columns help compare estimates with what happened. Add due dates if the timing of funding and bills matters, and use categories that reflect your own costs rather than relying on a generic example.

How do I make a student budget in Excel?

Create columns for category, planned amount, actual amount and difference. List income and expenses in separate groups, use SUM to total each group, and subtract expenses from income to calculate the balance. Update actual figures regularly and keep the budget period consistent, such as one month at a time.

Should student loans or grants be shown as monthly income?

Record funding in a way that reflects when it is paid and the period you are planning. If it arrives as a termly or annual installment, a cash-flow view should show the payment date rather than implying that an equal amount arrives every month. Check the real payment schedule and terms with the funding provider.

How often should I update my uni budget?

Update it often enough to catch changes before they affect bills. Some people find a weekly check manageable; others update actual totals once a month. The important part is to compare the plan with reliable figures and revise estimates when rent, income, travel or other costs change.

Can a spreadsheet show whether I can afford a bill?

It can help compare a bill with planned income and other costs, but a monthly total alone may hide payment timing. Include due dates and expected income dates when cash flow is tight. A spreadsheet is only as accurate as its inputs and cannot guarantee future income or expenses.

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.