Thank you to all
My grateful thanks to all that commented. I will try out all suggestions but for the meantime:
David: Thanks, I was expecting someone to suggest pivot table which of course is the obvious answer, but the person to whom I pass on the results is not comfortable with pivot tables .... No - please don't ask!!
Alan & Joyce: Thanks, I'll give it a go
Clint: Thanks - I would "preset" a table which would have ready all the combination, possibilites and permutation of Ref, Cost Centre and Name listed in col A, B & C of the results table, ready to receive the SUM £ in col D. So, in the result table, no combination data in column A, B & C would repeat in any given row. Does this make sense?
Now please don't shoot me down in flames.........
......as I have not researched this answer and merely going on dim and distant memory and practice, but MIGHT it be something along the lines of:
P&L account is prescribed in Companies Act and certain "rules" such as layout/format applies.
I&E account is not prescribed in Companies Act???....but does certainly arrive at the surplus/deficit figure using accruals concept?
I agree that receipts and payments account is something else.
I would like to know the answer as well.
Free financial forecast?
If my experience is anything to go by, you will NOT find FREE forecast models that will comprehensively and robustly intergrate all P&L, BS and cashflow forecasts. The Microsoft freeware is a simple, one dimensional P&L which you could knock up on Excel in seconds anyway.
I think you'll find the choices for such (budget end) software to boil down to Sage Forecast or web based CashFlow Wizard.
If you do find free models do let me know, but I don't think you will.
James - thank you
The industry is advertising and related production work, but you have given me a good idea of where the SAB is coming from.
You read my mind..........
My 1st request was indeed prompted by by visit to Google, saw the reams of detail, when what I really needed a potted appreciation. Perhaps one does not exist?