, ,

College Student Budget Spreadsheet | Quadpenny Semester & Monthly Budget Planner for Excel & Google Sheets with Money Left Per Week, Financial Aid Tracker, Roommate Rent Split & Meal Plan Tracker

$9.99

A college student budget spreadsheet that turns refund checks, paychecks, family help and rent into one number: how much you can spend this week without running dry before finals.

  • Semester plan for Fall, Spring and Summer, plus 12 month tabs
  • Financial aid, scholarship and student loan tracker
  • Rent and roommate split with who owes who, meal plan tracker and savings goals
  • Works in Excel and Google Sheets, any currency

Student money is lumpy. A financial aid refund lands in late August, a campus job pays every two weeks, a parent sends something when they can, and rent, books and food have to last until the last week of finals. A normal monthly budget does not fit that. Quadpenny is a college student budget spreadsheet built around the way students actually get paid, and it answers the one question you ask before every purchase: how much can I spend this week?

What this college student budget spreadsheet does

You plan each semester once. Quadpenny adds up your grants, scholarships, loans and work-study, subtracts your school bill, adds your day-one money, job pay and family help, and takes out rent, phone, books, travel and savings goals. What is left becomes your money per week. Then you log what you spend in the month tabs and the dashboard keeps a live number: money left per week for the rest of the semester.

Spend a little more on Friday and the number for the remaining weeks goes down. Pick up an extra shift and it goes up. No guessing, no math on your phone calculator at the register.

Who it is for

  • College and university students living on aid, loans, a part-time job, family help or all four
  • Students sharing an apartment who split rent, utilities and groceries
  • Students on a meal plan who want swipes and dining dollars to last
  • Parents setting up a first budget with a son or daughter heading to campus
  • Complete beginners: you only type in the white cells

Features

Dashboard with money left per week

The big number at the top is your safe weekly spending money for the semester you pick. Under it, a short table shows exactly how it was worked out, step by step, so you can trust it. Cards show your estimated bank balance, weeks left, spending this semester, aid for the year, money borrowed, savings and meal swipes left. Two charts show money in vs spent by month and where this semester’s money went. Roommate balances and goal progress sit at the bottom.

Semester plan

  • Fall, Spring and an optional Summer term, side by side
  • Aid toward your bill vs tuition and fees, housing, meal plan and other charges
  • Refund to you or the balance you owe, worked out automatically
  • Part-time job estimate from pay per hour and hours per week
  • One-time costs such as books, parking, travel home and move-in
  • Plan vs actual spending per week, with a bank balance estimate
  • Student loan box: what you borrowed this year and roughly what it adds to your monthly payment after school

12 month tabs, August to July

Each month has budget vs actual for up to 24 categories, a money-in table by source, a week-by-week view of flexible spending against your weekly allowance, and a 150-row transaction log. Amounts are always positive: the category decides whether a row is money in, spending or a savings deposit.

Financial aid and scholarship tracker

Thirty rows for grants, scholarships, federal and private loans, work-study and other aid, each with semester, amount, expected date, received, renewable and loan rate. Anything past its date and not received is highlighted so you know to check your student portal.

Rent and roommate split

Split up to 12 shared bills equally or by custom percent between up to 5 people. Your share feeds straight into your rent budget. A shared purchases log works out who owes who, and settled rows drop out of the balance.

Meal plan tracker

Track swipes and dining dollars week by week for Fall and Spring. See how many you can use per week from now on, and which weeks went over an even share.

Savings goals and a year view

Six goals with a target, date and plan per month, from a spring break trip to a new laptop. Deposits logged in the month tabs count automatically. The 12 Months tab shows the whole school year with a heat map of where your money goes.

What is included

  • Quadpenny College Student Budget Spreadsheet (.xlsx) with 21 tabs: Start Here, Dashboard, Settings, Semester Plan, Aid & Income, Roommates, Meal Plan, Goals, 12 month tabs and 12 Months
  • User guide (Word .docx) with setup steps, every feature explained, troubleshooting and FAQ

How it works

  1. Settings: currency, school year, semester dates, roommates and your categories with a monthly budget.
  2. Aid & Income: add each award from your financial aid letter.
  3. Semester Plan: type your school bill, day-one money, job hours and one-time costs. Read your money per week.
  4. Month tabs: log deposits and purchases as you go.
  5. Dashboard: check money left per week before you spend.

File format and software

One .xlsx file that opens in Microsoft Excel (2016 or newer, Microsoft 365, Windows or Mac) and in Google Sheets. Every tab was tested in Google Sheets with sample data. There are no macros or scripts. The violet buttons that jump between tabs are made for Excel; in Google Sheets you use the tab bar at the bottom. A free Google account is all you need to use it in Sheets.

Customizing

Pick any currency symbol and every money card follows it. Rename the 24 spending categories and 8 money-in sources, change their type, set your own semester dates and decide which semester each month belongs to, so quarter schools and January starts work too. Formula cells are locked without a password so you cannot break them by accident; input cells stay open.

Digital download

This is a digital product. Nothing is shipped. Download the spreadsheet and guide straight after checkout from your order page and your account. For personal use only: please do not share or resell the file.

Real situations it handles

  • A $3,600 refund arrives in August and has to cover rent and food until December
  • Three roommates split rent, internet and a streaming plan that only two of them use
  • Week 9 of the semester and the meal plan has 40 swipes left
  • Deciding whether you can afford a concert ticket this weekend
  • Working out how much a summer job needs to cover before fall

FAQ

Does this student budget template work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. All tabs were tested there.

My school uses quarters. Will it work?

Yes. Set three terms with your own dates and choose which term each month belongs to.

Does it connect to my bank?

No. You type transactions yourself, which keeps your bank login private and makes you notice where money goes.

What if I live in a dorm with no roommates?

Leave the roommate names blank and type your housing cost on the Semester Plan or as a monthly bill.

Can I use it on my phone?

You can log purchases in the Google Sheets or Excel app. Setup is easiest on a laptop.

Can I use it again next year?

Yes. Save a copy, change the school year on Settings and clear the logs.

Is it good for a parent to give a student?

It works well as a back to school gift. Set it up together the week before move-in.

Reviews

There are no reviews yet.

Be the first to review “College Student Budget Spreadsheet | Quadpenny Semester & Monthly Budget Planner for Excel & Google Sheets with Money Left Per Week, Financial Aid Tracker, Roommate Rent Split & Meal Plan Tracker”

Your email address will not be published. Required fields are marked *

Scroll to Top