Skip to main content
All CollectionsForecastingPredictions
Create a manual prediction
Create a manual prediction

How to create and set up your own prediction.

Updated over a month ago

In any Futrli forecast, you can create manual predictions. We cover the four methods you can use to create a prediction manually.

๐Ÿ“ŒTIP: You can also import predictions via a Google Sheets template.


How to create a new manual prediction

๐Ÿ“Œ TIP: You can create multiple predictions against any account, then toggle any prediction off to hide any impact of the prediction.

  1. Click Forecasting then click View/edit in the relevant forecast.
    โ€‹
    โ€‹

    View/edit option on a forecast.


    โ€‹

  2. Click New prediction in the top right of the window, then click Manual prediction.
    โ€‹
    โ€‹

    'Manual prediction' option showing on the 'New prediction' dropdown.


    โ€‹

  3. On the Prediction method drop-down, select which method you'd like to use to create a new prediction. We cover these methods in the next section.
    โ€‹
    โ€‹

    Creating a manual prediction and selecting a method.


Prediction method options

There are four methods you can use to create your prediction.

Formula

You can use formulas for predictions such as:

  • Adding percentage increases to previous data

  • Removing or adding accounts from groups

  • Corporation tax

  • Using an 'if' formula

    ๐Ÿ“ŒTIP: An example you could use an 'if' formula for is commission structures.

Freestyle

Freestyle is useful for those less predictable accounts.

Set certain totals against certain months, or use the 'Quick Actions' option for bulk updating.

Repeating

Use this for the more predictable accounts.

Set the repeating amount, choose how often it repeats (daily, weekly, monthly, quarterly or annually), and then specify the end date for the repetition. You can also add percentages or increase and decrease amounts if required.

Unit

This is perfect for the selling of items.

Set the selling price, then how many you'll be looking to sell and in what time range. Confirm when the selling will commence, and when it might end (if it does). You can then even add a growth percentage or a refund percentage, as well as future price changes.


What is the Accounts impacted tool?

Whichever method of predicting suits you, the Accounts impacted tool gives you a live view of exactly what numbers your prediction is producing.

Prediction builder builder view for Repeating method.

As you update your prediction, numbers populate each impacted account.

๐Ÿ“ŽNOTE: The Accounts impacted tool will not show until you start editing the prediction method. It won't appear until you add, at the minimum, a prediction Name and Account. When using the formula method, the tool will display after you populate the formula section.

When you use the freestyle, repeating, or unit-based methods, you see figures updating for:

  • The account your prediction is set against

  • The bank account being credit/debited

  • The VAT/GST/sales tax account (if the prediction has VAT/GST/sales tax)

  • The accounts payable/receivable line (depending on the cash flow payment treatment)

    ๐Ÿ“ŒTIP: You can update default accounts for accounts payable and accounts receivable in the forecast's settings.

  • The chosen balancing account (if a non-cash transfer has been selected)


What is the Formula values tool?

When you use the formula method to create a prediction, a second tab displays alongside Accounts impacted called Formula values used.

Formula values used option within a prediction builder.

This tab displays anything referenced in your formula. This allows you to sense-check what you're creating as you create it.

Did this answer your question?