The short answer
Money you do not spend does not disappear in this workbook. It rolls forward. The Budget tab has a rule, written at the top of the page: Rollover In carries last month’s unspent money forward, and Available is Planned plus Rollover In. February’s rollover is $198.00, and it comes from three categories in January where the planned money went unspent: Internet, $60 planned and $0 spent; Health Insurance, $120 planned and $0 spent; and Renters Insurance, $18 planned and $0 spent. Sixty plus one hundred and twenty plus eighteen is one hundred and ninety-eight. February’s Available is $6,398.00, because the planned income is $6,200, and $6,200 plus $198.00 is $6,398.00. The money did not disappear. It moved.
What rollover is
Rollover is the workbook’s answer to the vanishing money. In most budgets, each month starts from zero, and whatever you did not spend last month is forgotten. In this workbook, each month starts from what is left.
The rule is on the Budget tab, and it is one sentence: Rollover In carries last month’s unspent money forward, and Available is Planned plus Rollover In. That is the number Over is measured against. In plain terms: each category has a Planned amount, which you type, and a Rollover In amount, which the workbook fills in from last month, and an Available amount, which is the two added together. Available is what you actually have to spend in that category this month.
The rule only carries money forward. It does not carry overspending forward as a debt, and it does not carry the whole month’s surplus forward as a lump. It carries the unspent money, category by category, from last month into this month, so the money stays with the job it was given.
Where February’s $198.00 comes from
February’s rollover is $198.00, and it comes from three categories in January. Here they are, one by one.
Internet: January planned $60, and January actual spending was $0. The $60 was planned, and it was not spent, so $60 rolls into February. February’s Available for Internet is $120: the $60 planned for February, plus the $60 carried in from January.
Health Insurance: January planned $120, and January actual spending was $0. The $120 was planned, and it was not spent, so $120 rolls into February. February’s Available for Health Insurance is $240: the $120 planned for February, plus the $120 carried in from January.
Renters Insurance: January planned $18, and January actual spending was $0. The $18 was planned, and it was not spent, so $18 rolls into February. February’s Available for Renters Insurance is $36: the $18 planned for February, plus the $18 carried in from January.
Sixty plus one hundred and twenty plus eighteen is one hundred and ninety-eight. That is the whole of February’s rollover. Three categories, three amounts, and the arithmetic is the explanation. Nothing else in January rolled over, because in every other category, the planned money was either spent or the category does not roll over.
February’s Available for the whole month is $6,398.00: the planned income of $6,200, plus the rollover of $198.00. That is the number the month is measured against. January’s planned spending was $6,200, and January’s actual spending was $6,044.90, and the $198.00 is the part of the plan that was not spent, carried forward instead of forgotten.
What does not roll over
Two things do not roll over, and both matter.
First, overspending does not roll over as a negative. Dining Out in January was planned at $195.10, and the actual spending was $238. It went over by $42.90, and its rollover into February is $0. The workbook does not punish the next month for the last month’s overspending. It measures the overspending against Available, in the Over column, and leaves February alone to start clean. The rollover carries unspent money forward. It does not carry debt forward.
Second, the rollover is not the same as the surplus. January’s cash left over is $1,617.10: actual income of $7,662 minus actual spending of $6,044.90. That is the cash in the account at the end of the month. The rollover is $198.00: the unspent money in the categories that roll over. The two numbers are different because they measure different things. The surplus is the cash left over. The rollover is the plan left over, category by category, carried into next month. Do not confuse them, and do not expect them to match. The surplus is what is in the account. The rollover is what the plan says you still have to spend, in the categories where the money was not used.
What to do next
Open the Budget tab, and look at the Rollover In column for February. Find the three categories with money in them: Internet, Health Insurance, and Renters Insurance. Check the January Planned and January Actual for each one, and see the unspent money for yourself. Then look at the Available column for February, and see the Planned plus the Rollover In, added together, category by category, up to $6,398.00 for the month.
If you are starting the workbook in a new month, type your planned amounts, and let the rollover build itself. The first month has no rollover, because there is no last month. The second month has one, because the first month left money behind. That is how the money stops disappearing: it is carried forward, in the open, where you can see it.
You can see the Monthly Budget Spreadsheet in the shop at monthlybudget365.com. The Starter, at $12.99, is the workbook plus the Setup Guide. The Complete, at $19.99, adds the four PDFs. The Everything, at $49, adds the UK, Canada, and Australia versions. The shop charges in US dollars only.
FAQ
Where did my unspent money go?
It rolled forward. Rollover In carries last month’s unspent money into this month, category by category, and Available is Planned plus Rollover In. In the sample, February’s rollover is $198.00: Internet $60, Health Insurance $120, and Renters Insurance $18, each planned in January and unspent. February’s Available is $6,398.00, which is the planned $6,200 plus the $198.00 carried in.
Is the rollover the same as my surplus?
No. January’s cash left over is $1,617.10, which is actual income of $7,662 minus actual spending of $6,044.90. That is the cash in the account. The rollover is $198.00, which is the unspent money in the categories that roll over. The surplus is what is in the account. The rollover is what the plan says you still have to spend, in the categories where the money was not used.