Cash Flow Reporting from Sage 200 using Microsoft Query?

Cash flow reporting in Sage 200 with MS Query

Didn't find your answer?

Hi everyone,

I really want to try and build some form of automatic cashflow forecasting / working tool using Sage 200? This will mainly be used to manage cashlow on a regular basis so I want it "live" to Sage 200 rather than constantly having to update workings manually.

Does anyone know of a way to get some useful information out of Sage 200 using Microsoft Query that can be built upon to achieve what I am attempting? Obviously if anyone has a better suggestion on how to get some detailed cashflow information out of Sage 200 that would be great.

Thanks,

Replies (3)

Please login or register to join the discussion.

Photo of MilesBW
By milesbw
14th Apr 2016 14:46

Linking Sage 200 to MS Excel

i'd recommend that you don't use Microsoft Query, but rather link Excel direct to the Sage 200 database. You can then use Excel's tools to create a whole gamut of reports including cash flow reports.

Hope this helps

Thanks (0)
avatar
By emma_h
19th Apr 2016 10:05

Just did it

I just started for a new company and have developed an automated cashflow from the Sage database. 

My information tabs are current creditors, one for each of our projects (3) and one for general, open purchase orders, supplier payment terms for lookup. All consolidated into a cashflow tab for the forthcoming 18 months.

Have also pulled in daily cash balances in 3 currencies and fx rates from OANDA.

Thanks (0)
Replying to emma_h:
avatar
By h2dgy
18th Jun 2019 18:51

Have you got this template to sample?

Thanks (0)