# Business Central Chart of Accounts Mapping Worksheet > Source: https://netray.co/tools/business-central-chart-of-accounts-mapping-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Map legacy accounts to Business Central G/L accounts, flag account types and direct posting, and reconcile opening balances to zero variance. ## Category microsoft-dynamics ## Erp Microsoft Dynamics 365 Business Central ## Audience - Controller - BC finance consultant - Implementation lead ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Legacy account **Key:** old_no **Type:** text #### Legacy name **Key:** old_name **Type:** text #### BC No. **Key:** bc_no **Type:** text #### BC Name **Key:** bc_name **Type:** text #### Account Type **Key:** acct_type **Type:** select **Options:** - Posting - Heading - Total - Begin-Total - End-Total #### Income/Balance **Key:** inc_bal **Type:** select **Options:** - Income Statement - Balance Sheet #### Direct Posting **Key:** direct **Type:** select **Options:** - Yes - No #### Legacy balance **Key:** old_bal **Type:** number **Format:** currency #### BC opening balance **Key:** bc_bal **Type:** number **Format:** currency #### Variance **Key:** variance **Type:** number **Expr:** old_bal - bc_bal **Format:** currency **Rows:** **Old no:** 1000 **Old name:** Cash - Operating **Bc no:** 10100 **Bc name:** Operating Account **Acct type:** Posting **Inc bal:** Balance Sheet **Direct:** No **Old bal:** 184250.4 **Bc bal:** 184250.4 **Old no:** 1200 **Old name:** Accounts Receivable **Bc no:** 11100 **Bc name:** Accounts Receivable **Acct type:** Posting **Inc bal:** Balance Sheet **Direct:** No **Old bal:** 612300 **Bc bal:** 612300 **Old no:** 1400 **Old name:** Raw Materials **Bc no:** 12100 **Bc name:** Inventory Raw Materials **Acct type:** Posting **Inc bal:** Balance Sheet **Direct:** No **Old bal:** 298400 **Bc bal:** 298000 **Old no:** 2000 **Old name:** Accounts Payable **Bc no:** 20100 **Bc name:** Accounts Payable **Acct type:** Posting **Inc bal:** Balance Sheet **Direct:** No **Old bal:** -402750 **Bc bal:** -402750 **Old no:** 4000 **Old name:** Product Sales **Bc no:** 40100 **Bc name:** Sales Domestic **Acct type:** Posting **Inc bal:** Income Statement **Direct:** Yes **Old bal:** 0 **Bc bal:** 0 **Old no:** 5000 **Old name:** Cost of Goods Sold **Bc no:** 50100 **Bc name:** COGS Materials **Acct type:** Posting **Inc bal:** Income Statement **Direct:** No **Old bal:** 0 **Bc bal:** 0 **Totals:** #### Legacy total **Key:** old_bal **Agg:** sum **Format:** currency #### BC total **Key:** bc_bal **Agg:** sum **Format:** currency #### Total variance **Key:** variance **Agg:** sum **Format:** currency **Summary:** #### Net difference to resolve **Key:** net_diff **Expr:** sum_old_bal - sum_bc_bal **Format:** currency **Primary:** true **Description:** Should be zero before opening balances are posted #### Accounts mapped **Key:** lines **Expr:** count **Format:** integer **Notes:** Debits positive and credits negative, so a balanced trial balance sums to zero. Example figures are illustrative; the third row shows a deliberate variance to investigate. ## Content **Intro:** Mapping the chart of accounts is where finance and the implementation team agree what the new Business Central ledger looks like. This worksheet captures the mapping, the BC account properties and the opening balance reconciliation in one place. **Sections:** #### How to use it **Body:** List each legacy account and decide the BC account number and name. Set the Account Type: Posting accounts receive entries, while Heading, Begin-Total, End-Total and Total accounts structure the reports. Mark Income Statement or Balance Sheet and decide whether Direct Posting is allowed. Direct posting should usually be off for control accounts such as receivables, payables and inventory, so users cannot post to them from a general journal by accident. Then enter legacy and BC balances to prove the trial balance. #### Design guidance **Body:** Business Central supports dimensions, so avoid encoding department, plant or product line into account numbers when a dimension does the job. A leaner account list with global dimensions keeps reporting flexible and reduces the posting group matrix. Many partners start from a standard chart template and adapt it, then map legacy accounts many-to-one. Keep a record of many-to-one merges because auditors will ask how historical comparisons were preserved. **Bullets:** - Plan numbering ranges per class: assets, liabilities, equity, revenue, cost, expense - Decide which accounts need the Reconciliation Account setting in your version - Use totaling formulas on Total and End-Total accounts and test them #### Reconciling opening balances **Body:** The variance column is legacy balance minus BC balance. After you load balances through a general journal or configuration package, the total of every balance must match the legacy trial balance at the cutover date. Differences usually come from rounding, accounts mapped twice, accounts missed, or sub-ledgers that were converted separately from the control account. Resolve variances before posting, not afterward. #### Common mistakes **Body:** Do not post subledger balances such as customers and vendors directly to the receivables and payables control accounts through a journal without matching open entries. Doing so leaves the control account out of step with the sub-ledger. Also check fiscal calendar and posting date rules so opening balances land in the right period. **Cta:** Netray can help reconcile large chart conversions from NAV, SyteLine or other systems with scripted checks and human sign-off. Ask for an expert review if the variance will not close. **Faq:** #### Should I keep my old account numbers in Business Central? **Answer:** You can, and it eases user adoption, but it is rarely optimal. A redesign with dimensions often shrinks the chart considerably. If you keep old numbers, store them for reference and still document every merge or split in this mapping. #### What does Direct Posting mean on a G/L account? **Answer:** It controls whether users can select the account directly on general journal lines and documents. Accounts fed through posting groups, such as inventory, receivables and payables, are normally excluded from direct posting to protect control totals. #### How do I show debit and credit balances? **Answer:** Use positive numbers for debits and negative numbers for credits in this sheet. A complete, balanced trial balance then totals to zero in each of the legacy and BC columns, which is a quick completeness check. #### Is this worksheet a substitute for an accountant's review? **Answer:** No. It is a planning and reconciliation aid. Your controller or external accountant should approve the final chart and the opening balances, particularly for statutory reporting and tax account requirements in your country. ## Search terms business central chart of accounts template, business central chart of accounts excel, map chart of accounts to business central, dynamics 365 business central g/l account mapping, opening balance reconciliation template erp, business central g/l account types --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json