There may be occasions where either unmatched or unreconciled turnover lines are reported in DealTrack. This will mean that these turnover lines are not being applied to qualifying deals, so it is important that these are reviewed.
Our Reconcile turnover article explains the basic concepts and functionality of reconciliation, but does not explain how to check for and fix unreconciled or unmatched turnover.
To troubleshoot data reconciliation queries, click on Config at the top of your page and then on Turnover in the drop-down menu that appears.
Next, click on the Reconcile tab where you will be shown a list of recent reconciliation jobs. This list will include any individual file imports (Addition of lines) and scheduled imports which occur at a set time each day (5am by default).
Addition of lines - Each 'addition of lines' reconciliation will give a reconciliation report for a single import only. This is useful to investigate if an issue can be isolated to a specific import.
Scheduled imports - Each 'scheduled' reconciliation will give a full reconciliation report showing all unreconciled lines that are in the system. This is useful to investigate any broad issues regarding missing turnover that cannot be isolated to specific import.
Against each reconciliation job, there is the option to download an 'Unreconciled turnover lines' or 'Unmatched to a supplier' csv file.
Unreconciled turnover lines - This file will show any turnover lines that fail to reconcile over one or more dimension references, i.e. products. This file will list the reason why each line fails i.e. missing product reference. Using this example, we can check to see if a product does in fact exist in DealTrack, or perhaps if there is a similarly named product or even a typo.
Unmatched to a supplier - This file will show any turnover lines that do not match to a supplier in the system. In the majority of cases, this is due to the supplier not existing within the system.
If your requests are specific, these can be easily handled through the Client Portal, where we can provide you with useful screenshots, csv files or links to help guides.
Where your requests are less precise in nature, it is usually more effective to set up a screen share to troubleshoot the problem with you. This will usually involve downloading the reconciliation reports (as described above) and discussing these with you. Please raise a ticket in our Client Portal to request this.