We have a lump sum of money coming in 4 different currencies, but the lump sums are paid in advance for 12 month of service, so we need to see how much revenue should be recognized per month. Is there any way to just put in the lump sums and have it automatically update and breakdown every time?
I have an example of the manual process i had.
Accrual Cashflow.xlsx
Thanks for the help.
Bookmarks