Allocation formula question
I have been asked to create an auto allocation journal that would take the average balance from the three previous periods, subtract what has been entered this period and post the difference. I am struggling to figure out how this could be accomplished either as an allocation or as a recurring journal. I would love to hear any suggestions anyone might have. As an example:
Period 1 1000
Period 2 1200
Period 3 1800
Period 4 To date 700
(1000+1200+1800)/3=1167-700=466 (amount to book)