How to Budget | Free Printable Budget Worksheet

by Kelly on January 2, 2012 · 35 comments

Free Printable Budget Worksheet

Now is a great time to sit down with your spouse and make up a budget. I know a lot of you think of the word “budget” as being limiting or terrible or just a plain nuisance, but that’s simply not true. A budget is a tool–just like couponing or menu-planning–that can lead to big savings for you and your family. And now, Faithful Provisions is excited to show you how to budget using this FREE printable Budget Worksheet with step-by-step instructions for filling it out. Easy and user-friendly, this How to Budget worksheet is ready to download and then be personalized by you.

::  Download the FREE Printable How to Budget Worksheet HERE.

Tips for How to Budget

Review your budget at the end of every month. This is the best time to look at the past month, and review your goals for the upcoming month.

Look at your calendar. What is going on during the month ahead? Are there any special items you need to budget for? Things like:

  • A child’s birthday party
  • A family member’s birthday gift
  • Date night: your plans for an evening out plus money for a baby sitter
  • A special offering at church

You can look at past months or even last year’s calendar to get an idea of the different expenses you may have coming up.


Budget-Worksheet

How to use the “How to Budget” Worksheet

Using this budget couldn’t be easier.

  1. Download the FREE Printable Faithful Provisions How to Budget Worksheet.
  2. Follow the pop-up instructions as you fill in your income and expenses. (Instructions will pop up as you hover over the cells.) You’ll find that everything is mapped out for you and easy to navigate.
  3. Ask any questions by commenting on this post.

If you have questions, please ask! I am striving to be here to help you and answer those important questions as you create a budget and set your own goals for sticking to it this year.

You might like these articles:

Plus, find more FREE Tools for Budgeting and Planning HERE.

Photo Source

 

Related Posts:

{ 35 comments }

{ 29 comments… read them below or add one }

1 Chellsey January 2, 2012 at 1:29 pm

How can I open this on a mac? Is it only PC friendly? Thanks!

Reply

2 Kelly January 2, 2012 at 2:01 pm

Oh goodness, I don’t have a Mac and didn’t even think of that. I’ll get to work on it. Anyone else have a Mac and able to download it?

Reply

3 Brenda January 2, 2012 at 2:37 pm

I was actually just about to ask the same question as Chellsey. I was able to get it on my screen, but couldn’t do anything with it. I look forward to a Mac version???

Reply

4 Tracy January 2, 2012 at 8:59 pm

I have a Mac and it does work. When your Mac confirms where you want to save it, there is a drop box below that will give you the option of saving as an .xls file or as ‘any file’. Choose ‘any file’ and it will automatically open it up in the Numbers program.
Thanks for the download! Will be working on it tonight. :-)

Reply

5 Chellsey January 2, 2012 at 11:26 pm

My mac does not give me that option. It just asks if I want to allow “text edit” to open or “other”. When I click other numbers is not an option? I am new to MAC and it can be rather frustrating sometimes for me :) Thanks for any help I can get.

Reply

6 Kelly January 3, 2012 at 7:33 am

CHellsey – I don’t have a Mac, but check out Tracy’s or Rebecca’s comments for a way to use the doc in a MAC. Hope that helps!

Reply

7 Brenda January 2, 2012 at 11:31 pm

Mine doesn’t give me the option Tracy spoke of either, at least not that I saw. I’m not even sure I have a “Numbers” program.

Reply

8 Chellsey January 2, 2012 at 11:53 pm

Me either Brenda :)

Reply

9 Rebecca January 3, 2012 at 12:23 am

Mine worked on my Numbers program on my Mac. Great budgeting tool! I’ve tried over and over to make my own spreadsheet like this but I usually fail miserably. I was able to put together our budget in about 45 minutes tonight using this download and looking back at our past 3 months expenses. Thank you!

Reply

10 Kelly January 3, 2012 at 7:31 am

Rebecca – I am so glad it was helpful! Thanks for letting me know. :)

Reply

11 Tracy January 3, 2012 at 12:46 am

Sorry that it’s not working ladies. I have a Mac OS X 10.6.8 and it came with iWork which has the Numbers program in it along with Pages and Keynote. They are all part of iWork.
Not sure if this will work for you but you may be able to hold the mouse over the .xls download and then hold down ctrl and click on the download. This would be the same as right clicking on a PC. You should see an option to ‘Open With’. Then you should (hopefully) see ‘Numbers’ as an option.
I hope this works for you. :-)

Reply

12 Brenda January 3, 2012 at 8:24 am

I don’t have the entire Work suite, I just have Pages. Looks like we need to get Numbers. Hmm, not sure that’s in the budget. :-)

Reply

13 Melissa January 9, 2012 at 4:59 pm

Silly question but once I enter all my data will the “help” boxes go away or will they be there each time? Or is this designed to strictly print out as a guide?

Thank you for your hard work in creating such a useful tool!

Reply

14 Kelly January 9, 2012 at 6:05 pm

you can right click on each grid that has a comment and “delete comment”

Reply

15 Danielle January 10, 2012 at 1:49 pm

Just FYI for all you other Mac users… I downloaded a free program called Open Office. http://www.openoffice.org/ Opens this worksheet just beautifully. Thanks Kelly for the worksheet! I’ve been looking for an easy way to create a budget, and this worksheet is perfect!

Reply

16 Kelly January 10, 2012 at 1:51 pm

You are so welcome! Thank so much for the help for Mac users. :)

Reply

17 Jessica January 11, 2012 at 4:50 pm

What a great tool! Thank you so much for sharing! This is everything I’ve been looking for in a budget worksheet. I do have a question: On the “Monthly Cash Budget” tab, I’m a little confused about the “Take Home” column. The cell just says “0.1″ and then cell G2 has a comment that says that number should equal the take home amount. Both columns F & G just have large percentage numbers running down. I hope this makes sense. I’m wondering if you could help clear that up? I’m probably doing something wrong, I just know it. It probably doesn’t help that I don’t have a clue what “take home” is anyways. :)

Reply

18 Kelly January 13, 2012 at 6:39 pm

Jessica – for the “Take Home” cell that you’re referring to, you will type in the actual amount of money you take home (how much your pay check is). Then, as you budget out your items in the “Sub-total” column, you will see that they add up. The total amount you “budget” should equal the amount of money you take home (in your paycheck). The goal is to have those 2 numbers equal each other – then you have a “balanced budget”. :-)

Hope that helps clear up your questions. Please let me know if there are any other questions.

Reply

19 Jessica January 15, 2012 at 10:45 am

Perfect!! Thank you for taking the time to answer my question. That clears it up perfectly. :)

Reply

20 Marcie January 28, 2012 at 4:36 pm

I have been working with your Budget Worksheet this afternoon. I don’t understand the tabs “Monthly Cash Budget” and “Pay Period Allocation”. How do I use those? When I enter data into the “Cash Spending Plan” should it cross over to the other tabs? Do you have a tutorial for these extra tabs? Thank you!

Reply

21 Kelly January 29, 2012 at 11:50 am

Marcie – Here are a few things to help you: I”ll work on a tutorial for the other two, but in the mean time.

Cash Spending Plan – no, the data will not cross over to the other tabs. You have to add it manually.
Monthly Cash Budget – this is the first column of the Cash Spending Plan tab, you dont’ need it unless you like to see the data differently (if you are a numbers nerd!) he he
Pay Period Allocation – In this spreadsheet, you just insert your pay period income/take home pay, and as you deduct the other items, the total will change in the “Amt Left” columns. This gives you a visual of exactly where your money is being spent each pay period. It is the same field as in the Cash Spending plan tab. Just shows you last two sets of columns on a separate tab.

Reply

22 Darci April 11, 2012 at 7:37 pm

I found a couple of times in the cash spending plan where it didn’t do the math properly and I had to subtract some categories manually . Then it seemed to reset and be okay from then on out. I noticed it in the repairs and tires row – and again down further too. Not sure if this is a gliche or something I wasn’t doing right but….?

Also, I’d like more of an explanation of the last two sheets of this budget as well. I’m not sure how to use them. What goes in the subtotal of the first column? And when I say what I automatically spent, does it automatically then tell me somewhere how much I have left to spend in that category? Help! :D Thanks so much.

Reply

23 Miguel Collins September 4, 2012 at 12:04 pm

Column D & E have a few errors in the equations that make the Amount Left in columns D & G wrong.

I would suggest that before you use this spreadsheet take a look at all of the equations and make sure the everything totals correctly.

If you don’t have Excel you can also import the spreadsheet into Google docs it converts seamlessly and you can access it where ever you go.

Thanks for the great spreadsheet.

Reply

24 Darci April 11, 2012 at 7:44 pm

Ok so I’ve figured out that the pay period allocation is where I”m logging what I spend and it’ll go down. However, still wondering if there is any place that will keep a running log of how much I’ve spent in each category from month to month so that if I overspend in food one month, it’ll show a negative start the next month – reminding me to spend less that month to get it balanced again??

Reply

25 Adrian January 1, 2013 at 10:53 am

Keeping expenses under control is very important. And to do that it is mandatory to maintain a monthly budget. I am doing this for a few years already and I say that it pays off. I started first with an excel sheet, later I realize there are free online tools which helps you to do that.

Reply

26 Crystal B January 20, 2013 at 9:45 pm

Thank you for the spreadsheet! I have one question–my husband gets paid weekly. Is there a way to add two more pay periods without messing up the totals? :)

Reply

27 Kelly January 21, 2013 at 7:34 am

Crystal, i’ll have to check into it!

Reply

28 kristen February 6, 2013 at 8:16 am

I am wondering the same thing. My husband is paid weekly as well. =0)

Reply

29 http://tinyurl.com/sanatuzo37031 January 23, 2013 at 4:32 am

How much time did it require you to compose “How to Budget | Free Printable Budget Worksheet |
Dave Ramsey — Faithful Provisions”? It comes with plenty of wonderful advice.
Thx -Tamika

Reply

Leave a Comment

{ 6 trackbacks }

Previous post:

Next post:

Web Analytics