How to build a Business Forecast in seconds
With Futrli Last Years Actuals method you can create a business forecast in seconds based upon existing trends in your business over the last twelve months. Learn how to quickly project forward and get a clearer picture of the road ahead.
Written by Ross MacLeod
With Futrli’s Last Years Actuals method, you can create a Business Forecast in seconds based upon existing trends in your business over the last twelve months. Learn how to quickly project forward and get a clearer picture of the road ahead.
Firstly, you need to sync your Organisation’s financial data. Futrli allows you to create an automatic sync with Xero or QuickBooks, or to pull in data from any Accountancy Platform via CSV. If you don’t have an existing Futrli Account, you can register here.
Once your data has been uploaded, it’s time to navigate to the Scenarios section of Futrli. This is where you build everything from Budgets, to Scenarios to effortless Cash Flow Forecasts. Before you can create your projection, you first need to enter your Organisation’s Tax settings and map your Default Bank Account, Accounts Receivable and Accounts Payable lines. These only have to be entered once and allow the system to perform all of the core automatic calculations for you, so you can put your feet up and let it do the hard work. Please click Settings adjacent to the Organisation in question:
After entering your defaults, it’s time to create your Forecast. To do so, you’re going to build a new Scenario for your Organisation using Futrli’s Last Years Actuals method. This allows you to use past data to quickly build up a picture of how you expect your business to perform in the future. Adjacent to the Organisation in question, click New, which will give you four main options, one of which being Create from Last Year’s Actuals:
Once you press Quick Create, Futrli will look at your profits, costs and overheads month-by-month for the 12 months prior to your Scenario’s chosen start date. These will then be applied going forward, thus ensuring that any seasonal variety is taken into account. For example, if sales are higher in March and lower in April, you’ll see that factored into your projection.
And that’s it. In a matter of minutes we have a clearer picture of the future of our business.