How to Install the Finance Reconciliation Agent: A Step-by-Step Guide

If you need an assistant that matches transactions, detects discrepancies, and suggests corrective actions (and also, be autonomous) you’re in the right place. But before the magic happens, here’s a step-by-step guide to get everything installed and ready to go in Excel. Let’s dive in!

First, as always, the origin of the universe…

🌱 What is the Reconciliation Agent in Excel?

Easy-peasy: It’s an Excel Add-in that matches transactions across different tables.

In other words, it automates financial data analysis, surfaces insights that support strategic decision-making, and significantly reduces the time spent on manual and repetitive tasks.

As finance professionals, much of our time goes into matching balances and finding/correcting discrepancies. How do we usually handle this? By exporting data to Excel, manually highlighting rows that match, then going back into the system to analyze and correct transactions.

Well… if you need an assistant that matches transactions, detects discrepancies, and suggests corrective actions, this is your new best friend. 😉

It helps you spend less time on tedious tasks and more time reviewing smart suggestions; so you just focus on approving and applying the fixes.

And the best part? It all happens in seconds, or even fully automatically with the Agent.

These agents are not just assistive (providing help when you need it), but also autonomous; capable of performing reconciliations on their own to boost efficiency even further.

🌱 Finance Reconciliation Agent: Key Functionalities:

🌿 Automates comparison of financial data
🌿 Suggests reconciliation rules
🌿 Generates reports with comments and recommendations
🌿 Identifies and helps troubleshoot problematic transactions

The reconciliation report summary and documented action items are automatically prepared and can be added to the sheet, so that its everything saved for future reference and auditing purposes.

🌱 To keep in mind:

🌿 (ex) Copilot for finance is available since version .38
🌿 This environment is in version .43
🌿 Language only in en-US (English of United States)

✨Time to install it:

🌱 1. APPSOURCE

Download the apps:

🌿 Finance agents in Microsoft 365 Excel (Preview)

📎https://appsource.microsoft.com/en-us/product/office/WA200006575

🌿 Finance agents

📎https://appsource.microsoft.com/en-us/product/dynamics-365/mscrm.copilotforfinance?tab=Overview

Or directy from the workspace in D365FO:

Then, follow the steps:

Select the environment, accept the conditions and click in the ‘Install’ button:

And then, in the Power Platform Admin Center (PPAC), you´ll see:

The installed apps are:

🌱 2. POWER PLATFORM ADMIN CENTER (PPAC):

📎https://admin.powerplatform.microsoft.com/manage/environments/

Select the target Dataverse environment.

In the Resources section, start by verifying whether the apps are already installed. If so, check for available updates before proceeding.

In the list of the installed applications, you´ll see:

Next, in the access section, under Users, select See All:

On the ribbon, select Add User to add all required Finance agents users:

And then assign the security roles, clicking in the 3 dots and then Administrate security roles:

🌿 For users to create and view their templates and agents apply the following security roles: Basic User, Copilot for Finance – Finance Professional.

🌿 For users who need access to all agents and templates in an environment, assign the following role: Copilot for Finance – Administrator.

🌱 3. COPILOT STUDIO

📎https://copilotstudio.microsoft.com/environments/

Import the administrated (pre-built) agent ‘Financial reconciliation’.

⚠️ Super important!! Always check that you´re in the correct dataverse environment.

Then, access to ‘Create’.

From the list of the pre-built agents click in the ‘Financial Reconciliation (preview)’ tile: