Docs
To enable automatic synchronization of Invoices, Customers, and other data from Chargebee to Intacct integrate your Intacct account with Chargebee for financial management and analysis.
We recommend consulting your accounting advisor before configuring the integration. You can test the integration on the Test Site before setting up the integration on the Live Site.
To set up the integration in Chargebee follow these steps:
Click Settings > Configure Chargebee > Billing LogIQ and Enable Accounting fields integration by selecting Intacct from the drop-down.
Enter a GL Account for each Plan/Addon in Chargebee. Click Product Catalog > Plans/Addons > Select a Plan/Addon > Select a Plan/Addon Price Point > Accounting Information > enter the GL Account Name. You can also provide a Revenue Recognition Template ID for Plan/Addon Price Points.
If the Plan ID/ Addon Price Point ID is greater than 30 characters, you should provide an alternative name in the Alternative Name/SKU field.
Caution!
If the Plan ID/ Addon ID is greater than 30 characters, you should provide an alternative name in the Alternative Name/SKU field.
Verify if the base currency in Chargebee and Intacct are the same. If you have multiple currencies enabled in Chargebee, then you should ensure these currencies are enabled in Intacct as well. You can view the currencies in Chargebee by navigating to Settings > Configure Chargebee > Currencies.
Follow these steps to connect Chargebee with Intacct.
Login to your Chargebee site.
Connect to the Sage Intacct application listed on Chargebee's app marketplace by selecting Apps> Marketplace> Sage Intacct.
Click Connect to integrate Chargebee with Sage Intacct.
Enter the Intacct login credentials on the Connect Chargebee to Intacct screen.
You can connect your Chargebee site with Intacct either using Chargebee's license or using your own web services developer license, as required. If you already have a developer license with Intacct, select the Use developer license option and enter the required details.
Once you have entered the credentials click Submit.
Select a default entity in Sage Intacct where Chargebee should post customer and invoice information.
Chargebee performs a list of checks in Intacct. This prerequisite check verifies if the accounting codes, customers, and their currencies in Intacct are available in Chargebee before proceeding with the integration.
Customer duplicate check: If invoices from Chargebee are already available in Intacct, customers will be present as well. To avoid duplicates, you should 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 in Chargebee. If there is no possibility of duplicates, ignore this step and proceed.
Currency check: The currencies present in Chargebee should be present in Intacct. Chargebee does not compare the currencies via API. You need to manually compare and add the currencies in Intacct.
If customer data already exists in Sage Intacct, the following error message will be displayed. In such cases, you can contact our support .
In Sage Intacct, it's possible to activate the tax solutions addon for designated regions. This addon ensures that accounts receivable invoices are generated for those regions. Additionally, within Intacct, you have the capability to establish and customize transaction definitions for both Chargebee invoices and credit notes.
Intacct's tax solution helps in generating Accounts Receivable invoices for regions using the tax solutions add-on available in Intacct. You can activate Intacct's tax solution by toggling the Tax Solutions button.
Tax Solutions setting will be displayed only if the user account has Tax Solutions access.
You can map Transaction Definitions in Intacct for Chargebee invoices and credit notes from the drop-down. Click Proceed after selecting all the required fields.
To ensure that the integration settings are common to all the connected entities you need to perform account mapping for payments, invoice line items, and refunds.
Payment transactions recorded in Chargebee can be mapped to payment accounts in Intacct. 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.
Refunds are created as vendor payments in Intacct. You can configure the following for mapping refunds:
Check number: The check number is a reference number. When there is a refund, the number you provide here is automatically incremented.
Vendor ID: Enter a vendor ID for the refund.
Refund clearing account: Select a clearing or temporary account to map refund transactions.
One-time charges: One-time or adhoc charges created in Chargebee can be mapped to a GL Account in Intacct.
Bad Debts (write-offs): You can choose where Bad Debts should be mapped in Intacct.
Discounts: Select an Account to map Discounts/Cost of Goods (COGs) in Intacct.
Round-Off: If the invoice total calculation between Chargebee and Intacct differs, Chargebee will add a round-off item automatically. You can select an account to map these round-off line items.
You need to select the invoice line items in the itemGL group only if the feature multi-entity with a different base currency is enabled.
If you have multiple Chargebee sites you can configure product line per Chargebee site.
If necessary, you can choose a Revenue Recognition template for the invoice line items.
This is a screenshot of Revenue Recognition Rule mapping when enabled.
You can configure the dimensions for invoice line items within the Dimensions Configuration.
This is a screenshot of Dimensions Configuration when enabled.
Dimensions can be configured for each currency based on a backend setting. Contact support if you need mapping at the currency level.
When excess payments are added in Chargebee, they are synced to Intacct as overpayments. When the Top Level is chosen, Intacct mandates the inclusion of the 'Overpayment Location ID' and optionally the 'Overpayment Department ID'.
Over Payment Mapping is accessible if a backend setting is enabled to be used when Intacct's multi-base currency feature is enabled. Reach out to support to enable this feature.
When offline payments are reconciled against payment due invoices in Intacct, invoices get updated as paid in Intacct. These payments can be synced back to close payment_due invoices in Chargebee. You can choose to enable this option using the toggle button.
This is a screenshot of Sync Offline Payments when enabled.
Update the accounting details for Plans and Addons price points in Chargebee. This information is necessary to set up the integration between Chargebee and Intacct. Ensure all required fields are completed.
You can upload a CSV file containing mapping details of products. Within these mappings, you can specify accounting codes for each entry.
The 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 |
|
| ACC_CODE |
Accounting code associated with the item |
|
| ACCOUNTING_FIELD1 |
Revenue Recognition |
If you've configured Revenue Recognition templates in Intacct, enter the relevant template ID here. |
| ACCOUNTING_FIELD2 |
Location |
If you've classified Dimensions for your products in Intacct and would like to sync data specific to it, enter the information here |
| ACCOUNTING_FIELD3 |
Dimension3 |
|
| ACCOUNTING_FIELD4 |
Dimension4 |
Populate the file with the required data and upload it using the option provided here.
Once you have uploaded the file click Proceed. Once the Upload is successful the following screen appears.
If you perform any validations, you will receive an error message, as shown below. This error can be fixed by re-uploading the file with the correct mapping.
Once PCM is used no longer the configurations on the item details page will be honored.
To save time, we pre-populate the CSV with the information from the UI filled out on the item prices page accounting details tab.
Even if there are no changes we need to re-upload the file for the first time.
You can add taxes as sub-totals in Intacct for accounting or ERP modules. For example, if you are remitting sales tax in New York (which is based in the US), you can create a sub-total item for each tax jurisdiction within that region.
You can map the subtotal description for regions without tax solutions as shown here.
You can select a specific date from the drop-down menu to sync invoices from Chargebee to Intacct.
We recommend that you review these invoices in Intacct. If the sync works as expected, you can click the Run Full sync.
The Intacct setup is now complete.
After setting up the integration, you can configure the daily schedule to sync all the information to Intacct automatically. Invoices and related information will be synced once every 24 hours. You can choose to disable auto-sync if required.
For on-demand sync, you can sync data from Chargebee to Intacct immediately.
You can edit the configurations or GL Account mapping provided during the setup process.
Link to record mapping document.
You can modify the tax sub-totals provided during the setup process. If you have added tax regions in your Chargebee settings, you can provide new tax sub-totals in this section.
You can enable the Tax solutions for the countries that do not have it enabled previously using Manage Preferences.
Manage and update the product catalog.
Disconnecting will unlink this integration. If you want to reconnect, you must perform all the above listed steps again.
Once the integration is setup, you can see when the last sync was run, success or errors in the sync, and options to edit the configurations:
Enable/Disable Auto Sync:
After setting up the integration, you can configure a daily schedule to sync all the information to Intacct automatically. Invoices and related information will be 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 Intacct immediately.
Manage Mapping:
You can edit the configurations or GL Account mapping provided during the setup process.
Manage Tax Mapping:
You can modify the tax sub-totals provided during the setup process. If you have added tax regions in your Chargebee settings, you can provide new tax sub-totals here.
Manage Preferences:
You can enable the Tax solutions for the countries that do not have it enabled previously.
Unlink:
In case you want to stop syncing data from Chargebee to Intacct, you can unlink the integration.
The exchange rate applied in Sage Intacct is not imported into Chargebee when the offline payment is imported.
1. We create Sales Orders for fulfillment, how does this work as part of this integration?
Sales Orders are not created as part of the integration. Sales invoices are only created when they are synced from Chargebee.
2. How does Chargebee sync data and invoices when you're using Sage Intacct's Tax Solution
Currently, Chargebee syncs all billing-related information to Sage Intacct including tax line items for US and Canada regions only. If you're using Sage Intacct's Tax solution module for the United Kingdom (UK), Australia, and South Africa regions, you can use this integration to sync your invoices and other data from Chargebee to Sage Intacct. This allows creating the AR invoice instead of sales invoice.
Contact Sage Intacct to determine if using the AR invoice in the integration will meet your requirements.
Contact support for any further details.
3. What happens if the customer has the Intacct configured with multiple entities where the base currency is different and has some entities with the tax solution enabled?
We recommend the customer to have an individual Chargebee site to select each entity.
4. What is the limitation in Intacct for syncing the Overpayment once you enable the multi-entity support with different base currency features?
To sync, the Overpayment, Invoice location, Payment location, bank account, and location currency should be the same.
