Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

COA - Account subcategories vs Begin-End Total

(0) ShareShare
ReportReport
Posted on by 70

I'm not sure if I should use the start-finish totals or the subcategories in my chart of account

Is there an advantage to using one over the other? Or are the 2 complementary?

  • Suggested answer
    MahGah Profile Picture
    15,437 on at
    RE: COA - Account subcategories vs Begin-End Total

    Hi

    In your Finical reporting (account schedule) you can use G/L account and build total, sub-total etc using G/L.

    But sub-category can help you to run reports, use them in Power BI , filter, etc. It also gives future users better view and understanding of the account. My suggestion is always asked what will happen if I add 10 more accounts? Then if the answer is you will need sub-category then start build it today with one account.

    Those are all helpful when you go to COA page to see everything organized and clean. Your team does not need to go to Finical Reports to see many information. They can use COA and find some answers. Hence, it is better to use both subcategories and beg/end.

    See this post as well and look at COA and how they categorized

    community.dynamics.com/.../begin-total-and-end-total

  • MarilynG Profile Picture
    70 on at
    RE: COA - Account subcategories vs Begin-End Total

    Hi!  Thanks for your answer!  

    Is this means that the Begin-end total in the COA have no impact on any financial report?

    As for your example for Travel expense; for this precise example, I might have 1 G/L per subcategorie.  Is there an advantage using the subcategorie? Is it because the financial report are based on subcategorie and not on G/L account directly?

    Thanks for your time!

  • Suggested answer
    MahGah Profile Picture
    15,437 on at
    RE: COA - Account subcategories vs Begin-End Total

    Hi

    Begin-End Total is for showing sub-total in COA. They are not needed but it helps to explorer COA.

    sub-category let you organize your COA more since you can create your own subcategories. For example you can create below sub-categories

    Travel Hotel Expense

    Travel Meal Expense

    Travel Ticket Expense

    Then use Begin-End Total to have Travel Expense

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,996 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans