Simon
Forum Replies Created
-
Posts
-
SUMMARY OF FORECASTS FOR THE YEAR TO 31 JANUARY 2018
Feb-17 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Total
as per last email example of headings for 2018. First month is correct March onwards not.
Hi
Most of the report tabs in our forecasting file have the wrong year showing.
Year one heads the months up correctly.
Year two onwards, apart from the first month, it shows the month and year as per year one.
Cant correct as protected cell.
What is going wrong.
This is the case on most of the report tabs.Hi
Most of the report tabs in our forecasting file have the wrong year showing.
Year one heads the months up correctly.
Year two onwards, apart from the first month, it shows the month and year as per year one.
Cant correct as protected cell.
What is going wrong.
This is the case on most of the report tabs.Hi again
I think we may be talking at cross purposes.
All the tabs in the file helpfully show the financial statements by month, starting with the current month and showing the following 11…so for the profit and loss you see…..PROFIT FORECAST FOR THE 12 MONTHS TO 31 JANUARY 2017
Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 TOTALThis is great although the pre-selected 12 month period has no relevance to the company or its financial period.
The above format by month is on every tab other than the equally crucial tab of balance sheet which shows…..HALO X-RAY TECHNOLOGIES LTD
FOR THE 36 MONTH PERIOD TO 31 JANUARY 2019
BALANCE SHEETJanuary 2016 January 2017 January 2018 January 2019 January 2020 January 2021 January 2022 January 2023
£ £ £ £ £ £ £ £so it is showing balance sheets at January month end for the next 7 years.
What I want to see at a glance is the balance sheet at the end of each month in a similar way to the profit and loss and cash flow. How do I do this? Having a balance sheet at January for the next 7 years is irrelevant to the company.
I hope this is a bit clearer to what I am trying to do. I have to present to the directors monthly profit and loss, balance sheet and cash flow forecasts in the same format. I do not want to go in to the “monthly” tab create a balance sheet cut and paste and then go back and create the next one for 36 times over.
Thanks for the quick response.
The monthly tab in our file is headed 36 months balance sheets to January 2019 but shows balance sheets for the next ten years just for January. So the heading and what is shown are inconsistent. What has gone wrong with this tab?Re actuals – yes I can overtype the forecast numbers for the profit and loss. How would I do this for the balance sheet and cash flow? This is important as this would be the only way of making the file consistent with our financial years. The report pages are all locked out so cannot be changed manually.
Richard
