Tracking Your Spending this MAY
posted in budget, calculator |It seems so simple, but I know a few people that don’t, so perhaps it’s time to iterate:
You NEED a budget. You NEED to track your spending.
I don’t just mean read over your bank statement, or check your credit card bill.
Follow these simple steps:
Use this calculator and figure out your monthly income after taxes.(I got it from Miss Mini-Ducky)
Plug it into this calculator and get a rough budget.
Make an excel spreadsheet (or use quicken) and enter in ALL your receipts. I really mean all. Your coffee, your McDonald’s, your gasoline, your cell phone. Plug it all in. Categorize it (Food, Auto, Rent, Utilities, Pets, Kids - you can be as specific or as vague as you want -it’s *your* tool).
I suggest using the budget from the calculator as a guideline - use it to give you some rough numbers to guide yourself along and perfect your budget.
We did this for April, and it’s quite an eye-opener. It was on my “ToDo” for 2007 and I saw how horribly we were aware of our expenses - we ate out WAY too much, we put way too much on our credit card.
I ran through our statement, and I see why - luckily, the majority of the credit card was on computer parts (I built a system for Dad - he reimbursed me, the check was sent straight to the card).
One thing we did do this month - I have a UPromise Citicard. A *fraction* of every purchase (especially groceries and local establishments, including bars!) go towards my student loan. We’ve devised a system where we use the card to pay for groceries/food and when we get home, we enter the amount into our budget spreadsheet and I write a check through my online credit union to AUTOMATICALLY be sent that night to pay it off - the money is gone that night, the card is paid in full! So it’s win-win, I get a % to my student loans, my card gets used, and we pay it off!
Problems with our budget:
- I don’t account for external incomes. Side-jobs, ebay, my wife’s job, etc. aren’t included in our budget, which makes it much more conservative then it needs be (so if we’re over budget by $50 - it’s BAD but not HORRIBLE).
- We also discovered our eating out habits is responsible for a huge decline in income. We saw the effect one and a half weeks in and cut out dining out the rest of the month - much to our benefit! We also are starting to research local prices to see where we can get the best deals (who has the cheapest bread, eggs, milk, etc.)
Improvements to the Spreadsheet:
I’m looking for other’s spreadsheets before I post mine to incorporate others improvements. Ours is pretty simple - written in Excel Office 2k7 - with mostly simple layout and design. It’s my goal to have it be our one stop shop for budgeting, I still use Quicken as a “whole picture” view, but I’m finding it to be bulky and annoying - I haven’t given up, I just need to learn it more thoroughly.
Anyone else find a useful method for budgeting? Any “must-haves” or “good to knows” you’ve come across?
Related (via The Simple Dollar):
Tips on making a budget
Why you should make a budget
