# Dynamics GP Chart of Accounts Mapping Worksheet > Source: https://netray.co/tools/gp-chart-of-accounts-mapping-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable worksheet mapping segmented GP accounts to a target chart of accounts and dimension values, with balance tracking. ## Category microsoft-dynamics ## Erp Microsoft Dynamics GP ## Audience - Controller - GL accountant - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### GP account **Key:** gp_account **Type:** text **Help:** Full segmented string, for example 000-1100-00. #### GP description **Key:** gp_desc **Type:** text #### GP category **Key:** gp_type **Type:** select **Options:** - Asset - Liability - Equity - Revenue - Expense #### Closing balance **Key:** balance **Type:** number **Format:** currency #### Action **Key:** action **Type:** select **Options:** - Map 1 to 1 - Merge - Split - Retire - New #### New account **Key:** new_account **Type:** text #### Dimension value (dept or site) **Key:** dimension **Type:** text #### Reviewer **Key:** owner **Type:** text **Rows:** **Gp account:** 000-1100-00 **Gp desc:** Cash operating account **Gp type:** Asset **Balance:** 184250 **Action:** Map 1 to 1 **New account:** 10100 **Owner:** Controller **Gp account:** 000-1200-00 **Gp desc:** Accounts receivable **Gp type:** Asset **Balance:** 412900 **Action:** Map 1 to 1 **New account:** 11100 **Owner:** AR lead **Gp account:** 000-2000-00 **Gp desc:** Accounts payable **Gp type:** Liability **Balance:** -298400 **Action:** Map 1 to 1 **New account:** 20100 **Owner:** AP lead **Gp account:** 100-5000-00 **Gp desc:** Salaries, Sales dept **Gp type:** Expense **Balance:** 96000 **Action:** Merge **New account:** 60100 **Dimension:** SALES **Owner:** Controller **Gp account:** 200-5000-00 **Gp desc:** Salaries, Operations dept **Gp type:** Expense **Balance:** 142500 **Action:** Merge **New account:** 60100 **Dimension:** OPS **Owner:** Controller **Gp account:** 000-6900-00 **Gp desc:** Misc old suspense **Gp type:** Expense **Balance:** 0 **Action:** Retire **Owner:** Controller **Totals:** #### Net of closing balances **Key:** balance **Agg:** sum **Format:** currency #### Accounts listed **Key:** gp_account **Agg:** count **Format:** integer **Summary:** #### Average balance per account **Key:** avg_bal **Expr:** sum_balance / count **Format:** currency **Notes:** GP accounts are typically built from segments (for example company-department-account-sub) while many targets use a single account number plus dimensions. Decide which segments become dimensions first. Net closing balances should be zero when assets, liabilities and equity are listed with consistent sign conventions, and revenue and expense are closed. ## Content **Intro:** The chart of accounts is where most GP migrations either get simpler or get messy. This worksheet lets you map every GP account string to a new account and dimension, with the balance next to it for review. **Sections:** #### How to use the worksheet **Body:** Export GP accounts with GL00100 and GL00105 or from the Account Maintenance screen, then paste or type them in. For each account, choose an action. Map 1 to 1 keeps an account, Merge combines several GP accounts into one, Split divides a GP account across several, Retire drops it, and New creates an account with no GP equivalent. Record the dimension value for any segment that becomes a dimension, and assign a reviewer for each row. **Bullets:** - Start with accounts that have non-zero balances - Decide segment-to-dimension rules before mapping rows - Use Merge to collapse department-specific accounts - Give each row a named reviewer #### Segments versus dimensions **Body:** GP encodes department, location or company in account segments, which multiplies the number of accounts. Business Central and many other ERPs hold one natural account and attach dimensions such as department or project. A mapping that merges 400 segmented accounts into 120 natural accounts plus dimension values is common and usually desirable. Check statutory reporting before merging, since some regimes require specific account structures. #### Reading the totals **Body:** The count shows how many accounts you have reviewed and the balance total helps you spot mapping errors. If your list includes all balance sheet accounts with correct signs, the net should reconcile to the trial balance. After mapping, compare the trial balance by new account against the GP trial balance as of the same date. Differences usually come from a missed account, a wrong sign convention or an inactive account that still holds a balance. #### Common mistakes **Body:** Do not map inactive accounts blindly, since they may hold residual balances. Avoid merging accounts that auditors or lenders watch separately. Another error is changing the chart and migrating at the same time without a bridge, which makes year-over-year comparison hard. Keep this worksheet as the permanent bridge between old and new account numbers, and store it with your migration records. **Cta:** We can help extract GP accounts and balances from your database and draft a first mapping for your review. Optional. **Faq:** #### Which GP tables hold the chart of accounts? **Answer:** GL00100 is the account master and GL00105 holds the account number string by account index. Closing balances by period come from the summary tables such as GL10110 for the open year and GL10111 for history. #### Should we redesign the chart during migration? **Answer:** It is a good moment to simplify, but a redesign adds work and risk. Many teams map 1 to 1 for go-live and plan a cleanup after the first close. Decide with your auditors and based on reporting needs. #### How do GP segments map to dimensions? **Answer:** Typically the natural account segment becomes the account number, while department, location or company segments become dimension values. Your reporting and consolidation needs determine which segments become dimensions. #### Can I export this to Excel? **Answer:** Yes. The worksheet exports to Excel and CSV, including the action and reviewer columns, so you can send it to your accounting team and implementation partner. ## Search terms gp chart of accounts mapping, chart of accounts mapping template, dynamics gp to business central chart of accounts, gp account segments dimensions, chart of accounts migration excel, gl account mapping worksheet, erp coa mapping template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json