Do you guys keep track of your income/expenses on a spread sheet?

Page 2 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.

madoka

Diamond Member
Jun 22, 2004
4,344
712
121
I don't keep track because it would be a tremendous waste of time and I would be sad to see how much frivolous spending I do. I've already spent over $1500 over this weekend.
 

Broheim

Diamond Member
Feb 17, 2011
4,592
2
81
my online bank has a nifty graphic that shows me my earnings vs expenses, how much I've spent in different categories etc.

works pretty well.
 

rh71

No Lifer
Aug 28, 2001
52,856
1,048
126
The point is that no matter how much you make, it is easy to piss money away. If you are only putting away 8% into 401k, you could even benefit from additional savings.

If your company isn't matching 8%+, why put more into 401k? Curious.
 

Jumpem

Lifer
Sep 21, 2000
10,757
3
81
Guess online banking and smartphones have taken the manual work out of it for me. Yea when I was a teenager I'd have to go home to check my balance online, or even stop by an ATM. These days it's just a few touches away. And even then I don't buy anything with debit anymore, credit cards give a free one month loan to figure out what's needed to pay the statement balance.

The balance via the bank's website or smartphone app is almost always inaccurate.

My checking account has two direct deposits for paychecks, random deposits from a HCSA and DCSA. It also has one or two checks at a time outstanding, automatic bill payments, and two regular debit card users.

It's not feasible at all to track it in your head.
 

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
48,518
5,340
136
Planning on doing this to keep track how much money I spend via cash and stuff.

Need some help with it though.

If you are married, then do you also keep track of your wife's income/expenses?

If you need some help with a basic personal finance system, this is what I started out with:

1. Create a Gmail account (if you don't already have one)
2. Create a new Spreadsheet file: In Google Drive called "Finances"
3. Create the following Sheets: (+ sign on the bottom to add new Sheets)

a. Expense Tracker
b. Fixed Expenses
c. Variable Expenses
d. Accounts

4. In Expense Tracker, add the following columns: (horizontally)

a. Date
b. Amount
c. Description

5. In Fixed Expenses, add the following columns:

a. Due
b. Amount
c. Bill Name
d. Type
e. Paid?

6. In Variable Expenses, add the following columns:

a. Monthly Average
b. Expense Name

7. In Accounts, add the following columns:

a. Website Link
b. Phone Number
c. Account Number
d. Username
e. Password
f. Notes

Because you store this in your Google Drive, you can access this anywhere. You can also share the file with your wife. So basically, the first step is to create an account and setup your spreadsheet per the instructions above. This is a very basic, easy-to-use system that doesn't require any special software or math skills. Don't get overwhelmed by it - it's only 4 Sheets inside a single Spreadsheet.

The first Sheet is the Expense Tracker, which is a very simple way to track what you spend every day. Every evening before bed, sit down with your wife for a minute or two and punch in what you spent for the day. If you want to get fancy, you can create an Expense Tracker for cash, bank, and credit cards. This gives you a real-time balance, unlike say your online bank account, which sometimes doesn't display a charge for a few days. You can also get more complex if you want to create a new spreadsheet for yearly Expense tracking - one Sheet per month - and then have a complete history of everything you've spent. This is not as powerful as say Quicken or Mint.com where it can auto-categorize your spending into food, entertainment, gas, etc., but it's simple, it's easy, and it gets the job done. Just sit down for 60 seconds a day and type in what you spent - done.

The second sheet is for Fixed Expenses, which are bills that come out every month. So your car insurance, Netflix subscription, etc. Basically just fill in what the due date is, the amount, the name of the bill, what type it is (for your own records, such as "Entertainment" or "Car"), and whether or not you paid it for the month. So it could say "$8.99, 15th, Netflix, Entertainent, Yes". That way you know what is due & whether or not you've paid it. So every time you pay a bill, type in "Yes" in the "Paid?" field. I'd also recommend doing an auto-sum down the Amount column, which calculates out the total, so you can see what your total fixed monthly expenses are. So if you have a mortgage, services, cars, etc. you can see if you need $1500 a month or whatever just for fixed expenses. Easy, at-a-glance system.

The third sheet is for Variable Expenses. This is where guesswork comes in. How much do you spend on gas per month? If you fill up once a week and your car costs $45 to fill up, then your monthly average would be $180. Tracking your expenses for a few months in your Expense Tracker Sheet will help you figure out how much you spend on average and in what areas - food, gas, clothing, cleaning supplies, etc. I'd also recommend doing the auto-sum calculation feature to see what your average monthly variable expenses are. Combine that with your Fixed Expense total and you have a rough idea of how much you spend per month.

The fourth sheet is Accounts, which is just a quick reference for all of your accounts. So for Netflix, you can put in the website link, your username, password, and any notes (such as - "Setup Netflix on auto-pay via Bank Card"). This gives you quick access to the websites & phone numbers so you can call on your accounts if needed. Ultimately, your workflow will look like this:

1. One-time: Setup spreadsheet
2. Daily: Type in what you've spent into the Expense Tracker with your wife
3. Monthly: Review your spending in Expense Tracker and update your Variable Expense sheet
4. As Needed: Whenever you add a new bill (say you add a Cable TV service), update your Fixed Expense sheet

Very simple and gives you a clear picture on how much money you actually have available, what accounts you have (with easy-access information), how much your monthly budget is, and when everything is due. And because it's a spreadsheet, you can make it as complex as you'd like and add automatic category calculation, add sheets for different investments, payoff plans for loans & other debt, etc.

If you are struggling with debt, Dave Ramsey is usually the go-to guy for financial help. His system is basically: Put $1,000 in Savings first, then pay off each debt starting with the smallest first so that it snowballs until you've got everything paid off.

Other than that, there are a million tools available - Quicken, Mint.com, Microsoft Money, GnuCash, etc., hundreds of them available. Depends on how complex you want to get. If you just have basic needs, then the spreadsheet system above is pretty simple - a minute a day to punch in what you've spent, then add bills & review your variable expenses to calculate monthly spending averages as needed. Done.
 

kyrax12

Platinum Member
May 21, 2010
2,416
2
81
I was wondering. Are those online banking apps safe? Especially for Android.

Also, is it more recommended that I access those banking apps with 4g/lte than any public wifi?
 

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
48,518
5,340
136
I was wondering. Are those online banking apps safe? Especially for Android.

Also, is it more recommended that I access those banking apps with 4g/lte than any public wifi?

If it's from your bank, then it's pretty safe. If it's from a third-party, I'd only trust big names like Quicken. Do you research on other stuff!
 

kyrax12

Platinum Member
May 21, 2010
2,416
2
81
If it's from your bank, then it's pretty safe. If it's from a third-party, I'd only trust big names like Quicken. Do you research on other stuff!

Ok but what about using which internet connection to access the app?

Are public wifi more unsafe than my service provider's 4g network?
 

yottabit

Golden Member
Jun 5, 2008
1,380
249
116
I use spreadsheets to keep track of income and expenses on a more macro level. I typically only update it if I'm looking at something that will change my income or expenses (new job, new apartment, etc)

I just map out all my major expenses (Rent, Utilities, Monthly Food Budget, Loans, etc) using exact figures wherever possible and try to stay conservative on things that fluctuate like food budget or spending money. Keep everything monthly, so if it's a weekly charge multiply by 4, etc. Then have an expense subtotal.

Then map out your income, either using your current pay stubs or a payroll tax calculator to figure out exactly how much you would take home from a new job. Again keep everything monthly. Create income subtotal. (these can both be done for household, or personal)

Subtract expense subtotal from income subtotal and you get what should be your net savings (or loss) every month.

This is the number that's important to keep track of IMO, because it's your only real indicator you have of if your spending habits change. It's a bit of an iterative process at first. Your initial budget might project you saving $1000/mo and you may only save $500. Then you need to go back and reexamine what areas you are overbudget and update them.

Then say you settle into a regular routine of saving $700 a month. It's good to know how much because say if you only saved $500 one month, there should be a reason for that. Either an unexpected expense you knew about in advance (and were expecting your savings to drop) or it could be a red flag for some hidden fees or charges hitting you somewhere that's worth investigating.

I think the hardest part for people that have never done this before is getting their expenses estimated accurately. If you're saving less than the budget says you should be then your expenses off. Yeah it can be hard to admit you spend $400 a month doing XYZ but it's important to first of all track it, and then figure out if XYZ really deserves that much money a month. But until you track it you'll never have the knowledge to be able to make that decision.

I think there is tremendous value to getting an accurate monthly income/expense sheet set up, and quite limited value for most people to going beyond that and tracking expenses daily/weekly. The only reason I could see that being worth it is if you had some kind of irregular income such as sporadic contract/freelance work, and your cashflow was very important.
 
Last edited:

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
48,518
5,340
136
Ok but what about using which internet connection to access the app?

Are public wifi more unsafe than my service provider's 4g network?

As long as the app is encrypted, you should be good. But if it's anything other than an app from your actual bank or from a big-name software vendor like Quicken or Mint, I'd do my research.

Bank information is sent over encrypted communication, so it's basically blocked from view even if someone was sniffing your packets. Aside from the NSA snooping around, you're probably covered
 

manly

Lifer
Jan 25, 2000
11,364
2,373
136
Don't reinvent the wheel, use Mint.com or Quicken.

Not necessarily an 'endorsement', I haven't used the former and it's rather baffling sometimes how little has evolved from Quicken 2001 to 2009 (haven't bothered with anything newer yet).
 

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
48,518
5,340
136
I think the hardest part for people that have never done this before is getting their expenses estimated accurately. If you're saving less than the budget says you should be then your expenses off. Yeah it can be hard to admit you spend $400 a month doing XYZ but it's important to first of all track it, and then figure out if XYZ really deserves that much money a month. But until you track it you'll never have the knowledge to be able to make that decision.

That's why I like doing daily tracking - it really only takes about 30 seconds to punch in what you spent (cash/bank/credit) at the end of each day, and over time you get a clear picture of where your money is going. People I've helped out with finances are always shocked to see how much they are spending on stuff they thought was cheap, especially eating out - one of my buddies was spending over a grand a month in fast food and had absolutely no idea, he thought it was a couple hundred bucks, but as they say, small leaks sink big ships and the little stuff like that adds up. That's an extra $12k a year in his pocket by skipping Starbucks, Dunkin Donuts, McDonalds, and Subway.

The bottom line is that you don't know how much you spend unless you know how much you spend. Spreadsheet tracking is the easiest method for me because you just type in the amount and do an auto-sum on the column. And if you want to get fancy with it, you can do categories & formulas. Bankrate.com did a survey earlier this year and said that basically about 75% of people are living paycheck-to-paycheck and 25% of people have no savings, so it's obvious that it's a difficult subject and most people aren't going to delve into difficult software or more complex financial routines like split transactions. I don't really bother myself either - if I buy something from Newegg, I just throw the final cost with shipping into the "Computers" category. Same with home theater stuff - "Roku 3 - $85 shipped" goes into computers, done. Then I can see at a glance what my general technology spending is per month & per year.

The other tools I use are a scanner & shredded. Right above each other. Mail comes into my house in a bin, then I sit down and shred the junk mail (or throw it away if it's a large catalog), and then scan the keepers into Dropbox and then shred them. No messy papers everywhere, and everything is backed up to my local computer & the cloud. Piece of cake. So maybe about 5 minutes total to sort my mail, update my daily spending tracker spreadsheet, and pay any upcoming bills I owe. Voila, no headache!
 

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
48,518
5,340
136
Don't reinvent the wheel, use Mint.com or Quicken.

Not necessarily an 'endorsement', I haven't used the former and it's rather baffling sometimes how little has evolved from Quicken 2001 to 2009 (haven't bothered with anything newer yet).

Well, it depends on how you do finances. I found Quicken to be overkill and Mint.com didn't fit my needs. So I just do it in a spreadsheet. It depends on how complex your financial picture is & how good your skills are, I guess. Personally, I'm terrible at math and I like having something simple to update & simple to get info from at-a-glance. My ADD kicks in when I look at all those crazy charts in the financial software packages :biggrin:
 

gururu2

Senior member
Oct 14, 2007
686
1
81
Because our income and cost of living are steady now, I know what we earn and spend monthly on fuel, food, entertainment and bills. I input all this information on a spreadsheet so I know where I am at monthly and what category unexpected costs may have arisen. This also lets me project what my savings will be months or years down the road, so it makes it easy to plan for large expenses like vacations or house/car stuff. It also makes it easy to identify problems like when a bill doesn't make sense.
 

stlc8tr

Golden Member
Jan 5, 2011
1,106
4
76
The point is that no matter how much you make, it is easy to piss money away. If you are only putting away 8% into 401k, you could even benefit from additional savings.

Or it might be that 8% already maxes out his 401K contributions. This is ATOT, afterall.
 

zanemoseley

Senior member
Feb 27, 2011
530
23
81
I keep track of all of our accounts (checking,savings, IRA) as well as any "debts" (daughter's savings in our account, amount still owed on IRS first time homebuyer credit). With this basic method I can track my liquid savings month to month and our long term savings (including IRA).

Actually tracking daily expenses fits into more into budgeting. Probably 70%+ of what people spend is fixed (grocery, gas, mortgage, insurance, utilities) so budgeting does little good unless are allowed to follow the budget you've spent. To me its more about knowing when to splurge on vacations, hobbies and home upgrades based on what your month to month savings look like.
 

Slew Foot

Lifer
Sep 22, 2005
12,381
96
86
i keep my business expenses on an excel spreadsheet. its not worth the time to do so for personal stuff.
 

Ms. DICKINSON

Golden Member
May 17, 2010
1,221
1
81
bit.ly
I used to run everything through Money Manager on Iphone for a year then I thought I was totally useless when I'm saving >75% of my income.
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |