How to Make Monthly Expenses Sheet in Excel (With Easy Steps)

People use Excel for many different reasons. We can store important information there. You can also create various useful templates in Excel worksheets. It’ll be beneficial if we can make an Expenses Sheet in Excel. Because it’s essential to track our monthly expenses. In that way, we can have a precise knowledge of our spending. But, creating a tracker may seem a hassle. And you may not know what exactly you should input there. We’ll make it easier for you. In this article, we’ll show you the step-by-step procedures to Make a Monthly Expenses Sheet in Excel.


Download Free Template

Download the following template to practice by yourself.


Step by Step Procedures to Make Monthly Expenses Sheet in Excel

Excel helps us to store different information and perform various tasks. In our daily life, we have to purchase our necessary things. Again, there are some monthly bills and payments. Some of them are fixed, while others vary upon usage. A monthly expenses sheet can come in handy to track all those records effortlessly. But, you may have doubts about what to input there. So, making a tracker may seem complicated. Don’t worry. We’ll keep it easier for you. Therefore, go through the following steps carefully to Make a Monthly Expenses Sheet in Excel.


STEP 1: Prepare Excel Workbook

  • First, open a blank Excel workbook.
  • Then, give a clear heading of what this file is about.
  • After that, type the Month names.
  • See the below image for a better understanding.
  • Save the file.


STEP 2: Set up Income Section

  • Now, input the income sources.
  • Here, we will place the Salary We’ll consider a fixed monthly salary in this example.
  • You can input any other sources of income.


STEP 3: Insert Excel SUM Function to Compute Annual Income

  • Next, we’ll insert the SUM function to total the Salary.
  • For that purpose, select cell O6.
  • Type the formula:
=SUM(C6:N6)
  • Subsequently, press Enter.
  • It’ll return the sum of the 12 months’ income.


STEP 4: Make Monthly Expenses Segment

This step is the most important for us. So, pay attention.

  • Firstly, create a header for different types of Expenses.
  • The following picture will make it clear.

make monthly expenses sheet in excel

  • Consequently, input the precise Expenses amounts.
  • You need to type the amounts in the proper categories and months.
  • Otherwise, it will result in errors.

make monthly expenses sheet in excel

Read More: How to Make Personal Expense Sheet in Excel (with Easy Steps)


STEP 5: Create Excel Formula to Automate Expenses Sheet

Moreover, we wish to make our Expenses Sheet a dynamic one. Dynamic means, it’ll update automatically once a change happens in any of the expense values. Hence, follow the below process.

  • First of all, choose cell O9.
  • Then, type the below formula:
=SUM(C9:N9)
  • Press Enter.
  • Thus, you’ll get the annual Rent fee.

make monthly expenses sheet in excel

make monthly expenses sheet in excel

  • Now, we’ll figure out the month-wise expenses total.
  • For this reason, in cell C17, type the formula:
=SUM(C9:C16)
  • Return the result by pressing Enter.

make monthly expenses sheet in excel

  • Next, apply AutoFill for completing the series.

make monthly expenses sheet in excel

  • At last, we’ll calculate the yearly total expenses.
  • So, select cell O17.
  • Type the formula:
=SUM(C17:N17)
  • Accordingly, press Enter.
  • Thus, you’ll get the sum of all the expenses in a year.

Read More: How to Track Income and Expenses in Excel (4 Suitable Examples)


STEP 6: Calculate Net Balance

In our final step, we will determine the net balance. You just need to subtract the annual total expenses from the annual income.

  • Select cell I19 at first.
  • Then, type the following formula:
=O6-O17
  • Subsequently, press Enter.
  • In this way, you can get a surplus amount.
  • You can also see if there’s any due left to pay.

make monthly expenses sheet in excel


Final Output of Monthly Expenses Sheet

Finally, our Monthly Expenses Sheet is complete. You can modify any headers you want. You can type your own expenses values there. It’ll automatically update and give you the correct results. The following picture demonstrates our designed expenses tracker.


Conclusion

Henceforth, you will be able to Make a Monthly Expenses Sheet in Excel following the above-described procedures. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo