hi there! i was curious to see if anyone has ever imported historical trial balance data into netsuite of an entity that they have acquired that has a different year end date then the existing parent company in netsuite? i'm running into all sorts of issues with retained earnings not closing out correctly because netsuite is thinking retained earnings should be closed out in december, when historical data of the entity acquired has been closed out in March. they want to move the acquired entity to eventually be on the same year end for this year (2024) after consulting with tax/legal teams, but for getting historical data into the system does any one have csv import methods/recommendations for how to best get this historical data into the system while dealing with a different year end than what netsuites been operating off of?

Check out the Multiple Calendars feature. That allows you to assign different year-ends to subs and should fix your R/E roll problem. Using that, you shouldn't need to do anything differently with the imports.

Multiple calendar features as mentioned above, you might be dealing with an Indian Subsidiary I am guessing.

I would reach out to Paul at Optimal Data Consulting paul@optimaldataconsulting.com they are the masters in all types of historical data conversion :)