I personally developed an extremely useful spreadsheet which projected not only cash flow and profit and loss but also confirmed the figures in a related balance sheet.
This showed figures up to to 24 months in advance as auditors require you to prove you are a 'going concern' for 12 months after signing off the accounts - not just for the succeeding year.
I have been providing these figures to the bank and to directors for the last ten years. By inputting the SAGE TB onto a spreadsheet.
As I was concerned at the fragility of this system and its reliance on my input, I convinced them to move to XERO.
I now find that I can't generate even a simple 12 month forecast in a format they would recognise.
Your old formatting system could l do that. Whilst you work out a new system could you not re-instate that format.
Marilyn Jeffcoat
supported this idea
·
I personally developed an extremely useful spreadsheet which projected not only cash flow and profit and loss but also confirmed the figures in a related balance sheet.
This showed figures up to to 24 months in advance as auditors require you to prove you are a 'going concern' for 12 months after signing off the accounts - not just for the succeeding year.
I have been providing these figures to the bank and to directors for the last ten years. By inputting the SAGE TB onto a spreadsheet.
As I was concerned at the fragility of this system and its reliance on my input, I convinced them to move to XERO.
I now find that I can't generate even a simple 12 month forecast in a format they would recognise.
Your old formatting system could l do that. Whilst you work out a new system could you not re-instate that format.