Netting process

Required system configuration

The netting process requires the following setups in Zuora Revenue:

• Setups > Application > Profiles

  • The ALLOW_NETTING_PROCESS profile is set to Yes to enable the netting process.

  • The NETTING_PROCESS_LEVEL profile is specified to determine whether the netting process is done at the application level or transaction line level.

  • The NETTING_ON_NEGATIVE_RC profile determines whether to create netting entries for the revenue contract that has all negative lines. 

  • The NETTING_RC_MJE profile specifies whether to include MJE lines in the revenue contract for CA/CL netting.

• Setups > Application > Revenue Books

  • If the netting process is to be done at the application level, the Contract Asset and Contract Liability accounts must be assigned to the revenue book for each company code. To do this, hover over the target book and click the Assign Accounts icon .

    

• Setups > Application > Accounting Setup > Account Type

  • The Include In Netting switch is toggled to Yes for each account that will participate in the netting process.

• Setups > Security > Roles

  • The role of the user who will start the netting process has full access to the Netting Process sub-menu in the role privilege settings.

Procedure

Complete the following steps to start the netting process in the UI:

1. Navigate to Reports > Schedule Jobs.
2. Click  . The Schedule Job/Job Groups window is displayed.

3. In the Schedule Program tab, select RevPro3.0 Netting Process as the program name and specify other fields as necessary.

4. Click the Program Parameters tab to specify the required parameters.

5. To start the job, click Submit Job.

6. (Application level only) If netting is enabled at the application level, after the Rev3.0 Netting Process program is complete, navigate to Accounting > Netting Process and then click Perform Netting.

Processing logic

For the current open period, Zuora Revenue determines whether the revenue contract is in CL or CA position for the account types with netting enabled based on the following rules:

• If the recognized revenue amount is more than the invoice amount (Cr - Dr < 0), the revenue contract is in CA position.

• If the recognized revenue amount is less than the invoice amount (Cr - Dr > 0), the revenue contract is in CL position.

Netting currency

When there is more than one transaction currency in the revenue contract, the Lowest Common Currency is identified for all related account types and used for the netting process. The exchange rate of each line is used to identify the value in the lowest common currency, which can be one of the following:

• Transaction currency

• Functional currency

• Reporting currency

Netting at transaction line level

When netting is done at the transaction line level and the revenue contract is in CA position, different actions are taken on each transaction line, depending on the net CL amount (Cr - Dr) of the line:

• If Cr - Dr = 0, no accounting entry is created for the line.

• If Cr - Dr > 0, the CA account gets credited and the balance sheet account type is Debit.

• If Cr - Dr < 0, the CA account gets debited and the balance sheet account type is Credit.

For example, there is one revenue contract 121 in the system.

After the netting process is run at the transaction line level, the accounting entries are created as follows:

Netting at application level

When netting is done at the application line, the top-sided journal entries are created for the CA amount.

For example, there is only one revenue contract 121 in the system.

Zuora Revenue will book the following MJE:

After MJE is approved, the following schedules are created.