# Dynamics GP Cutover Open Balances Reconciliation Worksheet

> Source: https://netray.co/tools/gp-cutover-open-balances-reconciliation-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare GP and target-system balances for AR, AP, inventory, GL and open orders, calculate variance and track who signed off each line.

## Category

microsoft-dynamics

## Erp

Microsoft Dynamics GP

## Audience

- Controller
- Finance analyst
- ERP project manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Area

**Key:** area

**Type:** select

**Options:**

- General ledger
- Receivables
- Payables
- Inventory
- Open sales orders
- Open purchase orders
- Fixed assets
- Bank

#### Account / control total

**Key:** item

**Type:** text

#### GP balance

**Key:** gp

**Type:** number

**Format:** currency

#### New system balance

**Key:** target

**Type:** number

**Format:** currency

#### Variance

**Key:** variance

**Type:** number

**Expr:** target - gp

**Format:** currency

#### Absolute variance

**Key:** abs_var

**Type:** number

**Expr:** abs(target - gp)

**Format:** currency

#### Status

**Key:** status

**Type:** select

**Options:**

- Open
- Explained
- Fixed
- Signed off

#### Owner

**Key:** owner

**Type:** text

#### Checked on

**Key:** date

**Type:** date

**Rows:**

**Area:** General ledger

**Item:** Trial balance, all accounts

**Gp:** 0

**Target:** 0

**Status:** Signed off

**Owner:** Controller

**Date:** 2027-01-03

**Area:** Receivables

**Item:** AR control account vs open invoices

**Gp:** 1284500.75

**Target:** 1284500.75

**Status:** Signed off

**Owner:** AR lead

**Date:** 2027-01-03

**Area:** Payables

**Item:** AP control account vs open vouchers

**Gp:** 742310.2

**Target:** 742310.2

**Status:** Signed off

**Owner:** AP lead

**Date:** 2027-01-03

**Area:** Inventory

**Item:** On-hand value, all sites

**Gp:** 3920440.1

**Target:** 3919880.1

**Status:** Open

**Owner:** Cost accountant

**Date:** 2027-01-03

**Area:** Open purchase orders

**Item:** Open PO value, not yet received

**Gp:** 615200

**Target:** 615200

**Status:** Explained

**Owner:** Purchasing

**Date:** 2027-01-03

**Totals:**

#### Net variance

**Key:** variance

**Agg:** sum

**Format:** currency

#### Total absolute variance

**Key:** abs_var

**Agg:** sum

**Format:** currency

#### Lines checked

**Key:** item

**Agg:** count

**Format:** integer

**Summary:**

#### Average absolute variance per line

**Key:** avg_abs

**Expr:** sum_abs_var / count

**Format:** currency

**Notes:** Net variance can hide offsetting errors. Use total absolute variance as the real go/no-go number. Inventory often needs a separate lot and site level check.

## Content

**Intro:** At cutover, finance needs proof that what was in the old system is in the new one. This worksheet lists each control total in a row, calculates variance and keeps a status and owner so sign-off is traceable.

**Sections:**

#### How to use it

**Body:** Add one row per control total you will check: trial balance, AR, AP, inventory value, open orders. Enter the GP balance from the final reports and the new system balance from the equivalent report. Variance calculates automatically. Aim for zero absolute variance on GL, AR and AP; inventory may need an agreed tolerance if costing methods differ.

**Bullets:**

- Take GP figures after the final freeze
- Reconcile at customer and vendor level, not only totals
- Record who checked each line
- Export the signed sheet to your audit file

#### Net versus absolute variance

**Body:** A net variance of zero can hide a plus and a minus error that cancel. The absolute variance column counts both as problems. Use it for the go/no-go decision and use the net figure only for the explanation.

#### Typical causes of variance

**Body:** Unposted batches, foreign currency revaluation, inventory costed on a different method, items on hand with negative quantities, and customer credits applied differently are the usual suspects. Fix the source and rerun the load rather than adjusting with a journal, unless auditors have agreed that route.

**Cta:** If you want the comparison to run automatically from GP and the target system, we can look at building that check.

**Faq:**

#### Which GP reports should I use?

**Answer:** Use the trial balance, aged trial balance for receivables and payables, and the inventory valuation report, all printed after the freeze. Keep the printed or PDF copy with the signed worksheet.

#### What tolerance is acceptable?

**Answer:** Zero for GL, AR and AP is normal. For inventory, agree a tolerance with finance and auditors before the load rather than after you see the numbers.

#### Should I reconcile at detail level?

**Answer:** Yes for AR and AP. Compare by customer and vendor, and for inventory by item and site. Totals alone can match while detail is wrong.

#### Does this work for AX 2012 as well?

**Answer:** Yes. Replace the source label with AX and keep the same structure of control totals, variance and owner.

## Search terms

erp cutover reconciliation template, gp opening balance reconciliation, data migration reconciliation excel, gp to business central balance check, migration sign off worksheet, trial balance reconciliation migration

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json