Forecasting in Futrli takes three forms. All can be found on the Forecasting homepage, this guide will look at all options found on that homepage.
🔍 WALKTHROUGH: For a walkthrough tour of the full Forecasting section within Futrli, please click the GIF below ⬇️
Forecasting homepage layout
Let's run through what you'll find on the homepage.
1 year P&L
1 year P&L
The first of the the three methods available when creating a new forecast.
You will find listed all published and draft 1 year P&L forecasts. All draft forecasts will have been created by you, whilst the published section will list forecasts created and published by both you and other Futrli users with access to this organisation.
This forecast type is P&L only and the start date of the forecast is up to you.
Within a 1 year P&L forecast you can create your own manual predictions, you can build the new forecast to include Futrli auto-predictions, or you can import predictions in bulk.
1 year P&L forecasts can be locked, preventing any further changes from being made.
To learn more about 1 year P&L forecasts, take a look at this help guide.
3 year cash flow
3 year cash flow
Below 1 year P&L forecasts you will find all published and draft 3 year cash flow forecasts listed.
Again, you might have been the creator, but listed here will also be any forecasts created and published by anyone with access to the same organisation.
A 3 year cash flow forecast will always start from the current month and look ahead at the next 3 full financial years, plus the remainder of the current financial year.
Within the a 3 year cash flow forecast you can create your own manual predictions, you can build the new forecast to include Futrli auto-predictions, or you can import predictions in bulk.
To learn more about 3 year cash flow forecasts, take a look at this help guide.
3 year cash flow with due invoices
3 year cash flow with due invoices
Finally on the left-hand menu you will find listed all published and draft 3 year cash flow with due invoices.
As with the other two forecast options, you might have been the creator, but listed here will also be any forecasts created and published by anyone with access to the same organisation.
A 3 year cash flow with due invoices forecast will always start from the current month and look ahead at the next 3 full financial years, plus the remainder of the current financial year.
The 3 year cash flow with due invoices forecast slightly different to the 1 year P&L or the 3 year cash flow. The 3 year cash flow with due invoices pulls through unpaid invoices and bills from the data source, then gives you the power to override expected payment dates.
You can also create your own manual predictions, you can build the new forecast to include Futrli auto-predictions, or you can import predictions in bulk.
Create your own
Create your own
Create a new forecast, choosing from one of the three options:
Whichever option you select, you will have four methods to then use to build the new forecast:
Create from scratch - the new forecast will have no predictions, just the balances of any balance sheet account from the last available actual data.
Create with auto-predictions - the new forecast will have a Futrli-created automated prediction built for every account. Learn more about those auto-predictions in this guide.
Create from last year's actuals - the new forecast will have a prediction created automatically for each account. That prediction will be a formula referencing the actual data from 12 months previous for the account in question.
Create from an existing forecast - the new forecast will be created by using a pre-existing Futrli forecast.
Within the new forecast, regardless of how it was created, you will be able to create your own manual predictions, or import predictions in bulk.
Performance comparison
Performance comparison
Finally, the simple to use performance comparison. This is not a replacement for reporting, but it does give a conveniently easy view of how multiple forecasts compare against one another.
