WFMW- Budgeting

Prov. 31:16

She looks over a field and buys it, then with money she’s put aside, plants a garden.

I may not apply this verse with fields and gardens.. but the following post explains how I “put money aside” in order to can fulfill this trait!

Ever since I moved out of my parents house… 18 years ago.. I’ve always tried my hardest to keep a budget. When I first started, I was waitressing, and bringing home lots of cash. As a young woman on my own, I knew I needed to find a way to keep my money set aside for paying bills like rent, food, electric, gas etc… but it was so hard to keep track! As a waitress, it was exciting to walk out the door on a Friday night with $200 in small bills in my pocket.. but it was also easy to BLOW almost that much money going out with my friends or on a trip to the mall.

So.. I started budgeting.

I knew what my “fixed” expenses were, so I wrote them down.  Then I figured out what I would typically make in a month.  Then I came up with percentages for each expense based on the formula expense/income.

I wrote these percentages down on envelopes labeled with the appropriate category.

Then, every night, when I emptied my pockets of all that cash… I would sit down with my calculator and put the right percentage into EACH envelope. That way.. I KNEW that when the rent was due… I would have enough money to pay for it!

Over the years… I grew up! (how on earth did that happen so fast by the way?)

I changed from an all cash situation to earning a paycheck, and I also added quite a few “categories” to my expense list as I added people to my family. 🙂

So, I developed a spreadsheet to be my “envelope” system on my computer.

realtimebudgetcapture

For demonstration purposes I've used random numbers in this image.

This “budget” spreadsheet is something I open everytime I balance my checkbook or use my Quicken. It is formatted on one tab to have an easy at a glance summary of how much money I have set aside into each needed category.

There is another tab that looks like this:

)

Numbers used are not real! 🙂

This tab helps me figure out what my percentages are…. AUTOMATICALLY! That way, as my needs change, and my budget changes.. I can easily change and update my “envelopes”. 🙂

I’ve created a version of my spreadsheet that has “comments” on the main page so that I can make it available to you all! The “comments” are like directions for how to use each column and tab properly. But once you get it all set up it’s really simple and really only involves a weekly  copy/paste to accurately divide out your deposits.

Here’s a view of it with the comments attached. Remember, they can be turned off in excel once you get the hang of it!

formulamakerwithcommentscapture

If you’re interested in downloading this excel spreadsheet for yourself, you can get it here:

Deni’s Budget Spreadsheet

It will help if you go ahead and think about the categories that might work for your family budget. Remember to do your Fixed expenses first, and your discretionary expenses last.

After you get everything set up and start using this system, it’s important to make sure you don’t “steal” from a certain category just because you seem to have leftovers. This system really helps keep you organized with your spending. If you find that after a year you have a major surplus in one category, then you can take from it and readjust your budget number to reflect what you actually need. I’ve found that in the “electric” category it seems like I have “extra” for a few months… but if I leave it there.. it really helps during those super cold months when the heat bill goes up or during the really hot months when the AC is running full blast. I don’t even notice that my bill is higher than usual because I left the surplus alone on the months when my bill was lower than usual.

Make sense?

Well, it works for me! 🙂 Let me know if it works for you too!

siggy1

PS- If you want to see some more Works for Me Ideas

Click this picturew4mw

Advertisements

7 Comments

Filed under Getting Started, organization, Works-for-Me Wednesday

7 responses to “WFMW- Budgeting

  1. Hi Deni,

    Thanks for stopping by and commenting! I also love your suggestions for Bible memory. Thanks so much for sharing.

    Have a blessed day!

  2. Hello. Great spreadsheet. I use this idea too; mine’s a little a different, but the concept is the same. I like to keep up with my expenses throughout the month, so that overtime we’ll see a trend and we’ll know how much we typically spend on groceries and going out to eat, etc. And then if we need to make cuts, we can look at the spreadsheet and decide where to make them.

  3. Deni, what a wonderful tool !

    In these times,it is so important to keep a grip in our spending and know where all our hard earned money goes…I need to improve in this area…thank you very much !

  4. PolishMom24

    Demi –

    I’ve tried downloading your budget spreadsheet but I keep getting an error:

    Invalid Download Format

    Sorry, downloading this document in the requested format has been disallowed at the author’s request.

    Can you help?

    • That was strange.. did the same thing for me, I’ve gone back into my account and reset the copyright status to allow downloads again. Don’t know how that got changed!!! But.. it’s back and should work for you now! Thanks for letting me know.

  5. PolishMom24

    Thank you!! It downloaded perfectly this morning. Time to get to work!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s