Share via


Reconcile with subledger to general ledger reconciliation agent

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users by admins, makers, or analysts Apr 2025 -

Business value

Reconciliation of data is a time-consuming process that you often defer until the end of a period. This deferral adds time and headaches to the completion of period end tasks. The subledger to general ledger reconciliation feature changes this process to be proactive rather than reactive when it identifies a difference. Use Copilot to notify you of a difference between the subledger and the general ledger, provide options for how to resolve the issue, and eventually resolve the issue on your behalf. Reconciliation is no longer a bottleneck but is always in a continuous state of readiness.

Feature details

The first reconciliation copilot automations focus on reconciling subledgers to the general ledger balances. SQL Server Reporting Services (SSRS) reports are replaced with a near-real-time process that proactively notifies the finance team of any reconciliation issues. Upon recognition of an issue, Copilot identifies the mismatched transactions and provides a solution. That solution might be changing a setting on the main account (such as don't allow manual entry) or recognizing when a posting profile change causes a different balance sheet account to be used for reconciliation.

An audit trail is maintained when you identify issues, along with the solution. Copilot learns from the solutions of the past and moves toward automatic resolution to any reconciliation issues (longer-term vision). Again, the audit trail tracks actions taken by Copilot.

The first releases focus on a subset of subledgers: accounts payable, accounts receivable, tax, and bank. Future releases add subledgers such as fixed assets and inventory.

Reconciliation overview

Reconciliation detail

Additional resources

Ledger and subledger accounting overview (docs)