Skip to main content

Add predictions to a forecast

Learn about the different ways to add predictions to a forecast in Futrli.

You can add predictions to any forecast in Futrli. Choose the method that best suits the way you want to forecast your data.


Create manual predictions

You can manually create predictions in any forecast type. The following prediction methods are available:

Formula

Create predictions using formulas that reference accounts, other predictions and calculations.

Freestyle

Enter different values for each period individually.

Repeating

Create recurring predictions that repeat daily, weekly, monthly, quarterly or annually. You can also apply percentage or fixed value increases or decreases over time.

Unit

Forecast sales using quantities and selling prices. You can also apply growth, refund percentages and future price changes.


Import predictions from Google Sheets

Import multiple predictions into a forecast using Google Sheets.


Import predictions from Excel

You can import predictions into P&L budgets and 3-way forecasts using an Excel template.

NOTE: Importing an Excel template does not replace the existing predictions in the forecast, it will add new predictions alongside existing predictions.


Create a forecast with auto-predictions

When you create a forecast, you can choose to use auto-predictions.

Futrli analyses your accounting data and automatically creates predictions for your forecast.

Did this answer your question?