HOME / COMMUNITY Switch to knowledge base

Cashflow forecast report

I think what we’ll do is just start with a basic set of projections based on the points I mentioned further up. We can always add to this later.

It would be preferable to go down the route of integrating with an established service, however any 3rd party application would need to pull data from QF over the API (as Vistr are doing with Xero), this would take a commitment on their part.

3 Likes

Hi, has there been any update on the development of this at all please?

1 Like

Hi @joevans

There isn’t an update at the moment I’m afraid.

However, we will update this thread as soon as we are able to.

As @Glenn mentions above, it is preferred that we integrate with an existing piece of software

Hello. It’s great so have seen so many positive contributions above; yet the trail had gone quiet since January. I’m possibly not alone to be waiting with baited breath for a further update or progress update?
G.

Hi Yes could we get an update on this feature please
It would be great to have this feature implemented to be forward looking, and customisable to assess potential contract wins / losses / changes in programme, and overhead changes eg staff / supplier cost amendments over a differing periods. Ideally we would like the ability to project forwards based on potential recurring and one off receipts and payments.
Hopefully implementing something which provides this (or something along these lines) within QF or possibly through a separate app link up would not be too far in the
distant future?? Thanks!

I’m sorry we don’t have any updates to report on this at the moment, we will certainly update this thread as and when this feature request is reviewed.

Hi Gents,

A crucial report that appears to be missing from Quickfile is the Cashflow Forecast Report. This is a simple report that calculates the customer invoice due dates Vs the supplier due dates and gives a report of what the state of cashflow will be like in a specified amount of time, with intervals such as days, weeks, months etc.

This is a crucial report as it allows you to calculate how much cashflow will be available at any future date.

Of course this assumes all customer invoices are paid on time, and when a due date passes and payments have not been paid.

1 Like

Hi @cr123

I’ve merged your post with he existing topic to keep everything together

After reading through the posts, I think every-one is demanding QuickFile to step up the game.
QuickFile is a very basic bookkeeping software but as I’ve been using it for quite some time, the cash flow forecasting falls under management reporting and the best way is to create extracts and work on excel.
Not to confuse cash flow statement which is something different altogether.
There are 3rd party software available which can do some complex forecasting and if thats the case then im not sure why the user is on QuickFile.
After using SAP by design, which produces 100’s of generic reports one would still need to rely on excel. So why not simply use it in the first place.
QuickFile is a brilliant piece of software and the export functions can do some wonders if you have the skills via excel.

Thats right and it cost $100 a month and Quickfile is the fraction of its price. So i think integrating a new feature like that would raise the cost significantly which is best left to 3rd party software.

Not sure if its worth reviving a two year old post, but this particular point is worth understanding better.

The way I see this issue is the question that should be asked is not whether 1,2 or 3 or YNAR or PACE is better, but more what businesses are trying to achieve.

As I understand it, there are presumably three main points businesses want to accomplish.

  1. Project how much income and expenditure will occur over the next 12 months (whether you do that weekly, monthly or quarterly). Mainly to see what you are spending your money on in order to reduce your expenses and to evaluate where you are making money in order to improve your income.

  2. Determine Net Profit as well as final Bank Balance at end of year

  3. Determine Cash flow over the months to ensure that you have sufficient funds at all times?

I have found using the profit and loss in previous years and the budgeting tool that I have has enabled me to reduce my expenditure, identify areas where I am not making money and making changes to address that. In addition, it has enabled me to project my income and expenditure with reasonable accuracy and allows me to budget for expenditure like advertising etc.

However, I have find that while I can determine net profit, this approach does not help with determining what will be in my bank account at the end of the year as well as my cash flow requirements. In addition, it does not help with fixed asset purchases which are on the balance sheet not on the profit and loss sheet.

I would recommend that a budgeting tool which is essentially a future projection of your profit and loss would be a good start to add to the accounting program as I have found it to be a great help. However it is admittedly limited in that it does not cover cash flow, final bank balance as well as balance sheet transaction such as fixed asset expenditure which will naturally hit your bank balance even if it theoretically does not affect profits on paper.