Zuora Community Resource Library

Best Practice Checklist: Redistributing Revenue Using Mass Updater 

06-21-2024 15:13

Strengthen your Zuora foundation with best practice checklists from the Community, Knowledge Center, and Self Service Solutions so that you can confidently use Zuora. This checklist focuses on the Redistributing Revenue Using Mass Updater.

What is Billing Revenue Recognition?

If you have Z-Billing Revenue Recognition enabled (not Zuora Revenue) this process will help you redistribute revenue before you close out your books for the year. Billing Rev Recognition will generate an Revenue schedule at the time of invoice creation.

Steps to Redistribute Revenue Using Mass Updater

GOAL: For all transactions for the affected term are updated to reflect the revenue redistribution

STEP 1: Create new revenue rules (If applicable)

Make sure you add your new Revenue Rules in your Finance Settings:

  1. Go to Finance Settings: Manage Revenue Recognition Rules
  2. Select the Recognition Model: Daily over time, Upon invoicing, etc and create new rule. 
  3. Select your Revenue Rule settings and save the rule

STEP 2: Update product catalog rate plan charges for affected charges

In your Product Catalog, make sure to update the revenue rule in the Product Catalog Rate plan charge. No amendment is needed for New and existing subscriptions for this update.

STEP 3: Cancel all posted journal runs for the affected term 

Click into Journal Runs, locate your specific Journal runs with the accounting period you are going to update and cancel the journal run.
Note: Once the Journal run is cancelled in Zuora, be sure to make the same changes in your GL.

STEP 4: Re-open accounting periods for the affected term

  1. Click into Accounting periods, locate the accounting period you are going to reopen, starting from the newest period > Click into the period > Click on the more button > Click on Re-Open this Accounting Period.
  2. Once the period is open, click into the next period to re-open until you are done reopening all periods you are updating.

STEP 5: Use Finance Mass Updater tool to redistribute revenue

  1. Under the Finance section, select Mass Updater > Under the Mass Action to perform dropdown menu, select: Update Revenue Schedules
  2. Once Revenue Schedules is selected, click on the Download Updates Revenue Schedules Template (Blue Link)
    • Mass Updater Template
    • Using Download Revenue Detail Report for Mass Updater Details
    • Update in Mass Updater
    • Check Revenue Schedules after Mass Updater


STEP 6: Close the accounting periods one at a time

  1. Run your trial balance to verify the revenue distribution updates.
  2. Close your accounting periods.
  3. Create Journal runs
    • Verify Revenue Distribution Update and Close Accounting Period
    • Create Journal Run

Statistics
0 Favorited
9 Views
0 Files
0 Shares
0 Downloads

Related Content