There is a field to enter a target and set an asset target. To display the tables and graphs again, click on the 2 button in the upper left corner. To set the month to the previous month, enter the number of the previous month for the start date of the month portion of '=DATE(year,month,day)'. If the 5th of the next month falls on a Saturday, Sunday, or holiday, the end date can be 3 or something like that. If so, enter 5 as the start date for the next month's sheet. If you entered 5 for the start date, enter 4 for the end date. You can change the start and end date for each month.Ĭell C51 is populated with the formula for the start date entered in setting.Įnter the number of the date you want to start in the Settings!L5 section.Ĭell E51 is populated with the formula for the end date.Įnter the date of the end date in the Set!L5-1 section. I want to change only certain months to weekdays, for example, when paydays fall on weekends. The total amount will be automatically entered at the bottom and colored for no-money days. Please use the amount on the left and the right as a memo. Percentage of taxes, savings, fixed expenses, special expenses, and variable expensesīelow the tables and graphs, there is a Gantt chart of variable expenses.Ĭlicking the 1 button in the upper left corner hides the table and graph, making it easier to enter the data.Ĭlick on cell B54 and uncheck the 0 or blank cell.Įnter each expense item in the column for the date you wish to enter. The total amount of each expense item for the week is displayed on the reserve graph. The graph reflects what you have entered in the Gantt chart of variable expenses. The bar graph shows the total income at the top and the total expense amount at the bottom.Īfter all entries have been made, the remaining balance is displayed. The remaining budget for this month (Income - (Taxes + Savings + Self-investment + Fixed Expenses + Special Expenses + Variable Expenses)) will be displayed. The amount entered in Special Expenses will be automatically entered in the Total Special Expenses column. (light yellow area)įor personal investments, enter the details and actual expenses. The expense items entered in the setup are set on the monthly sheets (Jan-Dec).Įnter your budget for income, taxes, savings, and actual fixed expenses for variable expenses. Values entered on the Special Expense sheet will be reflected on the respective monthly and annual sheets. You can set up each month and each expense item so that it is easy to look back. Special expenses are those that do not occur every month but are special expenses and should be set for large amounts, such as event expenses or annual payments. Please change the units of the other sheets after changing the month sheet first.Ĭlick on the money symbol to select the currency unit.Ĭlick on the ”More Accounting Format” to see more unit information. The January-December sheets can be changed in units at the same time. Press the 'Select a Currency' to select a range of currencies. Saturdays are displayed in blue, Sundays and holidays in red. Please set the national holidays of your country in the Holidays column. When you select a start date, each month sheet will automatically set the date to match the start date. You can change the start date to match your payday or other date. Self-investment is kept on a sheet for the month, while special expenses are kept on a separate sheet. Easy to set the start date to coincide with payday, etc.Monthly income and expenses are displayed in a list and graph, allowing you to see monthly trends at a glance.Special expenses for the year can be entered by expense item.A pie chart is displayed for each expense item, allowing you to see which items you are overspending on.Can be printed out on A4 paper, making it easy to compare months.

Colors on the days you didn't spend money.Weekly trends of variable expenses are displayed in a graph, making it easy to revise the budget.Monthly sheets are set up for easy entry.In addition, by using many graphs for analysis, you will not only be able to see at a glance how your money is flowing, but also how you should spend the rest of the month. Income - (Taxes + Savings + Personal Investments + Fixed Expenses) = Variable Expense Budget Prioritize your money and figure out how much you can spend each month. This kakeibo that allows you to make the anticipatory personal investments necessary to increase your income. This Excel kakeibo is the 2024 version of the Excel family budget book (free template will be distributed), which is recommended for those who did not continue with the Excel kakeibo. Based on the 'Free Template with Pipot Tables for. This kakeibo template allows you to record and analyze your assets in addition to daily records.

Excel household budget