Microsoft has removed eight familiar Excel reports from Dynamics 365 Business Central. If your team has recently struggled to find reports such as Aged Accounts Receivable, you’re not alone.
In this on-demand webinar, Paul Cartwright, Chief Technical Officer at TVT, and Ian Robinson, Senior Support Consultant, explain what has changed, why these reports have been replaced, and how finance teams can adapt to Microsoft’s new Excel layout approach.
Watch the recording to learn:
- Which reports have been removed from Business Central
- Why Microsoft made the change
- How to access and work with the replacement reports
- How Excel layouts work within Business Central
- Tips for managing layouts, updates and report governance
- How finance teams can customise reports without developer support
Watch on demand now.
What changed in Business Central reporting?
Microsoft began phasing out several standard Excel reports in Dynamics 365 Business Central 2025 Release Wave 1, before removing them completely in 2026 Release Wave 1.
These reports have been replaced with versions built using Excel layouts, giving organisations greater flexibility to customise reporting output without requiring development changes.
While the new approach offers significant benefits, many finance teams have been caught out when familiar reports suddenly disappeared from their system.
Business Central reports affected
The following reports have been replaced:
- Balance Sheet
- Income Statement
- Statement of Cash Flow
- Statement of Retained Earnings
- VAT Collected (previously Sales Taxes Collected)
- Customer Statements
- Aged Accounts Payable
- Aged Accounts Receivable
For many organisations, Aged Accounts Receivable has generated the most questions. However, the same concepts and solutions discussed in this webinar apply across all affected reports.
Understanding Excel Layouts in Business Central
One of the biggest changes introduced by Microsoft is the use of Excel layouts.
Rather than relying on fixed report formats, Excel layouts provide a more flexible framework that allows finance teams to:
- Modify report presentation in Excel
- Tailor reports to specific business requirements
- Refresh data directly from Business Central
- Reduce dependence on developers or third-party reporting tools
During the webinar, Paul and Ian demonstrate how Excel layouts work, where they are stored, and the key considerations when managing updates and report changes.
Who should watch?
This webinar is ideal for:
- Finance Managers
- Finance Directors
- Financial Controllers
- Management Accountants
- Business Central Users
- Reporting and Analytics Teams
Whether you’re currently affected by these reporting changes or want to prepare your organisation for future updates, this session provides practical guidance to help you get the most from Business Central reporting.
