[This article is prerelease documentation and is subject to change.]
This article describes the reconciliation features of Microsoft 365 Copilot for Finance in Excel.
Copilot for Finance in Excel is an add-in component that's designed to revolutionize how finance professionals approach their daily tasks. Copilot for Finance in Excel combines the power of AI with user-friendly functionality to maximize productivity, enhance accuracy, and reduce the time that's spent on manual processes.
Financial data reconciliation
Copilot for Finance in Excel empowers accounting teams through a sophisticated but user-friendly tool that enhances the accuracy and efficiency of financial data reconciliation.
Effortless data reconciliation
Copilot for Finance in Excel lets accountants effortlessly reconcile two data sets that are represented as tables in an Excel workbook.
Users can select and reconcile data that resides on one or two worksheets. Therefore, the reconciliation process is streamlined.
Intuitive user interface
The add-in is accessible through the Copilot for Finance sidecar in Excel and provides a user-friendly interface for a seamless reconciliation experience.
AI-aided analysis
The AI-driven analysis of data structures suggests reconciliation rules. Therefore, less manual effort is required.
Copilot for Finance in Excel suggests a mapping for key types and monetary columns. Users can choose AI-generated parameters or customize parameters as they require.
Flexible reconciliation vectors
Users can review AI-suggested rules, and can choose to accept, regenerate, or remove suggestions before they continue.
Options let users add, remove, or modify reconciliation parameters, based on specific requirements.
Comprehensive reconciliation report
The reconciliation report categorizes transactions into unmatched, potentially matched, and perfectly matched transactions.
Clear insights into discrepancies and matched values facilitate efficient identification and resolution of financial discrepancies.
Generative AI summarization
Generative AI analyzes reconciliation results and provides insights and suggestions for addressing inconsistencies in the report summary.
Transaction details provide more information about reconciled finance, together with AI-suggested troubleshooting steps.