The day has finally come!
HERE–> EOD Basic 3.0 is RIGHT HERE!! <–HERE
This one is lighter than the deluxe version (still to come), so I called it EOD Basic. I created it with newbies in mind with a step-by-step process to help you from beginning to end.
I am confident that you will love this version.
With 2.0, the first reaction I usually got when showing it was:
In their very best Bill Lumberg impression.
2.0 was great and certainly comprehensive enough for the nerd balls like myself, but I have to admit at first glance, it was like trying to walk as soon as you are born.
Babies take baby steps until they are walking like a pro, and that’s exactly how you should view learning how to budget. It takes time to learn, but before long, you’ll be doing it like a pro!
EOD Deluxe Budget 2.0 ROCKED, so don’t think I won’t be releasing EOD Deluxe Budget 3.0 with lots of new features! Because I WILL! 🙂
I am calling this the Beta version since I know there will be something I missed, but I tried to work out all the snags late into the night. If you find something, email me so I can correct it or make something more clear. Just contact me at firstname.lastname@example.org.
Budget Basics Step-by-Step (Tab One)
Step One – This is where you enter your income for the month.
You’ll notice I have 6 weeks set up for income. No there’s not six weeks in a month but for people that budget based on calendar week I had to do it this way.
In October, starting the week on Sunday there are 6 different weeks in the month. The first and the last have one and two days. for example, if you made money on the1st or 2nd of October, then that income would count for week one. The same goes for October 31st—the sixth week in the month. It’s the only day of that week, but if you made money on that day, that’s where it would go. (if that’s how you want to, but it’s not necessary to use this budget.)
In 2.0, I only had room for 5 weeks and got a few emails about implementing a sixth week. To be honest I didn’t understand why until I started the Manage Your Money challenge where Pocketsmith introduced me to calendar-based budgeting. Not only did I like it, I decided to merge the zero-based and calendar-based budget methods together. I personally think that visualizing the month helps your mind see what needs to be done and by when. A date is just a date, but once you connect that date to a day, it makes all the difference in the world. (for me at least.)
It’s the little things. 🙂
Step Two – Create a bill list.
This is something my wife and I have done for years. This helps us have an updated list of all our bills and when they’re due. This is where the calendar-based budgeting style comes in handy for me. I update this list each and every month as things get knocked off or added. Once you have the list done, updating it takes mere minutes. VISUALIZE when things are due! 🙂
Step Three – List irregular expenses.
It has been my budgeting experience to forget about something important from time to time. This is what kills most peoples desire to budget, because it convinces them it just doesn’t work.
No…what doesn’t work is not budgeting at all because you forgot something. The solution? Create a list of things up to a year in advance, and make a note of the date it is due or when you need the money available. This list has been a life saver for us, as long as you don’t forget to do it, I think it can help you too! 😉
Step Four – This is where you tell EVERY dollar where to be spent.
This is your financial blueprint for your money and your future. Get to know it. Look at it frequently. Read the Total Money Makeover with it. Sleep with it. Take it to work. Just get to know it intimately. (That kind of sounded like a Mattress Discounters commercial didn’t it?)
Seriously though, this is important. If you have a plan, you will be headed where you want to go. Knowing where your money is going is crucial to adjusting your financial plan in order to accomplish each of your goals. Without it, you’re just kind of floating along, never really sure of where you are or where you are headed.
KNOW where you are going!
Step Five – Tell each paycheck what bills it will be paying for that week. (optional)
Of all the special emails I received about version 2.0, a majority of them were so happy to have this available on the same worksheet. I love using the allocated spending plan, and like Dave Ramsey points out when talking about it, most of us use it already, even if only in our heads. I have found that having it somewhere other than my forgetful brain, makes for a much easier budget experience. Give it a shot, but I would recommend at least using it for a month or two before you stop using it. It took me about that long to start liking it.
Your Budget Overview (Tab Two)
I created this for motivational purposes, because I totally believe in having visual aids to help me visualize. 🙂
This form can be printed and takes up only one piece of paper.
The top portion of this worksheet has an overview of your budget — income and expense totals according to category. This snap shot can be handy to have on your fridge.
Not only does it provide a snap shot, it also includes a section for you to list your financial goals out, one by one. You list each goal, the day you want to reach that goal, and there’s also a place to mark it DONE! (they don’t have to be done in order though.)
One of the greatest things is when you accomplish a goal and mark it off! It gives you a much needed motivational boost and keeps you productive. I think what’s more important than accomplishing your goals, is celebrating your milestones along the way. When I say celebrate I don’t mean taking a 5 star luxury vacation cruise to the Bahamas — save that for celebrating your debt freedom. But I don’t mean a simple played out high five either. Make a big deal out of successfully achieving your financial goals. Take your spouse out for a nice dinner, or a play, or anything better than a high five. 🙂 Just celebrate!
My hopes are that this budget worksheet will inspire and encourage you to start a budget. Like it? Hate it? I would love to hear from you!
Note: Be sure to notice the comments marked by a little red triangle. These comments go into more detail about specifics concerning your budget. How to do that, why you want to do that, and anything that I thought would be helpful to know. Don’t know what to do? Look for the red triangle. If you don’t see one, email me at email@example.com, and let me know how I can serve you.
UPDATE: If you have Microsoft Excel 97-2003 download this version: EOD Basic 3.0 (Excel 97-2003)
Be sure to understand that some functionality may be lost between versions. If you have any problems let me know so I can try to resolve them.
Congratulations! I’m make sure to review it and let me subscribers know about it.
Do you have a non-2007 version? I have Office 2000 which does not support .xlsx files. Maybe save it as the 2000 version?
Hey Texas T! Done!
I updated the post above, but here is the link: EOD Basic 3.0 Beta_XL2000
Hope it works okay. It said there may be a loss in functionality. If there is, let me know and maybe I can work out the kinks. 🙂
Loved it really had never used EOD Budgeting Guides. My question is this I set it up for November and it went perfect. I tried to set up December in the same workbook so I copied and pasted to a new sheet which it did fine with except the Budget Overview. It won’t pick up numbers from December’s budget but takes them from November sheets instead. Any ideas? Should you not copy and paste? How would you handle month after month?
Hey Barbara and thanks! 🙂
I normally save the default to have a master copy, in case I mess something up. LOL Then I\’ll save as \”November 2010\” after I have put all my information in there for November. When I want to start a budget for December I open up the previous month (in this example \”November 2010\”) and go through the steps one by one until everything is updated for December. Then save it as \”December 2010\” rinse and repeat. 🙂
Usually very little changes from month to month so updating it each month becomes quick and easy to do.
I hope that helps, that\’s how I do it. I don\’t know much about copying and pasting a whole worksheet but I\’ll assume that you lose some of the functionality if you do. Let me know if I can help you with anything else. Thanks for the feedback and I look forward to hearing from you after you have used it for a month. 😀
Holy freaking crap! I downloaded this a couple months ago and completely ignored it. I took one look at it and said, that thing is too confusing there’s no way I’m tacking that. For some reason, I took a look at it a couple months later and I must say, I’m SOOO upset with myself for not using it the first time I downloaded it!! I love this spreadsheet. I have kept my own spreadsheets, but this combines all my sheets and saves so much time!! I just want to say thanks man. You did an OUTSTANDING job on this thing!!
Hi Therm! Thank you so much for leaving this comment! It is so awesome to know that something I created is helpful for people. I am really glad you are enjoying it!
I’ve been kind of procrastinating about it but I am totally planning on making it even better the next time around with even more features in the same worksheet!
Again thank you for the kind words and the excellent comment! You ROCK! 😀
I’m liking what I see, but I’m just wondering if there is a way I can import (macro) a csv,ofx, qfx,qbo format, so I don’t have to manually input every transaction? I would prefer OFX, QFX, QBO format conversion because I can download just the dates that I want from my bank.
Thanks for the download!
was Deluxe 3.0 ever released, tried to look through the postings but couldn’t find it.
I am wondering the same thing. I love this spreadsheet! There is nothing wrong with this current one but I was wondering if there is an enhanced version of this or a 4.0 version? I have shared this with others too! Thanks for this Brad! Its awesome!