Here's the quick version. To bring in quarterly Actuals for the September quarter*, we:
- July: use zero for all Profit & Loss items, and repeat the June numbers for the Balance Sheet
- August: use zero for all Profit & Loss items and repeat the June numbers for the Balance Sheet
- September: use the quarterly totals for all Profit & Loss items and the September Balance Sheet data
* Note we're assuming the forecast already contains either an Opening Balance sheet or Actuals data for June.
For both July and August, 0 movement in the Profit & Loss together with 0 movement in the Balance Sheet means 0 cashflow. The cashflow for the whole quarter will appear in September.