Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

COA - Account subcategories vs Begin-End Total

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
    MahGah 15,428 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
    MarilynG 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
    MahGah 15,428 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans