Reports

Knowledge Center > Zuora RevPro > Reports

Reports

You can use the Reports menu options to do the following things:

  • Manually run reports based on the predefined or customized report layouts (For instructions, see Run Reports)
  • Schedule reports to run in the background and have the report results available for download (For instructions, see Schedule Jobs)
  • Download reports that are scheduled for downloads  (For instructions, see Download Reports)

RevPro pre-summarizes data for reporting in a report summarization table. Then, based on the report summarization table, up to 50 columns can be displayed in a report for the selected report layout. 

Reports have predefined layouts, which can be copied and then customized based on your preferences. Reports default to the open accounting period. Access to reports is controlled at a role-based level in RevPro.

RevPro reports are grouped into the following categories in different tabs when you navigate to Reports > Run Reports.

Revenue

Report Name Description
Billing RollForward Report A subset of RC Rollforward Report to display the beginning and ending balances and activities for contractual revenue based on billings.
Billing Waterfall Displays revenue waterfall data for billed contractual revenue for a particular invoice (rollout at the line level of contract liability balances).
Cost Capitalized Rollforward Report Displays capitalized cost beginning balances, activities, and ending balances for all cost types for the purpose of reconciliation and disclosures.
Cost Insight Displays cost activities, cost on hold, and cost that is not posted for each transaction line in details by cost type, by period, by year or contract to date.
Disclosure – Contract Level Displays revenue activities based on type (prior liability, current liability, or contract asset) and revenue from previously satisfied POBs summarized at the net contract level.
Disclosure – Line Level Displays revenue activities based on type (prior liability, current liability, or contract asset) and revenue from previously satisfied POBs summarized at the line level.
RC Rollforward Report Displays beginning and ending balances for contract asset or contract liability accounts, and activities for the selected period. This report is used for reconciliation and disclosures.
Revenue Book Comparison Report Displays a comparison of two revenue books based on ASC 606 or IFRS rules.
Revenue Insight Displays revenue activities, revenue on hold, and revenue that is not posted for each transaction line in details by period, by quarter, by year or contract to date.
Revenue Summary Displays a revenue summary for the selected period.
Unbill RollForward Report A subset of RC Rollforward Report to display beginning and ending balances and activities for contractual revenue that is not billed yet.
Unsatisfied POB Balances Displays the remaining balances for the unsatisfied or partially satisfied POBs.
VC Insight Displays variable consideration revenue activities, VC on hold, and VC that is not posted for each transaction line in details for each VC type by period, by quarter, by year or contract to date.
VC Rollforward Report Displays variable consideration price adjustments for each VC type and the beginning and ending balances for different period activities.
Waterfall Report Displays waterfall data of the prior period, current period, and future schedules for revenue, cost,  and forecasted revenue. This report can be used for timing of revenue for unsatisfied or partially satisfied POBs. 

Transactions

Report Name Description
Billing Report Lists all billings that are associated with revenue contracts in the specified period.
Booking Report Lists all transaction order line (booking) information for revenue contracts in the specified period.
Cost Transactions Lists details of all cost transactions in the specified period.
Events Report Lists all events that are processed in the specified period.
Failed RSSP Transaction Report Displays all transactions that use residual SSP estimate but fail to meet the RSSP minimum.
POB Dependencies Displays information about the performance obligation whose release is dependent on another POB in the contract.
POB(s) Released Report Displays information about the performance obligation whose revenue is released in the specified period.
Pricing Orders Report Displays the pricing order details that increase or decrease sales order lines in the specified period.

Reduction Orders Report

Displays details about reduction orders in the specified period.
Revenue Contract Detail Report Displays details about the filtered revenue contracts including revenue allocation information.
SSP Optimizer Range Displays the SSP Optimizer range information for an SSP batch, which is generated during the SSP analysis process.
SSP Stratifications Displays the stratification information that is related to the SSP batch.
Transactions Processing Report Displays the number of transactions and revenue that is processed in the specified period.
Unreleased POB(s) Report Lists the performance obligations that have not been fully released.
VC Events Process Report Displays the processed VC events that are related to VC estimates, actuals, or actual cancelations.
VC Transactions Lists the variable consideration transactions (VC estimates or VC actuals) that are linked to revenue contracts.

Accounting

Report Name Description
Accounting Report Displays detailed information about accounting entries for the specified period.
MJE Details Report Displays detailed information about manual journal entries for the specified period.
OnHold Accounting Report Displays the transactions that are placed on hold for the specified period.
Transfer Accounting Errors Report Displays the errors that occur during the transfer accounting process and indicates which accounting entries do not pass the validation.

Foreign Exchange

Report Name Description
Period FX Waterfall Displays waterfall data that use different exchange rates for functional currency and reporting currency for the specified period.
Trial Balance Report Displays balance information for different accounts in reporting currency that is calculated based on historical rates. The reporting currency is calculated based on the period-end rates for the balance sheet account and period average rates for the income statement account.
Unbilled Fx Report Lists the transactions that have different exchange rates for the revenue recognized before billing and for the subsequent invoices to track the potential FX gain and loss.

SOX And Audit

Report Name Description
Approvals Report Lists pending or approved revenue contract approvals.
Audit Trail Report Displays the information about system configuration changes in the specified period.
Contract Modification Report Displays the transaction lines that trigger a contract modification, the contract modification rule triggered, and the allocation treatment information.
Cost Stratification Displays all cost types, stratification fields, and cost formulas that are defined in RevPro.
Cost Transaction Changes Displays the cost changes for different cost types in the specified period.
Line Stage Exception Report Lists the sales order lines that have line stage errors.
Line Staging Report Displays the records in the staging table as well as the errors that are associated with the records.
Manual POB Report Lists the performance obligations that are manually added to revenue contracts.

Manually Created Revenue Contracts

Lists the revenue contacts that are manually created.
Mass Action Batch Report Lists of mass action changes in the specified period, such as updating attributes, updating accounts, or releasing holds.
Orphan Transactions Report Lists the orphan transaction lines that are not associated with any revenue contracts.
RC Hold/Release Report Displays information about the new, pending, or released revenue contract holds.
RC Workbench TimeLine Report Lists the actions that are manually taken by users on lines, POBs, or revenue contracts in RevPro Workbench for the specified period.
Revenue Contract Move Report Displays the movement of transaction lines from the original system grouped revenue contracts to the user-defined revenue contracts or between two user-defined revenue contracts.
Role Privileges Report Lists the user roles and their access to system functions.
SSP Exception Report Lists transactions for which SSP cannot be derived.
SSP Update Report Displays the manually edited or updated SSP groups.
User Access Report Lists the user access information in RevPro.
User Assignment Report Displays information about the roles that are assigned to RevPro users.
VC Actions Displays all VC actions that are taken for different VC types in the specified period, such as VC estimates, reversals, actuals, or VC clearing.
VC Template Displays information about VC setup.
VC Transaction Changes Displays the VC changes that are associated with transactions in the specified period.

All

This tab lists all available RevPro reports that are described above.

Favorites

This tab appears after you add one or more reports to your favorites. Use this tab to quickly access the reports that you frequently need to run. 

For information about how to add a report to your favorites, see Add to Favorites.

Last modified

Tags

Classifications

(not set)