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 | $ | $ | 1st | Check 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 | $ | $ | Weekly | Separate 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-in | Yes | Confirm refund rules. |
| Application/admin fees | $ | Before lease | Maybe | Ask before applying. |
| First month’s rent | $ | Move-in | Yes | May be prorated. |
| Utility setup fees | $ | Move-in | Maybe | Electric, internet, water. |
| Furniture | $ | Move-in | Maybe | Skip if apartment is furnished. |
| Kitchen basics | $ | Move-in | Yes | Coordinate with roommates. |
| Bedding / towels | $ | Move-in | Yes | Confirm bed size first. |
| Books / course materials | $ | Semester start | Yes | Wait for syllabus if possible. |
| Parking permit | $ | Semester start | Maybe | Campus or apartment. |
| Emergency buffer | $ | Before move-in | Recommended | Target 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.