Wanting to start a budget? Intimidated by all the choices? Just want something simple to get you going? Stephen P. created his own budget spreadsheet, and he’s offered to share it with Get Rich Slowly readers. He writes:
I have something for Money Hacks. It’s a simple budget spreadsheet that I made in Excel when I was making $30,000/year and struggling to live paycheck-to-paycheck. It helped me to keep things in perspective. Things you can do:
- The tax table pulls from married filing separate. It is in the first 14 or so rows of the blacked out columns to the right of the sheet. If you want to change the tax table, just change the taxable values.
- My fiancee recommended that I add in a pets row, so I did that, and its now under personal expenses. If needed, this could be changed to be child-related.
- Default value for 401k pretax savings is 5% (Typically, employers match some portion for 5% of gross)
- Health insurance typically comes out pretax, hence why its green. You can also put in FSA money here too.
- The pale yellow cells is of course where the budget information is entered . I tried to put those cells where most people would have the easiest time budgeting.
This is based on a lot of input from financial planners. I think it works really well. Let me know if you like it!
Give Stephen’s budget spreadsheet a test-drive. Drop a line with any comments or suggestions.
This article is about Budgeting, Money Hacks, Tools Monday, 26th March 2007 (by J.D.)

RSS Feeds
Facebook
GRS Twitter




March 27th, 2007 at 12:14 am
Thanks! I had been sticking numbers in a pretty sad looking spreadsheet but this is really nice. Makes it real easy to try some different “what if” scenarios.
March 27th, 2007 at 4:41 am
Very well done. I like the financial research that was put into this. One thing that seems to be missing. Charity, church donations, etc. Otherwise perfect.
March 27th, 2007 at 8:30 am
I think the following is missing from E29:
=D29/12
March 27th, 2007 at 8:51 am
Thanks. I’ve made the correction.
March 27th, 2007 at 11:02 am
Please advise. I use Open Office 2.0, How can i download and try it?
March 27th, 2007 at 11:20 am
D6 should read “=D1-D3-D4-D5″
Right now it is taking your C1 income field and subtracting taxes from that, instead of the D1 field, which would be gross minus any pretax contributions (though social security/medicare should still be taxed on C1).
March 27th, 2007 at 11:26 am
I have developed a web application to keep track of my own expenses. It’s a standalone application. Would be interested to know what your readers think of it.. The latest version is available on the link off of http://prolificprogrammer.com/blog/2007/03/23/how_to_keep_track_of_your_chec.html — enjoy!
March 27th, 2007 at 1:31 pm
[...] subscribe to my RSS feed. Thanks for visiting!Astute readers have spotted a couple of errors in the simple budget spreadsheet I shared yesterday. I’ve made corrections and re-posted the [...]
March 27th, 2007 at 2:40 pm
I have something that can complement this budget spreadsheet.
I made this Excel spreadsheet that automatically keeps a running total of all your expenses. All you have to do is input your daily spendings and choose which category they falls into.
http://www.harvestsb.org/savvysteward/wp-content/uploads/2006/Sample_Budget.xls
April 20th, 2007 at 5:00 am
[...] about. I encourage you to subscribe to my RSS feed. Thanks for visiting!Last month Stephen Popick shared his home-grown budget spreadsheet with GRS readers. He listened to your suggestions and went … Growing up, I was taught the importance of having a budget. It wasn’t until I finished [...]
December 10th, 2007 at 6:55 pm
How do you open the application using microsoft works
I do not have excel
I do have the microsoft works spreadsheet
January 4th, 2008 at 8:36 am
[...] http://www.getrichslowly.org/blog/2007/03/26/a-simple-budget-spreadsheet/ [...]
January 25th, 2008 at 2:02 pm
Pretty unrealistic on health cost - our health insurance is over 13% of after tax income for a family of 5. The total for the “personal life” category is only 10%.
Also property tax alone is 11% of our shelter budget.
January 6th, 2009 at 1:39 am
Do you see comments on ancient posts? I was following a link-storm and ended up here looking at budgeting spreadsheets.
There’s something weird about this spreadsheet I just don’t get: The Net Worth is equivalent to Gross minus the sum of 401(k) contributions, Health Insurance, and $2 per dependent.
I followed it up until that last bit; any idea what that’s supposed to be?
Anyway, great resource. Thanks for posting it
September 11th, 2009 at 12:56 pm
It seems that the spreadsheet link above is broken. Gives me an 404 error.