Three-statement forecast: plan balance sheet and cash flow
Updated:
Plan balance sheet and indirect cash flow per period from a plan version, with assumptions and a reconciliation to the cash horizon.
Open Planning & control in FiattoIn this article
On the Three statements tab of a P&C cycle under Reporting & sustainability → Planning, control & CFO cockpit → Planning & control (/dashboard/planning), Fiatto derives a plan balance sheet and an indirect cash flow per period for a plan version. The basis is that version's profit and loss plus the opening balance from your accounts. Nothing is posted: it is a derivation. The tab is available to approvers.
Steps
- Open Planning & control, click a cycle and choose the Three statements tab.
- Pick the plan version under Version and click Calculate. You see the Plan balance sheet (opening position and every period, with the Balance closes check) and the Cash flow (indirect): from result via depreciation, changes in receivables and payables, investments, repayments and new financing to cash.
- Under Assumptions for this version, enter Investments and New financing per period, and optionally your own DSO (days) or DPO (days); empty means the figure from the working-capital cockpit. Click Calculate again to see the effect.
- Click Save to version to store the assumptions and the derived balance sheet in the version. This only works for a draft version and when the balance sheet closes in every period.
Tips
- Repayments come from the scheduled instalments of your loans under deposits and loans. Depreciation counts as a non-cash item; in a forecast version, depreciation of your own fixed assets comes from their depreciation schedule.
- If a source or assumption is missing, such as an opening balance, a DSO or an investment plan, the screen says so instead of silently calculating with zero.
- After calculating, Reconcile with cash horizon puts the three-statement cash per month next to the 18-month horizon of the cash-flow forecast. The difference is split into result, working capital, investments, lease payments, financing and rounding. This needs the bank module and bank rights.
- The three-statement forecast only works company-wide (all entities) and on the primary book. Saved balance-sheet positions do not count as budget and are not included in plan versus actuals.
- Under Does this scenario hold? a version tests itself: Liquidity checks the cash position per period against the cash buffer of your bank accounts (against zero if no buffer is set), Covenants checks the bank covenants from deposits and loans per quarter with this version's plan EBITDA. A covenant that cannot be assessed is shown as such and never counts as met.