Simultaneously, you need to create 4 weekly trackers apart from this week 1 tracker, based on the number of weeks in a month. Similarly, the above step is followed for another category as well now, the Week 1 Tracker is ready.
Now add SUM function for each category & its description in a vertical & horizontal range column C till column I cells.Īfter using the SUM formula, the result is shown below. Total expense for each description in column J. Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday in column C, D, E, F, G, H, & I, respectively. adds each category and its total expense.Įach description in column B and weekdays in a respective column, i.e. Let’s create for week 1, with a day-wise breakup. If we are creating a monthly expense tracker, we need to create day-wise for each week, i.e.
Now, you can add these in excel with each category separately & need to create a category wise batch.
You should know or be aware of your monthly expenses or spending, which is categorized into various sections. If I want to create a family expense planner, the following criteria are kept in mind while creating an expense tracker I can add the below-mentioned categories to create a template. You can download this Expense Tracker Excel Template here – Expense Tracker Excel Template
0 kommentar(er)
