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.
- Consequently, input the precise Expenses amounts.
- You need to type the amounts in the proper categories and months.
- Otherwise, it will result in errors.
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.
- Afterward, use the AutoFill tool to get the annual total of other expenses.
- 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.
- Next, apply AutoFill for completing the series.
- 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.
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
- How to Calculate Business Income and Expense in Excel Worksheet
- How to Keep Track of Small Business Expenses in Excel (2 Easy Ways)
- Daily Income and Expense Sheet in Excel (Create with Detailed Steps)
- How to Make Office Expense Sheet in Excel (with Easy Steps)
- How to Create Daily Expense Sheet Format in Excel (With Easy Steps)