How to set up your budget
Open the Categories sheet and enter the budget amounts for each category in column E. Each subsequent month will automatically be populated with the budgeted amount in column E for that category.
Once you’ve set the budget amounts on the Categories sheet you can start categorizing transactions and reviewing the Monthly and Yearly Budget tabs. Based on those budget view sheets you can fine tune your budget amounts for each category on the Categories sheet.
You can change a category’s budget amount for a specific month by directly editing the value for that month. Be aware that months after that change will also adopt the new budget value.
Adjusting the start month of the budget
You can change the year’s budgeting start month by editing the date in cell E1 to be the first day of the month in which you want the budget year to start. For example, if you want your budget year to start in September 2019 you would enter 9/1/2019 into cell E1.
The rest of the year (12 months) following Sept 2019 will automatically populate. This is nice if you just want to start budgeting this month going forward.
Review your Monthly Budget
The Monthly Budget sheet gives you a breakdown of planned vs actual spending and income as well as a planned vs actual cash flow analysis.
Visualize your budget by type, group, and category. You can quickly see what’s remaining for a category or if you’ve gone over.
Each group’s line also indicates the % of your expense budget that’s allocated to that group.
Customize the view of the data on this sheet by using the controls in the upper right. You can view the data for the previous year and month here. If there are no budget periods configured for the time frame on the Categories sheet you will still see your actuals for that period.
Review your Yearly Budget
You can use the Yearly Budget view to see your entire year’s budget. Get a cash flow analysis for the entire month and the year based on the budget you’ve set on the Categories sheet and your actual spending.
You can view a different 12 month period of budgets and data using the controls in the upper right. Keep in mind this is a visualization of your data based on the start month and number of budget months that are configured on the Categories sheet.