When you create a Forecast in Futrli, we'll source the opening balances of your Accounts Receivable, Payable and Sales Tax lines from your Actuals. The Balance for each line will be taken from the Closing Balance of the last period prior to your Forecast Forecast's start date.
Therefore, if you start your Forecast in May, we'll be sourcing your balances as of April 30th. To ensure your Forecast is accurate, we'll need to enter when we expect these balances to be paid. In this guide, we're going to walk through creating a Forecast Item against an accounts receivable line, in order to account for the expected payment of a brought forward balance.
Forecasting the Payment
In this example, we're going to walkthrough receiving the payment of an existing balance on our accounts receivable line. To do so, we first need to navigate to where our accounts receivable line appears in our chart of accounts on the workings tab of our Forecast scenario:
Futrli allows you to create Forecasts against both profit & loss and balance sheet lines. We can enter a Forecast against our accounts receivable line by clicking the + symbol:
In this example, we anticipate that we'll be being paid in three instalments of £27030 over the next three months. To enter this Forecast, we simply need to enter our anticipated amount in our Amount column and the Bank Account we expect this money to be paid into, then the Start Date of our Forecast and how often we wish to repeat it:
After hitting 'Save Changes', we'll see each payment reflected in our Cash Flow.