Happy Business Starts Here

Zuora Support
Zuora Support

How to re-distribute revenue schedule with mass updater using "Manual: Delta Amount" type?

Question: How to re-distribute revenue schedule with mass updater using "Manual: Delta Amount" type?



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Support
Zuora Support

Re: How to re-distribute revenue schedule with mass updater using "Manual: Delta Amount" t

  1. Run Trial Balance against one accounting period, taking "Oct 2019" as an example. (Click the 'run trial balance' button. (If your revenue schedule list is available, please ignore the first thress steps.)   https://knowledgecenter.zuora.com/CC_Finance/E_Accounting_Periods/D_Run_a_trial_balance )
  2. Get the corresponding Revenue schedule list from the Revenue Details report.
    https://knowledgecenter.zuora.com/CC_Finance/Revenue_Recognition/X_Accounting_Period_Revenue_Detail
  3. If Foreign Currency Conversion is not enabled, please focus on 'Revenue Schedule' and 'Recognized in this Accounting Period' column; 
    If Foreign Currency Conversion is enabled, focus on 'Revenue Schedule' and 'Recognized in this Accounting Period (Home Currency)' column. Please filter column "Customer Account Currency" and make sure the currency is the same as home currency.  (For foreign currency Revenue Schedule, need to find their corresponding amount in this accounting period separately, this is not mentioned in this topic.) 
    https://knowledgecenter.zuora.com/CC_Finance/Revenue_Recognition/X_Accounting_Period_Revenue_Detail/...

Screen Shot 2019-04-29 at 16.22.39.png

One result for your reference:

Screen Shot 2019-04-29 at 16.22.48.png

 

  1. Download Update Revenue Schedules template to help get you started. Remove the unnecessary columns and copy the non-Zero Revenue Schedule to mass updater file. Upload once it's done. For more details of Mass Updater, you can refer to the instruction in our knowledge centre: 
    https://knowledgecenter.zuora.com/CC_Finance/Mass_Updater 
    https://knowledgecenter.zuora.com/CC_Finance/Mass_Updater/Update_Revenue_Schedules 

 

Screen Shot 2019-04-29 at 16.25.32.png

 

Set "Distribution Type" as "Manual: Delta Amount". If so there's no calculation needed for column 'Open-Ended', just copy the recognized amount in this accounting period.
For example, I want to re-distribute below revenue schedule as 0 in the accounting period 19-Oct.

  • Copy the amount from Revenue details report under 'Recognized in this Accounting Period (Home Currency)' column into mass update file, Open-Ended.
  • Set the number as opposite under 19-Oct.

Screen Shot 2019-04-29 at 16.25.39.png

  1. Check the upload result and make sure the Failed Records number is 0. 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √