Forum Discussion
Spread amount based on THREE dates
Any help here will be greatly appreciated. I have a list of invoices with a posting date, from date and a to date, as well as the total amount. No Posting Date From To Total Desired ...
Hi arij66,
Can you please elaborate on how you are calculating the Desired result column, not really sure what you mean by:
- Invoice posted in September 18, but with a historic from date (invoice 4 above). In this case, all historic portion of the invoice should be absorbed on the day of the invoice, with the remainder of the amount apportioned to future dates at a standard daily rate
Can you show what are you making the divisions and multiplications in order to get the 300 on row 4?
Regards,
MFelix
- Hi ,
In some rare cases what can happen is a customer is invoiced late, so a customer was should was to be invoiced on 1st July 2018, was instead invoiced in September. If that happens the accounting policy is that the historic period of the invoice should be recognised straight away, in this case in September.
So in this instance the invoice is for 1200 for the period of 1st July 18 to 1st July 19. Therefore revenue of 100 would be allocated to each month from July to June next year. The invoice was issued late so the revenue of 100 from July 18, and 100 from Aug 18 would be recognised together along with September's proportion.
Hope this makes sense. What I should also add is that I am applying the days360 rule when apportioning the invoices to avoid fluctuations in apportionment due varying number of days between different months.
Many thanks
