Reconciliation in Excel

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

This article describes the reconciliation features of Finance agents in Microsoft 365 Excel.

Finance agents provide process-specific workflows to help revolutionize how finance professionals approach their work. Finance agents combine the power of AI with user-friendly functionality to maximize productivity, enhance accuracy, and reduce the time that's spent on manual processes.

Financial Reconciliation Agent

More specifically, the Financial Reconciliation agent empowers accounting teams through a sophisticated but user-friendly tool that enhances the accuracy and efficiency of reconciling financial data.

Assistive and Autonomous

• Assistive: the Financial Reconciliation agent can assist users "in the moment" as they are actively performing a reconciliation.
• Autonomous: the Financial Reconciliation agent can be set to perform the reconciliation autonomously creating even greater efficiency.

Effortless financial reconciliation

• The Financial Reconciliation agent 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, streamlining the reconciliation process.

Intuitive user interface

• The add-in is accessible through the Finance agents 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.
• The Financial Reconciliation agent 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.