Netsuite History Loaded at Transaction Level

When converting to a new system, many Netsuite clients request loading their history at the transaction level. However, this is rarely undertaken due to the great amount of data and effort involved to exactly rebuild the historal account balances. Recently we encountered a client where this transaction detail was necessary and who was prepared to fund the cost to complete. ​In Netsuite there are approximately 10 different transaction types under which transaction history needs to be separately imported, often involving multiple linked-file imports. Preparing the source data including  links by record between bills and bill payments or invoices and receipts can be complicated, depending upon the source. We were able to recently complete this undertaking in a Quickbooks to Netsuite conversion and found the Netsuite software effectively supported the process.