Couriers Please is a logistics company based in Australia that leads the franchised parcel delivery services and generates innovative solutions to deliver more efficiently. They deliver millions of orders on a daily basis and provide cross-border logistics services
Tracking millions of deliveries and charges manually can be time-consuming and demanding, but it’s essential to maintain the accuracy of Couriers Please charges and prevent potential financial losses. You can rely on Cointab Reconciliation to ensure the precision of your Couriers Please fee verification process.
Cointab Reconciliation software streamlines the entire reconciliation process, boosting your finance team’s productivity. Our software allows you to upload multiple files and customize the entire workflow to meet your specific requirements. We take care of verifying your ERP reports, SKU reports, Rate Card, and Pin Code master against Couriers Please invoices, identifying any overcharges or any other miscalculations.
The pincode zone report consists of the origin pincode, origin-destination and pincode zone according to the combination.
SKU report
Every product is assigned a SKU number that will give us the weight and dimension of the product.
Rate card
For each invoice, a particular amount is given according to the weight and zone of the product which is present in the rate card.
Couriers Please Invoice
Billing zone, weight, SKU Product type, Billing pincode, order ID, RTO, applied weight slab and the amount charged is given in the Couriers Please invoice that helps us in further processes.
SKU Report
Tracking millions of deliveries and charges manually can be time-consuming and demanding, but it’s essential to maintain the accuracy of Couriers Please charges and prevent potential financial losses. You can rely on Cointab Reconciliation to ensure the precision of your Couriers Please fee verification process.
Cointab Reconciliation software streamlines the entire reconciliation process, boosting your finance team’s productivity. Our software allows you to upload multiple files and customize the entire workflow to meet your specific requirements. We take care of verifying your ERP reports, SKU reports, Rate Card, and Pin Code master against Couriers Please invoices, identifying any overcharges or any other miscalculations.
Required Reports for Couriers Please Invoice Verification Process
Pincode zone ReportThe pincode zone report consists of the origin pincode, origin-destination and pincode zone according to the combination.
SKU report
Every product is assigned a SKU number that will give us the weight and dimension of the product.
Rate card
For each invoice, a particular amount is given according to the weight and zone of the product which is present in the rate card.
Couriers Please Invoice
Billing zone, weight, SKU Product type, Billing pincode, order ID, RTO, applied weight slab and the amount charged is given in the Couriers Please invoice that helps us in further processes.
Invoice verification
In the following reports we get to see the detailed calculations of the SKU report, Pincode master, rate card and ERP report that gives us the expected weight, dimension, zone and fee charged of all products. The software reconciles all these reports and checks if the shipping company has overcharged us on the basis of these reports.SKU Report
- The SKU number denotes the weight and dimensions of each product and it is present in the SKU report and hence it is taken into consideration.
- If the weight is not given in the ERP reports then the weight given under the weight column in the invoice is taken into consideration.
- If the dimensions of the product are given then the volumetric weight is calculated with the help of this formula “Length x Width x Height”. In order to make the calculations work, the dimensions of the volumetric weight has to be in centimeters. The calculated value will be divided by the divisor given in the divisor card and if the divisor is not present in the card then it is to be divided by 5000.
- After we get the final amount, the amount is sent to the ERP reports as well as the Courier Please invoice.
- The final weight is then rounded off to get the final slab.
- A zone is assigned to the combination of origin location and delivery location. The origin and delivery location is linked to the invoice to get the desired zone for each invoice.
- Each order is divided zone-wise i.e regionally, locally etc and then further categorized with its own indicator like a,b,c etc.
- The rates are given in the rate card on the basis of the weight of the product and the zone of the product. The charges might differ if the weight of the products increases, the rates given above are given according to an acceptable limit. The columns “courier”, “zone”, “fwd_wt_fixed” (the additional weight on which the fixed rate increases), and the “divisor” are checked with respective columns present in the Couriers Please invoice to verify if the right items are put in the invoice.
- Each product has a particular rate assigned to it which is applicable for a particular time and hence it is essential for the delivery dates to fall under this time period.
Expected forward charge
The weight limit is given in the rate card and the final slab calculated is lower or equal to the weight limit (“fwd_wt_fixed”), which means that it is equal to the “fwd_wt_fixed” then the fees charged on it is “fwd_fixed” according to the zone. If it is not equal to the “fwd_wt_fixed” column then it means that the product has more weight. The fee charged for the extra weight is “fwd_add” according to the zone. So the formula for the expected charge is:
Expected_fwd_chg = fwd_fixed + (extra_weight) x fwd_add
Expected RTO charged
If the final slab calculated is lesser or equal to the weight limit (rto_wt_fixed”) given in the rate card, that means that it is equal to the “rto_fixed” and the fee charged on it is “rto_fixed” according to the zone. If it is not equal to the “rto_wt_fixed” column then that means that the product has extra weight. The fee charged for the excess weight is “rto_add” according to the zone. The formula for the expected charge is given as:
Expected_rto_chg = rto_fixed + (extra_weight) x rto_add
Expected final amount
The final amount is derived from the final calculation of forward charge, RTO charge and tax%.
ERP .
The weight limit is given in the rate card and the final slab calculated is lower or equal to the weight limit (“fwd_wt_fixed”), which means that it is equal to the “fwd_wt_fixed” then the fees charged on it is “fwd_fixed” according to the zone. If it is not equal to the “fwd_wt_fixed” column then it means that the product has more weight. The fee charged for the extra weight is “fwd_add” according to the zone. So the formula for the expected charge is:
Expected_fwd_chg = fwd_fixed + (extra_weight) x fwd_add
Expected RTO charged
If the final slab calculated is lesser or equal to the weight limit (rto_wt_fixed”) given in the rate card, that means that it is equal to the “rto_fixed” and the fee charged on it is “rto_fixed” according to the zone. If it is not equal to the “rto_wt_fixed” column then that means that the product has extra weight. The fee charged for the excess weight is “rto_add” according to the zone. The formula for the expected charge is given as:
Expected_rto_chg = rto_fixed + (extra_weight) x rto_add
Expected final amount
The final amount is derived from the final calculation of forward charge, RTO charge and tax%.
RESULT
Our software reconciles ERP reports, Pincode master and the rate card so that we get the expected value which will further give us the expected fee charge. The expected fee charged is then reconciled by our software with the invoice provided by Couriers Please. The detailed calculation of this process is shown in the following reports.ERP .
Found in ERP
The order entries that are present in the invoice are also present in the ERP report. In order for the orders to get verified it needs to be present in both these records and in this case it is present.
Not found in ERP
These reports can not be verified since the order entries are present only in the Couriers Please invoice and not in the ERP reports.
Pincode Master
The order entries that are present in the invoice are also present in the ERP report. In order for the orders to get verified it needs to be present in both these records and in this case it is present.
Not found in ERP
These reports can not be verified since the order entries are present only in the Couriers Please invoice and not in the ERP reports.
Pincode Master
Found in Pincode master
This denotes that the order entries present in the Couriers Please invoice are also present in the Pincode master. It is essential for the order entries to be present in both these records in order to be matched.
Not found in Pincode master
In this case, the order entries are present only in the Couriers Please invoice and not found in the ERP reports and hence it cannot be verified.
Rate Card
This denotes that the order entries present in the Couriers Please invoice are also present in the Pincode master. It is essential for the order entries to be present in both these records in order to be matched.
Not found in Pincode master
In this case, the order entries are present only in the Couriers Please invoice and not found in the ERP reports and hence it cannot be verified.
Rate Card
Found in Rate card
The order entries present in the Couriers Please invoice are also found in the rate card and hence it can be verified.
Not found in Rate card
In this case, the order entries are present only in the Couriers Please invoice and not in the Rate card and hence it cannot be verified.
The order entries present in the Couriers Please invoice are also found in the rate card and hence it can be verified.
Not found in Rate card
In this case, the order entries are present only in the Couriers Please invoice and not in the Rate card and hence it cannot be verified.
Fee verification using ERP- Couriers Please
Correctly Charged
The zone of the delivery and the weight of the product also match the ERP report as well as the invoice provided by Couriers Please. With the help of the rate card the fee has also been charged correctly.
Zone Match, Weight Match – Overcharged
Even though the zone of the delivery and weight of the product both match in the ERP reports and Couriers Please invoice, the fee charged is more than the expected amount, hence in this case the fee is overcharged.
Zone Match, Weight Match – Undercharged.
In this case, the fee is undercharged even though the zone of the delivery and the weight of the product both match the ERP report as well as the Couriers Please invoice.
Zone Mismatch, Weight Match – Overcharged
This shows that the zone of the delivery and the fee do not match whereas the weight of the product matches in the ERP reports and Couriers Please invoice, hence in this case the fee is overcharged.
Zone Mismatch, Weight Match – Undercharged.
The software compares the ERP report and the Couriers Please report and shows that the zone of the product and fee charged does not match the report whereas the weight matches and hence the amount is undercharged in this case compared to the calculated amount.
Zone Match, Weight Mismatch – Overcharged
This denotes that after comparing the ERP report and the Couriers Please invoice report the weight of the product and fee do not match in both the reports, whereas the zone matches. Since the weight of the product and rate do not match, the amount is overcharged in this case.
Zone Match, Weight Mismatch – Undercharged.
In this column, the software compares the ERP report and the Couriers Please report and shows that the weight of the product and fee do not match whereas the zone matches and hence the amount is undercharged in this case compared to the expected amount.
Zone Mismatch, Weight Mismatch – Overcharged
The software here compares the ERP report and the Couriers Please report and shows that the zone, fee and weight of the product do not match. Hence the amount charged is higher than the calculated amount in this case and so it is overcharged.
Zone Mismatch, Weight Mismatch – Undercharged
In this case, the software compares the ERP report and the Couriers Please invoice report and shows that the zone, fee and the weight of the product do not match. Hence the amount charged is lesser than the calculated amount in this case and so it is undercharged.
Cointab Reconciliation streamlines and simplifies the reconciliation process by effectively comparing the above mentioned reports and minimizing manual work. It offers a clear view of all transactional activities because of its smooth data loading and processing which improves the accuracy, fastens the entire reconciliation process, streamlines your workflow and helps you make better data-driven decisions.
Start your journey to a better and effective reconciliation process with Cointab Reconciliation.
Check out our other articles-
The zone of the delivery and the weight of the product also match the ERP report as well as the invoice provided by Couriers Please. With the help of the rate card the fee has also been charged correctly.
Zone Match, Weight Match – Overcharged
Even though the zone of the delivery and weight of the product both match in the ERP reports and Couriers Please invoice, the fee charged is more than the expected amount, hence in this case the fee is overcharged.
Zone Match, Weight Match – Undercharged.
In this case, the fee is undercharged even though the zone of the delivery and the weight of the product both match the ERP report as well as the Couriers Please invoice.
Zone Mismatch, Weight Match – Overcharged
This shows that the zone of the delivery and the fee do not match whereas the weight of the product matches in the ERP reports and Couriers Please invoice, hence in this case the fee is overcharged.
Zone Mismatch, Weight Match – Undercharged.
The software compares the ERP report and the Couriers Please report and shows that the zone of the product and fee charged does not match the report whereas the weight matches and hence the amount is undercharged in this case compared to the calculated amount.
Zone Match, Weight Mismatch – Overcharged
This denotes that after comparing the ERP report and the Couriers Please invoice report the weight of the product and fee do not match in both the reports, whereas the zone matches. Since the weight of the product and rate do not match, the amount is overcharged in this case.
Zone Match, Weight Mismatch – Undercharged.
In this column, the software compares the ERP report and the Couriers Please report and shows that the weight of the product and fee do not match whereas the zone matches and hence the amount is undercharged in this case compared to the expected amount.
Zone Mismatch, Weight Mismatch – Overcharged
The software here compares the ERP report and the Couriers Please report and shows that the zone, fee and weight of the product do not match. Hence the amount charged is higher than the calculated amount in this case and so it is overcharged.
Zone Mismatch, Weight Mismatch – Undercharged
In this case, the software compares the ERP report and the Couriers Please invoice report and shows that the zone, fee and the weight of the product do not match. Hence the amount charged is lesser than the calculated amount in this case and so it is undercharged.
Cointab Reconciliation streamlines and simplifies the reconciliation process by effectively comparing the above mentioned reports and minimizing manual work. It offers a clear view of all transactional activities because of its smooth data loading and processing which improves the accuracy, fastens the entire reconciliation process, streamlines your workflow and helps you make better data-driven decisions.
Start your journey to a better and effective reconciliation process with Cointab Reconciliation.
Check out our other articles-
