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.
Thirteen week-starting dates from one Monday; opening carried forward; two cash-in and six cash-out lines; total in, total out, net, closing (red below minimum cash, bold red below zero), vs minimum. Lowest closing and its week, weeks below minimum and below zero, 13-week totals. Pro: cells are SUMIFS over Items.
Three hundred rows: date, description, line from a list, amount, status (Expected, Confirmed, Received, Paid). Week number and in/out calculated; past-due items still expected red; past due not received / not paid; items outside the 13 weeks.
Per week: expected in, received, still expected (red in past weeks); expected out, paid, still to pay; forecast closing. Past weeks greyed.
As-of date, first Monday, opening balance, minimum cash, the lines and statuses.
Eight formulas explained: the week bucket with two date criteria, the carried-forward opening, the lowest week with INDEX/MATCH, the week number from INT.
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.
A cash flow forecast is a small sheet with two rules that people get wrong: every week opens with the previous week’s closing, and money goes in the week it lands, not the week it’s invoiced. Both are built in. The closing row turns red below the minimum cash you set, and the summary finds the lowest closing of the thirteen and the week it falls in — that date is the whole point of the exercise.
Typing into a grid is how forecasts go stale. In Pro the grid is read-only: every cell is a
SUMIFS over Items, one row per expected receipt or payment with a date and a status. Move
an invoice from the 5th to the 19th and the money moves two columns; mark it Received and
the Weeks sheet stops listing it as outstanding. Past-due items still marked Expected turn
red on Items — that’s the chasing list — and the summary adds up what should have arrived
and what should have gone out.
Rolling the forecast is one date: move “Week 1 starts” forward a Monday on Setup and the items re-sort themselves into the new thirteen weeks.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares forty-two values — the grid cells, totals, every closing, the lowest week, the below-minimum counts, week numbers and in/out on Items, past-due sums, and the Weeks table — 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.
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.
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.