What’s Inside the Monthly Budget Spreadsheet

Written by

in

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.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *