By Jeff Knox, The Financial Strategist, Edmonton, Alberta
Most budgets assume the same pay every month. This one does not. Start with the month you are actually in, put in that month's pay, and that month fills in on your Check In too, even if you are starting halfway through the year.
Yellow boxes are yours to type in. Grey boxes do the math on their own, and every chart on this page redraws itself as you type. One example is filled in on each sheet so you can see how it works. Clear the example numbers and type your own over them.
Pick the month you are in at the top, then type that month's take home pay. That month and its total carry over to your Check In on their own.
Fill in your fixed bills, your changing bills, and your once a year costs. Yearly costs get turned into a monthly amount so they stop being a surprise.
Add the small repeat costs. You will see what they add up to in a month and a year, and what that money could grow to if you saved and invested it instead.
List each debt and what you have saved. You will see your totals and how far you are from your cushion target.
Come back once a month. It takes about ten minutes. Your planned money in and out fill in on their own from Money In and Money Out. You just add what actually happened, and one change for next month.
Month you are planning for: January
Money in that month: $0.00
Total debt owing: $0.00
Cushion target: $0.00
Start in whatever month you are in now, even if that is halfway through the year. That same month is highlighted on Check In, and its planned money in comes from the total below. Change the month here and Check In follows.
Each income source for January.
Fixed bills, changing bills, and the monthly share of once a year costs.
Which leak is eating the most, by cost per month.
Your leaks per month: $0.00. This fills in on its own from your leak total above. Add or change a leak and this amount, and every number below, changes with it. It shows what could happen if you cut those leaks and invested that money instead.
These are example numbers only. They use a steady return of 6 or 8 percent a year, with the money going in at the end of each month, and they do not count taxes or fees. Real returns go up and down and are not guaranteed. This shows how the math of saving works in general, and it is not personal advice for your situation.
Grey planned boxes do the math on their own. Money in, planned comes from the month you picked on Money In. Money out, planned comes from your total on Money Out. Change those tabs and every planned number below changes with them. Yellow boxes are yours: what actually came in and went out, and one change for next month.
Gold is money in, grey is money out. Months appear here once you type their actual numbers.