Follow the steps below to display a cash flow forecast in a report.
Step 1 - Create a cash flow forecast
Select the cash flow type
From the Forecasting tab, select one of the following options:
3 year cash flow - This type of forecast uses balances from Accounts Receivable and Accounts Payable (AR/AP)
3 year cash flow with due invoices - In this type of forecast, AR/AP is split into actual unpaid invoices, and payment terms and estimated payment days can be amended
Select a Method
You can create a cash flow forecast by using the following methods:
Create from scratch - you can either:
Publish the forecast
Make sure to publish the forecast to be able to select it in the report.
Step 2 - Create a report
From the Reporting tab, create a report from scratch or from a template.
Click the Builder section.
Select a chart or table widget and drag it across into the report.
Under Datasets, select the forecast created previously.
Click Choose data.
Under Financial data > Cash Flow Statement, select the level of cash flow information you need to report on:
The report widget will display the information based on the date range selected:
