Annual cash flow/ p&l report by month

[boatbabe]

Hi there, what a great forum, I always learn loads when I stop off here

I am running Line 50 V 12 on XP and had a question I haven't seen before that I thought you may be able to help with.

I am preparing an actual cash flow by month for 2007 (Jan to Dec) in Excel by going into the individual nominals, clicking Record, and then transferring the monthly figures manually into my Excel cash flow s/sheet, Jan into the Jan column, Feb into the Feb column etc. This is fairly time consuming as certain rows on the s/sheet are made up of up to 15 or so nominals. However as I have a COA set up with the nominals grouped as they need to be for my cash flow, it struck me that Sage might have a report for this already.

If anyone knows if they do and where to find it I would be most grateful for the info.

Many thanks
Nina
www.cpbs.co.uk

[boatbabe]

OK so I've realised my stupid mistake and have now run the P&L by month, and printed off 12 copies, which has saved me some time, but I would still love to know if Sage actually produces a report that shows all months together, or if I can create one, if anyone knows.
Thanks

[brucedenney]

Depends on what version you are on.

The way I would do it, (which works for all versions) is to use an ODBC link to "suck" the balances for each month out of the nominal ledger records.

Here is near perfect example of linking sage 50 to Excel just add in all the monthly balances.