> For the complete documentation index, see [llms.txt](https://netsuite-data-migration-guide.fowlersconsulting.co.uk/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://netsuite-data-migration-guide.fowlersconsulting.co.uk/best-practices/handling-historical-data-in-netsuite-migrations.md).

# Handling Historical Data in NetSuite Migrations

## Handling Historical Data in NetSuite Migrations

#### **Avoid Loading Full Historical Data (If Possible)**

In my 20 years of experience with data migrations, I have yet to see a scenario where the cost and effort required to load **full historical data** outweigh the benefits. While it's technically possible, especially when migrating from simple systems like Xero or QuickBooks, the cost and complexity usually outweigh the advantages.

***

### **Recommended Approaches for Loading Historical Data**

If you need to load historical data, here are three efficient options to consider:

***

#### **1. Load the Balance Sheet Only**

The simplest approach. This is ideal when a company has acquired another business and needs to bring over its **assets** and **liabilities**.

**Use Case:**

* Reflect the **balance sheet** at a specific date, such as an acquisition.

***

#### **2. Load P\&L Year-to-Date**

Load the **Profit & Loss (P\&L)** data for the current financial year up to today. You can also include **departments** for detailed reporting.

**Use Case:**

* Report on **year-to-date P\&L** without needing detailed historical transactions.

***

#### **3. Load Balances with P\&L Year-to-Date + Historical Journals**

For more detailed records, load **year-to-date P\&L** balances plus a journal entry for each historical period.

**Use Case:**

* Retain historical records by posting **journal entries** for each financial period while avoiding cumulative errors.

***

### **Summary of Best Practices:**

* Avoid loading full transaction histories unless absolutely necessary.
* Consider using the **Balance Sheet** or **P\&L year-to-date** approaches for simplicity.
* Use **journal entries** for each period if you need more historical detail while maintaining efficiency.