--- id: video/gMyp9JkXf9g type: video title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" summary: "Business Central 2024 release wave 1 adds eight Excel reports for finance and sales: trial balances, receivables and payables aging, and customer top list. They are marked preview but described as fully functional. The session covers how to find the reports, data aggregation limits and the roadmap, and demos Copilot in Excel (preview) finding outliers in vendor aging data." tier: official language: en tags: - excel reports - trial balance - accounts receivable - accounts payable - aging reports - copilot in excel - data analysis - report discovery - customer top list system: finance review: state: reviewed by: opus at: "2026-10-07T23:09:46.433Z" flags: [] generated: at: "2026-10-07T23:09:46.479Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 11cf417cd9ab54f6915adbff2bd684079b835584a42c74f9e490d62ab66443b0 evidence: - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s title: "Trial balance Excel report: preview" date: "2024-04-04T13:30:25.000Z" commit: null t: 78 quote: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s title: "Accounts receivable aging report: preview" date: "2024-04-04T13:30:25.000Z" commit: null t: 78 quote: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s title: "Customer top list report: preview" date: "2024-04-04T13:30:25.000Z" commit: null t: 78 quote: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s title: "Accounts payable aging report: preview" date: "2024-04-04T13:30:25.000Z" commit: null t: 78 quote: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s title: "Copilot in Excel - data analysis: preview" date: "2024-04-04T13:30:25.000Z" commit: null t: 720 quote: right now in preview as of April or March 2024 U there's also new things coming in Excel - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 78 quote: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=280s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 280 quote: for the trial balance uh we have decided that the aggregation level is of course accounts the - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=300s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 300 quote: we have broken it down per Dimension values in this case where we have also included account categories there's a further uh breakdown there - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=321s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 321 quote: we found out that when we're looking at data around at 100,000 rows is what is manageable uh performance- wise - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=583s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 583 quote: in this release in in in the first wave uh April wave we have released eight reports the trial balances and payables and receivables - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=583s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 583 quote: we want to include uh more Finance reports the consolidation reports the uh closing trial balances uh we want to include more reports for - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 720 quote: right now in preview as of April or March 2024 U there's also new things coming in Excel and since Excel reports are in - kind: video url: https://www.youtube.com/watch?v=gMyp9JkXf9g&t=881s title: "What's New: Excel Reports for Finance and Sales (2024 release wave 1)" date: "2024-04-04T13:30:25.000Z" commit: null t: 881 quote: we have machine learning on AI to suggest something for a human being to go and control so I'm always in the loop I links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: gMyp9JkXf9g channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=gMyp9JkXf9g published_at: "2024-04-04T13:30:25.000Z" duration_s: 1099 captions: full audience: - functional consultant - administrator - end user - decision maker chapters: - t: 0 title: Introduction and session overview - t: 57 title: Discovering Excel reports - t: 118 title: Finance reports - trial balance - t: 280 title: Excel report limitations and data aggregation - t: 352 title: Sales reports - receivables and top customers - t: 563 title: Roadmap and upcoming reports - t: 685 title: Copilot capabilities introduction - t: 720 title: Copilot in Excel demo - outlier detection - t: 900 title: Key takeaways and user recommendations - t: 981 title: Additional resources and closing features: - name: Trial balance Excel report status: preview t: 118 verified: true status_source: video - name: Accounts receivable aging report status: preview t: 352 verified: true status_source: video - name: Customer top list report status: preview t: 352 verified: true status_source: video - name: Accounts payable aging report status: preview t: 352 verified: true status_source: video - name: Copilot in Excel - data analysis status: preview t: 720 verified: true status_source: video - name: Open in Excel functionality status: unclear t: 685 verified: false status_source: video objects_mentioned: - report Trial balance - report Age receivables - report Age payables - report Top list - report Customer top report - report Consolidation reports - report Closing trial balances - report Balance to date reports - report Asset list - page Report Explorer quotes: - t: 78 text: they are marked with preview for now because we might have some design changes we want to do but they're fully functional check: exact - t: 280 text: for the trial balance uh we have decided that the aggregation level is of course accounts the check: fuzzy - t: 300 text: we have broken it down per Dimension values in this case where we have also included account categories there's a further uh breakdown there check: snapped - t: 321 text: we found out that when we're looking at data around at 100,000 rows is what is manageable uh performance- wise check: exact - t: 583 text: in this release in in in the first wave uh April wave we have released eight reports the trial balances and payables and receivables check: exact - t: 583 text: we want to include uh more Finance reports the consolidation reports the uh closing trial balances uh we want to include more reports for check: exact - t: 720 text: right now in preview as of April or March 2024 U there's also new things coming in Excel and since Excel reports are in check: exact - t: 881 text: we have machine learning on AI to suggest something for a human being to go and control so I'm always in the loop I check: exact --- # What's New: Excel Reports for Finance and Sales (2024 release wave 1) > Business Central 2024 release wave 1 adds eight Excel reports for finance and sales: trial balances, receivables and payables aging, and customer top list. They are marked preview but described as fully functional. The session covers how to find the reports, data aggregation limits and the roadmap, and demos Copilot in Excel (preview) finding outliers in vendor aging data. [Watch on YouTube](https://www.youtube.com/watch?v=gMyp9JkXf9g) · Microsoft Dynamics 365 Business Central (YouTube) · 2024-04-04 · 18:19 · tier official · reviewed (checked by Opus) ## Overview The session covers the Excel reports released in the April 2024 wave, where eight reports were released across trial balance, payables and receivables. It shows how to find the reports, then walks through the trial balance report, the accounts receivable aging report and the customer top list. It also explains data limits: the reports use aggregated data, not transaction-level detail. The session lists reports planned for later, then demos Copilot in Excel, including outlier detection. It closes with the point that Copilot suggestions need human review. ## Key points - The new Excel reports are marked preview because their design may still change, but the presenter says they are fully functional. You can find them on the role centers, in the Report Explorer (search for 'preview') or with Tell Me. - Eight reports shipped in 2024 release wave 1: trial balances, receivables aging, payables aging and the customer top list. - Trial balance data is aggregated at account and selected-period level, with no daily totals, and broken down by dimension values and account categories. About 100,000 rows was found to be manageable for performance. - Trial balance has slicers for dimensions and account categories, comes in local currency and additional reporting currency versions, and has a printable layout plus raw data for pivot tables and charts. - The accounts receivable aging report filters by aging date, due date, period length and count, can skip customers with zero balance, and offers views by period, local currency and currency. Data is aggregated per customer per period with a dimension breakdown. - The customer top list report shows top customers by sales or balance with a chart. The top count can be changed, for example to 100. - Planned reports include consolidation, closing trial balances, customer and vendor balance-to-date reports based on ledger entries, and then fixed assets, jobs, manufacturing and possibly service. ## Chapters - [0:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=0s) Introduction and session overview - [0:57](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=57s) Discovering Excel reports - [1:58](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=118s) Finance reports - trial balance - [4:40](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=280s) Excel report limitations and data aggregation - [5:52](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=352s) Sales reports - receivables and top customers - [9:23](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=563s) Roadmap and upcoming reports - [11:25](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=685s) Copilot capabilities introduction - [12:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s) Copilot in Excel demo - outlier detection - [15:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=900s) Key takeaways and user recommendations - [16:21](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=981s) Additional resources and closing ## Features | Feature | Status | At | Evidence | |---|---|---|---| | Trial balance Excel report | preview, demoed | [1:58](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=118s) | "they are marked with preview for now because we might have some design changes we want to do but they're fully functional" ([1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s)) | | Accounts receivable aging report | preview, demoed | [5:52](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=352s) | "they are marked with preview for now because we might have some design changes we want to do but they're fully functional" ([1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s)) | | Customer top list report | preview, demoed | [5:52](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=352s) | "they are marked with preview for now because we might have some design changes we want to do but they're fully functional" ([1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s)) | | Accounts payable aging report | preview | [5:52](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=352s) | "they are marked with preview for now because we might have some design changes we want to do but they're fully functional" ([1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s)) | | Copilot in Excel - data analysis | preview, demoed | [12:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s) | "right now in preview as of April or March 2024 U there's also new things coming in Excel" ([12:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s)) | | Open in Excel functionality | status not stated | [11:25](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=685s) | | ## 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. - report "Trial balance" at [2:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=138s) - report "Age receivables" at [2:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=138s) - report "Age payables" at [2:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=138s) - report "Top list" at [2:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=138s) - report "Customer top report" at [6:13](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=373s) - report "Consolidation reports" at [10:03](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=603s) - report "Closing trial balances" at [10:03](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=603s) - report "Balance to date reports" at [10:03](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=603s) - report "Asset list" at [10:44](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=644s) - page "Report Explorer" at [1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s) Not found in BC28-30: report "Age receivables", report "Age payables", report "Top list", report "Customer top report", report "Consolidation reports", report "Closing trial balances", report "Balance to date reports", report "Asset list", page "Report Explorer". More than one object has this name, so none is linked: report "Trial balance". ## Quotes - [1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s) "they are marked with preview for now because we might have some design changes we want to do but they're fully functional" - [4:40](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=280s) "for the trial balance uh we have decided that the aggregation level is of course accounts the" - [5:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=300s) "we have broken it down per Dimension values in this case where we have also included account categories there's a further uh breakdown there" - [5:21](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=321s) "we found out that when we're looking at data around at 100,000 rows is what is manageable uh performance- wise" - [9:43](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=583s) "in this release in in in the first wave uh April wave we have released eight reports the trial balances and payables and receivables" - [9:43](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=583s) "we want to include uh more Finance reports the consolidation reports the uh closing trial balances uh we want to include more reports for" - [12:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s) "right now in preview as of April or March 2024 U there's also new things coming in Excel and since Excel reports are in" - [14:41](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=881s) "we have machine learning on AI to suggest something for a human being to go and control so I'm always in the loop I" ## Disclaimers in the video - [1:18](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=78s) preview: they are marked with preview for now because we might have some design changes we want to do but they're fully functional - [12:00](https://www.youtube.com/watch?v=gMyp9JkXf9g&t=720s) preview: right now in preview as of April or March 2024 Presenters (as heard): Brian Nilson, Kenny Pontop.