# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://netsuite-data-migration-guide.fowlersconsulting.co.uk/best-practices/handling-historical-data-in-netsuite-migrations.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.