Available with: Microsoft 365 Copilot for Finance and Copilot Studio
Finance scenario: Reconcile financial data to accelerate period closing
Scenario
Improve time to close with Copilot for Finance
Aggregate sales invoice and payment data into an Excel spreadsheet, then use Copilot for guidance on how to standardize the data formatting.

Copilot in Excel
Example prompt: Suggest formulas to standardize the data formatting, including removing trailing spaces and correcting capitalization.
Use Copilot for Finance in Excel to streamline the reconciliation of accounts across customers and suppliers.

Copilot in Excel
Copilot for Finance (Preview)
Action: Open Copilot for Finance in Excel and select Reconcile data. Define the reconciliation vectors.
Review the Reconciliation Report transactions for any discrepancies.

Copilot in Excel
Copilot for Finance (Preview)
Example prompt: What are my top 3 product categories, by revenue, over the last 3 years?
Copilot in Finance in Excel analyzes the reconciliation results and provides insights and suggestions for addressing inconsistencies in the report summary.

Copilot in Excel
Copilot for Finance (Preview)
Action: Select Include the summary in the report and click Save as PDF to save a downloadable version of the report summary.
Create a custom AI agent based on the reconciliation reports and financial statements for the period closing so that you can query to understand any discrepancies based on the latest status reports.

Copilot Studio Agent
From Copilot Studio, create a new Copilot. Under the knowledge section, add the reconciliation report PDF from SharePoint.
Share the custom copilot in Teams so team members can ask the agent questions about the report.

Copilot in Teams
Action: Open the configuration pan for the Microsoft Teams channel, select Open copilot, then add the custom agent as an app in Teams. Share the agent via a link with team members.
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
What's next
Explore more Finance Scenarios
Finance Scenario LibraryStart using Copilot
Go to the Copilot app to try a new scenario now. Everyone can start with Copilot Chat and if you are licensed Microsoft 365 Copilot connects to your work data and apps.
Start using CopilotView all downloadable content
Download our functional scenario kits, scenario guides, and day in the life guides to accelerate your Copilot implementation.
View downloads