Cashflow feeding from Sage

[SailingSara]

Hi all, I'm new here. I wonder if you can help me please

Does anyone know of any cashflow software that would feed from Sage. At present we use a very complex spreadsheet. We have deferred income and use forecasting. Everything is entered manually which leads to human error sometimes
We would like to find a product that links with Sage 50 Accounts and brings in the figures we need and is not over-complicated for us to be able to add additional forecast figures.

Is there anything out there? Or does Sage sell a Cashflow module?
Many thanks in advance

[brucedenney]

Hi

It sounds to me like the problem is that you are not reading the data into your spreadsheet directly from Sage.

The re-keying will lead to errors.

There are cash flow forecasting software, but they use generic models and it sounds like you have a pretty good model, you just have an issue getting the data into it.

You can use odbc to extract the data from sage and put it into your spreadsheet and link all your forecasts to that data.

If you prefer you could hire someone like myself to convert your existing sheet so it extracts the data from sage.

I would need to look at it first but i would expect it to be sub £100 cost to do.

[SailingSara]

Thanks Bruce. We are going to do some more work on our cash flow spreadsheet then may come back to you for this.

[brucedenney]

The issue with the Sage system is that it pretty inflexible and is short term.

If you need a cash flow projection that reflects the changes you plan to make in your business, then using a tool like Excel is far more flexible.

The only issue is that spreadsheets tend to attract errors, so you want to build in some controls, to make sure everything is covered.