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.
Eighty rows: PO, date, supplier from a list, what, amount, status (Ordered, Part received, Received, Cancelled), expected, received on, paid ✓. Days — lead time or days open — and a flag: Late red, Due this week yellow; received-but-unpaid tinted, cancelled struck through. Open POs and value, late, received this month, ordered this year, received-not-paid, average lead time. Pro: amount from Items, lines and outstanding quantity.
Three hundred lines: PO from a list, item, qty, unit price, line total, received qty, outstanding (yellow while something is still to come). Supplier and status looked up. Still-to-arrive lines and value.
POs, spend this year with share bars, open value, average lead time, late now (red); biggest supplier, slowest.
Twelve months from the first month on Setup: POs raised, ordered by PO date, received by received date, still open from that month.
As-of date, first month of the Monthly view, statuses, suppliers.
Ten formulas explained: the Days branch, the two-status open value, received-not-paid by subtraction, still-to-arrive value with one SUMPRODUCT.
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.
Purchase order tracking comes down to two questions, so that’s what the sheet keeps at the top.
What’s still to arrive, and what have we not paid. The first is the Late flag and the open value at the top: a PO whose expected date has passed and which isn’t received or cancelled turns red. The second is received, not paid — the received POs minus the ticked ones, which is the pile of invoices. Days does double duty: for a received PO it’s the lead time, for an open one it’s how long it has been waiting, and the average of the first is the number to put in the next expected date.
Items is one row per line — quantity, unit price, received quantity — and from it the PO’s
amount on Orders becomes a SUMIF, so you stop retyping totals. Outstanding is ordered
minus received, never below zero, and the value still to arrive across every open line is one
SUMPRODUCT that skips cancelled POs. Suppliers puts the same log the other way round: spend
with share bars, what’s open with each, average lead time and who is late right now. Monthly
is ordered by PO date and received by received date, so the two columns don’t have to agree.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares fifty-five values — days and flags, every summary figure, PO amounts from the lines, outstanding quantities, each supplier’s spend and lead time, and the Monthly columns — against numbers computed outside Excel.
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 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.