How to reconcile Delivery data and Invoice data in RevRec?

Scope

Example: Reconcile Delivery Data in RevRec

How to view delivery logs in RevRec?

How to handle expired units in RevRec?

How to reconcile Invoice Data in RevRec?

Solution

Delivery Data

The following steps demonstrate how to reconcile delivery data from your delivery systems to what is in RevRec. It explains how to view new units sold vs consumed units for the open accounting period. This will give the user an option to analyze the data if there are differences of any kind. The report also illustrates expired units, which were not consumed at the end of a contract and hence expired unused in the period.

Delivery Data: RevRec > Reports > Service Delivery > Service Delivery Control

Invoice Data: Reports > Control and Validation > Invoice Control

Say, for example, we are about to close the Accounting period for July 2021, before closing we need to reconcile what was delivered and what was sold in the month of July with the source center.

Below, we have the source center sheet and we have converted it into the pivot form for better understanding.

To check this we will navigate to RevRec > Reports > Service Delivery > Service Delivery Control

Then select the Accounting Period that you need to verify for our example, it's July 2021 and then we will see the report and source center data matches in RevRec.

Also, you can click on Expired Units to check the list of expired units also if you do not want the units to expire you can update the Service Delivery end date of the units on the contract.

Invoice Data

The following steps demonstrate how to reconcile invoice data from your source systems to what is in RevRec. It explains how to view new billings for the open accounting period. This will give the user an option to analyze the data if there are differences of any kind.

Solution

Navigate from Reports > Control and Validation > Invoice Control

The purpose of this report is to reconcile the data that we have in RevRec with the source at the end of the accounting period. In our example, Before we close the accounting in July 2021 we would like to reconcile the invoice data with the source center

For reference, we have created a pivot table of the source center to match the corresponding RevRec invoice control data, referred to in the screenshot below.

Related Article and Documentation

Configuring Product Catalog