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... / Running the Prior Year...
Small and medium business | Business Central, N...
Answered

Running the Prior Year Trial Balance after closing the account period and income statement

(4) ShareShare
ReportReport
Posted on by CU01020732-0 25
Hello all,
 
I am new to Dynamic BC, and I have run my first year end closing and there is a problem.  
 
The steps I perform:
1) Run the "Trial balance" by choosing the period "01.01.2025..12.31.2025" (which is perfect and nice)
2) Closing the accounting period and close the income statement
3) Re-run the trial balance by choosing the period "01.01.2025..12.31.2025"
 
At this moment, I have an issue, I am not able to generate a "complete" trial balance.  Some expenses accounts that have number during 2025 are missing.  
May I know if my setting is wrong?   And I am able to get the complete picture in "closing trial balance" but failure to get it in "trial balance"
 
Many thanks for your help.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,886 Super User 2026 Season 1 on at
    Hi,
     
    This is standard behavior and following is the explanation.
     
    When you close any fiscal year and run Close Income statement batch, the resulting entries are posted with closing dates and not normal dates. For e.g. if your fiscal year end on 12/31/2025 then closing date is C12/31/2025.
     
    When you run trial balance report it does not consider C12/31/2025 but only till 12/31/2025. While Closing trial balance considers C12/31/2025.
     
    If you will check Trial balance report before or after running Closing Income statement it will give same result.
     
    I hope this helps you explain the difference.
     
    Regards,
    Dhiren.
  • CU01020732-0 Profile Picture
    CU01020732-0 25 on at
    Hi Dhiren
     
    Thanks for your reply.  I should explain clearly related to trial balance: 
     
    Before close the income statement: 
    Marketing expenses as at 12/31/2025 =  1,500 
    Staff cost as at 12/31/2025 = 2,000
     
    By choosing "trial balance" function, date filter: 1.1.2025..12.31.2025, it able to show.
     
    After close the income statement, 
    By choosing "trial balance" function, date filter: 1.1.2025..12.31.2025, it only able to show some items, such as marketing expenses but staff cost is missing.
     
    I have no idea why.  May I know if there is any set up I have to check? 
     
    Many thanks for your help.
     
    Martina
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,886 Super User 2026 Season 1 on at
    Hi,
     
    There is no setup for this. Also I wonder why one expense is showing and not other.
     
    Can you make sure that during Close Income statement process all the Expense G/Ls were closed?
     
    Also I hope for Income statement G/Ls you are checking Net Change Columns for Income statement G/Ls and Balance column for Balance sheet G/Ls.
     
    If you still not able to identify the issue, please do the following:
     
    1 - First export the trial balance report before closing of the income statement.
    2 - Close the income statement.
    3 - Open General Ledger entries, apply filter of Period, then Export to excel, then make a pivot with rows being G/L No and Columns of Balance & Net Change.
    4 - Now match the balances. If it matches there is no issue with your posting and report.
  • Verified answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 15,536 Super User 2026 Season 1 on at
    Hello,
     
    After you Close Income Statement, Business Central posts closing entries on the Closing Date (C), which zeroes out all P&L (expense/income) accounts; when you rerun the Trial Balance for 01.01.2025..31.12.2025, those closing entries are excluded and zero-balance accounts are hidden by default, so some expense accounts appear “missing” — this is expected behavior, not a setup issue. To see them, either enable Show Zero Balance, include the closing date in the filter (01.01.2025..31.12.2025|C), or use Closing Trial Balance, which is meant for year-end review.
     
    Regards,
    Oussama Sabbouh

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,184 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 677

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans