One row per transaction; the category decides whether it's income or an expense, so amounts stay positive and every total is a plain SUMIFS. Year totals and margin at the top, a category summary beside the log. Pro adds a Monthly sheet with quarters, a P&L by category with shares, and a formulas walkthrough. No macros.
400 rows: date, description, category and account from dropdowns, amount. Type looked up from the category (unknown flagged red), income rows green. Income, expenses, net and margin for the year. Free: the category list with this year's total per category, and the accounts, on the same sheet.
Twelve months: income and expenses with bars, net, cumulative net, margin; quarters; best month; averages over months with activity.
Income categories with share of income, expense categories with share of expenses, totals, net profit and margin, anything uncategorised — listed from Setup without FILTER.
Year, twenty categories with Income/Expense, eight accounts.
Ten formulas explained: the type lookup, the sign-by-category split, DATE() bounds, EOMONTH months, the numbered-category trick behind the P&L.
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.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
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.
The usual bookkeeping sheet asks you to type expenses as negatives, and the usual error is a
missed minus. Here every amount is positive. You pick a category; a lookup on Setup says
whether it’s income or an expense; two helper columns split the amount, and every total —
the year at the top, the months, the P&L — is a plain SUMIFS on those columns. A category
that isn’t on the list shows “Unknown” in red and its amount lands in an “Uncategorised” line
on the P&L instead of quietly vanishing.
Monthly gives twelve rows of income, expenses, net and cumulative net with bars, four quarters for whoever does your estimated tax, the best month, and averages over months with activity so September’s year-to-date isn’t diluted by an empty October. P&L lists income categories with their share of income and expense categories with their share of expenses, then net profit and margin.
The P&L lists categories by type without FILTER: Setup numbers the income categories
1, 2, 3 and the expense categories 1, 2, 3 with a running COUNTIF, and each P&L row looks up
its number. It’s the same trick our calendar uses for the second event on a day.
A cash ledger, not double-entry bookkeeping: no invoices outstanding, no VAT logic, no depreciation. For tax, hand the P&L to whoever does yours — it’s laid out for that.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares forty-six values — every year total, specific months and quarters, cumulative net, each P&L row against sums computed outside Excel, the category numbering on Setup.
First release
A week of trading, one row a day: card, cash, how much of it carried VAT, and how many people came in. Takings, the VAT already inside those sales and the spend per head are calculated. Pro adds the month's running costs with a budget, a variance and an On plan / Watch / Over status on every line, plus a summary that reads the week back to you. No macros.
Thirteen weeks across, cash in and out down: the balance carries forward, weeks below your buffer turn red, and the lowest point and its week are found for you. Pro fills the grid from a dated list of expected receipts and payments and shows what's still outstanding from past weeks. No macros.
One row per purchase order: supplier, amount, status, expected and received dates, paid. Days open or lead time, a Late flag, open value, unpaid invoices. Pro adds line items per PO with what's still to arrive, a supplier view with lead times, and a monthly view. No macros.