Configuring the reconciliation process

The reconciliation process attempts to reconcile transactions which have been uploaded or imported into your Enable channel by matching the transactions to your dimension and trading partner data.

The reconciliation process can either be manually triggered or scheduled. Both settings can also work in conjunction with each other.

This article will guide you through:

1. How to access reconciliation settings
2. How to manage reconciliation settings
3. Calculation queue modes
4. Standard
5. No calculations
6. Approximate affected calculations

Looking for something else?

• Trying to trigger a reconciliation report? Click here to learn how to manually reconcile transactions.

Channel admin users have access to the Config area and reconciliation settings within Enable. If you require additional help or cannot see the reconciliation page as a channel admin user, please reach out to our support team here.

To access the reconciliation settings:

Step 1: Click on Config in the green banner at the top of the page

Step 2: Click on Processing in the drop-down menu.

Step 3: Click on the Reconciliation tab. You will automatically be navigated to the Reconciliation settings area (displayed below).

Tip: You may need to click on … at the end of the visible tabs to display additional tab options.

Pending reconciliation jobs will be displayed in a table, indicating reconciliation processes which have been started but are not yet completed.

The following reconciliation settings can be configured on the right of the page:

• Enable scheduled transactions reconciliation: Set the checkbox to allow the reconciliation process to automatically generate on a scheduled basis, where the platform will attempt to reconcile transactions at a scheduled time if there has been a change in the dimensional or trading partner data. The run type will be specified as Scheduled in the reconciliation report. If the checkbox is set, the reconciliation process can still be manually triggered on an ad-hoc basis if required.
• Scheduled reconciliation ignores duplicates: Set the checkbox for reconciliation processes to ignore duplicates, i.e. if duplicate transactions exist, these won’t be prevented from being reconciled if other details on the transactions reconcile.
• Scheduled transactions reconciliation time of day: The hour at which the reconciliation process will automatically generate. Tip: This should be configured to a time of low usage/outside of your business hours to minimize impact, and ideally after any automated data imports are scheduled to ensure these are included in the reconciliation job.
• Addition of transactions triggers reconciliation: Set the checkbox for the reconciliation process to automatically generate once new transactions are imported or uploaded into Enable (recommended). The run type will be specified as Addition of lines in the reconciliation report.
• Calculation queue mode: Select the required calculation queue mode below to determine how calculations are queued post-reconciliation. Options to select from are Standard, No calculations, or Approximate affected calculations. The default mode is Standard.

• Calculations are queued normally as per the platform’s existing functionality. This is the default calculation queue mode.

• Calculations are queued following reconciliation, until a channel admin user decides to switch the calculation queue mode back to Standard.
• In this mode, imports and reconciliation take place without queuing the subsequent calculations, reducing the amount of resource required by the channel to queue a large number of calculations following an import and therefore improving performance of the channel.

Use this mode when:

• Importing large amounts of historic data, when you don’t have all of your program lines configured yet.
• Importing historic data over the course of days.
• When you want to have more control over when to queue a large number of calculation jobs, particularly at low-risk times. For example, in Standard mode, you may import large sets of data which immediately attempt to generate calculation jobs and impact the channel’s performance. With this mode, you can switch back to Standard mode during off hours for the channel’s performance to not be impacted during peak business hours.

For large one-off imports, or multiple large files being imported over the course of a few hours, we’d recommend using Standard mode, as opposed to using No calculations and importing the files before switching to Standard. This is because switching back to Standard will queue calculations for all program lines (not just affected program lines), which may end up taking more time than simply importing the files using Standard mode initially.

• Calculations are completed faster using simplified logic in certain cases.
• In this mode, the channel uses a simplified approach to match reconciled transactions to their corresponding program lines. Instead of Enable’s standard mapping process, transactions are matched to program lines based on trading partner, date range and currency.

Use this mode when:

• You have a large number of program lines using indirect rebates.
• Importing a large number of transactions you still wish to get an approximate calculation for.

What’s next?

Ready to review your reconciliation results? Learn how to generate and understand the reconciliation report here.