We are connecting the reports with expenses to the consolidated statement now. «Rename».ĭo not forget to write down the sum formula in the «Total» line. And then copying and pasting.įor giving the name of the detail sheet, we click the right mouse button on its designation. «Date» - «Item of expenditure» - «Amount». On each - is the Excel detailed table of expenditures of the family budget. You are spent – you are recorded.įor convenience we will create drill sheets for all expenditure. To optimize the management of the family budget, it is recommended pay the costs immediately. Money is spent almost every day: food, fuel, travel tickets are bought. The sums in the report will be recalculated automatically. You can make changes to the detail sheet as many times as you need during a month now. We have attached the detailed report to the main consolidated statement. And we press the total amount of income for the month. We go over to the sheet with a detailed report. Select the empty cell where the numbers should appear. You need to make now, that the total amount from the detailed report is automatically transferred in the report. We sign: «The family budget for a month». Distinguish the cell above which we want to insert a row. In this cell, we put to the formula for calculating the sum. Give a name for it.ĭenote the graphs: «Date», «Income item», «Amount».
And plus to periodic part-time work.įor detailing to the incomes, on a separate sheet we create the Excel spreadsheet of incomes and expenses of the family. A couple of days later - interests on the deposit.
In one day – is the salary, in a week later - is advance payment. It is necessary to take into account the monthly earnings of a husband and a wife. It is important who brings in the house how much. For example, there is a separate budget in the family.