The Trading Partner Reconciliation Report is a report that can be used to validate the system's transactional data and earnings data regularly. It is intended to be periodically shared with Trading Partners. If you would like to have this report enabled, please raise a Helpdesk ticket and a member of the Customer Success team will respond to you.
The TPRR is available within the Reports area of the Trading Programs app and can be viewed by users with read access to this area. The report is downloadable as an XLSX file, with 5 tabs:
- DT Earnings
- YTD Reconciliation
The Levels and Growth tabs will only be included when the report includes program lines utilizing targeted mechanism plugins. Tabs will not be included if no data exists for them.
The TPRR contains a number of filters that are similar to other reports within the Trading Programs app:
Trading Partner: a user can select a single trading partner.
Program line type: a user can select multiple program line types.
Program line ID: a user can select multiple program lines to filter the report down. These program line IDs will be filtered down to those that belong to the selected trading partner, where a trading partner has been selected.
Dimension Item: a user can select multiple dimension items. These dimension items will be filtered down to those that belong to the selected trading partner if a trading partner has been selected and the dimension operates at the trading partner level. A dimension item selector is available for each dimension that has been configured as a “Dimension for Reconciliation Filtering” by Enable’s Customer Success team.
Dimension Collection Attribute: a user can select multiple Dimension Collection Attributes from a searchable list. A Dimension Collection Attribute is available for each Dimension Collection Attribute that has been configured as a “Collection Attribute for Reconciliation Filtering” by Enable’s Customer Success team.
Transaction Date: a user can select a date range for transaction dates. This date range must span less than 12 months and cannot span multiple years (as data is shown for the current year).
Currency: a user can select a single currency.
Include interim trading programs: a user can choose whether interim trading programs should be included in the report.
You will see the following five tabs on the report itself:
After opening the downloaded report, you will see the Title tab. This tab displays all of the search criteria used and the selected filters.
DT Earnings Tab
To view the DT earnings, click on the DT earnings tab located at the bottom of the document. The DT Earnings tab displays earnings data on a per program line basis. It can be configured to report earnings across a number of dimensions, in the same way that view-bys can be applied to other program lines. This configuration must be handled by Enable’s Customer Success team.
YTD Reconciliation Tab
To view the YTD Reconciliation, click on the YTD Reconciliation tab located at the bottom of the document. The YTD Reconciliation tab displays year to date transacted (value) information by dimension item for the selected trading partner and currency. The dimension items that are displayed are determined by a configuration setting that is handled by Enable’s Customer Success team.
The YTD Sales column is the sum of the totals of each Dimension Item from the preceding months and the current month to provide a year-to-date total. For example, the March 2019 YTD Sales column for a Dimension Item will be equal to the sum of that dimension item's January 2019, February 2019, and March 2019 Total columns.
Once all of the months in the calendar year have been listed, this tab will display transactional data by dimension item and program line type.
To view the Levels, click on the Levels tab located at the bottom of the document. The Levels tab displays targets and rates for program lines that use the targeted mechanism plugin. Each row represents the level of a target band, grouped by the Program Line. The target bands are displayed in ascending order of their value.
To view the Incentives, click on the Incentives tab located at the bottom of the document. The Growth tab contains transaction data (units and value) for each program line displayed by month in the current calendar year. The current calendar year is determined by the transaction date filters.
Growth % is the total transacted values for the current year as a percentage of growth over the previous year's baseline values. Rebate % is the earnings value as a percentage of the current year's transactions.
If you believe that the Trading Partner Reconciliation Report may be of use to you and your trading partner, please raise a Helpdesk ticket and the Customer Success team will be on hand to configure this functionality for you.