Forecasts in Futrli are how you are going to look into the future, Forecast Items are the key to that! Every Account within the Organisation's Chart of Accounts can have an unlimited number of Forecast Items created against it, all you need to decide is the method you'd like to use!
When it comes to creating a Forecast Item, you'll need to ensure you are in the 'Workings' tab of the Forecast. Expand the Account Category to expose Accounts by clicking the title of the Account Category, you'll then see a green cross. This is what you'll need to click to create a Forecast Item:
Clicking this green cross will open out your Forecast Item, which is where we can start exploring your forecasting options. You can see the five methods available, so let's run through them!
The number you add here will be consistent according to the repetition method you go with. Enter your invoice amount, set the GST/VAT rate, then select the first invoice date.
Is this going to be a one off entry, or a repeating entry? You have various repeating options, from daily to annually. You can then set how often, so would you like this repeating every one week? Every five years? You can also set when you would like the repetition to finish.
Finally, you can adjust the Forecast Item's payment terms (this Help Guide gives you more information on there terms):
'Set Monthly Growth Rate':
Whilst the 'Single/Repeating Entry' allows you to repeat a single figure, this method gives you the option to add an increase or decrease. Not only this, you can use an average of the last three, six or 12 months, again with an increase or decrease if you'd like!
Set your increase or decrease percentage (you won't be able to leave this as zero) and set the GST/VAT rate. The first invoice date will then need to be set, before you can decide to use a manually entered starting figure, or an average of the previous number of months.
This has to be a monthly repetition pattern, but you can set it to repeat every certain number of months as well as setting when the repetition concludes.
Finish up by setting your payment terms and you're good to go:
'On The Fly':
This is much more static method. Each month within the Forecast's date range will be available to have a figure entered against it. If you create a Forecast via CSV, each row within the CSV will be added as an 'On The Fly' Forecast Item.
The 'Quick Edit Options' will be your best friend when using 'On The Fly'. Using this, you can:
- Set selected to
- Increase selected by %
- Decrease selected by %
- Add £$ to selected
- Subtract £$ from selected
- Split between selected
You'll just need to then select which date in the month the movement occurs, set the GST/VAT rate and ensure the payment terms are as you need:
'Formula Method/Last Years Actuals':
This is how you can get creative with your numbers! Futrli's Formula Builder allows you to reference different Accounts, Account Categories, other pre-made Formulas and even look at data from previous periods!
If you wanted to reference last year's actuals, just ensure the drop down is set to 'yes'. You'll then see the Formula auto-complete with the Account in question, but with a period offset of 12 months set against it.
Set the Formula up as you wish, ensure that the periods being referred to, first invoice date and GST/VAT settings are all showing as expected, then choose your repetition pattern and payment terms. You can always tweak the Formula if it is not showing quite as expected!
Slightly different to the other four options, this is the tool used to move figures from one Account to another.
Set the amount along with the GST/VAT and the first invoice date, choose the repetition pattern and select the payment terms:
With each of the methods available, you'll notice a 'Override Journal Defaults' option. We won't look into this here, but you can explore this further, if you'd like!