Skip to main content


What Does "Skip Accounts with all Zero Amounts" Do?

Jun Wang Profile Picture Jun Wang 4,053 Super User



When it comes to financial reporting, clarity is key. Microsoft Dynamics 365 Business Central offers a range of reporting features designed to make financial statements as insightful as possible. One of these features is the "Skip Accounts with all Zero Amounts" option in the Trial Balance report. This small, yet significant feature can make a big difference in how you review and analyze your financial data. Here's what you need to know.

What Does "Skip Accounts with all Zero Amounts" Do?

The "Skip Accounts with all Zero Amounts" option, found in the settings of the Trial Balance report, allows users to exclude any G/L accounts that do not have any activity in the reporting period from the report. This means that if an account has a zero balance and there have been no transactions affecting it, it won't show up on your trial balance.

Benefits of Skipping Zero Amount Accounts

1. Enhanced Readability: By removing the clutter of inactive accounts, your trial balance becomes much easier to read and analyze.

2. Focus on Relevant Data: It helps you focus on the accounts that have had activity during the period, which are typically the areas of interest for most financial reviews.

3. Simplified Auditing: Auditors often look for discrepancies or unexpected balances. Removing zero-balance accounts can help them concentrate on accounts that matter.

4. Save Paper and Ink: For those who still rely on printed reports, excluding these accounts can save pages, making your report more environmentally and budget-friendly.

5. Streamlined Analysis: When using the report for comparative analysis, having only the active accounts can make it easier to spot trends and changes over time.

How to Use This Feature

To use this option, simply:

  1. Go to your Trial Balance report in Business Central.
  2. In the options pane, look for the "Skip Accounts with all zero Amounts" toggle.
  3. Turn it ON by clicking the slider.
  4. Run your report as usual.

Now, your trial balance will only show accounts that have had some financial activity in the selected period, whether that's the current month, quarter, or year.

Things to Consider

While this feature is undeniably useful, it's important to remember that just because an account has had no activity in a period doesn't mean it's not important. Some accounts might have seasonal activity or be used infrequently, but still play a critical role in your financial landscape. Always review your financial reporting needs comprehensively before deciding to skip accounts with zero amounts.


The "Skip Accounts with all Zero Amounts" flag in Microsoft Dynamics 365 Business Central's Trial Balance report is a great tool for finance professionals who want to create concise and focused reports. By understanding and utilizing this feature, you can ensure that your financial reporting is as efficient and effective as your business operations.

Remember, Business Central is designed to support your business's unique financial processes, and this is just one of the many features that can be tailored to suit your reporting needs.


*This post is locked for comments