- Feature
- Trace G/L account usage in financial reports
- Availability
- Generally available (October 2026)
- Industry focus
- Acquisitive dental, veterinary and healthcare practice groups
Dental, veterinary and healthcare groups often grow by acquisition, adding several practices a year. Each acquisition brings new revenue streams, cost lines and sometimes new G/L accounts. The group's management reports must keep up. If a new account isn't included in the right line of the P&L, numbers quietly go missing. Business Central 29.0 makes those gaps much easier to spot.
The industry challenge
In Business Central, financial reports use row definitions to decide which G/L accounts appear on each line. In a growing group:
- New accounts are added for new services, such as implants, orthodontics or insurance plans
- Accounts are restructured as the group standardizes its chart of accounts
- Several people maintain report definitions over time
A common risk is the uncategorized account. It has postings, but no report row includes it. The P&L then doesn't add up to the trial balance, and finding the cause can take hours. Report authors also struggle to see which reports use a given account, or how a particular line is calculated.
What Microsoft delivered in Business Central 29.0
According to Microsoft, financial report authors can now:
- Identify uncategorized accounts
- Trace account usage and calculations
- Preview definitions before publishing
In practice, report authors can check that every account is included where it should be, see where an account is used, understand how a figure is built, and test changes before other users see them.
Where the value shows up
| Business area | Impact for a healthcare group |
|---|---|
| Report completeness | No accounts silently missing from management reports |
| Reconciliation | Faster agreement between reports and the trial balance |
| Change confidence | Report changes previewed before they reach the board |
| Integration of acquisitions | New practices' accounts mapped correctly from day one |
| Knowledge transfer | Easier for new finance staff to understand report logic |
This fits well with the other financial reporting changes in 29.0, including automatic logging of report definition changes. Together, they make financial reporting more transparent and more reliable.
A worked scenario
Consider a group of 45 dental practices that acquires eight more in a year (an illustrative example). The group finance team adds new G/L accounts for a dental plan membership scheme introduced at the new practices.
At month-end, group revenue in the management P&L is lower than the trial balance. Using the new tools, the financial controller identifies two uncategorized accounts, the new membership income accounts, that aren't in any revenue row. She traces where similar accounts are used, adds the new accounts to the right row, previews the updated report and publishes it. The P&L reconciles before the board pack goes out.
Adoption considerations
- Check for uncategorized accounts monthly. Make it a standard close step.
- Map new accounts when you create them. Include financial report updates in your account creation process.
- Preview before publishing. Use the preview to test changes to important reports.
- Document report logic. Use trace results to document how key lines are calculated.
- Combine with the change log. Review logged changes alongside account traces.
The bottom line
For acquisitive healthcare groups, management reporting has to keep pace with a changing business. G/L account tracing in Business Central 29.0 helps finance teams keep reports complete, understandable and reconciled as the chart of accounts evolves. It's a quiet feature that protects the reliability of the numbers the board relies on.
If your financial reports regularly need manual reconciliation, it's worth reviewing your report definitions with an experienced Business Central adviser.
Source: Microsoft roadmap 573324