Getting Started

Before you can set up and create reconciliations, ensure that the company is configured to use the Eagle app, either as a Service Agency or as a Single Company. To learn more about the initial setup of the Eagle app, see Getting Started with Eagle.

Set up Reconciliations

Reconciliations are managed using the Workflow Automations feature in the Eagle app. This allows you to create and manage reconciliations in a structured way, defining the steps, parameters, and functions needed for each reconciliation type. This documentation begins by setting up reconciliation codes, table setup codes, and reconciliation tolerances. You will reference these components later when configuring the reconciliation in the Workflow Automation.

Step 1: Create Reconciliation Codes

A reconciliation code serves as a unique identifier for each reconciliation and links related reconciliations together. By defining reconciliation codes, you can configure specific settings for each one, such as enabling specifications for line-level details and determining how reconciliation lines are sorted and displayed.

Choose the search icon, enter Reconciliation Codes, and then choose the related link.
Select New.
Enter a code and a descriptive name for the reconciliation code.
Optionally enable specification to allow applying specifications to each line in the reconciliation, which is particularly useful for balance sheet reconciliations.
Optionally select the field by which to sort the reconciliation lines, and specify the sort order.

Step 2: Create Reconciliation Table Setup Codes

A Table Setup Code defines the data table for reconciliation and how entries are grouped and displayed. It also specifies which page opens when drilling down into entries, making it easier to review and navigate the underlying data.

Choose the search icon, enter Reconciliation Table Setup List, and then choose the related link.
Select New. Or, choose Add Default Settings to create default table setup codes that you can modify. Then, continue to Step 4: Create a Workflow Automation.
Enter a code and a descriptive name for the table setup code.
Select which table to use for the reconciliation in the Table No. field. For example, if you want to use the General Ledger Entries table, select G/L Entry with ID 17.
Select which page to open when drilling down to the entries in the reconciliation in the Page No. field.
Select which field to use for the value in the reconciliation in the Sum Field No. field. For example, if you want to use the amount in local currency, select Amount LCY with ID 17 in the G/L Entry table.
Select which field to apply a date filter on in the reconciliation in the Date Field No. field. For example, if you want to use the posting date, select Posting Date with ID 4 in the G/L Entry table.
Select the Add Field action on the Grouping FastTab to specify how the entries in the reconciliation should be grouped. For example, if you want to group by account number, select G/L Account No. with ID 3 in the G/L Entry table.

Tip

You can create multiple table setup codes for different reconciliation types, such as balance sheet, income statement, or sales reconciliations using item ledger entries. You can group by several fields, like account number, item number, or dimensions such as department or project. This lets you tailor reconciliations to your specific needs and analysis requirements.

Tip

In a reconciliation, you can compare one table setup code to another. For example, compare a table setup code with general ledger entries to one with budget ledger entries to analyze variances between actuals and budgeted amounts.

Step 3: (Optional) Create Reconciliation Tolerances

Reconciliation tolerances define acceptable variances in reconciliations, either as a percentage or an amount, in absolute or relative terms. This automates the process by marking lines within tolerance as handled, while lines outside tolerance require manual review.

Tolerances are optional but help streamline reconciliations by ensuring that only significant discrepancies require review. You can apply tolerances to individual reconciliation lines, groups of lines, or all lines in a reconciliation.

Choose the search icon, enter Reconciliation Tolerances, and then choose the related link.
Select New.
Enter a code and a descriptive name for the tolerance.
In the Type field, choose what the tolerance applies to.
Optionally, enable Absolute Tolerance to set a fixed range, such as 5. This allows values between -5 and 5, regardless of whether they are positive or negative.
Enter the tolerance thresholds on the Tolerances FastTab.

Step 4: Create a Workflow Automation

In the workflow, you define how a reconciliation is performed. This includes which reports to generate, the steps to follow, and the parameters to use, such as the periods to reconcile, compare, and reference. This setup ensures that each reconciliation process is consistent and repeatable.

Choose the search icon, enter Workflow Automations, and then choose the related link.
Choose the New action.
Enter a descriptive Name for the workflow automation, such as Balance Sheet Reconciliation - Last Month, Income Statement Reconciliation - Last Quarter, or Sales Reconciliation - Last Week depending on the type of reconciliation you want to create.
Select the Links field to add the relevant links, if applicable. For example, a manual for how the reconciliation should be carried out.
1. Choose the New action.
2. Enter a Description for the link and enter the URL.

Step 5: Create Parameters in the Workflow Automation

Parameters let you set dynamic date filters for each reconciliation. Instead of using fixed dates, parameters allow you to reference relative periods such as "last month", "current quarter", or "last day of last month". This ensures your reconciliations always use the correct time frames, making the process more efficient.

Parameters can be applied to all reconciliations, functions and KPIs in the workflow automation. For example, you can use parameters to set the reconciliation period and comparison period for the reconciliation, or to set the date range for a report that is part of the workflow automation.

Select the Parameters action on the Workflow Automation.
Select New.
Enter a code and a descriptive name for the parameter, such as Reconciliation Period or Comparison Period.
In the Date Calculation Type field, select Date Range to pick a Date Code (like "last month" or "current quarter"). Or, select Date Formula to set a code for a single date, such as "last day of last month".
In the Date Code field, select a predefined date code or create a new one. For example, you can use the predefined date code CM-01M for the last month and CM-02M for the comparison period, if you want to compare to the previous month.

Tip

Use the FactBox to preview and verify the date filter before applying it.

Step 6: Set up Reconciliations in the Workflow Automation

Select the Reconciliation Setup action on the Workflow Automation.
Select New.
Select a Reconciliation Code from the list you created in Step 1.
Select Comparison Type depending on what to compare in the reconciliation. For example, if you want to compare the difference between two periods, select Period. See more information in the table below.
Select a Difference % Calculation. The options are:
- Index: Divides Value by the Value (Compared).
- % of Value: Divides the Difference by the Value.
- % of Value (Compared): Divides the Difference by the Value (Compared).
Optionally, select a Tolerance Code to automatically handle lines within the specified tolerance; lines outside the tolerance will require review. Optionally, enable Exclude Values Within Tolerance to create only records that fall outside the defined tolerance.
Select the appropriate Table Setup Code from the list you created in Step 2 to define which data table will be used for the reconciliation values. If your chosen Comparison Type requires it, also select a Table Setup Code (Compared) to specify the table for comparison.
Specify a Filter to apply to the entries in the reconciliation. For example, if you want to filter by specific account number(s) or dimension(s). Also specify the Filter (Compared) if you selected a Table Setup Code (Compared).
In the Period field, select the date parameter for the reconciliation, such as Reconciliation Period. This applies the date filter to the entries. If your Comparison Type requires it, also select the Comparison Period.
Optionally, select a Reference Setting to specify a benchmark period for the reconciliation, such as last quarter (divided by 3) or the same month in the previous year. This lets you compare current results with historical
periods for deeper analysis.
Optionally, add additional Reconciliation Setup entries to the workflow automation to create multiple reconciliations within the same workflow. For example, you can set up a sales revenue reconciliation for department A and another for department B, allowing you to manage and analyze several reconciliations in a single, streamlined process.

Tip

Use Lines in Workflow Reconciliation Setup to set line-specific options, such as tolerances or to add specifications, like linking to a customer or vendor balance report. Enable specifications in the Reconciliation Code to use this feature. Use Groups to organize lines into groups for the reconciliation.

Comparison Types

The following comparison types are available for use in the reconciliation process:

Comparison Type	Description
Period	Compare values from two separate time periods, such as the current month and the previous month, for the same groupings (like item, account, or dimension). Use this option to analyze trends or changes over time within the same source data.
Filter	Compare values by applying a specific filter within the same source data and period, such as focusing on a particular account, dimension, or segment. Use this option, for example, to compare sales for a specific product line or department to the associated cost of goods.
Period & Filter	Compare values from two separate time periods while applying a specific filter to each period. This allows for detailed analysis of changes over time within a specific segment, such as comparing sales performance for a particular product line across two different months.
Table & Filter	Compare values from two different data tables, such as general ledger entries and budget entries, while applying specific filters to each table. This option lets you analyze variances between actual and budgeted amounts or compare different source data using the same period.
Table & Filter & Period	Compare values from two different data tables while applying specific filters and comparing across two separate time periods.
None	No comparison is made, and the reconciliation will only show the values from the selected table setup code. This option is useful for simple reconciliations where no comparison is needed, such as a basic balance sheet reconciliation.

Tip

Use Opposite Sign to reverse values in the reconciliation.
This can be useful, for example, when comparing revenues and expenses to show gross profit per line, displaying revenues as positive values.

Step 7: Add Functions and KPIs to the Workflow Automation

Functions and KPIs enhance the reconciliation process by delivering insights and supporting information. Functions can include reports, such as customer or vendor balances, while KPIs can display key metrics related to the reconciliation, like the number of open lines. The only mandatory function is the Create Reconciliation report, which generates the reconciliations for the workflow automation.

Add the report Create Reconciliations with ID 71389576 to the workflow automation on the Functions FastTab. No filters or settings are mandatory for this report.
1. Optionally add other Functions, such as reports. For example, this is useful when setting up balance sheet reconciliations to be able to link to a customer balance report to a specific account in the reconciliation.
Optionally add KPIs to the workflow automation.
Choose the Select and Insert action on the Steps FastTab to add the function(s) as step(s).

Tip

Enable the Process Automatically field on the step to run it automatically.

You are now ready to begin the reconciliation process. Select the Start Workflow action on the Workflow Automation to initiate your reconciliations.

Tip

For quick access to reconciliations from the Workflow Automation, add a KPI to show their count. Alternatively, add a function to open the Reconciliations page (ID 71389610) or the Reconciliation Lines page (ID 71389608), instead of using Alt+Q to search for reconciliations.