BeyondERP.Newsletter
Menu

Workspace page · General ledger

Account reconciliation

A workspace in Dynamics 365 Finance that reconciles the general ledger with the accounts payable, accounts receivable, tax, and bank subledgers and shows the exceptions it finds.

Business process
Close periods
Menu item
ReconciliationAutomationWorkspaceOverviewPage
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workspace in Dynamics 365 Finance that reconciles the general ledger with the accounts payable, accounts receivable, tax, and bank subledgers and shows the exceptions it finds.
What you do hereUse this workspace to review open and addressed exceptions and automatically reconciled transactions for each module and legal entity, and to act on each exception, with optional suggestions from the Copilot agent.
ExampleAccept an exception without change when the difference is a small amount or a rounding difference.
Account reconciliation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processClose financial periods › Close periods
Menu pathGeneral ledger › Workspaces › Account reconciliation
Set up firstProcess automations Microsoft Learn Posting profiles Microsoft Learn General ledger parameters Microsoft Learn
Used next byGeneral journals Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to General ledger > Workspaces > Account reconciliation.
  2. Use the filters at the top of the workspace to choose the period, for example the current or previous fiscal period.
  3. On the Open exceptions tile, select Mitigate exceptions.
  4. Select an exception and review its suggested action, analysis and justification.
  5. Choose an action, such as Create journal entry, Match exceptions or Accept without change.
  6. To change how an exception was handled, select Undo, enter a reason, and then select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
StatusShows how many exceptions still need attention for a module and legal entity, or Fully reconciled when none remain.Microsoft Learn
Suggested actionThe step recommended to resolve the exception.Microsoft Learn
AnalysisBackground and insight about the exception, drawn from the underlying data.Microsoft Learn
JustificationExplains why the suggested action was recommended.Microsoft Learn
Group exceptionsSwitches the list from one exception at a time to groups of exceptions that can be handled together.Microsoft Learn
Reconciliation optionTurns reconciliation on or off for each module on the configuration page.Microsoft Learn
Start dateThe date from which transactions are checked by the automatic reconciliation.Microsoft Learn
Solution architect

4Design impact

If you change it laterChanging how exceptions are grouped creates a custom grouping, and the agent summary is no longer shown until you reset to the suggested grouping. Microsoft Learn
Technical architect

5Technical

Menu itemReconciliationAutomationWorkspaceOverviewPage Checked in Dynamics 365
FormReconciliationAutomationWorkspaceOverviewPage Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccountant LedgerAccountantGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=ReconciliationAutomationWorkspaceOverviewPage
Everyone

7Sources