--- id: video/jricCM_04H4 type: video title: "What's New: Excel Reporting (2025 release wave 1)" summary: "Business Central 2025 release wave 1 Excel reporting: the finance and fixed assets Excel reports are now generally available, there are new Customer Top 10 and Vendor Top 10 reports, and the three sustainability reports have updated layouts. Sales and purchase order performance analysis queries are coming in version 26.1. A fixed asset ad hoc analysis query is already available from version 25.3. Legacy Excel reports move to a Legacy group before being removed." tier: official language: en tags: - excel reports - pivot tables - power query - analytics - legacy reports - printable layouts - finance reports - sales order analysis - fixed assets analysis - sustainability reporting system: reporting review: state: reviewed by: opus at: "2026-10-07T22:58:10.793Z" flags: [] generated: at: "2026-10-07T22:58:10.842Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: cc44abb2b8b5597c4d854c8845ca57c81b9d1ed0f1b72933db8b4cdb89e2552b evidence: - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=30s title: "Excel Reports for Finance (Generally Available): generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 30 quote: made the Excel reports that were in preview generally available - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=373s title: "Aged Accounts Receivables Excel Report: generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 373 quote: this is just one of of the finance reports that is now generally available in version 20 25 release Wave 1 - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=394s title: "Customer Top 10 Excel Report: generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 394 quote: we also made gen generally available two new Excel reports or maybe four - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=394s title: "Vendor Top 10 Excel Report: generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 394 quote: we also made gen generally available two new Excel reports or maybe four - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=515s title: "Sales Order Performance Analysis Query: announced" date: "2025-04-01T15:01:04.000Z" commit: null t: 515 quote: in sales and purchasing we also gave you a little bonus it will come in version 26. - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=515s title: "Purchase Order Performance Analysis Query: announced" date: "2025-04-01T15:01:04.000Z" commit: null t: 515 quote: in sales and purchasing we also gave you a little bonus it will come in version 26. - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=618s title: "Fixed Assets Excel Reports (Generally Available): generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 618 quote: we made three of the Excel reports or the three preview report reports in Excel generally available - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=679s title: "Sustainability Excel Reports with Updated Layouts: generally available" date: "2025-04-01T15:01:04.000Z" commit: null t: 679 quote: we added in the last release wave through three Excel reports so they have already generally available but in this release wave we also - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=30s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 30 quote: made the Excel reports that were in preview generally available it's not only that we made sure they worked but we also applied a - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=152s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 152 quote: since this is an Excel report you just get the download you don't get a print option here so let's download uh and run - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=233s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 233 quote: these Excel reports are the the main reason we use Excel is to have interactivity with pivot tables and slices and so on - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=618s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 618 quote: we made three of the Excel reports or the three preview report reports in Excel generally available fixed assets analysis fixed asset details and - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=638s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 638 quote: as a bonus that you already have in your environment today if you're on a version 25.3 or later - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=760s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 760 quote: in business Central the Legacy Excel reports are the ones you find under the Excel reports menu and then they they now have a - kind: video url: https://www.youtube.com/watch?v=jricCM_04H4&t=780s title: "What's New: Excel Reporting (2025 release wave 1)" date: "2025-04-01T15:01:04.000Z" commit: null t: 780 quote: later release wave this group will be removed and you can you should only be able to find these in the RO Explorer links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: jricCM_04H4 channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=jricCM_04H4 published_at: "2025-04-01T15:01:04.000Z" duration_s: 831 captions: full audience: - functional consultant - administrator - end user chapters: - t: 0 title: Introduction and Excel Reports for Finance - t: 30 title: Finance Excel Reports Overview and Access Methods - t: 110 title: Aged Accounts Receivables Report Demo - t: 192 title: "Excel Report Features: Print and Analysis Worksheets" - t: 333 title: Finance Reports and Sales/Purchasing Excel Reports - t: 415 title: Vendor Top 10 Report Demo - t: 515 title: New Query-Based Analysis for Sales and Purchasing - t: 618 title: Fixed Assets and Sustainability Reports - t: 720 title: Legacy Report Deprecation and Manufacturing Analytics features: - name: Excel Reports for Finance (Generally Available) status: ga t: 19 verified: true status_source: video - name: Aged Accounts Receivables Excel Report status: ga t: 90 verified: true status_source: video - name: Customer Top 10 Excel Report status: ga t: 394 verified: true status_source: video - name: Vendor Top 10 Excel Report status: ga t: 435 verified: true status_source: video - name: Sales Order Performance Analysis Query status: announced t: 515 verified: true status_source: video - name: Purchase Order Performance Analysis Query status: announced t: 515 verified: true status_source: video - name: Fixed Assets Excel Reports (Generally Available) status: ga t: 618 verified: true status_source: video - name: Fixed Asset Ad Hoc Analysis Query status: unclear t: 638 verified: false status_source: video - name: Sustainability Excel Reports with Updated Layouts status: ga t: 679 verified: true status_source: video - name: Legacy Excel Reports Deprecation status: unclear t: 720 verified: false status_source: video objects_mentioned: - query Sales Order Performance Analysis - query Fixed Asset Ad Hoc Analysis quotes: - t: 30 text: made the Excel reports that were in preview generally available it's not only that we made sure they worked but we also applied a check: exact - t: 152 text: since this is an Excel report you just get the download you don't get a print option here so let's download uh and run check: exact - t: 233 text: these Excel reports are the the main reason we use Excel is to have interactivity with pivot tables and slices and so on check: exact - t: 618 text: we made three of the Excel reports or the three preview report reports in Excel generally available fixed assets analysis fixed asset details and check: exact - t: 638 text: as a bonus that you already have in your environment today if you're on a version 25.3 or later check: exact - t: 760 text: in business Central the Legacy Excel reports are the ones you find under the Excel reports menu and then they they now have a check: exact - t: 780 text: later release wave this group will be removed and you can you should only be able to find these in the RO Explorer check: exact --- # What's New: Excel Reporting (2025 release wave 1) > Business Central 2025 release wave 1 Excel reporting: the finance and fixed assets Excel reports are now generally available, there are new Customer Top 10 and Vendor Top 10 reports, and the three sustainability reports have updated layouts. Sales and purchase order performance analysis queries are coming in version 26.1. A fixed asset ad hoc analysis query is already available from version 25.3. Legacy Excel reports move to a Legacy group before being removed. [Watch on YouTube](https://www.youtube.com/watch?v=jricCM_04H4) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-04-01 · 13:51 · tier official · reviewed (checked by Opus) ## Overview The video covers what changed in Excel reporting in 2025 release wave 1. Reports that were in preview are now generally available with modernized layouts, including seven finance reports, three fixed asset reports and three sustainability reports. The presenter demos the Aged Accounts Receivables report, which has a printable version and analysis worksheets built on pivot tables and slicers, and the Vendor Top 10 report. It also covers query-based analysis for sales and purchasing, announced for version 26.1, and a fixed asset ad hoc analysis query. The last part explains that legacy Excel reports are moved to a Legacy group in the Excel Reports menu and will be removed in a later release wave. ## Key points - Seven finance Excel reports are generally available, ranging from trial balance and consolidated trial balance to collectibles, receivables and payables, with modernized designs and layouts. - The Aged Accounts Receivables report has a printable version and three analysis worksheets (local currency by period, foreign currency, by currencies) with pivot tables and slicers. - Opening the Aged Accounts Receivables report in Excel requires enabling content because it uses Power Query (Excel security settings). - Customer Top 10 and Vendor Top 10 Excel reports are new, each with a printable version and an analysis worksheet with slicers. - Sales Order Performance Analysis and Purchase Order Performance Analysis queries come in version 26.1 and join header data to line data. - Fixed Assets Analysis, Fixed Asset Details and Fixed Asset Projected Value Excel reports are generally available; a fixed asset ad hoc analysis query is available from version 25.3. - Three sustainability Excel reports, already generally available, got updated layouts in this release wave. ## Chapters - [0:00](https://www.youtube.com/watch?v=jricCM_04H4&t=0s) Introduction and Excel Reports for Finance - [0:30](https://www.youtube.com/watch?v=jricCM_04H4&t=30s) Finance Excel Reports Overview and Access Methods - [1:50](https://www.youtube.com/watch?v=jricCM_04H4&t=110s) Aged Accounts Receivables Report Demo - [3:12](https://www.youtube.com/watch?v=jricCM_04H4&t=192s) Excel Report Features: Print and Analysis Worksheets - [5:33](https://www.youtube.com/watch?v=jricCM_04H4&t=333s) Finance Reports and Sales/Purchasing Excel Reports - [6:55](https://www.youtube.com/watch?v=jricCM_04H4&t=415s) Vendor Top 10 Report Demo - [8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s) New Query-Based Analysis for Sales and Purchasing - [10:18](https://www.youtube.com/watch?v=jricCM_04H4&t=618s) Fixed Assets and Sustainability Reports - [12:00](https://www.youtube.com/watch?v=jricCM_04H4&t=720s) Legacy Report Deprecation and Manufacturing Analytics ## Features | Feature | Status | At | Evidence | |---|---|---|---| | Excel Reports for Finance (Generally Available) | generally available, demoed | [0:19](https://www.youtube.com/watch?v=jricCM_04H4&t=19s) | "made the Excel reports that were in preview generally available" ([0:30](https://www.youtube.com/watch?v=jricCM_04H4&t=30s)) | | Aged Accounts Receivables Excel Report | generally available, demoed | [1:30](https://www.youtube.com/watch?v=jricCM_04H4&t=90s) | "this is just one of of the finance reports that is now generally available in version 20 25 release Wave 1" ([6:13](https://www.youtube.com/watch?v=jricCM_04H4&t=373s)) | | Customer Top 10 Excel Report | generally available | [6:34](https://www.youtube.com/watch?v=jricCM_04H4&t=394s) | "we also made gen generally available two new Excel reports or maybe four" ([6:34](https://www.youtube.com/watch?v=jricCM_04H4&t=394s)) | | Vendor Top 10 Excel Report | generally available, demoed | [7:15](https://www.youtube.com/watch?v=jricCM_04H4&t=435s) | "we also made gen generally available two new Excel reports or maybe four" ([6:34](https://www.youtube.com/watch?v=jricCM_04H4&t=394s)) | | Sales Order Performance Analysis Query | announced, demoed | [8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s) | "in sales and purchasing we also gave you a little bonus it will come in version 26." ([8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s)) | | Purchase Order Performance Analysis Query | announced | [8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s) | "in sales and purchasing we also gave you a little bonus it will come in version 26." ([8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s)) | | Fixed Assets Excel Reports (Generally Available) | generally available | [10:18](https://www.youtube.com/watch?v=jricCM_04H4&t=618s) | "we made three of the Excel reports or the three preview report reports in Excel generally available" ([10:18](https://www.youtube.com/watch?v=jricCM_04H4&t=618s)) | | Fixed Asset Ad Hoc Analysis Query | status not stated | [10:38](https://www.youtube.com/watch?v=jricCM_04H4&t=638s) | | | Sustainability Excel Reports with Updated Layouts | generally available | [11:19](https://www.youtube.com/watch?v=jricCM_04H4&t=679s) | "we added in the last release wave through three Excel reports so they have already generally available but in this release wave we also" ([11:19](https://www.youtube.com/watch?v=jricCM_04H4&t=679s)) | | Legacy Excel Reports Deprecation | status not stated, demoed | [12:00](https://www.youtube.com/watch?v=jricCM_04H4&t=720s) | | ## AL objects mentioned As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named. - query "Sales Order Performance Analysis" at [9:05](https://www.youtube.com/watch?v=jricCM_04H4&t=545s) - query "Fixed Asset Ad Hoc Analysis" at [10:59](https://www.youtube.com/watch?v=jricCM_04H4&t=659s) Not found in BC28-30: query "Sales Order Performance Analysis", query "Fixed Asset Ad Hoc Analysis". ## Quotes - [0:30](https://www.youtube.com/watch?v=jricCM_04H4&t=30s) "made the Excel reports that were in preview generally available it's not only that we made sure they worked but we also applied a" - [2:32](https://www.youtube.com/watch?v=jricCM_04H4&t=152s) "since this is an Excel report you just get the download you don't get a print option here so let's download uh and run" - [3:53](https://www.youtube.com/watch?v=jricCM_04H4&t=233s) "these Excel reports are the the main reason we use Excel is to have interactivity with pivot tables and slices and so on" - [10:18](https://www.youtube.com/watch?v=jricCM_04H4&t=618s) "we made three of the Excel reports or the three preview report reports in Excel generally available fixed assets analysis fixed asset details and" - [10:38](https://www.youtube.com/watch?v=jricCM_04H4&t=638s) "as a bonus that you already have in your environment today if you're on a version 25.3 or later" - [12:40](https://www.youtube.com/watch?v=jricCM_04H4&t=760s) "in business Central the Legacy Excel reports are the ones you find under the Excel reports menu and then they they now have a" - [13:00](https://www.youtube.com/watch?v=jricCM_04H4&t=780s) "later release wave this group will be removed and you can you should only be able to find these in the RO Explorer" ## Disclaimers in the video - [8:35](https://www.youtube.com/watch?v=jricCM_04H4&t=515s) coming-later: it will come in version 26.1 - [13:00](https://www.youtube.com/watch?v=jricCM_04H4&t=780s) coming-later: they will be removed from the product