Found in rate card
In this case, the order entries present in the Correos invoice is also found in the Rate card and hence both these records can be verified and proceeded further.
Not found in rate card
These reports denote that the order entries present in the Correos invoice are not present in the Rate card and hence these records can not be verified.
Fee verification using ERP – Correos
Correctly charged
The ERP report and the Correos invoice report is compared by the software and is shown that the order deliveries where the weight and the zone of the product are correct. The fee calculated with the help of the rate card matches the fee present in the Correos invoice.
Zone Match, Weight Match – Overcharged
Here, the software compares the ERP report and Correos invoice and shows that the zone and weight of the product both match but the fee charged is wrong and charged more, hence the fee is overcharged compared to the expected amount.
Zone Match, Weight Match – Undercharged
In this case, the software compares the ERP report and Correos invoice and shows that the zone and weight of the product both match but the fee charged is wrong and charged less, hence the fee is undercharged compared to the calculated amount.
Zone Mismatch, Weight Match – Overcharged
This denotes that the software compares the ERP report and Correos invoice and shows that the zone and the fee charged do not match whereas the weight matches, hence the fee is overcharged here compared to the expected amount.
Zone Mismatch, Weight Match – Undercharged
In this case, the software compares the ERP report and Correos invoice and shows that the zone and the fee charged do not match whereas the weight matches, hence the fee is undercharged here compared to the expected amount.
Zone Match, Weight Mismatch – Overcharged
The software here compares the ERP report and Correos invoice and shows that the weight of the product and the fee charged do not match whereas the zone of the product matches hence, the fee charged here is overcharged.
Zone Match, Weight Mismatch – Undercharged.
In this case, comparing the ERP report and the Correos report shows that the weight of the product and fee do not match whereas the zone matches. Since the weight of the product and rate do not match, the amount is undercharged in this case compared to the expected amount.
Zone Mismatch, Weight Mismatch – Overcharged
The software here compares the ERP reports and Correos invoice that shows the weight of the product, the zone of the product and the fee charged, none of it matches. Hence the amount charged is more than the calculated amount in this case and so it is overcharged.
Zone Mismatch, Weight Mismatch – Undercharged
The software here compares the ERP reports and Correos invoice that shows the weight of the product, the zone of the product and the fee charged, none of them match. Hence the amount charged is lesser than the calculated amount in this case and so it is undercharged.
To sum it all up, Cointab helps you reconcile your data and check your fee verification process seamlessly with its automated software. With Cointabs software you can get rid of all the discrepancies and avoid the manual errors. Get a detailed overview of all your transactional activities and simplify your workload.
Click on the links below to view other Invoice Reconciliation Processes-