How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

Don't know anything about Excel? We've got you.

Having a budget is an essential part of money management, and while you can do this on pen and paper, monitoring your expenses digitally makes life so much easier. While you can use budget apps, nothing quite gives you as much flexibility as an Excel spreadsheet. But first, you'd need to learn how to create a budget spreadsheet.

How to create a budget spreadsheet in 10 easy steps.

1. Open Excel

2. On the first row, list the months where you want to budget. Leave the first column blank.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

3. In the first column, list down your sources of income.

You can list them under a heading "Income" to make it easier for you to understand.

End this section with a "Total" section.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

4. Then, list down your different expenditures.

This includes rent, groceries, shopping, phone bills, gas bills, "fun money", and so forth.

End this with a "Total" section.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

5. Calculate for your Total Income

Select the cell where you want the total to appear.

Then, click Autosum in the menu bar. This should add the values above your selected cell automatically.

Press enter.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

6. Then copy the formula in that first totalled cell and paste it along every cell in that row.

This should result in a row of zeroes — once you put in values for each income source, this will automatically add them up.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

8. Repeat steps 5-6 in the Expenditure section.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

9. Add a final section called "Savings".

10. Calculate for savings.

To calculate for the amount of money you have left over, subtract your Total Spending from your Total Income. Here's how you do that:

  • input "=" in the cell where you want the savings amount to appear
  • select the Total Income cell
  • input "-" (the subtract sign)
  • select the Total Spending cell
  • press enter

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide

And there you have it! A basic budgeting spreadsheet.

How To Create A Basic Budget Spreadsheet: A Step-By-Step Guide