Personal Expense/ Finance/ Budget spreadsheet

As many a new monkeys are currently facing... I am dealing with the reality of getting up to speed at work and adjusting to the real world (budgeting, paying bills and just simply staying truckin' organized). As I sat down to create a spreadsheet to organize my finances... I realized I should try to leverage WSO which I've lurked on for years to try to get some help.

So I ask you, do you have a spreadsheet that you use to track all your different streams of income, expenses, budgets... how detailed do you get? How do you organize it? And most importantly can you send it out (you definitely should)?

In addition, for general financial organization purposes.. do use a website like Mint? or just say truck it and hope you don't spend too much. IRA and 401K investments etc.

13 Comments
 

just say fuck, you are an adult, i do not have a truck of any kind

If I had asked people what they wanted, they would have said faster horses - Henry Ford
 
Best Response

Grocery, cable/internet, gas/electricity, weekly eat-out, work lunch/breakfast if needed, loans, gym cost

Some people might have a phone bill depending on job, I do not.

Then whatever is left goes into savings or going out and drinking the money away.

Grocery: $50/week cable/internet: $130/month gas/electricity: $90/month weekly eat-out: $150-200 (live with my g/f so this includes her dinner as well) lunch each work day: $50/week (some people have meal allowance so depends on person) loans: $1000/month gym: $90/month

I eat like a beast cause I gotta maintain those macros. I also live with my g/f so you might be splitting this with other people or not. I usually pay cable/internet and gas/electricity one month and she pays next. Everything else is constant.

Frank Sinatra - "Alcohol may be man's worst enemy, but the bible says love your enemy."
 
yeahright

Grocery, cable/internet, gas/electricity, weekly eat-out, work lunch/breakfast if needed, loans, gym cost

Some people might have a phone bill depending on job, I do not.

Then whatever is left goes into savings or going out and drinking the money away.

Grocery: $50/week
cable/internet: $130/month
gas/electricity: $90/month
weekly eat-out: $150-200 (live with my g/f so this includes her dinner as well)
lunch each work day: $50/week (some people have meal allowance so depends on person)
loans: $1000/month
gym: $90/month

I eat like a beast cause I gotta maintain those macros. I also live with my g/f so you might be splitting this with other people or not. I usually pay cable/internet and gas/electricity one month and she pays next. Everything else is constant.

$220 a month seems steep for what I assume is a one BR? Ever look into how to cut down the cable/internet bill? Friendly suggestion.

"I am not sure who this 'Anonymous' person is - one thing is for certain, they have been one hell of a prolific writer" - Anonymous
 
MFFL

Add $500/month as a 'Misc' expense. If you already have a 'Misc' expense, add another $500. Maybe even more.

I came in to say just take everything that isn't fixed and multiply it by about 25%, but this has the same effect. You will spend way more money than you can even imagine on stupid things.

This to all my hatin' folks seeing me getting guac right now..
 

I started out with a budget for each expense type, but I switched to a simple savings/consumptions model. Figure out what your after tax is each month and how much you want to save. When money is deposited, immediately/automatically put it into a savings acct or similar. The remaining is yours to spend. Start tracking your expenses by category (this is easy if you do mostly credit cards) and then you can see where you are spending frivolously, what you need to cut down on, etc. Mint.com is a great tool to help you do this. Your first few months are going to be expensive because you will inevitably need a bunch of stuff. Also wanted to echo the misc expense. That's going to be a big part of each month, trust me. There's always shit that comes up, random drinks, parties, etc.

 

i recently got an app on my phone where i enter (manually) an expense every time i buy something and categorize it. every week i export the data as a csv then bring it into my excel sheet and sumifs that shit to have all my expenses in one sheet.

definitely noticed my daily spending has gone down since i started using this because i can actually see how buying cheap $10 lunches every day actually adds up pretty quickly.

i understand if people find manually entering everything cumbersome, but personally i like how it forces me to actually think about how much i spend... and then cut down a bit.

Remember, once you're inside you're on your own. Oh, you mean I can't count on you? No. Good!
 

Dolorem et voluptatum dolorum nemo. Eligendi in possimus quia deserunt. Aut rem illum aut suscipit. Omnis est eius consequuntur odit laborum aut consectetur. Architecto dignissimos sit id est. Minima soluta libero et non reiciendis quos occaecati.

Dignissimos occaecati quas explicabo asperiores aut. Dolor odit totam quam quidem aperiam nihil aut aut. Necessitatibus nam sunt culpa ut natus quo vel necessitatibus.

Bourbon all day.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (68) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”