Configuring Oracle NetSuite

Integrate your Oracle NetSuite account with Chargebee to automate the synchronization of Invoices, Customers, and other data from Chargebee to NetSuite. This data is crucial for the financial management and analysis of your business.

We recommend consulting an accounting advisor before configuring the integration. You can test the integration on the Test Site before setting up the integration on the Live Site.

Pre-implementation steps in Chargebee

Make sure the following configurations are set up in your Chargebee site before enabling this integration.

• Enable Accounting fields: Login to the Chargebee app. Click Settings > Configure Chargebee > Billing LogIQ and enable accounting fields for NetSuite. This will add the Accounting attributes in the Plans and Addons pages.
  
• Enter a General Ledger (GL) Account for each Plan/Addon in Chargebee. Navigate to Product Catalog > Plans/Addons > Select a Plan/Addon > Accounting Information. Enter the GL Account Name. You can also provide a Revenue Recognition Template ID for Plan/Addons. This ID refers to the internal ID of the Revenue Recognition rules in NetSuite.
• To differentiate the invoices sent from Chargebee (from the invoices already present in NetSuite), you can enter a prefix and sequence number for Invoices and Credit Notes in Chargebee. Navigate to Configure Chargebee > Invoices & Credit Notes > Invoices/Credit Notes and set a prefix and a sequence number of your choice.

Pre-implementation steps in NetSuite

• Authentication: Authentication is done based on Tokens created in NetSuite. You can follow the steps mentioned in this page and create the tokens. It generally takes 3-4 hrs to refresh the tokens and it is recommended to create the tokens at least one day before setting up the integration in Chargebee.

• Unlock Accounting Periods: Ensure you have the necessary periods unlocked in NetSuite. Navigate to Setup > Accounting > Manage Accounting Periods and make sure that the FY/Quarters are unlocked.

• Currencies: The currencies present in Chargebee should be present in NetSuite. You need to manually add the currencies in NetSuite. Click here for more information.

• Enable Features: Ensure you have enabled features such as SuiteCloud or Advance Revenue Management for the integration. Navigate to Setup > Company > Enable Features and enable the features as required.

• Create Rev Rec Start Date/End Date (Advanced Revenue Management (ARM) Start/ End Date):

  • If you want Chargebee to send the subscription start date and end date to NetSuite, you can create a Start Date and End Date.
  • Navigate to Customization > Lists, Records & Fields > Transaction Line Fields > create invoice level fields (Transaction Column Custom fields) to accept Start Date and End Date.
  • You can then map the custom fields with Advanced Revenue Management fields by navigating to Setup > Accounting > Revenue Field Mapping.

• Mandatory Custom Fields: If there are custom fields mandatory in NetSuite, it is recommended to make the fields optional and set a default value.

  • Custom fields at Customer, Item, or Invoice levels should be reviewed before setting up the integration. Navigate to Customization > Lists, Records & Fields > Entity Fields or Item fields and make the necessary edits.
  • If you do not prefer to make the fields optional, you can create custom fields in Chargebee and map them to the respective fields in NetSuite. Contact support for more help on mapping custom fields.

• Override Document Numbers: You can select Chargebee's document numbers in NetSuite.

  • You can enable this option in NetSuite by navigating to Setup > Company > Auto-Generated Numbers > Review the option in Entities and Document Number sub-tabs.
  • If you have checked the Allow Override option, then Chargebee's identifiers will be set as the primary ID for Invoices, Credit Memos, Customers, and so on.

• Timezone Alignment: As a preliminary step, ensure that the timezone set for the user in Netsuite matches that of the Chargebee site before establishing the integration. This alignment is crucial as Netsuite converts the UTC date format sent by Chargebee to the user's timezone, potentially leading to discrepancies in invoice dates, revenue recognition dates, and other relevant timestamps if the time zones differ.

Configuration

Follow these steps to connect NetSuite to Chargebee.

Step 1: Connect Chargebee to NetSuite

• Login to your Chargebee site.
• Connect to the NetSuite application listed on Chargebee's app marketplace by selecting Apps > Marketplace > NetSuite.
  
• Click Connect to get started with the integration.
  
• Enter the NetSuite login credentials in the pop-up connect box.
• Click Save.
  

Step 2: Setup Subsidiary

A subsidiary is a distinct legal entity or company within a hierarchical structure, representing a separate entity in a global organization, with its own data management and potentially unique tax considerations.

Choose a default Subsidiary

Choose a default subsidiary within NetSuite where Chargebee can securely post customer and invoice-related information.

Set up additional subsidiaries

Enable this option If you wish to sync accounting information from Chargebee across multiple subsidiaries in NetSuite.

A sample CSV template with the headers is displayed here.

ISO_Country_Code(2 Letters)	Country Code
Subsidiary_Internal_ID	Internal Id of the Subsidiary from NetSuite

Step 3: Check Prerequisites

Chargebee performs a list of checks in NetSuite. This prerequisite check verifies if the accounting codes, customers, and their currencies in NetSuite are available in Chargebee before proceeding with the integration.

• Customer duplicate check: If invoices from Chargebee are already available in NetSuite, customers will be present as well. In order to avoid duplicates, you must map the customer records between both systems. You can download the list of customers as a CSV file, map the customers, and upload the updated sheet using record mapping once the setup is complete.

• Currency check: The currencies present in Chargebee must be present in NetSuite. Chargebee does not compare the currencies via API. You must manually compare and add the currencies in NetSuite.

Click Proceed to move to the next step.

If you choose to ignore, click Ignore, following which the Proceed button is enabled.

Step 4: Configure Sync Rules

In this section, you need to perform account mapping for payments, invoice line items, and refunds.

Account mapping for payments

Payment transactions recorded in Chargebee can be mapped to payment accounts in NetSuite. For reconciliation purposes, you can select a clearing or undeposited funds account. If you have multiple currencies, payment gateways, or payment methods enabled, you can choose specific payments or checking accounts.

Account mapping for invoice line items

Account mapping for invoice line items involves assigning specific accounts or categories to each line item on an invoice. The following account types of Netsuite can be configured for other line items:

Other Line Items	Netsuite Account Types
One-time charges / Adhoc charges	Income, other income, deferred revenue
Discounts	Income, other income, expense, deferred revenue, other expense, long term liability, other current liability, and "As configured for Plan/Addon"
Bad debts (write-offs)	Income, other income, expense, deferred revenue, other expense, long term liability, other current liability, and "As configured for Plan/Addon"
Round offs	Income, other income, expense, deferred revenue, other expense, long term liability, and other current liability

Coupon sync

Choose how you would like to sync coupons from Chargebee to NetSuite. You can choose either of the two options listed here:

Option 1: Non-Inventory Sales Line items

Option 2: Discount

By default, coupons will be created as discounts.

Currency exchange rates

When the currency exchange rates are enabled, you can send currency exchange rates from Chargebee for transactions, invoices, or credit notes to NetSuite.

Offline payment sync

Offline Payment Sync offers flexibility for automatically syncing offline payments from Netsuite to Chargebee. You can allow sync to handle offline payments automatically or skip offline payments from sync and in that latter case, you need to manually record offline payments in Chargebee.

Payment method mapping

You have the option to map payment methods manually using the Map Manually option or let it be done automatically. If you choose Map Automatically, the sync will automatically match payment methods between Chargebee and NetSuite. If it doesn't find a relevant match, it will create a new payment method and use it automatically.

Revenue recognition rules

You can send revenue recognition information from Chargebee for Invoice line items when this Revenue Recognition Rules button is enabled.

Tracking categories

You can send tracking category information from Chargebee for Invoice line items when the Tracking Categories button is enabled.

Customer duplicate check

You can choose to identify duplicate customers in NetSuite when data is synced from Chargebee using the two options available in the Customer Duplicate Check. You can use the customer's email or ID to check for duplicates.

Step 5: Map Product Catalog

Within Chargebee, items are configured at the site level, and different accounting attributes, such as accounting code, SKU identifier, and tracking category cannot vary for each business entity. To enable distinct accounting fields for each business entity, you can enable product catalog mapping, which allows you to assign the necessary data at the business entity level according to specific requirements.

You can upload a CSV file containing mapping details of the products. Within these mappings, you can specify accounting codes for each entry and other accounting information.

Upon Clicking Get Started, You can see the below pop up where you can download the sample CSV template using this button.

The sample downloaded CSV file contains the following fields:

CSV Field Name	Description	Additional Info
PRODUCT_ID	Unique identifier for Chargebee's item prices.
PRODUCT_NAME	Name of the Item price in Chargebee's Product catalog.
SKU	SKU of the product	This field is used to map the existing items from NetSuite to the respective plan/add-on in Chargebee. It can be used as an alternative name for plan/add-on and its character limit should not exceed 30 characters.
ACC_CODE	The accounting code associated with the item	The Accounting code field should be filled for all the plans and add-ons.
ACCOUNTING_FIELD1	Class	If you have classified Dimensions for your products in NetSuite and would like to sync data specific to it, enter the information here
ACCOUNTING_FIELD2	Location	If you've classified Dimensions for your products in NetSuite and would like to sync data specific to it, enter the information here
ACCOUNTING_FIELD3	Department	If you've classified Dimensions for your products in NetSuite and would like to sync data specific to it, enter the information here
ACCOUNTING_FIELD4	Revenue Recognition Rule Id	If you've configured Rev Rec for your products in NetSuite, and would like to sync data specific to it, enter the information here

In case of any errors during validation, an error message is displayed, you can fix this by re-uploading the file with the correct mapping.

Upon successful validation, you can view the successfully mapped records as shown below.

Step 6: Configure Tax Mapping

You can choose how taxes are to be computed, and also set up tax sync from Chargebee to NetSuite if required. Enable the Sync tax information from Chargebee to NetSuite.

Retrieve the latest mapping

Retrieve latest mapping button, retrieves the latest tax codes/tax groups used for tax mapping. This will run for some time to fetch the latest tax information that can be used for default tax mapping.

Step 7: Configure Advanced Sync Rules

This is an additional non-mandatory sync rule step. You can choose to skip it by clicking Proceed.

Prefix for object IDs

This value acts as a common prefix to all object IDs syncing from Chargebee to NetSuite. When syncing objects from multiple systems (such as another Chargebee account or a CRM) to a NetSuite account, this prefix helps you identify objects from this account.

Step 8: Sync Preferences

You can choose to sync invoices from Chargebee to NetSuite from a particular date by selecting the relevant date from the drop-down.

Step 9: Run Sync

Once the configuration is complete, click Run Initial Sync to begin the sync. Chargebee will sync the first 10 invoices, to ensure that mapping, conventions, and sync criteria align with your requirements.

You need to review these invoices in NetSuite. If the sync works as expected, you can click the Run Full Sync.

On triggering Run Full Sync, the sync dashboard is displayed, where you can view or manage settings.

Enable/Disable auto sync

After setting up the integration, you can configure the daily schedule to sync all the information to NetSuite automatically. Invoices and related information are synced once every 24 hours. You can choose to disable auto-sync if required.

Sync Now

For on-demand sync, you can sync data from Chargebee to NetSuite immediately.

Manage mapping

You can edit the configurations or GL Account mapping provided during the setup process.

Manage record mapping

You can add/update the mappings for the Chargebee records (Invoices, Customers, Credit notes, and Transactions.)

Manage tax mapping

Adjust the tax mapping configured during the setup process. If new tax regions have been added in Chargebee settings, update the tax mapping in this section accordingly.

Map product catalog

Manage and update the product catalog.

Manage advanced sync rules

Allows you to modify advanced sync rules. This new value will be applicable for further sync that will run, it will not modify any existing records.

Disconnect

On disconnecting at the site level it'll disconnect all the entities. Disconnecting at the entity level will only disconnect at a specific entity level.

Abort Sync Functionality

The Abort Sync functionality in Chargebee enables you to halt ongoing sync jobs, providing greater control over your sync processes and configurations. When you click Abort Sync, the current batch of processed records will be completed. Subsequently, the sync job will stop, and the remaining batches will not be processed. Any records skipped in this sync will be included in the next sync batch.

For domains with auto-sync enabled, sync resumes 15 minutes after the abort action. This ensures that all records, including those halted by the abort action, are synchronized in the next sync cycle. You can monitor the status of sync jobs in the Recent Syncs table.

The Abort Sync functionality is useful when updating specific records between syncs or pausing the sync process to verify or modify records in Chargebee before syncing to NetSuite.

Sync Preferences

Once the sync is setup, you can see when the last sync was run, success/errors in the sync, and options to edit the configurations:

Enable/Disable Auto Sync

After setting up the integration, you can set a daily schedule to sync all the information to NetSuite automatically. Invoices and related information will be synced, once every 24 hrs. You can reach out to support for reducing the sync timing to 24 hrs and also disable auto-sync if required.

Sync Now

For on-demand sync, you can sync data from Chargebee to NetSuite immediately.

Manage Mapping You can edit the configurations/ GL Account mapping provided during the setup process.

Manage Tax Mapping

You can modify the tax code mapping provided during the setup process. If you have added tax regions in your Chargebee settings, you can update tax codes here.

Unlink In case you want to stop syncing data from Chargebee to NetSuite, you can unlink the integration. For more information, contact support.

FAQ

1. Are UTF-8 characters supported in customer email field?

No, NetSuite does not support UTF-8 encoding for the customer email field.