I know, I know, the word “spreadsheet” often sends chills up my spine and I break out in a cold sweat, but I promise, this is soooo simple! And if you follow any suggestions from any of my posts, it should be this one. Seriously!
(You may need to click to enlarge)
Isn’t it beautiful?! This is a sample of a budget sheet I had prepared for someone and I rounded the numbers a little just to make things a little easier. This spreadsheet is GREAT if you’re just starting out and you’re not sure what you can afford or not. It’s even great if you’re not just starting out and you’re just looking to cut down in some places and save more money! I’m going to break it down for you so that it’s a little easier for you to make your own. It’s easy, just be realistic about how much you plan to spend in certain sections like: food, entertainment, savings, etc. Don’t expect to only spend $20 for entertainment a month if you know that you go out to eat twice a week.
1. You want to start out with your monthly income and the income of your spouse, partner, or maybe even a roommate. If you don’t receive a fixed monthly or weekly income then just estimate or average it out according to your previous paystubs. Then you want to add your income and the income of your spouse or roommate. If you don’t have a roommate or spouse and this spreadsheet is just for you, then just add the total at the bottom. Then take your monthly income and divide it by 2 in order to get your bi-weekly income. Once you’ve done that, take that number and multiply it by 26 (if you get paid every two weeks) or by 24 (if you only get paid on the 15th and 30th of each month) in order to get your annual income. If you have a partner on this spreadsheet, do the same for them. Then, add it all up. Add both of your monthly incomes together and put the total and add both of your annual incomes and put that at the bottom of the ‘Income’ section.
2. Now it’s time to talk about expenses. You want to make a list of every single bill that you have during the month. If you look at the sample there are expenses such as: rent, cable, cell phone, electric, and food. If you own a home you obviously won’t put rent. You will substitute that for a mortgage payment. Once you list all of the household expenses you want to put the exact amount that you pay each month under the ‘Monthly’ column. Once you’re done filing that in, go row by row and multiply those bills individually by 12. For example if you pay $850 a month in rent, multiply that $850 by 12 to get $10,200 for your annual expense.
3. Move onto the ‘Automobile’ section. Here you will want to list all expenses that have to do with your automobile. For example: Car payment, insurance, gas, and maintenance. Your car payments and insurance should be around the same price every month but your gas and maintenance may vary. I always pay for gas with my debit card so when my monthly statement comes in the mail, I add up how much I spent that month on gas, but for this you’ll want to either estimate or average off how much you spend. As for maintenance, I’m sure you’re not getting your oil changed or tires rotated every single month. Some months you may not spend any money on maintenance for your car but you want to put in some amount that you think is appropriate.
4. The next section is ‘Entertainment’. I consider entertainment expenses to be going out to eat, catching a movie, purchasing a video game, or anything that is a one time kind of thing. Allow yourself to have a certain amount of money every month for entertainment purposes. And remember, be realistic!
5. The ‘Liabilities’ section is important. This is for any credit card, student, or any other loan you might currently have. You may not pay the same amount every month but you want to give yourself a certain amount that you feel comfortable paying. That way if you want to pay a little more or a little less during a certain month, you won’t feel so bad.
6. My favorite and probably the MOST important part of this spreadsheet is the ‘Savings’ section. Every month you want to be able to put some amount of your income into savings. Whether it’s $20 or $200. Talk it over with your partner to see what you’re willing to put away every month and then enter that amount in the ‘Monthly’ column of your savings section. Multiple it by 12 to see how much you could be saving annually! If you don’t have a savings account or you’re looking for a better one, check out the ING Orange Savings Account.
7. This is the fun part. It’s like the “results” of the entire spreadsheet. ‘Total Income’ will just be your combined incomes from the top of the spreadsheet. ‘Total Expenses’ will be the total of all of your ‘Expense’ columns so you’ll need to add up your Household, Automobile, Personal, Liability, and Savings totals together to get that amount. Multiple them by 12 for the ‘Annual’ amount. To get the ‘Discretionary’ amount you want to subtract your ‘Total Income’ from your ‘Total Expenses’. Then the ‘Discretionary’ row is for any money that you have left over from your monthly expenses. Now you’ll get to decide if you want to adjust any of your amounts above. Let’s say that you only want to pay $150 towards your Visa CreditCard debt. Maybe now you want to increase or decrease that amount to make your discretionary amount bigger or smaller. You can also decide if you want to increase your savings amount, which I would prefer!
And that’s it for the monthly budget spreadsheet! I told you it wasn’t so bad. I have the blank prepared excel spreadsheet in my Dropbox account so you can download the entire file here. Please email me at kate@coordinatedkate.com if you have any problems with the download. Any way that I can help, let me know!
The next and final step to this financial organization project is the Yearly Budget Spreadsheet but you’ll need to have this monthly spreadsheet done first. So work on becoming more financially aware and organized and I’ll be posting the yearly spreadsheet soon.
I love this! I am 23 as well and it’s inspirational that you are so organized and budget friendly! I would love a copy of your spreadsheet! jcw522@gmail.com Thank you!
Please email me the Monthly and Yearly spreadsheet 🙂 justjoelyn@gmail.com thank you!
Please send monthly and yearly spreadsheet please 🙂 justjoelyn@gmail.com thank you!
Love your budget spreadsheet. Please forward it to me, I’m always willing to try something that might work for me!!! Greenfamof5@yahoo.com
Please send monthly and yearly spreadsheet please lbandazian.31@gmail.com
Thanks.
Please send me your budget spreadsheets. They will really help me. Thank you! danijocloud@hotmail.com
This is great. Please send the blank template to teenarie75@yahoo.com.
please send a copy of the monthly spreadsheet to tahra_watson@yahoo.com thanks!
I would love a copy of this. Really trying to get organized this year! Thank You!!
Awesome! Please send the monthly budget. Thanks so much.
I would love it if you would send me the monthly and yearly budget spreadsheet templates. I do have excel. Thanks!
I need this spreadsheet! So much better than mine! Krystalannlee@yahoo.com
I would love a copy of this spreadsheet please arober16@gmail.com
Awesome spreadsheet! Please send it to me in Google Doc form at ksuelucas@gmail.com =) Thank you & keep up the amazing tips!
Please send the monthly and annual budget spreadsheet to sarah_wirtz@rpsins.com. Thank you
Can you send me it as well please! burksbr@miamioh.edu
Love this budget spreadsheet! Can you pass it on to me at bridgetgerrity@gmail.com?! Thanks so much 🙂
Please email me your monthly budget spreadsheet anneleifer@hotmail.com thanks.
I would love a copy of this for my college daughter who is learning to live on her own. wljohns@sbcglobal.net Thanks so much!
Such a wise girl for your 23 years! If only I had handled my finances in such a way at your age, who knows where I would be now? Thanks for your generosity in sharing your methods!
This is a great idea!! could you pass it on to me please? scottpudney2407@gmail.com
Thanks.
Can you email me your budget
Please send the monthly and annual budget spreadsheet to jknee24@yahoo.com. Thank you so much!
Hello… what a great timesaver! I would love a copy of this spreadsheet. Please email to shimmer.shine4u@yahoo.com Thank you for sharing!!!
Hello, what a timesaver! I would love a copy of this monthly budget spreadsheet. My email is shimmer.shine4u@yahoo.com. Thank you for sharing!!!
Please send me the monthly and yearly budget spreadsheet…alibrooks21@gmail.com This is what I have been looking for!! Thanks so much!
Thank you for building something easy to read and understand! Would you be so kind to send me the file? Thanks in advance.
Sharleen
Sharleenkurtz@gmail.com
Please send me the monthly and yearly budget spreadsheet…lesley.remick@gmail.com This is so what I have been looking for! Thank you!
I would love a copy. staylers_hunny@yahoo.com
This spreadsheet is fantastic and I would love a copy sent to me at megkeeney@gmail.com
I would like a copy of your spreadsheet, if you’re still sending them out. (: olsufkakc@gmail.com
It’s difficult to find experienced people about this topic, however, you seem like you know what you’re talking about!
Thanks
I would love to get a copy of this! Looks perfect for what me and my fiance need to get started on budgeting! 🙂 gardnermm@me.com
This spreadsheet is so great! Will you email it to me at peyton.deleon@yahoo.com? Thanks so much!
I would love a copy of this spreadsheet! Thanks!! AmberWeyant@gmail.com
please send me your monthly budget spreadsheet eeustace78@aol.com thanks so much
I would love a copy of this!! Very organized! Teacherstaceytaylor@gmail.com
This is great! I would love a copy! commonjklt@yahoo.com
Hello! Please send me your monthly and yearly spreadsheets. I am always trying to be more organized. kefimple@gmail.com. Thank you! 🙂
My I get a copy please?? mmsbeaver@yahoo.com Thanks so much!
May I get the spreadsheet sent to me. miller.jessica991@gmail.com
Please send me a copy of the spreadsheet
please send me a template of this spreadsheet it is excellent
Please send me your awesome spreadsheet!
Thanks Kay
Can i get your spreadsheet – sharon.18.davis@gmail.com
thx!
This is Great! Can you please send me the excel spreadsheet!? Thanks! blwoods113@gmail.com
Briana
I think I could be fit from this. Could you please send me a copy of your blank spreadsheet. Thanks a bunch!
jamimassey@att.net.
I would love a copy of this spreadsheet. I am a 21 year old university student and would love to start budgeting!
kristina.slater@hotmail.ca
Pingback: Don’t forget about your new yearly budget! | Coordinated Kate
I’d love a monthly and yearly spreadsheet. schrambam@hotmail.com
thanks!