In this topic, a budget plan document template will be generated using an existing layout configuration. Each layout can have an associated budget plan document template to view and edit the budget plan data in an Excel worksheet. The goal of this tool is allow you to manage your cash over time using what actually occurs versus your plan. Budget plan documents can be viewed and edited using one or more layouts. If desired, the Description grouping can be expanded to display the data summarized by day. The user can expand the Category grouping to display summary by Category and Description. The summaries allow you to see by category Budget versus Actual to see what difference exist at that level. The details are summarized by Category, Description and Date. Summaries are generated from the income and expense budget details. If you decide you want to further define the input listed by category you may enter a descrption for each item for more detail.

To capture the total income, apply the SUM function in the C8 cell. Creating this list in the excel spreadsheet. It could be from your salary, from house rent, from a loan on interest. First is not to list your expenses but to list your income sources. The budget for income and expenses can be input in as much detail on a daily basis as you desire. Below are the steps for creating personal budget template in excel. Use predefined categories to standardize how income and expenses should be tracked. A running total for the month allows you to manage you future expenditures based on your forecasted income and expenses, taking into account what differences have impacted your forecast.ĭetailed income and expenses are input on separate pages. The budgeted and actual income and expenses are evaluated and the difference between the two is dispayed in a weekly summary. It offers a unique interface which allows you to see your cash status summarized on a monthly calendar with the variance show for each day. The purpose of this tool is to allow the user to track expected income and expenses (Budget) against what actually happens (Actuals). The Budget Tool allows you manage your budgeted and actual income versus your budgeted and actual expenditures.

Microsoft office personal budget