I would like to get some suggestions or perhaps some advice with the following scenario that we are facing.
Currently for our reporting on Turnover and our calculations of rebate, we include surcharges. Going forward July onward we will be changing this so that turnover and rebate calculations will not include surcharges.
Do you have any advice on this situation, we need to find a way to report the correct figures (inc surcharges) when viewing data prior to July 2017 but also view the correct figures (excluding surcharges) when reporting on dates post July 2017 we also need to calculate correctly when viewing financial data that falls between pre and post July (e.g Jan 2017 - December 2017)
Any Help Appreciated