At our company, data migration isn’t just a service we offer; it’s a challenge we eagerly embrace. With a track record of successful projects under our belt, we recently embarked on an journey with a client looking to transition from Xero to NetSuite.

Data migration comes in various forms—whether it’s the implementation of NetSuite for new customers or the integration of acquired companies’ operations into existing systems. In this particular case, our client had acquired a company that relied on Xero as its financial system. With the decision to migrate operations to NetSuite, our expertise was called upon to navigate this transition.

The task was twofold: first, to upload account balances into NetSuite as of the acquisition date, and second, to import all transaction details from the acquisition date until the client began using NetSuite. While seemingly straightforward, this project presented its fair share of challenges.

Xero’s search and reporting capabilities, though functional, are overshadowed by the robust features offered by NetSuite. Extracting transactions and establishing links between them proved to be more complex than initially anticipated. However, where there’s a challenge, there’s also an opportunity for innovation.

Our starting point was a single “Account Transactions” detail report in Xero. From there, we extracted all the necessary data for import into NetSuite, covering customers, vendors, vendor bills, payments, invoices, journal entries, and more. Recognizing the limitations of Excel formulas for this project, we turned to Python scripts in a Jupyter Notebook. These scripts processed the Xero extract, generating the CSV files required for seamless integration into NetSuite.

The Python script approach to processing transactions proved highly effective, especially considering our client’s continued to utilize Xero and the data was constantly changing. Updating the NetSuite files was straightforward: we extracted a new report from Xero and ran the Python script to generate refreshed CSV files.

Despite the success of our approach, we encountered one significant hurdle: Xero’s allowance of transactions with duplicate numbers. This posed a unique challenge in establishing transaction links, requiring some small manual intervention when multiple transactions for the same vendor on the same date shared the same number.

Nevertheless, our dedication to precision paid off. Our Python scripts were able to generate CSV files for NetSuite import with a 99% accuracy rate. Although a small number of transactions required manual processing due to limitations on the Xero side, the overall migration was deemed a success.

As with any project, minor discrepancies arose, such as differences in exchange rates and currency revaluation methods between Xero and NetSuite. However, these were deemed non-material by the client, who expressed great satisfaction with the outcome.

In conclusion, our experience with data migration—from Xero to NetSuite and beyond—underscores our capability to navigate complex challenges with precision and finesse. If you’re facing similar hurdles or have other data migration requirements, don’t hesitate to reach out. We’re here to help turn your migration vision into reality. Contact us today to schedule a consultation and let’s discuss how we can support your data migration needs.

Share this page

Let’s Connect.

Tell us about your project, and we’ll arrange a free consultation call
to discuss how we can help.