You find out you're short on cash the same week you're short on cash.
A rolling cash flow forecast that is just a grid of formulas is only as good as whoever remembers to check it against the minimum cash buffer or the lending covenant. Most weeks, nobody does — until the breach has already happened and the conversation with the bank is a different conversation.
Headline figures, charts and an action list of what to fix first, then the tabs where the work happens. Shown here with the worked example that comes with your download.

Real screenshot of the Overview tab. Every figure is calculated by the workbook.
This liquidity control system tests every forecast week against your minimum cash buffer and any lending covenant automatically, and flags a breach before it lands rather than after. An unfinished forecast reports itself as not ready — it never shows a false clean result.
Replaces the rolling cash flow spreadsheet, the separate covenant check and the monthly liquidity slide nobody can trace back to source.
Built for finance directors, CFOs, treasury and FP&A teams reporting liquidity to a lender or a board.
It is built as a rolling weekly forecast for liquidity management — the buffer and covenant tests run week by week across the forecast horizon you set up. It is a treasury and liquidity tool, not a three-statement long-range model.
Every system is built as a standard Excel (.xlsx) workbook using formulas only — no macros, no add-ins, nothing to install. Because there are no macros, the files also open in Google Sheets and LibreOffice.
Checkout is processed by Paddle. Within a few minutes of payment clearing, your download links are emailed automatically from info@appiqfinance.com. You get the blank master workbook and a fully worked example.
Report it within 14 days with the file, tab and cell, and we fix it and redeliver — or refund you in full if we can't. See the refund policy for the exact terms.
Practical guides on the problem this system solves. Free to read, no sign-up.
Build a rolling 13-week cash flow forecast using the direct method: structure, data sources, a cash buffer line, the weekly roll and variance tracking.
Read the guide →How to set a minimum cash buffer: three methods, a worked example, and how to test a weekly cash forecast against it so a shortfall shows up early.
Read the guide →How to monitor loan covenants such as leverage, interest cover and minimum liquidity: calculate headroom, forecast it forward and act before a test date.
Read the guide →The cash conversion cycle formula (DIO + DSO - DPO), a worked example, and practical ways to shorten it so less cash is tied up in running the business.
Read the guide →Run the free check on your own numbers today. If it finds gaps, this system closes them every period.
Working capital, the working capital ratio, operating working capital, days of working capital and the cash conversion cycle, with every formula. Free to use online.
Use the free toolWork out DSO and the cash tied up in late payers. Free to use online.
Use the free toolClose finishes when the file gets sent, not when the numbers are proven right.
View system →The first place a duplicate payment gets caught is the bank statement.
View system →Your cash is sitting in a customer's bank account, and nobody can say for how many days.
View system →