User Guide
Create Reconciliations
To create reconciliations, begin by starting the workflow that is configured for reconciliations. You can initiate reconciliations for various types of ledger entries, including item, project, and general ledger entries.
- Choose the search icon, enter Workflow Automations, and then choose the related link.
- Find the workflow that is configured for reconciliations, and then choose the Start Workflow action.
- Depending on your configuration in Eagle Setup, you might be prompted to select the companies to reconcile. In this case, choose the desired companies from the list and select OK to proceed.
- Depending on your workflow setup, you may need to select the Process
Step to complete the workflow.
- The system creates reconciliations based on your workflow and selected companies.
View Reconciliations
After the workflow completes, you can view the reconciliations that were created.
The Reconciliations page displays all reconciliations created by the
workflow.
The Reconciliations page lists all reconciliations, including their
status, type, and the date they were created.
You can filter the list by status, type, or date to find specific
reconciliations.
- Choose the search icon, enter Reconciliations, and then choose the related link.
- Select a reconciliation to view its details, including the lines that were reconciled, the status of the reconciliation, and any work notes or comments associated with it.
- Hover over the fields to see the tooltips that provide additional information.
Important
The reconciliation process varies depending on the type of reconciliation. If you have selected Enable Specification on the reconciliation code, you can link different types of specifications to the reconciliation lines.
Analyzing Reconciliations
To view related reconciliation lines, use the Related Lines action. This shows all reconciliation lines sharing the same reconciliation code, helpful for tracking and reviewing lines linked by reconciliation code, even if they have different filters or settings.
Note
When you first select the Related Lines action, no related lines appear. After you process the workflow and create a new reconciliation with the same reconciliation code, related lines will be shown. Each time you create a new reconciliation using the same code, more related lines become available. These related lines help you identify trends and patterns across periods for the same reconciliation code, supporting better analysis and reporting.
To view details, click a value to open its entries, or use Open in New Tabs to view the entries for both the value and its compared value side by side.
Use the Summarize Selected action to view a summary of the lines you have chosen. To see a summary of all lines in the reconciliation, including total amounts and counts, select Summarize All.
You can rename columns in the settings or on the reconciliation header as needed. If you update Custom Name (Value), Custom Name (Compared), or Custom Name (Reference), close and reopen the reconciliation to see the updated names.
Tip
Use the Group action to organize reconciliation lines for easier analysis. This can be helpful, for example, when comparing actuals to budgets, such as when actuals are posted to different accounts or dimensions than the budget. Grouping allows you to combine multiple accounts or dimensions, making it simpler to compare totals and analyze variances.
Working With Lines
You can change the default sorting of lines in the settings or on the reconciliation header. After updating the sorting, close and reopen the reconciliation to see the changes.
You can add work notes to inform other users that a line needs review or to leave comments about reconciliation lines. Use the Comment field to explain, for example, why a line has a large variance or to provide additional context for a specific line.
Tip
To help others review or comment on lines, open the Reconciliation Lines page and filter for lines with similar work note or comment values. For example, if you want user Karen to review lines with her name in the Comment or Work Note fields, filter for lines containing "Karen". Then, use the Share to Teams action to share a link to the page with the user in Microsoft Teams. The recipient will see the filtered lines and can review or comment as needed.
If you need to recalculate a reconciliation, such as after posting new transactions, use the Process Again action. This refreshes the reconciliation lines using the same settings and filters, so you can review updated data without creating a new reconciliation.
To update only specific lines, select them and choose Recalculate Selected. This lets you refresh particular lines without affecting the entire reconciliation.
If a report or table is linked as a specification to reconciliation lines, use Recreate Specification Report or Recreate Table Entries to update the specification for the selected lines. This ensures the specification reflects the most current data.
When you have finished reviewing a line, select Handle Selected or check the Handled field to mark it as reviewed.
Note
It is not possible to recalculate specification reports for handled lines, but you can reopen them by choosing Set Selected as Unhandled.
Working With Specifications
You can link different types of specifications to reconciliation lines if you have enabled specifications on the reconciliation code. If the data you want to use as a specification exists in Business Central, you can choose from a report, table entries, or use another reconciliation as a specification.
See the table with examples of reports that can be set up as specifications in How To Set Up Balance Sheet Reconciliations.
Tip
When you set up a report as a specification, you can use the Report Setup action to define which values to retrieve from the report and insert it as the Specified Value on the reconciliation line.
Table transactions can be used to retrieve data from a specific table, for example, to fetch non-reviewed transactions in G/L Entries. This is useful for accounts that have a review policy. Read more about review accounts on Microsoft Learn
Using another reconciliation as a specification is helpful when, for example, an account needs to be specified by grouping all transactions from the account by, for example, customer, vendor, department or similar.
If the data does not exist in Business Central, you can use a manual specification or upload a file containing the data you want to use as a specification.
Note
The Specification action shows the linked specification if only one type is connected. If there are none or multiple types, a specification overview is displayed instead.