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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Trial Balance that sho...
Small and medium business | Business Central, N...
Suggested Answer

Trial Balance that shows different months as header

(0) ShareShare
ReportReport
Posted on by MahGah 15,613

Hi 

Is it any report in BC that shows trial balance for time period per month? Something like below 

Let say want to see Jan to March 

Account#   Description  Jan      Feb     March 

Acc1          Account 1      123    345    500

Acc2 

Thanks 

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,978 Super User 2026 Season 1 on at

    Hi, This can be done in Account Schedule (Financial Reports).

    pastedimage1677630217943v1.png

    Here's an explainer video in NAV that also works in BC.

    https://www.youtube.com/watch?v=FvF4AGt9K84

    Hope this helps.

    Thanks.
    ZHU

  • MahGah Profile Picture
    MahGah 15,613 on at

    Thanks Mr Zhu

    I meant more like a dynamic header. like if I selected 4/1/2022..3/31/2023 then header read April2022 , .... , March 2023 (or for any date range)

    Thanks

  • Suggested answer
    Amit Profile Picture
    Amit 2,563 on at

    Hello,

    You can configure in Account Schedule as per the above requirement.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,978 Super User 2026 Season 1 on at

    Hi, I think your needs can be done in Account Schedule. You just need to modify the date range.

    And I did a test before, but this required customization.

    https://yzhums.com/1846/

    Hope this can give you some hints.

    Thanks.

    ZHU

  • Morten_DK Profile Picture
    Morten_DK 35 on at

    Have you tried trial balance by period? It might get you some of the way at least.

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,796 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 965 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans