Is There a Right Way to Track Expenses?
I introduced the The Simple Expense Tracker (a free expense tracking spreadsheet) about a week ago, and I’m thrilled that people are finding it easy to use and helpful to their finances. Thank you for the support, and please feel free to contact me with suggestions.
Earlier this week, one user asked me a question on how to use the tracker:
Presh, I noticed you started the [Expense] Tracker on September 1st with a corresponding paycheck of September 1st. If my first paycheck is dated September 6th, should I not record any expenses prior to the sixth? I’m wondering if an accurate, up-to-date spreadsheet requires all of the recorded expenses to be withdrawn from the first entered paycheck.
Here is what I replied back with:
The answer is that it actually doesn’t matter when you start. If you started on September 1, then go ahead and leave in the expenses before your first paycheck. If you want to start from your first paycheck on Sept 6, that way is fine too.
The reason it doesn’t matter is that spending and income will average out over a few months. This will be more obvious when you track a full year of data.
I like this question a lot, because it made me realize there really is no “right” way to track expenses. The “right” way to keep track of things depends on how precise you want the data and more importantly, what you want to use the summaries for.
If you input every piece of financial data starting from January 1 of a year, you can actually track to the penny where your money is going. I can say this because that is what I do. I do this since I’m a numbers freak, so I feel happy when my company annual tax summary matches my records of taxes paid.
If you are slightly less detailed, and instead make sure to input every purchase over $1.00, then you will still really have good sense of where your money is going. You can figure out that your expensive car is taking up lots of money through maintenance, or that you may be renting a place that’s too expensive for you.
The real purpose of the expense tracker is to help you make better decisions. When you know where your money is going, you can then make decisions on how to improve your situation. When I started tracking my expenses, one of the first things I learned was that I spent way too much eating out, so I started cooking at home a lot more. These broad-reaching plans are what I call “global financial decisions” since they account for the overall state of your money and not just one-time decisions, like whether an ATM is worth the fees if you need cash right away. (my answer: yes for a few times, no if it becomes a pattern)
Once you start tracking expenses, you will likely improve your personal finances by planning better and making better decisions. And that will get you a lot further than simply thinking about personal finances as a money-oriented field.
Click here for a link to download the Simple Expense Tracker.
4 Responses to “Is There a Right Way to Track Expenses?”
Hey Presh,
Have you tried moneycenter.yodlee.com? It is an online application that is used by a lot of banks, such as Bank of America (largest Bank in the US) for managing your money online and so is pretty trustworthy.
This particular version is unbranded and completely free and open to use. You login and fill in your online logins for your banks, credit cards, and market accounts. (Make sure your passwords are always very secure)
It will then interface with these accounts and break down your credit card bills and bank accounts automatically into how much you save and spend and add categories as well. If it messes up, it is simple to click a drop down menu to change that a regular store is actually a restaurant. It will also remember the changes that you make to their automated categorizing of your expenses.
You can then click and see charts of your money coming in and out and you can also set up a budget for each category (Food, Hobby, Travel, so on) and it will track automatically each month how close you are to that budget.
Finally, you can do online bill pay through their system so you can use the site as your one stop banking and expense tracking needs.
Another quick and easy site is www.worthie.com. It is in beta and I haven’t looked at it in a while. But it will do charts and you can tag and categorize your spending as well. Although I like Yodlee more because it will do it all for you automatically. But if you are uneasy about giving up your bank logins, check out Worthie.
Kyle
By Kyle on Sep 22, 2007
@Kyle: Thanks for the detailed information about automatic services. Clearly, I have a bias to my own spreadsheet since it is quick, customizable, and secure, but I am open to finding a good automatic service. I will check out Yodlee and Worthie.
By Presh on Sep 22, 2007
hey Kyle, thanks for pointing out those sites, I’d setup a script on my machine to login to various finance sites each day, to keep track of things but I still had to aggregate things myself
I usually try to keep my expenses on a single credit card, but that plan has holes in it, like if I hit up the ATM or use a different card. Thanks for the sites, they sound pretty neat.
By RohoMech on Sep 23, 2007