Fix Microsoft Finance Agents (Copilot for Finance): Setup & Errors
Why This Is Happening
I've seen this exact situation on dozens of enterprise deployments: a finance team hears about Microsoft Finance agents , formerly known as Copilot for Finance, gets excited, tries to open it in Excel or Outlook, and runs straight into a wall. Nothing loads. The add-in panel is blank. Or the ERP connection refuses to authenticate. Or the reconciliation feature simply isn't there at all, even though someone swore it was enabled in the admin center.
I know this is frustrating, especially when your month-end close is two days away and you were counting on the Financial Reconciliation agent to cut your workload in half.
Here's the honest explanation for why Finance agents breaks in so many different ways, and why Microsoft's own error messages rarely tell you what's actually wrong.
The licensing gap is the number-one culprit. Microsoft Finance agents requires a Microsoft 365 Copilot license specifically, not just any Microsoft 365 subscription. Many organizations have Microsoft 365 E3 or E5 and assume everything Copilot-related is included. It's not. Finance agents sits on top of the Copilot license tier, and if that license isn't assigned to the user, the add-in will appear to install but produce a blank or broken experience with no clear error.
Deployment path confusion is the second biggest issue. Finance agents can be deployed two ways: by an IT admin through the Microsoft 365 admin center (admin-deployed), or directly by a business user from AppSource (user-deployed). These two paths have different permission requirements. Admin-deployed installations behave differently in Outlook versus Excel. When IT deploys the add-in to users who then try to reinstall it themselves, or vice versa, conflicts emerge that are hard to diagnose without knowing which path was used first.
The ERP connector in Outlook adds a third layer of complexity. For the collections workflow inside Outlook, Finance agents connects to your ERP system, Dynamics 365 Finance, SAP, or other supported ERPs. That connection requires specific credentials, proper OAuth configuration, and in many cases firewall rules that IT hasn't opened yet. When the ERP handshake fails, Outlook just shows a spinner or a vague "something went wrong" message.
Language and region restrictions catch people off guard. As of this writing, Finance agents, both its AI-generated content and its entire user interface, is only available in United States-based English (En-US). If your Microsoft 365 tenant is set to a different locale, or your individual user profile has a non-US regional format, parts of Finance agents may not render at all, or the AI features like email summarization and suggested responses simply won't appear.
Finally, data preparation is a step most users skip entirely, and it's what breaks the Financial Reconciliation agent and the newer Variance Analysis feature in Excel. Finance agents expects your financial data to be structured in a specific way before the matching process can run. Skipping that prep step is like trying to run a formula on unformatted cells, it just fails silently.
The good news: every one of these issues is fixable. Browse all Microsoft fix guides →
The Quick Fix, Try This First
Before you spend an hour digging through admin settings, run through this checklist. In my experience, about 60% of Finance agents problems trace back to one of these four things, and fixing any one of them resolves the issue immediately.
Step 1: Verify the Microsoft 365 Copilot license. Open a browser and go to the Microsoft 365 admin center at admin.microsoft.com. Navigate to Users > Active users, find the affected user, and click their name. Under the Licenses and apps tab, confirm that Microsoft 365 Copilot is checked. If it's missing, that's your answer. Assign the license, wait up to 24 hours for propagation, and test again.
Step 2: Check the Finance agents add-in status. In Excel or Outlook, go to File > Get Add-ins (or Insert > Get Add-ins in Excel). Search for "Finance" in the My Add-ins or Admin Managed tab. If you see Finance agents listed but it shows a warning icon or "Error" status, remove it completely using the three-dot menu and re-add it fresh. A corrupted add-in registration is surprisingly common after Windows or Office updates.
Step 3: Sign out and sign back into Microsoft 365. Close Excel and Outlook entirely. Open the Windows system tray, find the Microsoft 365 or OneDrive icon, and sign out of all accounts. Reopen Excel, sign back in with your work account, and relaunch Finance agents. Token expiry and stale authentication state cause a lot of blank-panel issues that look like broken installations but aren't.
Step 4: Confirm your regional settings match En-US. Go to portal.office.com, click your profile photo in the top-right corner, and select View account. Under Settings & Privacy, check your language and region. Finance agents currently only works with United States English (En-US). If your profile is set to another locale, the AI features won't activate even if everything else is configured correctly.
If all four of those check out and you're still stuck, move to the step-by-step section below.
The installation path for Microsoft Finance agents matters more than most Microsoft add-ins because there are two distinct deployment models, and they don't mix well. Let's get the right one set up for your situation.
Admin-deployed (IT-managed environments): Your Microsoft 365 global admin or Exchange admin needs to deploy the add-in through the admin center. In admin.microsoft.com, navigate to Settings > Integrated apps. Click Get apps, search for "Finance agents," and assign it to the relevant users or groups. The add-in then appears automatically in Outlook and Excel for those users under the Admin Managed section, no action needed on the user's end.
Business user-deployed (self-service): If your organization allows self-service add-ins, individual users can install Finance agents directly from Microsoft AppSource. In Excel or Outlook, go to Insert > Get Add-ins, switch to the Store tab, search "Finance agents," and click Add. You'll see it populate in the My Add-ins section within a few minutes.
After installation, you should see the Finance agents pane appear on the right side of Excel or Outlook. In Excel, look for the Finance agents icon in the Home ribbon. In Outlook, it appears in the message reading pane toolbar when you open a relevant customer email. If the icon is missing from the ribbon after a confirmed successful install, try closing and reopening the application once. Office sometimes needs a restart to register new COM add-ins properly.
One thing worth confirming: your Microsoft 365 Copilot license must be active, not just assigned. You can check license service status under Billing > Your products in the admin center. Occasionally a license shows as assigned but the underlying service plan hasn't been enabled, click into the license details and make sure Microsoft 365 Copilot shows a green active status.
This step is where I see the most confusion, and honestly, it's not the user's fault. The Financial Reconciliation agent in Excel and the Variance Analysis feature (currently in preview as of October 2025) both depend on your financial data being formatted and structured in a specific way before Finance agents can do anything with it.
Microsoft introduced a dedicated Financial Data Preparation feature in August 2025 specifically to automate this step. It was added precisely because so many users were starting the matching or reconciliation process on raw ERP exports, getting errors or empty results, and having no idea why.
Here's how to use it. Open Excel with Finance agents active. In the Finance agents pane, you should see an option labeled Prepare Data or similar (the exact label may vary by version, look for any step that comes before "Start Reconciliation" in the workflow). Select your source data range, typically your GL extract or subledger export, and let the Financial Data Preparation tool analyze the structure.
What it's doing behind the scenes: it's checking that date columns are recognized as dates (not text), that numeric fields don't have currency symbols that Excel can't parse, that account codes are consistent across both datasets you're trying to reconcile, and that column headers match expected field names for the matching algorithm.
If the tool flags issues, fix them in your spreadsheet first. Common problems include:
- Amount columns stored as text (formatted with a leading apostrophe or imported from a CSV with mixed types)
- Date formats that differ between datasets, e.g., one file uses MM/DD/YYYY and another uses YYYY-MM-DD
- Account codes with trailing spaces or inconsistent zero-padding
Once data preparation completes without errors, the reconciliation process has a dramatically higher success rate. Don't skip this step, even if your data looks clean visually.
The Outlook side of Finance agents is built around the collections workflow, it lets AR teams connect directly to their ERP system to see customer account data, outstanding invoices, and payment history without leaving their inbox. Setting up that ERP connection is where things get technical.
Finance agents supports ERP connections to Dynamics 365 Finance, SAP, and other compatible ERP applications. The setup steps differ slightly depending on which ERP you're on, but the core process is the same.
Open a customer email in Outlook. In the reading pane, click the Finance agents icon (it appears in the top-right of the message toolbar as a small icon, look for the Finance agents or Copilot logo). The first time you open it, you'll be prompted to Connect to your ERP. Click that button.
You'll be asked to enter your ERP environment URL and sign in with your ERP credentials. For Dynamics 365 Finance, this is typically your tenant's Dynamics 365 URL in the format https://[your-environment].operations.dynamics.com. For SAP, your admin will have provided a gateway URL. Enter those details and authenticate.
If the connection fails with an authentication error, the most common causes are:
- Your ERP user account doesn't have the correct security role assigned in Dynamics 365 or SAP to expose the APIs Finance agents calls
- Your organization's firewall or Conditional Access policies are blocking the OAuth token exchange between Microsoft 365 and the ERP endpoint
- Multi-factor authentication (MFA) isn't completing correctly, make sure you complete any MFA prompts that appear during the ERP sign-in flow
Once connected successfully, Finance agents will surface customer payment history, open invoice summaries, and account health data directly inside Outlook when you open that customer's email. You should see a panel populate with that information within 10–15 seconds. If the panel loads but shows no data, verify that the customer's email address in your inbox matches an account record in your ERP, the matching is done by email domain and contact record.
The Financial Reconciliation agent became generally available on October 10, 2025 for all Microsoft 365 Copilot customers, so if you've been waiting on a preview, you now have full access. Here's how to actually run it end to end.
Open Excel with your reconciliation data already loaded (after completing the data preparation step above). Activate Finance agents from the Home ribbon. You should see the Finance agents pane open on the right side of the screen.
Select the option to begin Financial Reconciliation. You'll be prompted to identify your two data sets: typically a "source" (like your bank statement or subledger) and a "target" (like your GL balance or trial balance). Highlight each dataset and assign it to the appropriate role using the pane controls.
Finance agents will then run its matching algorithm, it compares the two datasets and flags:
- Matched items: transactions that reconcile cleanly
- Unmatched items: transactions that appear in one dataset but not the other
- Partial matches: transactions where amounts or dates are close but not identical
The agent generates an automated reconciliation report that includes a summary of findings, documented action items for each discrepancy, and suggested possible explanations for unmatched items. This report is generated directly in Excel and can be saved for auditing purposes.
If the matching process stalls or produces an error like "Unable to process data," go back and double-check your data preparation. Nine times out of ten, the issue is a formatting inconsistency that the preparation step didn't catch, usually a column that contains a mix of numeric and text values. Filter the column, sort it, and look for any cell that doesn't behave like a number when you try to sum it.
When it works correctly, you'll see the reconciliation results populate in the pane and a new sheet or report section appear in the workbook within about 30–60 seconds for a typical dataset of a few thousand rows.
One of the most-reported Finance agents issues is: "The Outlook add-in loads and I can see my customer's account, but there are no AI-suggested email responses or email summarization features." This is a specific, documented limitation, and understanding it will save you a lot of confused troubleshooting.
Finance agents' AI content generation, including email summarization, suggested email responses to customers about outstanding invoices, and communication summaries, is currently only produced in United States-based English (En-US). This is true even if the add-in appears to load and the ERP connection works. If your tenant's default language, your user's locale, or the language detected in the email thread is anything other than En-US, those AI features simply won't activate.
Here's how to confirm and fix it:
- Go to
portal.office.comand sign in with your work account - Click your profile photo → View account → Settings & Privacy
- Under Language, confirm it is set to English (United States)
- Under Regional format, set it to United States
- Save the changes, then close and fully reopen Outlook (not just minimize, use Task Manager to verify it's closed if needed)
After restarting Outlook, open a customer email thread and activate Finance agents. This time, in addition to the account data panel, you should see an option to Generate reply or Summarize thread in the Finance agents pane. If those options are still missing after confirming the locale settings, wait 24 hours, locale changes sometimes take time to propagate through the Microsoft 365 identity layer.
The AI-generated communication summaries and action items that Finance agents creates can be saved directly from the pane, look for a Save summary button. This creates a logged record in your connected ERP or saves to a linked SharePoint location, depending on your configuration. For collections teams, this audit trail is one of the most practical time-savers the tool offers.
Advanced Troubleshooting
If you've worked through the step-by-step fixes and Finance agents is still misbehaving, the problem is likely sitting at the admin, policy, or network level. These issues typically affect entire teams rather than individual users, which is a useful diagnostic signal.
Check Microsoft 365 Admin Center, Integrated Apps Settings
In admin.microsoft.com, go to Settings > Integrated apps. Find Finance agents in the list and click it. Under the Users and groups tab, confirm that the correct users or security groups are listed. A common mistake is deploying the app to "All users" during testing, then restricting it to a pilot group later without removing the broader assignment, this creates a conflict where some users have two competing add-in registrations.
Exchange Online Mail Flow and Add-in Policies
If Finance agents loads in Excel but not in Outlook, an Exchange Online add-in policy may be blocking it. In the Exchange admin center (admin.exchange.microsoft.com), go to Organization > Add-ins. Verify that Finance agents is listed and set to On for the affected users. Some organizations have policies that allow add-ins only from specific publishers, confirm that Microsoft's publisher certificate is trusted.
Conditional Access Policies Blocking ERP Authentication
If your ERP connection in Outlook fails with an error mentioning "access blocked" or "sign-in requirement not met," a Conditional Access policy in Azure Active Directory (now Microsoft Entra ID) is likely the culprit. Check in Microsoft Entra admin center > Protection > Conditional Access > Policies. Look for policies that require compliant devices or block non-browser authentication. Finance agents uses modern authentication tokens, but if a policy requires the client to be on a managed device and the OAuth prompt is being initiated from a context that doesn't meet that requirement, authentication fails silently.
Work with your identity team to exclude the Finance agents service principal from overly restrictive policies, or to ensure that the device running Outlook meets the compliance policy requirements.
Network and Firewall Requirements
Finance agents communicates with Microsoft's Copilot services and your connected ERP over HTTPS. If your organization uses a proxy or firewall with SSL inspection, the TLS certificates for Microsoft's Copilot endpoints may be getting intercepted and causing certificate validation failures that appear as blank panes or timeout errors. Work with your network team to add the relevant Microsoft 365 Copilot endpoints to the SSL inspection bypass list, Microsoft publishes these in the Microsoft 365 endpoint documentation.
Update and Version Issues
Finance agents releases both major and minor updates on a monthly cadence. New customers get the latest version automatically. Existing customers receive email notifications about updates. If your Finance agents version is significantly behind, particularly if you're missing features like Financial Data Preparation (August 2025) or the generally available Financial Reconciliation agent (October 2025), check whether automatic updates are being blocked by your IT environment. In some locked-down environments, add-in updates require explicit admin approval through the Integrated apps dashboard.
Prevention & Best Practices
Getting Finance agents working is one thing. Keeping it working as your organization grows and Microsoft ships updates is another challenge entirely. Here's what I recommend to finance teams and IT admins who want to avoid the same troubleshooting cycle six months from now.
Assign licenses before deploying the add-in. This sounds obvious, but the timing matters. If you deploy Finance agents to users via the admin center before their Microsoft 365 Copilot licenses are active, the add-in installs in a broken state. It doesn't self-repair automatically when the license arrives later. Always confirm license assignment is complete, and propagated, which can take up to 24 hours, before you push the add-in deployment.
Standardize on admin-deployed installations for enterprise environments. User-deployed Finance agents installs are fine for small teams and individual power users, but in organizations with more than 25 people using Finance agents, admin-deployed is the right call. It gives IT visibility into who has the add-in, makes version management easier, and prevents the double-registration conflicts that happen when users install independently on top of a managed deployment.
Track the monthly release notes. Microsoft ships Finance agents updates monthly, and some of those updates are significant capability additions, like the Financial Data Preparation feature in August 2025 or the Variance Analysis preview in October 2025. Subscribe to the Dynamics 365 and Microsoft Power Platform Release planner to see what's coming and plan accordingly. Features in preview sometimes change behavior in ways that break existing workflows when they go generally available.
Document your ERP connector configuration. When you set up the ERP connection in Outlook, record the environment URL, the service account used, and the security roles required. ERP upgrades, password rotations, and tenant migrations can silently break the Finance agents connection. Without documentation, rediscovering the correct configuration from scratch takes far longer than it should.
- Set up a monthly calendar reminder to check the Finance agents release notes, new features arrive whether or not you're looking for them
- Create a shared Excel template with the correct column structure for Financial Reconciliation so your team doesn't have to re-prep data every month-end
- Test Finance agents in Outlook after every major Exchange Online update, Microsoft 365 updates occasionally reset add-in states
- Keep a list of which users are on which ERP security roles so you can quickly diagnose connection failures without involving the ERP admin team
Frequently Asked Questions
What is the difference between Finance agents and Copilot for Finance?
They are the same product, Microsoft rebranded Copilot for Finance to Finance agents. If you have documentation, training materials, or admin configurations that reference "Copilot for Finance," they still apply to the current product. The core functionality, financial reconciliation in Excel and collections support in Outlook, is the same. Microsoft made this naming change as part of a broader effort to align its AI products under the "agents" terminology, reflecting how these tools act autonomously on your behalf. All release notes from February 2025 and earlier reference the old name, while March 2025 and later use Finance agents.
Do I need a special license to use Microsoft Finance agents, or is it included in Microsoft 365?
Finance agents requires a Microsoft 365 Copilot license, which is an add-on license and not included in standard Microsoft 365 E3, E5, or Business plans. Your Microsoft 365 admin can check this in the admin center under Billing > Licenses. If Microsoft 365 Copilot isn't listed or isn't assigned to your user account, Finance agents will either not install at all or install in a non-functional state with no clear error message. Contact your IT department or Microsoft account representative to add the Copilot license to your subscription.
Finance agents works in Excel but the AI suggestions in Outlook won't show up, why?
This is almost certainly a language and region issue. Finance agents' AI-generated content, email summaries, suggested responses to customers, and action item generation, is currently only available in United States-based English (En-US). The Excel reconciliation features have broader availability, but the Outlook AI capabilities are more restricted. Go to portal.office.com > Account settings > Settings & Privacy and confirm your language is set to English (United States) and your regional format is United States. Save, fully restart Outlook, and try again. If your organization's tenant is configured for a non-US region, some features may not be available regardless of individual user settings.
Which ERP systems does Finance agents support for the Outlook collections feature?
Finance agents officially supports Dynamics 365 Finance and SAP as named ERP integrations for the Outlook collections workflow. Microsoft also lists "other ERP applications" as supported, though the configuration process for non-named ERPs requires more custom connector setup and may need involvement from your ERP vendor. The Excel-based Financial Reconciliation agent and Variance Analysis features are ERP-agnostic, they work with financial data you bring in from any source, including ERP exports, FP&A solutions, and manual spreadsheets, as long as the data is structured correctly using the Financial Data Preparation step.
Is the Financial Reconciliation agent still in preview, or is it generally available?
The Financial Reconciliation agent became generally available on October 10, 2025, for all Microsoft 365 Copilot customers. It is no longer a preview feature. If you're still seeing a "preview" label on Financial Reconciliation, your Finance agents add-in may be on an older version, check for updates via the admin center under Integrated apps. The Variance Analysis feature, which analyzes forecasts, budgets, and financial variances in Excel, was introduced as a preview in the same October 2025 release and is still in preview as of this writing.
How do I save reconciliation reports and email summaries that Finance agents creates?
In Excel, after the Financial Reconciliation agent completes its analysis, the reconciliation report summary and action items are generated directly in your workbook. You can save these as a standard Excel file for future reference and auditing, the report is designed to serve as a formal audit trail, so keep a dated copy for each reconciliation run. In Outlook, after Finance agents generates an email summary or communication record for a customer interaction, you'll see a Save summary option in the Finance agents pane. Depending on your configuration, this saves to your connected ERP record, a linked SharePoint location, or both. Your admin determines where saved summaries go, check with IT if you're not sure where the records are being stored.