Oracle NetSuite integration
Unify your subscription billing with financial management by integrating Recurly with Oracle NetSuite.
Overview
Required plan
This feature is only available to customers on the Elite subscription plan. To request to upgrade to this plan, please reach out to your Recurly account manager or [email protected] for more details.
Prerequisites
- Integration supports Oracle NetSuite OneWorld or Oracle NetSuite Standard accounts
- Must have Credit Invoices and Only Bill What Changed configured in your Recurly site.
- Unique codes for each plan, add-on, or item in Recurly.
- An unused API key in Recurly for the integration setup.
- An Oracle NetSuite Sandbox account for User Acceptance Testing.
Limitations
- The integration is a one-way synchronization from Recurly to Oracle NetSuite.
- Custom fields in Recurly need to be agreed upon for mapping in Oracle NetSuite.
- Hierarchical structures, if present in Recurly accounts, need to be retained during data mapping.
Definition
Oracle NetSuite Integration with Recurly offers businesses a streamlined approach to synchronize their subscription billing data from Recurly with the comprehensive financial and accounting data in Oracle NetSuite. This integration ensures that recurring revenue data is accurately reflected, managed, and reported within a leading cloud-based business software environment.
Key benefits
- Unified data management: Centralize subscription billing and financial data in one integrated platform for streamlined operations.
- Enhanced financial reporting: Utilize Oracle NetSuite's GAAP-compliant revenue recognition and standard financial reporting tailored for subscription-based businesses.
- Automated synchronization: Minimize manual efforts with hourly automatic data transfers from Recurly to Oracle NetSuite, ensuring timely data updates.
- Accurate revenue management: Maintain accurate and up-to-date recurring revenue data in Oracle NetSuite for reliable financial tracking.
- Custom data mapping: Adapt the integration to your specific needs by mapping custom fields and unique item codes for a tailored data management experience.
Key details
Recurly's integration with Oracle NetSuite is designed to provide businesses with a robust solution for managing their subscription billing and financial data in harmony. By leveraging this integration, businesses can ensure that their financial reporting adheres to compliance guidelines while also gaining insights from customer-centric data.
To optimize your subscription business and get the most out of your customer data and other metrics, you need strong financial reporting that adheres to compliance guidelines. Financial reporting for subscription based-businesses presents unique requirements as these metrics have an emphasis on customer-centric data such as customer renewal rates, churn and lifetime value.
The Recurly for Oracle NetSuite implementation captures your customer-centric data and retains it in your Recurly plan until it is successfully transferred into your Oracle NetSuite environment where you can effectively manage the revenue.
Using this integration, Recurly can seamlessly integrate your Recurly billing and subscription data to your accounting and financial data within Oracle NetSuite, a leading cloud-based business software for accounting and Enterprise Resource Planning (ERP). Through this integration, you can effectively and accurately manage recurring revenue data using Oracle NetSuite’s automatic, Generally Accepted Accounting Principles (GAAP)-compliant revenue recognition and standard financial reporting.
The integration process is divided into five stages, ensuring a comprehensive and thorough approach to onboarding. Each stage involves close collaboration between the merchant and Recurly to ensure a seamless integration experience.
Rules of integration
The integration follows specific rules to ensure data integrity and compliance:
- It offers a one-way synchronization, moving transaction details from Recurly to Oracle NetSuite.
- The integration adheres to Generally Accepted Accounting Principles (GAAP).
- Data mapping ensures that items in Recurly correspond to the appropriate records in Oracle NetSuite, retaining any hierarchical structures.
Data mapping and synchronization
Data mapping is a crucial part of the integration process. It ensures that data from Recurly can be accurately transferred to Oracle NetSuite. This mapping involves items, customer accounts, invoices, transactions, credits, and any custom fields. The goal is to ensure that the data structures in both platforms align perfectly.
Timeframes for integration
The onboarding process is detailed and can take between six to eight weeks, depending on the project's complexity. Once onboarding is complete, the synchronization process runs hourly, ensuring that the most recent data is always available in Oracle NetSuite.
Onboarding process
The onboarding process is divided into five stages:
- Preparation: This involves initial discussions, data mapping, creating a joint project timeline and other preparatory tasks.
- Implementation: Here, the actual integration setup takes place, with Recurly assisting in the Oracle NetSuite environment setup.
- User acceptance: Merchants test the integration in their Oracle NetSuite sandbox, ensuring everything works as expected.
- Production: After successful testing, the integration is moved to the production environment.
- Project completion: Final steps include deploying the integration to the merchant's Oracle NetSuite production environment and backfilling data.
Troubleshooting
Should any issues arise post-implementation, merchants can contact Recurly Support for issues related to synchronization, data mismatches, or other integration-specific problems. For issues related to the Oracle NetSuite sandbox or other Oracle NetSuite-specific problems, contacting Oracle NetSuite directly is recommended.
Oracle NetSuite integration with Recurly
Step 1: Preparation
- Kick-off Meeting: Initiate a kick-off meeting between Recurly and the merchant to discuss the Oracle NetSuite integration project's objectives and expectations.
- Oracle NetSuite Sandbox Setup: Prepare the Oracle NetSuite Sandbox environment for the integration process.
- Provide Access: Grant Recurly access to the Oracle NetSuite Sandbox to facilitate the integration setup.
- Data Mapping Session: Collaborate with Recurly's Enablement Manager and a Solution Engineer to map data between Recurly and Oracle NetSuite, ensuring alignment and considering any custom fields.
- Finalize Data Mapping: Complete the data mapping process, ensuring all fields and structures are correctly aligned.
Step 2: Implementation
- API Key Creation: Create and provide Recurly with an API key specific to the integration.
- Integration Setup: With Recurly's assistance, set up the integration within the Oracle NetSuite Sandbox environment.
- YAML File Creation: Recurly will build a YAML file based on the values specified during the data mapping session. This file will be used to create the configuration file.
- External ID Exercise: Collaborate with Recurly to conduct an External ID exercise to minimize the risk of duplicating records in Oracle NetSuite.
- Initial QA Audit: Recurly will conduct a Quality Assurance audit of the data transferred to the Oracle NetSuite sandbox to ensure accuracy.
- Integration Sync Activation: Turn the auto-sync on. Data will begin to flow into the merchant's NetSuite sandbox account.
- Prepare for UAT: As a merchant, prepare for the User Acceptance Testing (UAT) phase.
Step 3: User Acceptance
- UAT Execution: Perform end-to-end User Acceptance Testing in the Oracle NetSuite sandbox to ensure the integration works seamlessly.
- Issue Resolution: Collaborate with Recurly to address and resolve any issues identified during UAT.
- UAT Sign-off: Once satisfied with the UAT results, approve and sign off on the integration.
Step 4: Production
- YAML File Check: Recurly will compare the sandbox YAML File version against the PROD version.
- YAML File Approval: Approve the YAML file to ensure it aligns with the production requirements.
- Lock YAML File: Recurly will lock the YAML file to prevent further changes.
- Cutover Plan: Discuss cutover plan with Recurly
- Integration Record: Create Integration Record in Merchant's NetSuite Production Instance
- Integration Deployment: Recurly will deploy the finalized integration to the merchant's Oracle NetSuite PROD environment.
- Data Backfill: Recurly will backfill the merchant's current data to the integration start date, ensuring all historical data is captured.
Step 5: Project Completion
- Post Go Live Support: Recurly’s professional services team provides support through the merchant's month end.
- Transition to Recurly Support: Transition to Recurly's Support for ongoing support of the integration.
By following these step-by-step processes, merchants can ensure a smooth and efficient integration of Recurly with Oracle NetSuite, enabling them to manage their subscription billing and financial data seamlessly.
FAQs
Q: How does the sync process work? Please go into detail.
A: The integration follows a structured 3-step approach: Accounts, Plans, & Transactions.
Initially, we synchronize the Accounts to ensure that your customer data is prepared and ready for the upcoming transactions.
Subsequently, we sync the plans. This step is crucial as it inserts the necessary details into the relevant transactions. Moreover, it's within these records that we persist the essential revenue recognition data.
Lastly, we synchronize the transactions to ensure that your financial data aligns accurately with your billing system.
For a deeper dive or more specific queries, please contact your CSM/AM to obtain our data sheet.
Q: What is the cadence of the syncs?
A: The synchronization is scheduled to occur every 20 minutes. For a more comprehensive understanding or specific details, please reach out to [email protected].
Q: Do you sync over parent accounts as customers as well?
A: Yes, we certainly do.
Q: Can we use serialized inventory items as the destination for plans/items?
A: Currently, we do not support serialized inventory items for this purpose. We only cater to non-inventory items.
Q: How do we manage external ids among customers, plans & transactions?
A: We offer multiple strategies to manage your external id for customers. One method is leveraging our out-of-the-box account id. Alternatively, you can create a unique account code or insert a new id value into our custom fields. However, a limitation with this approach is that ensuring uniqueness and preventing collisions becomes the merchant's responsibility. This method is also not suitable for parent-child account setups.
For plans and items, you can make use of the out-of-the-box ids (like plan id or item id). Another option is to use the plan code or item code, but this requires the merchant to ensure the uniqueness of these values. For add-ons, it's mandatory to use a distinct add-on code.
For transactions, we consistently use the associated id for that specific record (for instance, the invoice id for invoices) to insert the value into NetSuite's external id field.
Updated 7 months ago