Reconciliation in Excel (preview)

[This article is prerelease documentation and is subject to change.]

This article describes the reconciliation features of Microsoft 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.

Variance analysis

Coming soon