Tax handling in the Chargebee-NetSuite Integration
- Praveena Manohar (Deactivated)
This document explains the tax configuration of the Chargebee-NetSuite integration and helps understand the tax sync workflow for the integration to work as expected.
Tax Sync Workflow
In Chargebee, taxes are applied whenever an invoice is generated for either a subscription, renewal, or a one-time charge. If a tax is applicable for the customer, then Chargebee checks for the customer’s region to map taxes as per the location. If a tax not applicable, then the invoices are created without any tax details. The following flowchart displays the flow of tax sync workflow between Chargebee and NetSuite and helps understand how the taxes are mapped based on different regions.
If the customer’s Chargebee account is integrated with Avalara for tax calculation in the NetSuite connector, then we support tax sync only for the United States (US) region. For other regions, it is recommended to use the Chargebee’s Tax module.
Configure Taxes in Chargebee
Follow the steps below to configure tax and manage tax mapping in Chargebee:
While configuring the integration, under Manage Tax Mapping, you can enable the tax configuration to send the tax information from Chargebee to NetSuite. If you do not Enable this option, taxes will not be synced from Chargebee to NetSuite.
For the United States (US) region, the tax codes and tax rates are passed to each line item and tax codes are created in NetSuite.
A tax agency should be created (according to NetSuite’s guidelines) for creating tax codes in NetSuite.
3. For other regions, Chargebee-NetSuite tax mapping has to be done manually. The read-only tax codes are derived from the tax configuration in Chargebee and the options to list the tax codes are configured in NetSuite. The tax rates between Chargebee and NetSuite tax codes are mapped when invoices are synced for other countries.
Default tax mapping
If tax mapping is not available for a specific country, then Chargebee will look for the default tax code mapping and send them as part of each line item.
Configure Taxes in NetSuite
For the US region, the NetSuite connector creates and maps the tax codes to each line item.
The tax codes are created under United States Nexus.
The tax codes and tax groups are created in NetSuite through this integration.
If a tax code and tax group are available already, then the existing data is used. Otherwise, a new tax code or tax group is created.
To create the tax codes in NetSuite, do the following:
1. Create a Tax Control Account and Tax Type:
To create a Tax Control Account and Tax type in NetSuite, do the following:
Tax Control Accounts are GL Accounts for Taxes. Create a Tax Control Account in NetSuite under Accounting > Tax Control Account > New.
Create a Tax Type in NetSuite under Accounting > Tax Type > New.
2. Create a Vendor (Tax Agency):
To create Tax Agency in NetSuite, do the following:
Navigate to List > Relationship > Vendor in your NetSuite account.
Before creating a Tax Code, a Vendor with the “Tax Agency” category should be created in Chargebee. See the screenshot below for example:
The naming format of the Vendor: <TAX JURISDICTION (Max Length 12)>_<TAX_JURISDICTION_TYPE>_Tax.
For the example shown above, <TAX JURISDICTION> = CALIFORNIA and <TAX_JURISDICTION_TYPE> = STATE followed by “_Tax”.
Associate a tax account to a Vendor by setting it up under the Financial module of your NetSuite account.
3. Create Tax Codes
To create a Tax Code in NetSuite, navigate to Accounting > Tax Codes in your NetSuite account.
The naming format for Tax Codes will be as shown below:
CB_<TAX JURISDICTION>_<TAX JURISDICTION TYPE>@<RATE>
For the US region, Chargebee creates the tax codes. The following fields are passed by default:
Tax Name or ItemId
Rate
Tax Type
A subsidiary with the “include children” checkbox enabled
Tax Agency
Chargebee does not send a Tax Control Account. NetSuite assigns it by default.
4. Create a Tax Group
A Tax Group is used to combine multiple Tax Codes.
To create a Tax Group in NetSuite,
Navigate to Accounting > Tax Group in your NetSuite account.
Chargebee creates the Tax Group in NetSuite for the US regions.
The naming format for Tax Group: CB_US_<STATE>@<RATE>
Chargebee sends the following fields:
Tax Name or ItemId
Rate (Sum of the rate from tax codes)
Subsidiary including children is checked
List of individual tax codes that make a Tax Group
The tax group is passed into the invoice line item of the “Tax Code“ column:
For other countries, follow the steps below as part of the tax configuration:
Create Nexus for each country.
Create Tax Codes with the following details:
Tax Rate
Tax Agency
Tax Type
Available on (Both, Sales Transaction, or Purchase Transaction)
Subsidiary