Cashflow Forecast
Cashflow Forecast turns a handful of assumptions and a deal pipeline into a month-by-month cash projection you can export to Excel. It works for any business — SaaS, agencies, e-commerce, and light manufacturing — because the model is built from neutral primitives rather than one industry's vocabulary.
What you get
- Forecasts — a planning header with your cost-of-sale %, COGS %, payment terms, monthly opex, a variable-revenue ramp, and a horizon.
- Deals — the pipeline feeding a forecast. Each deal is either a one-time booking that lands in a month, or a recurring line that accrues every month from its start.
- A review lifecycle — move a forecast from Draft to In Review to Approved, then archive it.
- Excel export — one click produces a workbook with a Summary, a month-by-month Ledger, the Deals snapshot, and your Assumptions.
Build a forecast
- Open Forecasts and create one. Set the cost-of-sale %, COGS %, payment terms (how many months after a sale the cash actually arrives), monthly opex, and the variable-revenue ramp.
- On the forecast, add Deals. Mark each as
one_timeorrecurring, set its amount and month, and flag whether it is commissionable. - Click Export to Excel to download the full projection.
How the projection works
- Revenue recognised is when a deal or the variable ramp books revenue.
- Cash received is that revenue shifted by your payment terms — so a net-60 business sees cash land two months after the sale. Revenue booked in the last months of the horizon whose cash falls outside the window is reported separately, not dropped.
- Cost of sale applies to commissionable deal revenue; COGS applies to all revenue; opex is your fixed monthly cost. Net cash is what's left.
Starter examples
A fresh install includes four worked forecasts — SaaS, Agency, E-commerce, and Manufacturing — so you can clone the closest one and adjust.