Cash flow forecast with collection and payment lag
A cash flow forecast is not just a PL forecast. Searches like “cash flow forecast collection lag payment lag” point to a real modeling issue: revenue, expenses, receivables, payables, and cash do not always move in the same month.
1) Separate PL timing from cash timing
Revenue can be recognized before collection. Expenses can be recognized before payment. Collection lag and payment lag convert that timing difference into balance sheet movement and cash flow movement.
2) Use lag fields in the transaction form
- Set collection lag on revenue rows when cash arrives after sale.
- Set payment lag on expense rows when suppliers are paid later.
- Review receivables, payables, and ending cash after each run.
- Use the Checks tab before exporting Excel.
3) Why this matters for working capital forecast
A profitable plan can still run short of cash if receivables collect late or payments are due earlier than expected. Linked PL BS CF forecasting makes those timing effects visible before the Excel output step.