How to Make a Table for Daily Expenditure Control in Excel
Organizing your spending on a spreadsheet is the best way to keep your financial life under control. As complicated as it may seem, we will show you how, through simple procedures, you can create a table for daily expenditure control in Excel. Follow the post today and know all the steps necessary to create your own spreadsheet!
The first step in constructing a table is to define its structure, starting with its header. In it, you must determine the amount of time you want to track spending on the worksheet. Because it is a daily control chart, division into days, months and years is recommended. Dispose of the information in a way that you deem most practical for your viewing and understanding.
Defined the header, the second step is to list and categorize your expenses. It is suggested that categories be created that encompass certain types of expenses, which will facilitate their identification and control. You can create a category for housing, health, food, transportation, leisure and so on. An “Other” category might be of interest to include items that you can not categorize on existing tabs.
It is also possible to differentiate the expenses between fixed and variable, entering the first expenses as rent, condominium and IPTU and, in the second, expenses with meals, supply of vehicles, purchase of medicines etc.
In both cases, it is important that a total expenditure be assessed at the end of each period. So, making use of tools like self-sum can be interesting and make your job easier.
Because it is a daily expense control chart, it is very important for its proper functioning that all expenses made on the day are posted, however insignificant they may appear. Including all expenses, you will have a real sense of what your situation is.
Total day-to-day spending is of utmost importance, and you can also maintain that same control with weekly, monthly, and yearly expenses. By simply using formulas, you can add a value to the other and generate results without having to add item by item.
Applying formulas in the table for daily expenditure control
Excel gives your users the ability to do everything from the simplest to the most complex accounts automatically.
To perform any operation, simply select the cell where you want the result to be displayed. Always start operations with the equal sign. Then type the location of the cells that you want to work in the operation.
For ease of visualization, let’s take a practical example: I want to add the values displayed in cell D4 to those in cell J9. It is enough to start with the equal sign (=), add the location of the first cell (D4), insert the signal of the desired operation (+) and add the location of the second cell (J9), resulting in this sentence: = D4 + J9 .
When you press enter, the operation will be performed and the result displayed. The same holds true for operations of subtraction, division and multiplication, by simply using their corresponding signals.
To sum the values of a certain day, month or year, you can use the auto-sum or another very simple formula: like the one that was presented, start with the equal sign. Then enter the SUM operation. Then, within a parenthesis, place the cell location where the interval to be added starts and ends.
Let’s look at the example: we want to add up the expenditures between cells D2 and D23. To do so, simply follow the procedure indicated to have something like = SUM (D2: D23). The result shown will be the sum of all values comprised between cells D2 and D23. The same goes for sum between different columns, as in the formula = SUM (D2: G2).
In addition to the expenses, you can also create a spreadsheet for recipes and, from the intersection between the two, get your monthly and annual financial flow. It may seem complicated to do all these operations, but when put into practice it is possible to realize that making a daily expenditure control in Excel is easier than you might think.
However, there are always alternatives that make it even easier to perform such tasks. Automatic applications such as Cheshire Cat are already available, which perform all these operations quickly and accurately.