Hi everyone
I'm not sure if this would be better in the Work, Careers forum so sorry if I've got it wrong.
Keeping on top of our cashflow at work is a bit of a nightmare. We have letters of credit, FX deals, invoice discounting and the usual receivables and payables. I've messed about with lots of different spreadsheets myself to give a weekly snapshot/report to management but none of them have been that satisfactory and if I try to give a forecast for the next couple of weeks/months, it all gets very complicated and difficult to analyse. So it ends up just for being the immediate week/month which isn't really enough.
I just wondered if someone has a spreadsheet they use themselves or can recommend a website for this or maybe even a procedure/routine they follow in producing this kind of information. I just feel as though I'm on a constant threadmill compiling this info which is not as good as it should be.
Any ideas?
Thanks
Rebecca
By the way, apart from a P&L/BS, cashflow (and say, liquidity info) are there any other reports/details that are 'standard' for management reports. I know it's a bit of a piece-of-string question.
There isn't much point in asking management here as they are not really that interested but I think if they had the info they would really start to use it. I've only ever really worked in small companies so haven't got somebody else's lead to follow