Cash Flow Reports from Sage 50

 I'd like to produce a cash flow report from Sage 50. What I've done so far is to edit one of the standard bank reports, so that it includes sales receipts, bank receipts, supplier payments, bank payments and nominal journals. It shows nominal codes for bank receipts/payments and nominal journals, and the customer/supplier account for sales receipts/supplier payments. I use Excel integrated reporting to get the data into Excel and then a vlookup to put in the customer/supplier default nominal code and another vlookup to bring in the nominal account name. Lastly, I use a pivot table to give me months going across and nominal accounts down the side, so I end up with a report showing cash movements. This all seems a bit clunky to me. Does anyone have a more elegant solution to producing a report of cash flows? I do have Sage Forecasting, but that has its drawbacks too.

 

 

Comments

A little less clunky...

johndon68 | | Permalink

You could potentially use ODBC to extract all the relevant data directly into Excel which would be a bit more 'integrated' than what you have at the moment but, obviously, you'd need to create the relevant queries in MS Query to get the data...

John

Cash flow reports

jason.raikes | | Permalink

You may want to look at our product DBSage.  We provide a number of 'out of the box' reports which work in Excel  and connect to your Sage database including cash flow.  Please feel free to contact me if you would like to discuss your requirements or arrange an on-line demonstration.

Regards,

Jason Raikes

jraikes@pendragonsystems.com

www.pendragonsytems.com

Optegra Pivot

Optegra | | Permalink

Hi

Optegra pivot will do this in under 30 seconds.

Email me for a free copy to see how. jeremy@optegra-financial.co.uk

simple to use - just 2 buttons in excel to create connection and pivot table.

Thanks

Jeremy

Add comment
Log in or register to post comments