- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
For those that track expenses on a spreadsheet, what categories do you have?
Posted on 12/30/23 at 4:12 pm
Posted on 12/30/23 at 4:12 pm
I've been tracking our spending for 13 months now. It has definitely helped with identifying what we can afford when we purchase our next home. More importantly, it helped us see where our money is going.. to an extent..
Anyway, I have decided to take it a step further and start categorizing things. Here's what I have so far..
Income
--------
Mortgage
Insurance
Utilities (phone, home utilities, internet)
Groceries
Gas
Eating Out
Medical
Additional essentials
Non Essentials
I can probably lump Gas into a necessity because at some point, it just is what it is.
Groceries should be a category because we can look at what we're purchasing each month to see if it's truly needed or if we can look for different brands.
Eating out I want as a separate category for sure.
What do you all think I should add / consolidate?
Anyway, I have decided to take it a step further and start categorizing things. Here's what I have so far..
Income
--------
Mortgage
Insurance
Utilities (phone, home utilities, internet)
Groceries
Gas
Eating Out
Medical
Additional essentials
Non Essentials
I can probably lump Gas into a necessity because at some point, it just is what it is.
Groceries should be a category because we can look at what we're purchasing each month to see if it's truly needed or if we can look for different brands.
Eating out I want as a separate category for sure.
What do you all think I should add / consolidate?
10
Posted on 12/30/23 at 4:30 pm to VermilionTiger
My expenses:
Hookers
Blow
Hookers
Blow
Posted on 12/30/23 at 4:48 pm to VermilionTiger
I don’t understand why you would manually do this when there are multiple services that do this for you…allows your to spend the time on analysis.
Posted on 12/30/23 at 5:34 pm to lynxcat
I like doing it, personally
Posted on 12/30/23 at 5:56 pm to VermilionTiger
I've been keeping a personal budget in excel since 2012. When I started doing it I had basic categories like yourself but now I've treated it more like a trend report for a business. I have a few large headings with subcategories beneath them.
Housing
Mortgage
Homeowners Insurance
Property Tax
Utilities
Power
Water and Sewer
Phone
Gas Service
Cable and internet
Transportation
Gas
Car Service
Car Insurance
Flights
Lodging
Parking/Rideshare
Investments
Brokerage
Roth
Crypto
Consumables
Food
Groceries
Alcohol
Bar
Miscellaneous
Sport/event Sites
Childcare
Gifts
Church
Entertainment
Gas station
Clothes
Hair
Medical
Other
Housing
Mortgage
Homeowners Insurance
Property Tax
Utilities
Power
Water and Sewer
Phone
Gas Service
Cable and internet
Transportation
Gas
Car Service
Car Insurance
Flights
Lodging
Parking/Rideshare
Investments
Brokerage
Roth
Crypto
Consumables
Food
Groceries
Alcohol
Bar
Miscellaneous
Sport/event Sites
Childcare
Gifts
Church
Entertainment
Gas station
Clothes
Hair
Medical
Other
Posted on 12/30/23 at 8:29 pm to WG_Dawg
Nice list. (although my personality desires to know none of this)
Just curious, what's the difference in Alcohol versus Bar?
Gin versus olives?
ETA: My GF promptly answered my dumbass question. Beer from walmart versus beer from Fat Cat Saloon
Just curious, what's the difference in Alcohol versus Bar?
Gin versus olives?
ETA: My GF promptly answered my dumbass question. Beer from walmart versus beer from Fat Cat Saloon
This post was edited on 12/30/23 at 8:34 pm
Posted on 12/30/23 at 9:19 pm to VermilionTiger
Rent
Insurance
Gas
Power/water
Internet (includes streaming)
Tv
Groceries
Eat out
Entertainment/going out
Other
Like someone else said, it’s fun to have something you built yourself. And the fewer companies that have all my financial data the better
Insurance
Gas
Power/water
Internet (includes streaming)
Tv
Groceries
Eat out
Entertainment/going out
Other
Like someone else said, it’s fun to have something you built yourself. And the fewer companies that have all my financial data the better
Posted on 12/31/23 at 9:22 am to VermilionTiger
Interest expense - mortgage
Interest expense - CC / Auto / Other (if applicable)
I run an accounting firm and after a few years I found it easier for clients, and myself, to track this specifically because we have found errors on 1098s. Also helpful to show other cash outflow to clients for not paying down their CCs or other financed capex (or the spouse that is abusing a CC).
I’ve found a personal balance sheet to be very helpful as well. If you’re going to track income, might as well track your assets.
Interest expense - CC / Auto / Other (if applicable)
I run an accounting firm and after a few years I found it easier for clients, and myself, to track this specifically because we have found errors on 1098s. Also helpful to show other cash outflow to clients for not paying down their CCs or other financed capex (or the spouse that is abusing a CC).
I’ve found a personal balance sheet to be very helpful as well. If you’re going to track income, might as well track your assets.
Posted on 12/31/23 at 10:07 am to VermilionTiger
quote:
For those that track expenses on a spreadsheet, what categories do you have?
1. Booze
2. Drugs
3. Miscellaneous
Posted on 12/31/23 at 12:36 pm to WG_Dawg
I keep a spreadsheet just like this one. It could easily be a word doc. I keep it granular like this with dates to make sure they are forecasting on YNAB for the next month. Helps me keep an eye on running balances.
Posted on 12/31/23 at 4:00 pm to VermilionTiger
I have a drop down for expenses so my sumifs work
Not expenses but I budget savings/investment
Also I have entertainment - cable/golf/hookers/blow etc
Oh and since my a hole Dachshund likes expensive things pets get a line. No really he is the best boy
Not expenses but I budget savings/investment
Also I have entertainment - cable/golf/hookers/blow etc
Oh and since my a hole Dachshund likes expensive things pets get a line. No really he is the best boy
This post was edited on 12/31/23 at 4:04 pm
Posted on 12/31/23 at 8:41 pm to VermilionTiger
Vehicle gas and maint.
Holiday and bday spending budget
Car taxes
Savings
Food i split- groceries and eating out...shocking when I first did this to see how mich money went to food overall
Entertainment
Charity
Holiday and bday spending budget
Car taxes
Savings
Food i split- groceries and eating out...shocking when I first did this to see how mich money went to food overall
Entertainment
Charity
Posted on 1/1/24 at 1:30 pm to VermilionTiger
Vacation
Birthdays
Christmas
Alcohol
Auto (purchase, payments, repairs)
Home maintenance
Birthdays
Christmas
Alcohol
Auto (purchase, payments, repairs)
Home maintenance
Posted on 1/2/24 at 11:58 am to VermilionTiger
For me, everything can fit in to 3 categories: 1) Essentials, 2) Fun, 3) Savings
Posted on 1/8/24 at 8:32 pm to lynxcat
quote:
I don’t understand why you would manually do this when there are multiple services that do this for you…allows your to spend the time on analysis.
Agree.
For $0-$100 a year you can get a system to break it down with solid graphics to be able to quickly check things out.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News