Daily, weekly, monthly, quarterly scenario views

There are one-click, daily, weekly, monthly, and quarterly cash flow and forecast views to give you peace of mind over the numbers. You can also drill into the detail of every transaction, so there’s no more, “How did that figure get there?”. It’s complete clarity and peace of mind for you.

see all features

Daily, weekly, monthly, quarterly scenario views

The biggest difficulty when faced with a 3-way spreadsheet forecast or budget, is to understand the rationale behind why numbers are the way they are, both via the dependencies of cell values and  formulas that may reference numbers that are on different tabs of the workbook.

Is there another sheet feeding daily figures into the assumptions? Is there a workings sheet with multiple payment profiles at play? Is there another workbook that has dependencies that need to be updated every time you open the primary workbook? Is every formula accurate? How can you be sure?

It is little wonder that many business owners choose to put their heads in the sand when it comes to business planning and modelling as it’s just too hard.

As you create your plans, forecasts, budgets or scenarios in FUTRLI, the heavy lifting concern is gone. Every transaction you create (read more about what goes on behind the scenes here) has multiple associated transactions (journals) that are created when you hit save. If you want to know what the detail of the headline figures are you can do a few things:

(1) Open up the drop-downs for each account. Any time there is an arrow next to an account name you can drill into the forecast lines that make it up

Screen Shot 2016-04-25 at 12.35.40

(2) Change the view – you can drill into the monthly detail by changing the view to a weekly or daily view, in order to inspect the movements behind any forecast: (image)

(3) Drill into any hyperlinked figure. The top figure of any account is the net movement for that period, but if you want to see what is happening behind the scenes, you can as every positive and negative movement in and out of an account is available to you.

Screen Shot 2016-04-25 at 12.40.11

By using the above techniques on all four of the tabs in your scenarios (Workings, Profit & Loss, Balance Sheet and Cash flow) and by using unique names for your forecasts, this can really help you to find any figures that perhaps, on reflection need amendments. Should you pay your suppliers later? Is there a pre-payment that will make a big difference? If your customers paid you faster, how is your cashflow then?

“Their cashflow modelling is the best that I have used in my 30 years in this business.” - Paul Redmond

Try it for free

Don’t just take our word for it. See how easy it is to create forecasts and business reports in minutes…

Start free trial