There are many occasions in which we have praised the many virtues of Excel , from designing web pages from scratch to planning the domestic accounting , calculating the VAT , forecasting your retirement or calculating your pension plan. Well, in the article that concerns us today, it is the turn of how to create budgets in Excel in a simple way , something that will help you to save , take a more exhaustive control of your expenses and income and improve your personal finances.
First, it is important to select the different types of expenses and income that you will assign to that spreadsheet. For a simple Excel you can follow the steps listed below after opening a blank page.
Steps to calculate a simple budget in Excel
- Click on cell “A1” and enter the title of your budget sheet.
- Click on cell “A3” and enter “Articles”.
- Click on cell “B3” and type “Revenue”.
- Click on cell “C3” and enter “Expenses”.
- Make a list of your income and expenses in each row of the page – using the income in column B and the expenses in column C – making sure that all the figures you enter correspond to the same monthly period. You can go to the toolbar and use the “decimal .0 >>. 00” button to adjust the format and show both decimals.
- Click on a cell in column B that is below the last entered data and use the formula “= SUM (“, pressing “Enter / Return” to complete the calculation.) Thus you will obtain the result the income obtained in the period settled down.
- In the cell in column C below the last entered data, do the same and repeat the formula to calculate the total expenses
- Scroll to the cell next to column D and enter the “=” sign. Write the “-” sign and click on the cell of the total expenses, pressing “Enter”. This way you can know what net income you have left after calculating your expenses. In the case of being negative, they will appear in red format.
The best Excel templates for budgets
If you prefer to choose a template to make a specific budget, you can count on the following:
- Budget sheet
- Monthly annual budget
- Marketing budget
- Business expenses
- Sales budget
- Purchase planning
- Work Budget
- Budget of Revenue and Costs
- Training budget
- Budget, inventory and collection management
- Templates to prepare your company’s budget
- Party budget