Author: siteadmin

  • How the Rollover Works: Why Money You Don’t Spend Doesn’t Disappear

    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.

  • Excel or Google Sheets? How the Monthly Budget Spreadsheet Works in Both

    The short answer

    The Monthly Budget Spreadsheet is the same workbook in Excel and in Google Sheets, and the numbers agree in both. It has been tested in both, and the rollover, the quarterly review, and the paycheck-day balance come out the same. February’s rollover is $198.00 in both. February’s Available is $6,398.00 in both. The Safe to Spend on the January 31 payday reads −$56 in both, and it means the same thing in both. So the question is not which one is better. The question is which one you already have. If you have Excel, use Excel. If you do not, use Google Sheets, which is free.

    The numbers are the same in both

    This is the question that matters, so here is the answer first: the numbers agree. The workbook has been tested in Excel and in Google Sheets, and the sums come out the same in both.

    The rollover is the same. February’s Rollover In is $198.00 in both programs, because it is the unspent money from January in the categories that roll over, and the rule is in the workbook, not in the program. February’s Available is $6,398.00 in both, because Available is Planned plus Rollover In, and the planned income is $6,200 in both.

    The quarterly review is the same. The Quarterly Review tab reads the Budget, Debt Payoff, Savings Goals, and Net Worth tabs, and every number in it is a formula, so it updates itself when those tabs change. The first quarter shows the January actuals: income of $7,662, spending of $6,044.90, and $1,617.10 left over. Those numbers are the same in Excel and in Google Sheets, because the formulas are the same.

    The paycheck-day balance is the same. The Paycheck tab splits each payday before you spend it, and the Safe to Spend on the January 31 payday reads −$56 in both programs. That is not an error in either program. It is the rent money, set aside to pay the rent due on February 1, and the tab shows it the same way in both.

    So you do not have to worry that choosing the wrong program will give you the wrong numbers. The numbers are the workbook’s, and the workbook is the same. Choose the program you already have, and the totals will take care of themselves.

    Logging on your phone

    The purchase happens in the shop, in the afternoon, with the phone in your hand. The laptop is at home. That is the moment the log has to work, and it does, because the workbook opens on your phone.

    In Google Sheets, open the Sheets app on your phone, open the workbook, and enter the transaction in the Transactions tab, the same way you would on the computer. In Excel, open the Excel app on your phone, and do the same. The tabs are the same, the rows are the same, and the entry takes the same minute. You do not need the laptop. You need the phone you are already holding.

    Two small habits make phone logging work. First, keep the workbook open in the app, so it is one tap away instead of a search. Second, enter the purchase when it happens, or as soon after as you can, because a purchase entered in the shop is a fact, and a purchase remembered in the evening is a guess. The phone is there for the first one. The laptop is there for the second look, in the evening, when you want to see the month added up.

    Your partner does not have Excel

    This is the question that comes up in every household, and the answer is simple. If your partner does not have Excel, use Google Sheets. Sheets is free, and it runs in a browser, so your partner can open the same workbook on any computer, without buying anything, and enter a purchase or check the month without asking you to open your laptop.

    Share the Sheets copy with your partner, and the two of you are looking at the same budget, and the same totals, and the same Dashboard. The partner who did the shopping can see what the month looks like, and the partner who did the bills can see what is left, and neither of them has to ask the other to remember it.

    The workbook is built for a household, not for one person, and a household does not use one program. One person has Excel. Another does not. The workbook works in both, and the numbers agree in both, so the household can use whichever program each person already has.

    Which one should you choose?

    If you already have Excel, use Excel. If you do not have Excel, use Google Sheets. If you start in one and switch to the other halfway through the year, the workbook is the same, and the totals will still agree. There is no wrong choice, and there is no choice you have to make before the month starts. Open the one you have, enter the first month, and let the workbook do the adding.

    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

    Will the numbers be different in Google Sheets?
    No. The workbook has been tested in Excel and in Google Sheets, and the numbers agree in both. February’s rollover is $198.00 in both, February’s Available is $6,398.00 in both, and the Safe to Spend on the January 31 payday reads −$56 in both, because the rollover, the quarterly review, and the paycheck-day balance are formulas in the workbook, not features of the program.

    My partner doesn’t have Excel. Can they still use it?
    Yes. Use the Google Sheets copy, which is free and runs in a browser, so your partner can open the same workbook on any computer without buying anything. Share it with them, and you are both looking at the same budget and the same totals. The workbook works in Excel and in Google Sheets, and the numbers agree in both.

  • What’s Inside the Monthly Budget Spreadsheet

    The short answer

    The Monthly Budget Spreadsheet is one workbook with 11 tabs, built around a single rule: every dollar gets a job before the month starts, and at the end of the month, Left to Budget must read $0. The tabs cover the month and the years after it: the budget itself, the transactions that fill it in, the bills calendar, the payday split, the debt payoff plan, the savings goals, the net worth, and the quarterly review. The Dashboard shows the month at a glance. The sample family is the Millers, and their January shows planned income of $6,200, actual income of $7,662, actual spending of $6,044.90, and $1,617.10 left over. The Starter, at $12.99, is the workbook plus the Setup Guide. The Complete, at $19.99, adds four more PDFs. The Everything, at $49, adds the UK, Canada, and Australia versions.

    The eleven tabs

    The workbook has 11 tabs, and it helps to know what each one is for before you open it.

    Start Here is where you begin: it walks you through setting up the workbook for your year. How It Works is the instructions inside the workbook, so the method is there when you need it. Those two are the setup. The rest is the work.

    The month lives in four tabs. Budget is the zero-based budget itself, twelve months across, with Planned in gold for you to type and Actual filling itself in from Transactions. Left to Budget must read $0 every month, because every dollar has a job. Transactions is where every purchase goes, and the Budget tab reads it to fill in Actual. Bills & Calendar is the bill calendar: what is due, and when, so nothing is missed. Paycheck is the payday split: each payday must cover the bills due before the next payday, and what is left is safe to spend.

    The long game lives in four more tabs. Debt Payoff is the debt plan, snowball, avalanche, or your own order. Savings Goals is where the savings targets live. Net Worth is the running total of what the family owns minus what it owes. Quarterly Review is the quarter at a glance: it reads the Budget, Debt Payoff, Savings Goals, and Net Worth tabs, and updates itself when those change.

    And Dashboard is the month at a glance. Pick a month, and everything below re-reads the Budget tab for that month: planned and actual income and spending, the cash left, the net worth, and the debt-free date.

    What the Miller sample shows

    The workbook comes with a filled sample, so you can see what a finished month looks like before you fill in your own. The sample family is the Millers, in Austin, renting, with a child, and their planned monthly income is $6,200 after tax.

    Their January shows planned income of $6,200 and actual income of $7,662. January is higher than the monthly average because Daniel is paid biweekly, and January has three of his paychecks, on the 2nd, the 16th, and the 30th. Their actual spending in January is $6,044.90, and the cash left over is $1,617.10. Their net worth is $8,800.

    The debt plan in the sample covers three debts: a credit card paid off in 11 months, an auto loan in 20 months, and a student loan in 27 months. On the snowball plan, with the freed payments rolled forward, the last debt is paid off on 1 April 2028, and the plan saves $803.33 in interest compared with paying only the minimums. Those are the sample family’s numbers, from their plan, not a promise about yours. Your debts, your dates, and your savings will be your own.

    The three tiers

    The Monthly Budget Spreadsheet comes in three tiers, and each tier adds to the one before it.

    The Starter, at $12.99, is the workbook, Sample and Blank, plus the 8-page Setup Guide. That is the whole system, on screen, for one household.

    The Complete, at $19.99, is the Starter plus four more PDFs: a month-end close-out checklist, a quarterly money meeting agenda, a paycheck split worksheet, and a debt-free countdown. The checklists are for the moments the workbook does not cover on its own: closing the month, sitting down together once a quarter, splitting a payday before you spend it, and counting down to the debt-free date.

    The Everything, at $49, is the Complete plus the UK, Canada, and Australia versions of the whole package, for families who want the workbook adapted to their region. The shop charges in US dollars only.

    What to do next

    Open the Start Here tab, and read the How It Works tab. Then look at the Dashboard for January, and see the sample month added up: $6,200 planned, $7,662 in, $6,044.90 out, $1,617.10 left. Then clear the sample, or open the Blank, and type your own planned income for the first month. The workbook will do the adding. You do the typing.

    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

    What is inside the Monthly Budget Spreadsheet?
    One workbook with 11 tabs: Start Here, Dashboard, Budget, Transactions, Bills & Calendar, Paycheck, Debt Payoff, Savings Goals, Net Worth, Quarterly Review, and How It Works. The Budget tab is zero-based, so Left to Budget must read $0 every month. The sample family, the Millers, shows planned income of $6,200, January actual income of $7,662, actual spending of $6,044.90, and $1,617.10 left over.

    What is the difference between the three tiers?
    The Starter, at $12.99, is the workbook, Sample and Blank, plus the 8-page Setup Guide. The Complete, at $19.99, adds four PDFs: a month-end close-out checklist, a quarterly money meeting agenda, a paycheck split worksheet, and a debt-free countdown. The Everything, at $49, adds the UK, Canada, and Australia versions of the whole package.