Docs

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

  1. 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.
  2. On the forecast, add Deals. Mark each as one_time or recurring, set its amount and month, and flag whether it is commissionable.
  3. 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.