How to forecast with Brought Forward Balances

In this guide we’re going to walkthrough creating a forecast item against an Accounts Receivable line, in order to account for the expected payment of a Brought Forward Balance.

Written by Ross MacLeod

About

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 Scenario’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 walkthrough 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

Step One

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 Scenario:

Screen Shot 2017-01-19 at 09.38.36

Step Two

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:

Screen Shot 2017-01-19 at 09.40.05

Step Three

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:

Screen Shot 2017-01-19 at 09.45.20

Step Four

After hitting Save Changes, we’ll see each payment reflected in our Cash Flow.