Effectively and Efficiently Use Zuora Revenue Reports with Journal Entries and the Close Process Dashboard

By Lana Lee posted 04-10-2024 15:02


When it comes to Zuora Revenue reporting, there is a lot of information to cover which is why we decided to devote two Table Talk sessions to this topic.

In February our first Revenue reporting session covered reporting best practices, revenue reporting and journal entries along with some examples. In this second session, we dive deeper into journal entries, diagnosing problems with reports using journal entries, and the Close Process Dashboard.

Watch full video | View presentation

Zuora Revenue Reporting Best Practices

Watch video to learn more




Reporting Summarization

Real Time Mode

No need to manually run the job ‘Reporting Summarize Current Period’. It is automated as part of every system process

Period Open & Close Summarization

(Reporting Period Close / Reporting Period Open)

Perform Close from Close Dashboard (CPD)

No manual activity. 1-click close & open next period.

Zuora Revenue will automatically submit the period close & open summarization jobs as part of Close from CPD

Next Period Summarization

(37.016 release)

Run one a week, if your period open takes > 1 hour

Reduce period open summarization time around 90%.

Applicable for high Volume customers.

Post Period Summarization

(Current Period Post Summarize Data)

Use only if applicable

Required only if you use Trial Balance Report or any other report with ‘Aggregate Flag’ enabled in the layout.

Report Layouts

Limit to 30 columns or lower

Faster running reports. 

Review and remove columns that are not required from the specific report layout.

Reporting Performance

37.016 Release

Expect 1.5 - 2x improvement on report run times with 37.016 release. The Row count has been moved to the Report Footer

3 Facts about Revenue Reporting - Watch video to learn more

Revenue Reporting Facts

  1. Any reports needed to reconcile to the General Ledger are based on accounting journal entries.  
  2. All Zuora Revenue Financial Reports are summarized view of  journal entries 
  3. Accounting Report or Journal Entries in the RC Workbench is where the journal entries live.

Journal Entries

Journal Entries - Account Type


Account Type - Watch video to learn more

Zuora Revenue allows customers to use attributes to segmentate the reporting instead of using traditional GL accounts by Account Type. Each Account Type can be related to multiple GL accounts and GL accounts number can be ingested through the transactions.  The internal system hierarchy is define as transaction level account > Account Setup defined account

Account Type setup allows the user to define which accounting type the account is related to.


Schedules Type - Watch video to learn more


Schedule Type Flag



Contractual/Booking Revenue related journal entries


SSP Allocation Revenue related journal entries

Variable Considerations

Variable Considerations or SFC related journal entries


CA/CL reclassification related journal entries


Top Side MJE or LT/ST Reclass MJE related journal entries


MJE with RC link related journal entries


COGS or Direct Cost related journal entries


Data Points -
Watch video to learn more

Other data points related to journal entries to help user to understand the relationship between the reporting columns:

Journal Entries - data points


Sample Screenshot
Watch video to learn more

Journal Entries - screenshot



Diagnosing Reporting Issues with Journal Entries

Usually, users simply tie their reports to their GL and at the end of the day, that’s what we mostly care about. But what if your balance or report doesn’t match - that’s when you need to do more investigating as to why things are not not tying together. This is where you can dive deeper into your journal entries which provide a lot of information to help you research what might have happened to your contracts and your reports.


Watch Video: Diagnosing Reporting Issues with Journal Entries

How to Effectively and Efficiently Use Zuora Revenue Reports - Journal Entries, Reporting, CPD


RC Rollforward - Revenue Reporting

RC rollforward tells you a lot of information and is the subledger of your account balances. This report is a starting point of your reconciliation as it will give you your current revenue contract view and how much revenue you have left to recognize in your contracts.This is needed for reconciliations to tie out to the GL.


RC Rollforward

Chart 1: RC Rollforward Report Column Names. Applicable for right to bill flag = N
Watch video to learn more

RC Rollforward

Chart 2: Bucket meaning with the corresponding reports.  Applicable for right to bill flag = N
Watch video to learn more


RC Rollforward

Chart 3: Accounting Entries Schedule Types. Applicable for right to bill flag = N
Watch video to learn more

Close Process Dashboard - Accounting Analysis Tab

Watch video to learn more

Close Process Dashboard


The accounting analysis tab in the Close Process Dashboard applies the same process as previously described to reconcile your revenue numbers, but it does so automatically - saving you a lot of manual effort.

The Close Process Dashboard provides reconciliation between Accounting & Revenue reports in real-time:

  • Revenue for the Period (Insight & Waterfall Reports)
  • RC Rollforward (Contract Liability)
  • Unbill Rollforward
  • Billing Rollforward

Visibility to Variance, if any caused by:

  • Accounting holds/ Errors
  • Summarization process

Related Content


Stay Up-To-Date with Zuora Releases and Maintenance

Check out the Community’s News and Notifications groups to receive emails about Zuora Maintenance and Release Notifications including deployment schedules, the release window, and issues fixed.  Follow these steps to sign up and select the frequency you’d like to receive emails - real-time, daily digest, no emails.