Use Excel to reconcile financial data
Important
This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Copilot for Finance. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.
Important
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | 
Feb 29, 2024 |
Jun 2024 |
Business value
With Microsoft Copilot for Finance, users will get support to reconcile their financial data using Excel, including intelligent financial data structures comparison, automated reconciliation report creation, insights, and suggestions on possible ways to address discrepancies. The reconciliation report summary and documented action items are automatically prepared and available for saving for future reference and audit.
Account reconciliation is a process completed on a recurring basis (monthly, quarterly, and annually/year-end) as a part of financial period closure where we need to prove or confirm the accounting entries used are correct. Reconciliation ensures that financial records are accurate and free from errors or fraud. Control allows organizations to detect and rectify discrepancies promptly.
There are many dedicated tools to perform reconciliation, but none is as well-known as Excel. With this feature, users will get support to reconcile their financial data using Excel. This includes intelligent support when comparing financial data structures, automated reconciliation report creation, and insights and suggestions on possible ways to address discrepancies. The reconciliation report summary and documented action items are automatically prepared and available for saving for future reference and audit.
Feature details
Microsoft Copilot for Finance will support the following capabilities for financial data reconciliation:
- Start a new reconciliation project.
- Get Copilot-suggested relations between data structures for reconciliation.
- Perform comparison of data structures per given auto-suggested or user-defined criteria.
- Analyze reconciliation results in the system-prepared ready report that highlights any discrepancies.
- Get support and guidance on troubleshooting and resolving any discrepancies.
Geographic areas
This feature will be released into the following Microsoft Azure geographic area:
- United States
See also
Reconciliation in Excel (docs)