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.
Date, description, category and method as dropdowns, amount. A panel on the right totals the chosen month by category, counts entries and names the biggest category.
Twelve months back from the Setup month, one column per category, SUMIFS in every cell, data bars, an average that ignores empty months.
Each category against its monthly limit: spent, left (red when over), used as a bar that turns red past 100%.
The month to report on, categories with limits, payment methods — all as named ranges.
Eleven formulas explained, including why the ranges stop at row 1000.
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.
One row per payment. Category and method come from dropdowns, so a mistyped word can never hide a row from the totals. The panel beside the log adds up the month you chose — by category, with a bar for each — counts the entries, and names the category that took the most.
The Monthly sheet is twelve months across ten categories, every cell a SUMIFS, with data bars so the heavy months show. The Limits sheet puts each category against the limit you set on Setup: what’s left turns red when you’re over, and the “used” bar fills to 100% and then the number goes red. Rename a category once on Setup and the dropdown, the grid and the limits follow.
The Formulas sheet lists the eleven calculations in the workbook and says what each does — including why the ranges stop at row 1000 and how to raise it.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample data and compares twelve totals against numbers computed outside Excel. If any drift, the file doesn’t ship.
First release
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.
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.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.