# Reconciliation templates

## Reconciliation Templates

Reconciliation templates are often more important than the initial import templates. Pre-designed reconciliation templates can save significant time when checking and correcting any mistakes during data migration. They enable efficient and repeatable comparisons between the old and new systems, allowing for quick data extraction and rechecking after corrections are made.

Below are examples of essential reconciliation templates:

### 1. Mapping Document for Account Codes

This spreadsheet serves as a mapping document between the account codes in the old system and those in the new system. It ensures that each account is correctly aligned, making it easier to identify discrepancies and ensure accurate financial reporting after the migration.

* **Purpose**: Map account codes from the old system to the new one.
* **Usage**: Use this template to quickly verify that each old account has a corresponding account in the new system, reducing the likelihood of errors in financial statements.

<https://docs.google.com/spreadsheets/d/1-tKTD9RlXfJq_qmi9EOT1u0vmY_wl9dcy-tq5sKCRM8/edit?usp=sharing>

{% embed url="<https://docs.google.com/spreadsheets/d/e/2PACX-1vTiL0q3PVOlxKC3895OBhcmmZT1IDJ1sAumuNV8U0_s0Ue5u9L3Z85YT3tIuPOPyB0C_LOk0RK9Stiz/pubhtml>" %}

### 2. Line-Level AR and AP Reconciliation Templates

These templates reconcile Accounts Receivable (AR) and Accounts Payable (AP) at the line level. Amounts in foreign currencies should match for each transaction at the line level in both systems. This template ensures that both the base currency and foreign currency amounts are reconciled.

* **Expected Results**:
  * Foreign currency amounts should match exactly.
  * Minor differences in base currency are expected due to currency rounding at the line level.
* **Usage**: Use this template to confirm that each line item from AR and AP transactions matches the corresponding data in the new system.

<https://docs.google.com/spreadsheets/d/10G21jxw6el1ud9-FUy8HTa_-Rbda8iWIoJeOC7sEWXk/edit?usp=sharing>

{% embed url="<https://docs.google.com/spreadsheets/d/10G21jxw6el1ud9-FUy8HTa_-Rbda8iWIoJeOC7sEWXk/edit?usp=sharing>" %}

### 3. Balance Sheet Extract and Reconciliation

This template allows the finance team to extract the balance sheet from NetSuite in a format they are familiar with, making it easier to verify the data. The template should be populated by extracting the internal ID from a standard balance sheet in NetSuite.

* **Purpose**: Simplifies the process of comparing balance sheets between the old and new systems.
* **Usage**: Extract the balance sheet data from NetSuite, map the internal ID fields, and use the template to compare the results with the old system.

To use this template customise the standard NetSuite balance sheet as follows&#x20;

<figure><img src="/files/EsFOKCvP7itljAcOUZLN" alt=""><figcaption></figcaption></figure>

Note: account type and internal id have been added above as columns to the balance sheet report

###

<https://docs.google.com/spreadsheets/d/1hoq0iIKoPJKNuIi7rsSSF_SEvRA9XIJf/edit?usp=sharing&ouid=107957879709527661711&rtpof=true&sd=true>

Recomciliation template:

{% embed url="<https://docs.google.com/spreadsheets/d/1hoq0iIKoPJKNuIi7rsSSF_SEvRA9XIJf/edit?usp=sharing&ouid=107957879709527661711&rtpof=true&sd=true>" %}

### Benefits of Pre-Designed Reconciliation Templates

1. **Repeatable Process**: The reconciliation process becomes streamlined and repeatable, saving time and reducing errors when correcting any discrepancies.
2. **Quick Re-checking**: After correcting mistakes, the templates can be reused to quickly extract data and ensure all corrections have been made accurately.
3. **Familiar Formats**: The templates are designed in formats familiar to finance teams, making it easier for them to review and confirm the accuracy of migrated data.

By using these reconciliation templates, you ensure a more reliable data migration process, with fewer errors and a faster reconciliation period. Reference the example templates linked below to get started.

***

These templates will help facilitate the reconciliation process between systems. Once you have finalized your reconciliation templates, you can upload them for quick access here in GitBook.


---

# 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/reconciliation-templates.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.