Configuring Sage Intacct 

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.

Setup the Integration in Chargebee 

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!

  • When you add new plans, addons, and price points in Chargebee anytime after the integration is set up, do not forget to enter the GL Account Name and SKU fields.
  • If you make any changes to the GL Account Name in your Intacct account anytime after the integration is set up, you need to update them in Chargebee as well. Failing to do so could lead to a sync error.
  • 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.

Setup the Integration in Intacct 

  • You require Full Admin access to Sage Intacct, with user role permissions to set up the integration.
  • Chargebee is listed in Intacct's Marketplace. You can integrate your Chargebee site with Intacct using Chargebee's license, or you can also choose to integrate using your own web services developer license. Subscribe to Web Services by following these steps:
    • Once you have logged in to your Intacct account, click Company > Subscriptions.
    • Find Web Services and click to Subscribe.
  • Add your company's Sender ID (this is the Sender ID assigned to you by Sage Intacct) to the allowed list by following these steps:
    • Click Company > Company Info > Edit.
    • Navigate to the Security tab > Web Services Authorizations section and add the Sender ID.

Configuration 

1. Connect 

Once you have logged in to your Chargebee site, follow these steps to initiate integration:

  1. Click Apps > Go to Marketplace > Accounting > Sage Intacct.
  2. Click Connect and enter the login credentials. 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.

2. Set up Sync rules for Entity 

Select an entity and the account type in Intacct to which the invoices should be synced to.

  • Choose an Entity - these are Entities or Organizations in your Intacct account.
  • Account type is selected as Item GL Group by default.

    Note: Tax Solutions block is visible only if the customer has the View enabled in the Tax Solutions configuration in Intacct.

Note
  • If You choose the top-level entity and have different base currencies for each entity in Intaact then reach out to [email protected] to enable Multi-entity support with different base currencies.
  • Intacct multiple base currency support is only available for Sales Invoice workflow and not for Tax solution (AR Invoice workflow) enabled accounts.

3. Verify Accounting Information 

Chargebee checks whether your plans/addons have valid GL information. If a plan/addon doesn't have the GL information, the error details will get listed. You can download the CSV file, update the details and upload the file back into Chargebee.

Caution!
If you make any changes to the GL Account Name in your Intacct account anytime after the integration is set up, you need to update them in Chargebee as well. Failing to do so could lead to a sync error.

4. Check Prerequisites 

Next, Chargebee performs a list of checks in Intacct:

  • Customer duplicate check: If invoices from Chargebee are already available in Intacct, customers will be present as well. In order to avoid duplicates, you should map the customer records between both the 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 and proceed.
  • Currency check: The currencies present in Chargebee should be present in Intacct. You should manually compare and add the currencies in Intacct. Chargebee can not compare the currencies via API.
  • Inter-Entity Mapping: You need to configure Inter-Entity Account Mapping only if the customer enabled the Multi-entity with different base currencies.
    • Select Company → Setup → Inter-Entity Account Mapping

5. Configure Sync Rules 

Configure how Chargebee integrates with Intacct:

Transaction Definition

a. Payment Account Mapping: 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 or payment gateways or payment methods enabled, you can choose a specific payments or checking account.

b. Refund Mapping: Refunds are created as Vendor payments in Intacct. You can configure the following for mapping refunds:

  • Check Number: Check number is a reference number. When there is a refund, auto-increment occurs from the number you provide here.
  • Vendor ID: Enter a vendor ID for the refund.
  • Refund Clearing Account: Select a clearing or temporary account to map refund transactions.
  • Refund Tax Detail Id:All refunds issued will be mapped to the selected Tax detail ID. This is only applicable with Tax Solution enabled.

c. Account Mapping for Invoice Line Items:

  • One time charges: One time or Adhoc charges created in Chargebee can be mapped to a GL Account in Intacct.

  • Setup fee: If you have configured a setup fee for plans in Chargebee, the setup fee line items can be mapped to a specific GL Account in Intacct.

  • Discounts: Select an Account to map Discounts/Cost of Goods (COGs) in Intacct.

  • Bad debts (write-offs): You can choose where Bad Debts should be mapped in Intacct.

  • Round offs: If there is a difference in the invoice total calculation between Chargebee and Intacct, then Chargebee will add a round off item automatically, you can select an Account to map these round off line items.

  • The customer selects the invoice line items in the itemGL group only if the feature, Multi-entity with different base currencies is enabled.

d. Product Line: If you have multiple Chargebee sites you can provide a Product Line per Chargebee site. This is an optional step.

e. Revenue Recognition Mapping:
If Tax solution is enabled then the merchant should ensure that the Revenue Recognition is enabled at the AR Invoice.
Follow these steps to enable AR Invoice:

  • Company > Admin > Subscriptions > Revenue Management.
  • Configure > Select Standard Revenue Recognition.

If you are using Intacct's revenue recognition module, follow these steps to send the invoice line amount, start date, and end date when an invoice is synced from Chargebee to Intacct:

  • Enable Revenue Recognition Rule Mapping. You can also choose to mandate the revenue recognition template ID as part of the sync. This will ensure that the revenue recognition information is captured for every invoice that is synced from Chargebee.
  • Enter the revenue recognition template ID for One time charges, Setup fee, Discounts, Bad debts and Round off.
  • Navigate to the respective Plans/Addon Price Points and specify the revenue recognition template ID in the Accounting Information section.

If you are not using Intacct's revenue recognition module, you can skip this step during configuration. Learn more about how you can use Chargebee's reports for revenue recognition.

f. Sync Offline Payments:
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.

g. Dimension Configuration:
The customer defines the Dimension Configuration for each currency. The following are invoice line items within the Dimensions Configuration:

  • Location
  • One Time Charges
  • Setup Fee
  • Round Off
  • Refund
    Location is a mandatory field in the dimension configuration if the Multi-entity support with different base currencies feature is enabled.

Note: Defining Dimension 2 and Dimension 3 is optional.

h.Overpayment Mapping:

  • This configuration is enabled only when Multi-entity support with different base currencies feature is available for the customer.
  • To sync Overpayment mapping for each currency :
    • It is mandatory to configure the Location
    • It is optional to configure the Department

6. Configure Tax Mapping 

You can add taxes as sub-totals in Sage 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.

  • For Sales invoice the Subtotal description is mapped for countries that have Tax solutions disabled.
  • Tax details from Chargebee as will be mapped as AR invoices with taxes for countries that have Tax solutions enabled.

Tax Mapping for Canada 

Tax mapping is enabled for individual tax components in Canada.

It has the following tax components enabled:

  • The default country-level mapping is considered if there is no tax mapping provided at the province level or GST. Then the tax amount will be synced to the provided Subtotal description.

  • Enable the province level to map the GST and province level tax to different sub-total descriptions.

Note

The Intacct integration supports syncing the tax information if you have Avalara integration with Chargebee for the US & Canada region.

Note

  • Only US and Canada states/provinces can be configured for tax mapping.You can also enable the state or country-level tax mapping and enter state-level or country-level taxes as sub-totals.
  • If you're using Intacct's Tax solution module, read the FAQ on tax configuration support in other regions.
  • For the US and Canada, we support Avalara integration.

7. Select Sync Start Date 

Select a date from which invoices generated in Chargebee should be synced to Intacct.

You can choose from one of the following:

  • Sync all invoices
  • Sync invoices from a specific date

Invoices and related records, from the specified date will only be synced.

Caution!

  • If there are Invoices and related records in Chargebee that are created before the date you specify, they will not be synced and you could see a sync error. You can update the respective invoices manually in Intacct or contact us to ignore these invoices in subsequent sync.
  • If there are updates to invoices, or credit notes are created for those invoices created before the specified date, you should update those records in Intacct manually.

8. Run Initial Sync 

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

We recommend that you review these invoices in Intacct. If the sync works as expected, you can click the Sync All Records option and proceed.

Intacct setup is now complete.

Caution!

If you make any changes to settings like GL Account, Currency or Taxes in your Intacct account anytime after the integration is set up, you need to update them in Chargebee as well. Failing to do so could lead to a sync error.

Sync Preferences 

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 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.

Offline Payment Sync (Sage Intacct to Chargebee) 

  1. Chargebee syncs the invoices to Sage Intacct (all statuses including PAYMENT DUE invoices).
  2. When you pay offline payments against payment due invoices in Sage Intacct, the invoice is marked as Paid.
  3. In order to update the due invoice in Chargebee, you would have to manually record a payment against the payment due invoice in Chargebee. But with the Sync Offline Payments option enabled, Chargebee will read the AR payments in Sage Intacct and mark the invoice as PAID, so you need not record a payment in Chargebee manually.
Note

The exchange rate applied in Sage Intacct is not imported into Chargebee when the offline payment is imported.

FAQ 

1. We create Sales Orders for fulfilment, 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 Chargebee 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. 

Was this article helpful?
Loading…