Home » Budget Spreadsheet » Personal Income And Expenses Spreadsheet

Personal Income And Expenses Spreadsheet

Personal Income And Expenses Spreadsheet – Have you ever thought about what you spend the money? Do you know what kind of things you spend the most? Do you control your savings? In this article of personal finances I propose a way to go writing down your expenses and income in a excel sheet in a realistic way, to be able to know with reliability what are your biggest expenses, and thus manage them better.

Excel Spreadsheet For Business Income And Expenses

Step 1: Record your monthly expenses
The first thing we are going to do is write down, during a month, day by day, what our expenses are in different concepts. For this you can download this spreadsheet or create a new one:

– Download spreadsheet of income and expenses (format Excel MS Office .xls)

– Download spreadsheet of income and expenses (Open Document format .ods)

As an example, the filled sheet would look like this:

Some of the expenses to consider are:

– Supermarket (food, basic goods …)
– Restaurants
– Leisure
– Transportation (subway / bus voucher, train tickets, car expenses …)
– Shopping (clothes, technology, games, accessories …)
– Rent of the floor and associated expenses.
– Invoices (telephone, internet …)
– Other expenses not included (medications, travel …)

It is important not to forget any concept, and include all the expenses that we make monthly. Exceptional expenses (for example: holidays, Christmas gifts …) can be left aside, although it is more realistic to include them here, dividing them between 12 months to have an average calculation of the money we spend per month.

Once all the expenses have been introduced day by day during a month, we add up and we will have the money that we have spent in each concept, as well as the total expense. It is important to note the expenses daily since, if we write them down by heart, we would probably forget many concepts to introduce. In addition, you can repeat this account for several months to check if our data is stable or if it varies a lot from month to month.

Making a graph with percentages, we can have a better idea of which concepts are those that take more money out of our pocket:

In the example, it is seen as almost half of the costs are going to rent the apartment (which is quite common in some cities). From here we can obtain a global vision to know, in the case of wanting to save more, where we can stop spending and where we can spend more without danger. In our case it would be interesting to cut back on the rent of the apartment and, to a lesser extent, on the supermarket expenses (although these expenses are basic and it is difficult to cut here) … However in this example it would not make sense to cut back on clothing purchases or leisure since, although they are expendable expenses, currently in the graph it is seen that they are very low and cutting them would not mean a significant saving with respect to the total expenses.

In summary, this chart will give us an idea of whether we are optimizing the expenses or not. If we see that the basic expenses are the ones with the highest percentage, we are doing well, but if the highest percentages go to “luxuries”, it means that we can save more by reducing those items (in the event that we want to save more, of course).

Personal Income And Expenses Spreadsheet

Small Business Income And Expenses Spreadsheet

Step 2: Calculate your future predictions from the expenses previously recorded, and compare them with your monthly income
With the monthly expenses noted, we already have reliable data for planning. Now in the second part of the excel sheet we put our monthly plans, and the net income we get from work, interests, values, etc. (do not forget about extraordinary income and expenses, such as extra payments, grants, scholarships, tax deductions, interest on current accounts, investment profits, profits / losses on securities … we can include them here as a proportional part make a media, or we can leave them aside as long as we do not forget them).

If the difference between income and expenses is very broad, we have room to spend more, but if the values are practically the same, our savings will be very small:

In this way, we have already controlled our personal accounts, and we will know how much money we are saving monthly, being able to modify the different items to adapt them to our planning.

This type of excel sheets are very easy to use and seem superfluous, but they can be a good tool to control personal or family expenses, avoid waste and have a clearer idea of what we are spending our income on.

– Download spreadsheet of income and expenses (format Excel MS Office .xls)

– Download spreadsheet of income and expenses (Open Document format .ods)