web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to add existing main accounts to a chart of accounts?

(0) ShareShare
ReportReport
Posted on by 20

I am new to D365, not new to DAX. I am trying to figure out if I can create a new Chart of Accounts and populate it with main accounts that are already created? All documentation I've seen so far shows how to create new main accounts when creating the COA, but this seems like a big waste of time when the main accounts I'd want to use are already created. I know I can assign the "shared" or "standard" COA to a legal entity but I know our COF is going to want to create a COA with just the accounts he wants used in by an entity so I'm to figure out how easy/difficult this will be.

I have the same question (0)
  • Verified answer
    Juanse Profile Picture
    660 on at
    RE: How to add existing main accounts to a chart of accounts?

    Hello,

    There is no magic button to copy accounts from one COA to another, but you can easily upload them to the new CAO by using the Excel add in. Copy the accounts from your old COA to the new one. Use this data entity below.

    2020_2D00_03_2D00_16-12_5F00_55_5F00_25_2D00_Window.png

  • Suggested answer
    James Puehl Profile Picture
    20 on at
    RE: How to add existing main accounts to a chart of accounts?

    I just figured this out on my own. I created the new COA name, exported the main accounts to an Excel file, copied/created the accounts I wanted in my new COA, changed the COA column to my new COA, imported the Excel file, now my new COA has main accounts.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to add existing main accounts to a chart of accounts?

    Hi,

    You can open the main accounts form, which will provide you a list of the main accounts that are linked to the chart of accounts that is assigned to your company.

    Adding an account there ensures that it is part of your chart of account and is probably the easiest way adding an account.

    Except - of course - if you use the excel add in.

    Best regards,

    Ludwig

  • James Puehl Profile Picture
    20 on at
    RE: How to add existing main accounts to a chart of accounts?

    The response from Juan was the answer I was looking for and ended up figured out. The response from Ludwig works to enter main accounts on an individual basis.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 783

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 715 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans