Budget Money

Free Budget Spreadsheet Template

September 21, 2016
If you've been looking for a free budget spreadsheet template, this one is very user friendly! Gather all of your income, receipts, and statements and let it do the work for you! Get your copy today!
This post may contain affiliate links. See disclosure policy here.

 

I’ve been working on a free budget spreadsheet template for you all that will help you track your monthly expenses!

Initially, I went over to Fiverr with the grand idea of getting a kick-ass printable that will cover the majority of common household expenses. Needless to say, I’m out of $21.00.

The process and the lack of quality was very frustrating so I started messing around in Google Docs and created one myself.

Tracking your expenses is an extremely important step in getting your budget into shape!  If you’re new to budgeting, this spreadsheet will be the groundwork for creating your new super-fabulous budget.

 

Related Reading: Budgets: Quick, Easy, Simple Method for Beginners

 

To get your copy of this free budget spreadsheet template, drop your email in the box below.

 

How to Access Your Free Budget Spreadsheet Template

 

  • When you get the link to the expense tracker, here’s how you will be able to use it. Simply go to File (see screenshot below) and click Make a Copy.

 

free budget spreadsheet template-file-make-copy-screenshot

 

  • You have the option of making it available for use offline too! Click the green button in the upper left-hand corner (as shown above) to be taken out of the spreadsheet and you’ll see the screen below.

 

free budget spreadsheet template-make-available-offline-screenshot

 

  • As you can see above, click on those three little dots on the right side of your document (your document will be labeled as a copy of the Budget Expense Tracker). Then you will click on Available Offline.
  • You can also Download this spreadsheet as an Excel (xlsx) document or a CSV document by clicking on File inside of the spreadsheet.

 

How to Use the Free Budget Spreadsheet Template

 

life-and-a-budget-free budget spreadsheet template-screenshot

 

1. As you can see above, there are columns for each month and rows categorized for multiple expenses. The categories include income, housing, transportation, groceries, other (healthcare, personal care, gifts, etc), and savings.

Related Reading: 10 Sneaky Unexpected Expenses You’re Forgetting to Budget For

 

free budget spreadsheet template - add row to spreadsheet screenshot

 

2. If you need to add rows to the spreadsheet, you can! Simply go to Insert and click on Row Above or Row Below (shown above).

3. At the very top of the spreadsheet, there are rows for your income. The numbers are already pre-filled; however, you can change these to reflect your income each month. All of your expenses will be subtracted from the income line.

 

free budget spreadsheet template -end-zero-line

 

4. At the bottom (shown above), is a row labeled End (Zero).  This number will equal zero after all of your expenses and savings are subtracted from your income.  This is better known as zero-budgeting.

 

Related Reading: How to Create a Budget That Won’t Fail

 

 

free budget spreadsheet template-total-income-and-other-total-categories

 

5. To the right of the spreadsheet, there is a column for each total category. This very last number will tell you your total income for the year, as well as total expenses in each category of the budget. Once you’ve filled in this spreadsheet for the year, you can simply make a copy for the next year and fill it in with next years numbers.

 

free budget spreadsheet template -itemized-misc-expenses-per-month

 

6.  At the bottom, you’ll see a tab for Itemized Misc. Expenses Per Month (shown above). I created this tab so you could keep up with the Miscellaneous line (A44) under the other category. This can include cash purchases or any random thing that doesn’t fit into an expense line in the budget created. For example, in April you may buy Easter candy. Since this is an out of the ordinary purchase, you will still be able to keep track of what you’re spending throughout the year without adding a bunch of lines in the budget.

 

Wrapping Thangs Up

This budget spreadsheet template is very user-friendly!   Once you’ve put in the numbers, you’re well on your way to building a strong foundation for your finances. Gather your statements, paystubs, and receipts and start plugging in those numbers so you can get your budget under control. As always, if you have any questions on how to use this spreadsheet, drop me a line in the comments below or email me at latoya at lifeandabudget dot com.

 

Do any of you use a budget spreadsheet? If not, try this one!

 

Powered by ConvertKit
Latoya Scott
Writer/Creator
Latoya is a writer for hire who loves talking about budgets and money. Her mission includes paying off $79,000 in student loans and aspiring other millennials to hustle their way towards financial freedom. Her work has been featured on The Huffington Post, Rockstar Finance, and My Fab Finance.

You Might Also Like

24 Comments

  • Reply Stacie September 21, 2016 at 1:03 pm

    This is a cool budgeting tool. I stay on a monthly budget, but I’m an old fashioned pen and notepad type of girl. Hey, whatever works!
    Stacie recently posted…Reset Your Fall Beauty RoutineMy Profile

  • Reply Kemkem September 21, 2016 at 1:16 pm

    I’ve never used one. I budget in my head. Thank God l have a good memory, even though it is slipping now :-)..so l might give this a go. Will make a change from scraps of paper :-). For someone wanting to keep track of their monthly expenses, it looks great.
    Kemkem recently posted…Lagos, Portugal: Awesome, Beautiful and IdyllicMy Profile

  • Reply Walk One Day In Our Shoes September 21, 2016 at 1:36 pm

    Thank you for sharing this fantastic tool! I will certainly put it to good use. Way to improve on something to make it helpful to others!

  • Reply Daria September 21, 2016 at 4:07 pm

    Thanks LaToya, this is definitely the right time for me to see this. I have some cleaning up to do with my finances, and this is the perfect tool to assist me. Thanks for sharing.
    Daria recently posted…Grace Ann’s 1st Birthday Party was a HIT!My Profile

  • Reply Tamika Hall September 22, 2016 at 12:51 am

    What an awesome tool! I can’t wait to begin using it!!

  • Reply KenyaRae September 22, 2016 at 9:42 am

    This looks awesome! I have an similar oreformatted excel spreadsheet my mom gave me years ago. I used it when I was single and then transitioned it into the marriage. I have been slacking on budgeting lately. I need to get back on it.
    KenyaRae recently posted…Coparenting After Divorce: Making the Transition From Wife to CoparentMy Profile

  • Reply Adeola Naomi September 22, 2016 at 5:18 pm

    I have never use one befroe but I will absolutely try this one!
    Thanks for sharing.

    http://www.distinguisheddiva.com/2016/09/luxury-wood-watch-editorial-plus-jord.html

  • Reply Tryphena Wade September 22, 2016 at 5:52 pm

    Kudos to you for creating the product that met your needs and wishes. I’m so happy that my parents taught me the importance of budgeting as a child. I still make little snafus here and there but that teaching is firmly intact and keeps me responsible for my spending habits!

    • Reply Latoya Scott September 22, 2016 at 9:31 pm

      That’s awesome you learned about budgeting so early!

  • Reply Ashley September 22, 2016 at 8:00 pm

    Hey Latoya,

    Excel spreadsheets have always made me nervous but you really explain this thoroughly so I think I can do it! I’m old school like Stacie because I usually write out my budget on paper. I’ll let you know how my first try at this excel sheet goes. *smile*

  • Reply Katherine G September 22, 2016 at 10:45 pm

    This is such a nice tool! It would be great to have something for my computer. We track s number of ways but one more way wouldn’t hurt.
    Katherine G recently posted…The Benefits of High School Dual EnrollmentMy Profile

  • Reply Jennifer September 22, 2016 at 11:09 pm

    This is a great tool to have for budgeting, Latoya! I do the budget for my family and I use a notebook to keep track of everything. I think using your spread sheet idea would be a great way for me to keep track of our expenses.

    • Reply Latoya Scott September 23, 2016 at 11:02 pm

      Thanks, Jennifer! Let me know if you try it and it works for you! I would love feedback to make it better!

  • Reply Joanna September 23, 2016 at 12:14 am

    I don’t have a budget spreadsheet, but reading this has me thinking I should. Lol great resource.

  • Leave a Reply

    CommentLuv badge

    Top