Blank budget template as Excel spreadsheet

NOTE: I made a new Monthy, Bi-Weekly, Weekly combined form.

My wife and I are currently facilitators in Dave Ramsey’s Financial Peace class and several people have asked me how I made my nice one page budget form. It is a Microsoft Excel file, and has everything squeezed in a very small space.

Here is a blank version of my Budget Template.
See also the bi-weekly budget form.

Update 11/15: I was asked for instructions on how to use this spreadsheet.

It is very much like the paper budget forms. Column B is the category, and column C is how much you have budgeted for that month. Column D is how much you have spent so far this month, so at the beginning of the month these will be all zero. Now column D is all formulas, since I didn’t want to do math every time I wrote a check. So if you look at the second sheet “Actuals” you see a similar chart showing the same first 3 columns. Starting in column D, you can just enter one check per cell. So for example if you have spent $5, $20, and $15 on food, go to the food line and put 5 in column D, 20 in E and 15 in F etc. The total will automatically show up on the “Budget” sheet in column D.

Column E is simply a formula letting you know how much is left in that “envelope” for that category: i.e. Budgeted(C) – Actual(D).

The balances at the bottom are just for checking your math: Balance C should always be zero if your budget is balanced. Balance D should be exactly the same as the balance in your checkbook. Balance E should be the same as Balance D but reversed. If it is not, then there is a broken formula in the spreadsheet somewhere.

The tables on the right side:
The allocated savings register for you to record all of your savings goals, there is a formula for percent there but that is all.

The next table is the debt snowball table. The first column is the name of the debt, then the original amount, which is not really needed except that when you call in to scream “I’m debt free”, Dave will ask you how much debt you paid off, and if you didn’t write it down you won’t know. The next column is how much the current principle balance on that debt is, and then you have a nice little percent.

The Upcoming table is a list of infrequent bills that I always forget about. I don’t think that Dave has a form for this, but I needed it so that I remember to save up for big annual bills like car registration or quarterly insurance payments.

The next section in the black box, is what I call the motivating statement. It is what encourages me to keep going, when I can look at the budget taped to the side of the fridge and see in huge letters: “We saved $3,963 and paid off $16,883 in debt” it keeps me focused on the goal.

44 thoughts on “Blank budget template as Excel spreadsheet”

  1. I’m currently following Dave’s plan and was looking for something EXACTLY like this.

    Thanks and GOD Bless

  2. Hey I’m finally doing a budget and your spreadsheet is awesome! I finally figured out exactly how to use it and I think this is a great tool. Other places wanted $$$ for their spreadsheets…Hey I’m on a budget man! I can’t buy a spreadsheet.

    Thanks and you rule!

  3. Thanks! I ditto what Mark said! I am having a problem with sheet two though. It is not doing the transfer of Column D, E, and F like it should to page 1.

  4. Ditto all of the praise and gratitude! Now that I have this useful tool…FOCUS is my money mantra….

    God Bless!

  5. Jeremy,

    You’ve done a great deed for creating this. It’s helping me and I am sure it’s helping all the other people as well. I will credit you for this.

    Thanks

  6. Thank you so much for providing this extremely helpful and well-crafted spreadsheet! For some reason my MS Excel just would not activate so I had no access whatsoever to the templates on microsoft’s site (chock that up to one more reason I am going to linux!!!)

    thanks again!! you cant imagine the time and frustration this has saved me!!!

  7. read my lips… thank you for creating this! I am also in Dave Ramseys Financial Peace University. I have not been able to make up a form I can use after the class with all in one. YOU have done it!
    Thank you for all the tips also.

  8. How can I get a real copy? When you enter data does it negative or postive balances in the Diffference colum?

  9. Am I supposed to create a new spreadsheet for each month or is there a way to make several months in one worksheet? Thanks for the easy to follow budget!

  10. I just erase the budget and start over every month. I do actually keep old copies in a file folder so I can look back later and see how my budget has changed over time. But so far in 3 years, I have never looked at the old months. Perhaps someday I will out of curiosity.

  11. Thank you, thank you, thank you!!!! I have been trying to devise something like this for months but wasn’t smart enough to do it myself!! Thank you so much for sharing your expertise with others!

  12. Thanks Man. That is EXACTLY what was needed. Now I can hack and slash away without having to sharpen a pencil or remember math :-)

  13. Fantastic template. I’m still trying to work out exactly how to use it. My weekly income isn’t always consistent as I work casual hours and do we use Sheet2(actuals) to record our spending? Or do we enter what we are actually putting away each week/fn/month?

  14. The purpose of the “Actuals” sheet is to put in the actual spending, and then it will be subtracted from the front page so you can see how much you have left.

    If your income is not consistent, there are a couple of ways to do it. One way is to put in estimates, and then adjust your budget when you know how much the check will be. Another way is to save up enough money that you can wait until you have a month’s worth of paychecks and always live off last month’s pay. Then you know how much money you have when you make your budget.

  15. THANK YOU SO MUCH! I’ve taken Financial Peace University several times and love it! But I love this spreadsheet, and especially the motivational statements with the calculations built in! That’s awesome!!! We are trying to payoff $30,000 in debt over the next year and I think this will help us keep up with it and keep motivated! Thank you!!!

  16. Why does it say BLOW next to spending? Thanks for the sheet, i’m going to take a look at this sheet and try to work out a budget. s

  17. I was just about to try and tackle making a budget spreadsheet that would coincide with Dave Ramsey’s principles. Then I though, “maybe I should try googling it first.” Good thing I did! No use reinventing the wheel! Your budget worksheet is awesome! Thank you so much for making this. I just read Total Money Makeover last week and am just now starting on baby step 2. This is a total life saver!

  18. We all need to thank him for is REAL HONEST advice. I did my spread sheet and yup…way too much shame spending going on. If I dont “shame” spend,12 months and all but house and car debt are gone :) Thanks Dave!

  19. First I want to thank you for taking the time and effort to set this budget up. Its greatly appreicated. Your the best!
    Second- I need to add more categories, about 10-14. Ie..Insurance, I want to add house, car, life. For house: I want to add repairs, mort, taxes. So my question is can I just use the insert command where I need it and if so will that throw the formulas off ?
    Thanks, John

  20. probably a dumb question but what happens for the next month, do I have to open a whole new spread sheet or just copy accross. Will the formulas copy correctly? and what about the actual page, please advise.

    Love your budget by the way. has everything.

  21. What an amazing template! Thank you! I have inserted several new categories, and I was able to correct or add any necessary formulas by using copy/paste from a previous cell (and changing the cell information on the formula), but in the “Actuals” worksheet, Column A (which is where the title of the category transfers over), the formula shows up instead of the title of the category from the “budget” worksheet. Is there a way to correct this? I simply copy another working formula from “Actuals” column A, but it does not work. I see =IF(“”=Budget!B17,”",Budget!B17) instead of the name of Budget B17 such as “Medical Bill”. Please help when you get a chance. Thank you!

  22. I have the same problem (trying to add rows and also trying to name things on the Actuals page). I am a total newbie to spreadsheets. There must be some second-nature geek thing I don’t get…

    Thank you so much for this work.

  23. Someone helped me out with the “Actuals” page. We figured out that if you copy the CELL instead of the formula on the fx bar, you can paste the cell information where you need it in the actuals page and it will show up correctly.

  24. Thank you so much! We really struggled with this aspect of the Dave Ramsey program, but last night we finally did a budget! Extremely helpful.

  25. I cannot open the budget template. My computer will not open microsoft excel. Can you tell me how to open it another way or can you send it to me through email? Please let me know asap.

  26. I have Excel on my computer, but I’m unable to open… tried extracting the files, but that wouldn’t work either. Is there a more recent download?

    Thanks!

  27. you can download open office, openoffice.org which once installed will run this spreadsheet perfectly

  28. Tried to download the weekly and biweekly files and it automatically saved as firefox browser thingy and tried to change it to Open Office documents in excel, any suggestions as I cannot seem to get it to download thru the excel open office system I have. Thanks.

  29. The template is amazing, brilliant – sheer brilliance. My only problem is that the default setting is biweekly, so my “month” spans two months. I’m not versed in functions, so I was wondering how to change the settings so that I can have each column jump 7 days instead of 14. Any help? Thanks!

  30. I prefer the debt snowball practice, particularly how Ramsey advises doing it. If you’re instructing the masses like Dave, the one thing every person lacks is without a doubt motivation. The majority of people must be stimulated to keep proceeding, so begin with the tiniest financial debt and pay it off first.

  31. Thank You so much. Was starting to make one myself and found yours already made.
    saved me a ton of time.
    God Bless!!

  32. Thank you very much for this from the UK! I am just starting to try to get a grip on our finances and this well help enormously. Thank you for your generosity and kindness in making this available.

  33. How do I use it with Numbers (I have a Mac, its their answer to Excel)? Do you have a template I can use?

Comments are closed.