A monthly budget for Excel and Google Sheets with every formula visible: planned vs actual by category, red/green differences, savings rate. Pro adds a transactions log that fills the budget automatically, a twelve-month view with a chart, and a sheet explaining each formula.
Income and expense categories, planned vs actual, differences coloured red when you overspent, share of income per category, left-over and savings rate.
One row per payment: date, description, category from a dropdown, amount. Feeds the Budget for the chosen month and the Year sheet for all months.
The last twelve months from the Setup month back: income, expenses, left-over, savings rate, and an income-vs-expenses column chart.
The month you're budgeting, currency symbol, and the category lists as named ranges — rename here and everything follows.
Twelve formulas, each one shown and explained: what it adds up, why the IF is there, where the range ends.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Nothing is hidden. The Budget sheet has two kinds of cells: yellow ones you type into and formulas you can click. Overspending turns the difference red; coming in under turns it green. The percentage column tells you what share of your income each category actually took.
Log payments on the Transactions sheet — date, what it was, a category from a dropdown, the amount — and the Budget sheet fills its Actual column by itself for whichever month you named on Setup. The Year sheet looks back twelve months and draws income against expenses. Change a category name once on Setup and the dropdown, the budget and the year view all follow, because they read named ranges rather than typed words.
The Formulas sheet lists each calculation and says what it does in a sentence: why the SUMIFS has three conditions, why the ranges stop at row 400 instead of running down a whole column (Google Sheets gets slow), why there’s an IF in front of the percentage. If you want to change how something works, you can, because you can see how it works now.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample data and compares ten totals against numbers computed outside Excel — the month’s income, the grocery total, the savings rate, the twelve-month sum. If any of them drift, the file doesn’t ship.
The twenty transactions are examples; delete them. Categories, planned amounts and the currency symbol are yours to set on Setup and Budget.
First release
An expense log for Excel and Google Sheets that totals itself: this month by category with data bars, twelve months back, and spending against the limits you set — every formula visible. Pro adds the Monthly and Limits sheets, a Setup sheet with limits, and a formulas walkthrough.
Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.