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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Best Practice - Setting up GL Main Accounts tied to Bank Accounts (1 GL Account per Bank Account or Multiple Bank Accounts per GL Account).

(0) ShareShare
ReportReport
Posted on by 5

What is best practice when setting up Bank Accounts? Should you tie multiple bank accounts to 1 main account? or should you have 1 Main Account for each Bank Account?

What are the benefits of setting the accounts up as suggested by best practice?

Thank  You,

Tanya

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    305,012 Super User 2026 Season 1 on at

    Hi Tanya,

    The majority of companies (98%) which I have seen implementing this used one main account per bank account.

    This was for convenience in reporting to have directly the balance and transactions available per bank account.

  • Suggested answer
    Sukrut Parab Profile Picture
    71,741 Moderator on at

    Did you try to create one with same main account? If you try to set it up you get  below warning  which gives you a idea what could be the impact.

    "Main account xxxx is already associated with bank account USMF EUR. Associating more than one bank account with a single main account can result in unexpected or inaccurate results when reconciling that bank account or when generating cash flow reports."

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Tanya,

    Also prefer the 1:1 mapping that Andre mentioned and the locking of the main account for manual transactions.

    Best regards,

    Ludwig

  • Suggested answer
    saurabh bharti Profile Picture
    15,055 Moderator on at

    Hi Tanya,

    It completely depends on customer's need. In my experience i used main account as per following criteria's :

    1. One Main account for single currency (In case or multi currency bank account ) e.g.  One account for all USD banks, One for EUR and so on..

    2. One Main account for all banks with same Bank group or same type of bank e.g. Citi bank all bank accounts one main account

    3. Many customer prefer to report individual bank accounts in their financial statements e.g. Balance sheet then you have to use one main account for one Bank

  • TS Realfoundations Profile Picture
    5 on at

    Thank you all.

  • obergolsen Profile Picture
    12 on at

    Hi Saurabh, I agree in what you write above as the customer's need varies. I would prefer using the Bank account table as a genuin subledger with groups of bank accounts summing up to specific bank accounts per currency etc. But can we ignore the warning regarding unexpected errors regarding reconciliation and cash flow reports? Have you or anyone else experienced problems setting up more bank accounts to a main account?

  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,825 Most Valuable Professional on at

    Cash flow or bank reconciliation will not be effected. Only issue you may face is bank reconciliation report.

    I have seen companies use both of them. And do not remember if they have any issue with that.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 677 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 620

#3
Subra Profile Picture

Subra 483

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans