Best Free Excel and Googledocs Budget Templates 2020

How To Create a Budget In Excel or Googledocs

Number 1 Pick: The Spreadsheet for people that don’t know how to budget

Template by /u/Celesmeh.

showing template design

How to make a budget in excel made easy

The sheet was set up with three goals in mind:

  1. For it be simple to use
  2. That it focuses on a daily budget that supports long term goals- instead of a long term budget that doesn’t have daily support
  3. It be a good starting place for people who have never saved before

So how does it work?

The main budget is divided into three core areas:

  • Income: You use this to fill in your income and choose to have a monthly, weekly, or bi-weekly pay cycle. If you are a worker who is tipped it includes an area where you can add tips, my suggestion is put in your minimum average income from tips- So for example, if you usually make 100 from tips a week, even if you get extra, try to program your budget around the 100 minimum average.
  • Expenses: There you can add your expenses. Utilities are bills that are for electricity, heat, phone, internet, or water. Bills are important expenses that you can’t miss and are integral to living. Finally, expenses are other things you need to allocate money for- whether it be gas, lunch expenses, transportation- ect. Within your expenses there are TWO areas to which you need to pay attention:-Credit Card Payments: this is new to this year’s sheet, use the tab below to fill out your information for up to three credit cards. Decide whether to pay the minimum payment OR choose an amount to pay. The tab will allow you to see how much you’re paying and how much interest you’re accruing. Once you have filled it out, your budget will adjust accordingly. -Big Purchase: Use this tab to create a budget for a large purchase, and adjust your budget easily and automatically to finance this purchase!
  • Budget summary: Finally the most important part of this sheet is the budget summary- Here you will see just how much you can spend. This money is shown in three ways, the lump monthly sum, a weekly amount, or a daily amount. As long as you don’t go over that number, you will have enough money for the rest of your budget. It will also feature a breakdown of what your budget it, where your money is going, and what your income VS spending is!

The sheet includes three charts:

  • A bar graph as a simple visual tool to see if you are spending more than you are saving
  • A pie chart to see how money is distributed
  • A daily Pie chart to see realistically where your money is going compared to your target savings

Download: here


Instructions:

  • Go in
  • Make a copy
  • Change the numbers
  • Decide what percentage of your income you want to be saved
  • Budget.

Bonus Tip: A variety of financial calculators: Cash flow, college, credit and debt, home & mortgage, taxation (US), insurance, paycheck & benefit, qualified plans, retirement, savings, investment, automotive and business.

Number 2 Pick: Simple how to budget chart

Download: Excel or Googledocs

Check out how to easily track and calculate your weight loss percentage with excel charts using templates! Click HERE

Number 3 Pick:

template breakdown budget how to
Excel budget with graphs

Download: here

Excel Household Budget Chart Template

Excel household budget template

Simple Excel Budget Template that automatically calculates the difference between budgeted and actual outgoings, and compares this to income.

Using the Excel Household Budget Template

Enter values into the ‘Budgeted Amount’ and ‘Actual Amount’ columns of the above household budget template, the ‘Difference’ and ‘Total’ fields are automatically calculated. You can change the row labels to suit your own types of income and outgoings, and insert additional rows if you wish.

Download here

Leave a Reply

Your email address will not be published.

Thank you! :)

There was an error while trying to send your request. Please try again.

HowtoTeck will use the information you provide on this form to be in touch with you and to provide updates and marketing.