Excel Home Accounting Template


When three years ago it became necessary to keep track of income and expenses of the family budget, I tried a lot of specialized programs. In each there were some flaws, shortcomings, and even designer imperfections. After a long and unsuccessful search for what I needed, it was decided to organize the required based on the Excel template. Its functionality allows you to cover most of the basic requirements for conducting home accounting, and, if necessary, to build visual charts and add your own analysis modules.

This template does not claim to be 100% coverage of the entire task, but it can serve as a good base for those who decide to go this way.

The only thing I want to warn about right away is that a large desktop space is required to work with this template, so a monitor of 22 ”or more is desirable. Since the file was designed with the expectation of convenience and lack of scrolling. This allows you to fit the data for the whole year on one sheet.

The content is intuitive, but nonetheless a quick glance at the main points.

When you open the file, the working field is divided into three large parts. The upper part is intended for maintaining all income. In other words, these are the financial volumes that we can dispose of. Lower, largest - to record all expenses. They are divided into main subgroups for ease of analysis. On the right is the block of summing up the totals, the more the table is filled - the more informative its data.

Each type of income or expense is in rows. Columns break input fields by month. For example, take a data block with revenue.

What is there to hide, many receive "gray" or even "black" salaries. Someone boasts a "white". For others, the main part of the income may be part-time jobs. Therefore, for a more objective analysis of their sources of income, four main points are identified. It doesn’t matter if one cell is filled in the future or all at once - all the same, the correct amount will be calculated in the “total” field.

I tried to break down the expenses into groups that would be universal and suitable for most people who started using this file. How successful it is is for you to judge. In any case, adding the required line with an individual expense item will not take much time. For example, I don’t smoke myself, but addicted to this habit and wanting to get rid of it, and at the same time understand how much it is spent on it, can add the Cigarettes consumption point. Basic knowledge of Excel is quite enough for this, and now I will not touch them.

As above, all expenses are summed up by months in the final line - this is the total amount that goes to us every month, it is not clear where. Thanks to the detailed division into groups, you can easily track your own trends. For example, in the winter months, my food costs are reduced by about 30%, but the desire to buy any unnecessary nonsense increases.

Below that is a line called “remainder”. It is calculated as the difference between all monthly income and all expenses. It is from it that you can judge how much money you can save, for example, on a deposit. Or how much is missing if the balance goes into minus.

Well, that’s basically it. Yes, I forgot to explain the difference between the fields “average (month)” and “average (year)” in the right final block. First, the “monthly average” considers average values ​​only for those months in which there were expenses. For example, you have bought educational courses three times a year (in January, March and September). Then the formula will divide the total by three and place it in the cell. This allows you to more accurately evaluate your monthly expenses. But the second one, “average for the year”, always divides the total by 12, which more accurately reflects the annual dependence. The greater the difference between them, the more irregular these costs are. Etc.

You can download the file here . I will be glad if this helps you in mastering such a difficult task as conducting home bookkeeping. Success and revenue growth!

Also popular now: