Many Zuora customers find that by using Zuora as a revenue subledger, there is no need to perform a detailed transaction by transaction integration with an accounting system. If you have a specific business need that requires you to perform a transactional integration, our best practice is to invest plenty of time in planning and mapping your integration before commencing development. By reviewing the steps outlined below and spending plenty of time mapping yours fields and transactions in the planning process, your integration will go smoothly.
See How do I determine if it's better to bring over line item accounting data or summary level data? for more information about what you should consider when deciding whether or not to bring over line item accounting data into your accounting system.
A transactional integration should not be taken lightly.
When thinking about a transactional integration, consider these key implementation steps:
This may require consulting services from experts in that Accounting System as there will inherently be differences in the way the invoice to cash, AR, cash management, etc. functions between Zuora and the accounting system. A key example is that Zuora will create a negative invoice and most accounting systems do not. So, when you have an invoice item adjustment, invoice adjustment, or credit balance adjustment against the negative invoice, you don't have a corresponding transaction in the accounting system and you will have to determine how you want these transactions integrated to your accounting system.
Consider the following when identifying your philosophy:
There are over 80 common use cases for Zuora and your business may not need every one of these today, but you will want to plan for future support.
Often, a third-party integration platform/ETL vendor can be leveraged because they understand the complexities and nuances of the various APIs.
Map every field for every object for every Zuora use case you want to use to the corresponding field in your accounting system. To compare, Z-Suite has over 1000 fields that are mapped between Zuora and NetSuite.
These are non-trivial steps. However, completing the previous steps can greatly reduce development time and risk.