Blush graphic titled Student Budget Spreadsheet: How to Make a College Budget

Student Budget Spreadsheet: How to Make a College Budget in Google Sheets or Excel

A student budget spreadsheet works best when it plans by semester, not just by month. List each term's big costs (tuition, fees, books, rent, food), then your funding (savings, family help, scholarships, grants, loans and job income). The difference shows whether you have a gap, and dividing what's left by the weeks in the term gives you a weekly spending number you can actually use.

Short on time? Our student budget spreadsheet does all of this for you in Google Sheets or Excel.

Why budget by semester?

Student money arrives in lumps: a loan or grant at the start of term, a scholarship once a year, pay from a part-time job every two weeks. Big costs arrive in lumps too. A monthly budget alone can make January look terrible and February look rich. A semester view smooths that out.

How do you make a student budget spreadsheet?

  1. Make columns for each term (fall, winter, summer) and a school-year total.
  2. List your costs: tuition, student and program fees, books and supplies, rent or residence, meal plan or groceries, transit, phone, laptop and tech, personal and social, travel home.
  3. List your funding: savings, family support, scholarships and bursaries, grants, student loans, part-time job (after tax).
  4. Subtract: total funding minus total costs, for each term. A negative number is a gap to fill.
  5. Work out your weekly money: (what's left + your planned personal budget) ÷ weeks in the term.
  6. Track spending in a simple transactions list (date, description, category, amount) and compare it with your plan each month.

What should be in a college budget?

  • Fixed costs: tuition, fees, rent, phone, transit pass, subscriptions.
  • Variable costs: groceries, eating out and coffee, social life, clothes, travel home.
  • One-off costs: textbooks, a laptop, residence deposits, graduation.
  • Savings: even a small emergency fund helps when a bill surprises you.

How do you track student loan payoff in Excel or Google Sheets?

For each loan, record the balance, interest rate (APR) and monthly payment. Excel and Google Sheets both have the NPER function, which gives the number of months to pay off:

=NPER(rate/12, -payment, balance)

For example, a balance of 18,500 at 6.5% with a payment of 250 a month gives about 95 months (just under 8 years). Total interest is payment × months − balance. Try a higher payment to see how much time and interest you save. The Student Loan & Debt Payoff tab in our student budget spreadsheet does this for every loan and card. Loan terms, grace periods and repayment help differ by lender and country, so check your own.

Tips for sticking to a student budget

  • Check your weekly number every Sunday: one figure is easier to follow than twenty categories.
  • Buy used textbooks or check the library before buying new.
  • Use student discounts on transit, software and streaming.
  • Plan for the expensive weeks: start of term, exams and holidays.
  • Keep a small buffer for surprises so one bill doesn't wreck the month.

Want it done for you?

The student budget spreadsheet is ready to use in Google Sheets and Excel. It has a semester budget with costs vs funding and weekly money, monthly budget, dashboard, bill tracker, student loan and debt payoff, and savings goals.

Budget tools for students

FAQ

Is there a budget spreadsheet for students in Google Sheets?

Yes. You can build one with the steps above, or use a ready-made student budget spreadsheet that works in both Google Sheets and Excel.

How much should a student budget per week?

There's no single number. Work it out from your own term: funding minus costs, plus your personal budget, divided by the weeks in the term.

Should I include student loans as income?

Include loan money as funding for the term so you can see how costs are covered, and track the balance separately so you know what you'll repay.

How do I track debt payoff in Excel?

List each debt with balance, APR and payment, then use =NPER(APR/12, -payment, balance) for months to pay off and payment × months − balance for total interest.

Back to blog

More from the blog

Read all articles