Understanding the Planner sheet

You’ll start with the Planner sheet to establish your categories and set up your your current budget. The green cells are for you to edit. There is also space to plan a future budget and review a budget summary.

Building your categories

Your categories should reflect the way you need to budget your money. When you’re categorizing transactions, these categories will be available from a drop down menu or using keyboard shortcuts on the Transactions sheet. They’re also automatically pulled into the Dashboard sheet.

Income

Please don’t edit or remove the Income category name (that’s why it’s gray and not green). Enter in all sources of income as budget components into separate columns in the Category Breakdown area. If you only have one income source you can use “Paycheck” or some other label in row 12 or leave it blank. Then using the green cells in row 13 enter your current budgeted income. You can build out as many income budget components as you’d like, including other household members or other sources of income. 

Expenses

All the expense categories below “Income” are for you to add, edit, or remove as you want. Simply edit the suggested categories that already exist or add in new categories. You also have the option to create a detailed budget for an entire category using the green cells in the Category Breakdown area to the right. For example, the category “Housing” might be broken into mortgage, insurance, and security. 

Historical comparisons

The “3 month average” and “last month” data on the Planner sheet will begin to update and reflect trends for your spending in each category after you’ve categorized transactions for more than your first month. 

Next: Setting Up Your Budget

Did this answer your question?