Integration of current GAAP and future GAAP

Knowledge Center > Zuora RevPro > System-related configuration > Integration of current GAAP and future GAAP

Integration of current GAAP and future GAAP

If you work with different versions of RevPro under different accounting principles (ASC 605 and ASC606), you can integrate your data from the current GAAP (ASC 605) to the future GAAP (ASC 606).

Integration methods

The following integration methods are supported in RevPro:

  • Process Arrangement in cGAAP and interface Arrangement to fGAAP
    With this integration method, RevPro will process transactions under the current GAAP and then load transactions to the staging tables under the future GAAP with RC ID and Arrangement ID stamped without the prefix. All transaction types except SO and Invoice Deleted transactions are moved to the staging tables under the future GAAP. Revenue comparison is possible between the current GAAP and the future GAAP.
  • Interface Transactions to cGAAP and fGAAP stage
    With this integration method, when transactions are loaded to the staging tables under the current GAAP, the same transactions are loaded to the staging tables under the future GAAP. However, the RC ID will not be stamped in the staging tables under the future GAAP.

Transaction discrepancy

In RevPro under the future GAAP, the following types of transactions will be deleted from the staging tables under the current GAAP immediately after these transactions are loaded to the staging tables under the future GAAP.

  • Credit memo created (Transaction Type = CM)
  • Credit memo cancelation (Transaction Type = CM-C)
  • Credit memo for return (Transaction Type = CM-R)
  • Credit memo for reduction order (Transaction Type = CM-RO)
  • Reduction order (Transaction Type = RORD)
  • Cost (Transaction Type = CST)

In RevPro under the current GAAP, credit memo transactions are indicated by Transaction Type being INV and Cancel Flag being Yes. This type of transactions under the current GAAP can be passed to the staging tables under the future GAAP. However, in the same record of the ARR transaction staging table, you must use the INTG_TYPE column to populate the corresponding transaction types that are supported by the future GAAP. Use the following table to map the INV transactions under the current GAAP to the transaction types that can be supported by the future GAAP.

Transaction Type under current GAAP Quantity Invoiced Cancel Flag Return Flag Transaction Type under future GAAP
INV   Y   CM-C
INV A negative value   Y CM-R
INV 0   Y CM

Configuration procedure

For RevPro to perform data integration, some configurations are required in both versions of RevPro. The configuration steps are outlined as follows:

  1. Enable data integration in current GAAP.
  2. Set up integration method in future GAAP.
  3. Define integration mapping in future GAAP.

Enable data integration in current GAAP

Complete the following steps to configure the previous version of RevPro for data integration from the current GAAP to the future GAAP:

  1. In RevPro under the current GAAP (ASC 605), navigate to Setups > Application and click the IT Admin Lookups tab.
  2. In the Lookup Type field, select COMMON SETUP from the drop-down list. The common setup is displayed.
  3. Right-click the COMMON SETUP line and then click Edit Lookup Definitions. The Edit Lookup Definitions tab is displayed.
  4. Locate the ALLOW_REVPRO3_INTEGRATION line and set its lookup value to Y.
  5. Click the save icon to save the configuration.

The integration between the current GAAP and the future GAAP is enabled.

Set up integration method in future GAAP

In the latest version of RevPro, complete the following steps:

  1. In RevPro under the future GAAP (ASC 606), navigate to Setups > Application.
  2. Click side-menu-open.png to open the side menu and click Profiles.
  3. On the Profiles page, locate the RPRO_GD_INTG_METHOD line.
  4. Hover the mouse over the line and click icon-edit.png.
  5. In the Edit Profile window, make sure that RPRO_GD_INTG_METHOD is selected in the Lookup field.
  6. In the System Level Value field, select one of the following integration methods:
    • Process Arrangement in cGAAP and interface Arrangement to fGAAP
    • Interface Transactions to cGAAP and fGAAP stage
    • Interface Transactions to fGAAP (With this option selected, transactions are loaded to staging tables under the future GAAP only.)
  7. Click icon-save.png and close the window.

The integration method to be applied is set up.

Define integration mapping in future GAAP

You must define the field mapping for data integration so that the field in the current GAAP can be mapped to the appropriate field in the future GAAP. For example, the Arrangement ID in the current GAAP should be mapped to RC ID in the future GAAP.

An integration mapping example is provided in a downloaded file for your reference. See Worksheet in integration of RevPro from current GAAP to future GAAP.xlsx. In this spreadsheet, fields in the Source Column with a prefix of INTG indicate that these fields are specific to the future GAAP.

Complete the following steps to define the field mapping for data integration between the current GAAP and the future GAAP:

  1. In RevPro under the future GAAP (ASC 606), navigate to Setups > Application.
  2. Click side-menu-open.png to open the side menu and click Integration Mapping. to define the field mapping between transactions under the current GAAP and the future GAAP.
  3. Click icon-add-green.png to add a line for a field mapping.
  4. In the Source Column cell, select the name of the field that is under the current GAAP to be mapped.
  5. In the Destination Column cell, select the name of the field that is under the future GAAP to which the source column is mapped.
  6. In the Source Table cell, select the appropriate table based on the integration method to be applied.
    Integration Method Source Table to be Selected
    Process Arrangement in cGAAP and interface Arrangement to fGAAP
    • Select RPRO_ARR_TRANSACTIONS for the fields that exist in both current GAAP and the future GAAP, for example, CV_ELIGIBLE_FLAG, which exists both in RPRO_ARR_TRANSACTIONS in the current GAAP and RPRO_LINE_STG in the future GAAP. 
    • Select RPRO_ARR_TRANSACTIONS_STG for the fields that exist in the future GAAP only, for example, AR_ACCOUNT, which is specific to the future GAAP. 
    Interface Transactions to cGAAP and fGAAP stage Select RPRO_ARR_TRANSACTIONS_STG for all fields.
  7. Add as many lines are you need.
  8. Click icon-save-green.png and close the window.

The field mapping for data integration is defined.

Last modified

Tags

Classifications

(not set)