Setting up Data Sync

Introduction

Establishing a connection between your Chargebee Billing site and RevRec Premium ensures a seamless flow of transactional data for accurate revenue recognition. This document explains how to configure and customize your data sync settings, including authentication details and advanced configurations.

Enabling RevRec Premium Data Generation

Follow these steps to set up data synchronization between your Chargebee Billing site and RevRec Premium:

1. Navigate to Data Sync > Connect > Invoices > Chargebee.

2. Enter the following details:

   • Site Name: The name of your Chargebee Billing site.

   • API Key: The API key generated from your Chargebee account for secure connection.

Configuring Product Exclusions

To exclude specific products or coupons from synchronization, add the following JSON snippet under Exclude Products:

This ensures that transactions without coupons (or any specified products) are not included in the sync.

Adding Custom Fields

You can fetch custom field data from your billing site by adding the required fields in Custom Fields (in JSON format).

For example:

{ "cf_order_number": { "name": "Custom Order Number", "api_name": "cf_order_number", "type": "string" } }

This configuration ensures that custom fields—such as order numbers, product attributes, or metadata—are included during data import.

Setting the Billing Site Time Zone

Setting the time zone correctly ensures that invoice and transaction timestamps are synchronized with your accounting periods. To align your billing data with the correct local time:

• Enter the billing site’s time zone in the Time Zone input field. Example: America/New_York.

Configuring Advanced Connection Settings

Under Advanced Connection Settings, add the following JSON configuration:

{ "extension": "accounting", "tax_enabled": true, "enabled_ac_json_output": false, "batch_size": 10000, "conversion_date": "2000-01-01", "discard_zero_invoices": false, "enable_fraction_correction": true, "exclude_deleted": true, "exclude_business_entity": ["ac-none-31638902400000"] }

Parameter Overview

Configuring Advanced Settings for Multi-Business Entities

If Multi-Business Entity (MBE) is enabled in your Chargebee Billing site and you need to exclude specific entities from synchronization:

• Replace the value "ac-none-31638902400000" in the JSON configuration with the Business Entity ID(s) you want to exclude.
• For multiple entities, list them as a comma-separated array.

Example:

{ "exclude_business_entity": ["Entity_A", "Entity_B", "Entity_C"] }

This configuration allows you to precisely control which entities’ data flows into RevRec Premium.