What is a Zero-Based Budget? It is a saving and spending plan where you assign every dollar of your income to some specific purpose. At the end of the worksheet, if your budget is fully balanced, you should have ZERO budget left over. Some of your income will be going into savings, some will be going towards expenses, some might even be invested. The point is to plan what you want to do with it.
You can use pretty much ANY budget spreadsheet to apply the zero-based budgeting principles, but I designed this worksheet based on a very deliberate set of saving and expense categories. Continue reading below to learn how to use the worksheet to create a zero-based budget.
- Enter Your Income
If you are creating a monthly budget, list all sources of income for the month. If you actually get paid biweekly, you may want to base your budget on just two weeks of pay, then use your extra paycheck twice per year to do something special. If you get paid weekly, you can base your budget on 4 weeks. If your income varies a lot, you can base your budget on what you expect the minimum for the month will be.
- Enter Your Budget (Savings and Expenses)
The categories in this worksheet have a very purposeful structure. They are designed to help you apply the ‘Pay God First’ principle, the ‘Pay Yourself First’ principal, the ‘Debt Snowball’ and ‘Savings Snowball’ techniques, the ‘Sinking Funds’ idea, and the ‘Envelope Budget’ system.
This category is for making adjustments to your gross income, such as listing the tax with holdings and other deductions from your paycheck. If you pay a tithe (the “pay God first” principle), then you can multiply by a percent in excel using a formula such as =10%*B9 where B9 is the Total Income. This would also be a place to pull out priority savings to apply the “pay yourself first” principle.
Nobody makes it through life without unexpected big bills. So, plan for them. Things like medical bills, home repairs, and car repairs can be budgeted ahead of time so that you have the money when you need it. For a monthly budget, divide the total average yearly cost of a large bill by 12. You can divide in Excel using a formula such as =1500/12.
Some people like to track the savings for big bills in separate accounts, sometimes even a separate sub-accounts. That’s great. Whether you call some of these categories “sinking funds” or “short-term savings” doesn’t matter in this worksheet. The point is that you have a place called BIG BILLS to remind you to budget for the big important stuff, the stuff that if you don’t plan for, could break you.
If you have a lot of different debts, you may need to lump some of them into categories such as “credit cards” and “students loans.” If you are using a debt snowball, only include the MINIMUM monthly payments in this section! The debt snowball is included in the Savings section. Whether you list your mortgage as a big bill or a debt is up to you.
These are your utilities, subscriptions, and other recurring bills that may be variable, but are pretty much consistent and predictable. Some of these could be envelope categories, but in general, these are for bills that you can set on AutoPay.
The daily living categories such as groceries, fun and fuel tend to be highly variable. Many people like to use an envelope system to control the spending in these areas more closely.
If you are using a budget system where your envelope categories carry over from month to month, then as you complete your monthly zero-based budget, check the balances in each envelope (whether physical or virtual) to see whether you can reduce a category one month to make room for a bigger debt or savings snowball.