Skip to main content

College Expense Budget Sheet: Monthly Bills, Roommate Splits, and Shared Supplies

College Expense Budget Sheet: Monthly Bills, Roommate Splits, and Shared Supplies

A college budget works best when it is simple enough to actually use. Whether you are moving into your first apartment, sharing rent with roommates, or trying to understand where your money goes each month, this guide gives you a practical college expense budget sheet you can copy into a spreadsheet, notes app, or shared roommate document.

The goal is not to make every dollar feel stressful. The goal is to avoid surprises: rent due dates, utilities, groceries, gas, internet, shared paper products, cleaning supplies, and the random apartment costs nobody thinks about until move-in week.

Quick college budget categories

Start by grouping expenses into four buckets:

  • Fixed monthly bills: rent, parking, internet, phone, insurance, subscriptions.
  • Variable monthly costs: groceries, gas, dining out, utilities, laundry, personal care.
  • Semester or one-time costs: books, supplies, move-in purchases, deposits, parking permits.
  • Shared roommate expenses: toilet paper, paper towels, cleaning supplies, trash bags, shared kitchen basics.

If you are still comparing apartments, browse off-campus housing near your campus and estimate the full monthly cost, not just the advertised rent.

Monthly college budget sheet

Copy this into Google Sheets, Apple Numbers, Excel, or a shared Notes document.

Category Estimated Actual Due date Paid by Notes
Rent$$1stCheck lease for late fees.
Utilities / electric$$May change by season.
Water / sewer / trash$$Sometimes billed by apartment.
Internet$$Split by roommates if shared.
Renter insurance$$May be required by lease.
Parking$$Apartment or campus permit.
Groceries$$WeeklySeparate personal vs shared food.
Gas / transit$$Include bus pass, rideshare, parking.
Phone$$Family plan or personal bill.
Laundry$$Machines, detergent, dryer sheets.
Dining out / coffee$$Easy category to underestimate.
Subscriptions$$Streaming, music, apps, gym.
Personal care$$Toiletries, haircut, pharmacy.
Savings / emergency fund$$Even small amounts help.

Semester and move-in expense sheet

Some costs do not happen every month, but they can wreck a budget if you forget them.

Expense Estimated cost When due Required? Notes
Security deposit$Before move-inYesConfirm refund rules.
Application/admin fees$Before leaseMaybeAsk before applying.
First month’s rent$Move-inYesMay be prorated.
Utility setup fees$Move-inMaybeElectric, internet, water.
Furniture$Move-inMaybeSkip if apartment is furnished.
Kitchen basics$Move-inYesCoordinate with roommates.
Bedding / towels$Move-inYesConfirm bed size first.
Books / course materials$Semester startYesWait for syllabus if possible.
Parking permit$Semester startMaybeCampus or apartment.
Emergency buffer$Before move-inRecommendedTarget at least a small cushion.

Roommate shared expense sheet

Roommates should decide which expenses are shared and which are personal. Put it in writing before bills are due.

Shared item or bill Monthly estimate Split method Who pays first? Reimbursement due
Rent$Equal / by bedroom / by lease
Electric / utilities$Equal split
Internet$Equal split
Water / trash$Equal split
Toilet paper$Rotate / equal split
Paper towels$Rotate / equal split
Cleaning supplies$Equal split
Dish soap / sponges$Equal split
Trash bags$Equal split
Shared kitchen basics$Optional split

Three ways roommates can split bills

1. Equal split

Everyone pays the same amount. This is easiest for internet, utilities, cleaning supplies, paper towels, toilet paper, and trash bags.

2. By bedroom or lease share

If one roommate has a larger bedroom, private bathroom, garage spot, or different lease amount, rent may not be equal. Put the exact rent responsibility in writing so nobody is surprised.

3. Rotation system

Roommates rotate buying shared supplies. This can work for toilet paper, dish soap, and cleaning supplies, but it gets messy if one person buys expensive brands and another buys the cheapest option. A shared monthly supply fund is usually cleaner.

Suggested roommate bill rules

  • Pick one bill tracker: Google Sheets, Splitwise, Venmo groups, Apple Notes, or a shared spreadsheet.
  • Set a reimbursement deadline: For example, “pay back shared bills within 48 hours.”
  • Upload receipts: No receipt, no reimbursement drama.
  • Separate personal food from shared food: Label shelves or bins if needed.
  • Agree on brands: Especially for shared paper goods, detergent, and cleaning supplies.
  • Review monthly: Spend 10 minutes each month checking what changed.

Sample monthly roommate budget

Here is a simple example for four roommates. Replace the numbers with your real bills.

Expense Total Per person
Rent$2,800$700
Electric$160$40
Internet$80$20
Water / trash$100$25
Shared supplies$60$15
Estimated shared total$3,200$800

This does not include personal groceries, gas, phone, subscriptions, insurance, laundry, or spending money. Each roommate should still keep a personal budget.

Personal monthly budget example for a student renter

Category Example monthly amount
Shared rent and apartment bills$800
Groceries$250
Gas / transit$120
Phone$50
Laundry / household extras$30
Dining out / coffee$100
School supplies$40
Personal / fun$100
Emergency savings$50
Estimated monthly total$1,540

Your number may be higher or lower depending on city, campus, rent, transportation, meal plan, job income, and family support. The important part is knowing the number before rent is due.

Questions roommates should answer before signing or moving in

  • Is rent split equally, or does room size/private bathroom affect the split?
  • Who sets up electricity, internet, water, or renter insurance?
  • Whose name is on each utility account?
  • When are roommates expected to send their share?
  • What happens if someone pays late?
  • Are groceries shared or separate?
  • What supplies are considered shared?
  • Who keeps shared furniture at move-out?
  • How will you handle damage, lost keys, or move-out charges?

How to avoid common roommate money conflicts

  • Do not rely on memory. Track bills somewhere everyone can see.
  • Do not mix every purchase together. Shared supplies are different from personal snacks.
  • Do not wait three months to settle up. Smaller, faster reimbursements are easier.
  • Do not assume equal usage means equal responsibility. If one person brings a pet, car, or extra appliance, discuss related costs.
  • Do not ignore the lease. The lease controls rent responsibility, fees, parking, guests, damages, and move-out expectations.

Simple formulas for a roommate budget spreadsheet

If you are building this in a spreadsheet, use simple formulas:

  • Per-person equal split: total bill ÷ number of roommates
  • Monthly leftover: monthly income or support − monthly expenses
  • Shared supply fund: estimated monthly supplies ÷ number of roommates
  • Move-in savings target: deposits + first month’s rent + furniture + supplies + emergency buffer

Bottom line

A college budget sheet does not have to be complicated. Track fixed bills, estimate variable spending, plan for semester costs, and make shared roommate expenses visible. The more clearly roommates divide rent, gas, internet, utilities, paper towels, toilet paper, cleaning supplies, and other basics, the less stressful apartment life becomes.

Before you sign, compare apartment options on SkipTheDorm, review the Renter Handbook, and use this worksheet to understand the real monthly cost of living off campus.

Accessibility Tools

Adjust the site or get help using SkipTheDorm.