Blowhorn is a logistics aggregator that delivers goods to various locations by bringing together many courier partners. Many companies opt for Blowhorn as a courier partner as they would rather outsource delivery so that they can concentrate on their core products rather than worrying about handling delivery. Plus, they will be able to skip the challenging process of coordinating with several courier partners. It also provides delivery tracking and inventory storage Due to its reputation as a reliable courier partner, Blowhorn is the choice of the majority of businesses for deliveries.
When businesses employ an aggregator for delivery, they often levy a fee for every delivery. It is challenging to determine whether the rates charged for each delivery are accurate, whether they are undercharged, or whether they are overcharged. Particularly if bulk supplies are handled, a significant sum may have been overcharged. Companies must thus confirm the fee amount applied to orders or they end up incurring a loss
Therefore,Cointab’s reconciliation software would be helpful in this situation. It aids in the reconciliation of the fees levied by courier aggregators like Blowhorn. This is accomplished by examining the invoice they gave and confirming that the zone, weight, and rate used for invoicing are accurate. Following the actual charge computation, it also generates an output of the required data automatically.
Required Reports for Blowhorn Invoice Verification Process
SKU Report
This report includes the weight, dimensions, and volumetric weight of each delivered product.
Rate Card
This report includes a list of all the charges and the appropriate valid dates.
Blowhorn Invoice
This report includes the order ID, the weight that Blowhorn applied, the billing zone, the product type—which might be forward or RTO—the applied forward slab, the billing Pincode, and the total amount charged.
Blowhorn Courier Charges Invoice Verification Process
The software first confirms the rate, zone, and weight imposed by Blowhorn in the invoice. It does this by calculating the predicted rate, zone, weight, and fees. The software compares the predicted values to the invoice amounts after computing the anticipated values. The amount that was overcharged, undercharged, or appropriately charged is then shown.
Rate Card
• The rate card includes all of the rates that must be applied on orders as well as the dates that they are valid through.
• The software examines the time period within which the rates are relevant and estimates the expected rate.
Charges
Forward Charge
The F_weight column shows the weight limit till which the F_charge is applicable. It means that when the weight is less than or equal to the F_weight then the charge applied is as shown in the F_charge column. When the weight is more than the F_weight then on each extra unit as shown in the F_add column the amount charged is as in the F_add_charge column
Expected forward charge= F_charge + (F_add) x F_add_charge
RTO Charge
The rate on all returned orders are fixed in this case.
Expected RTO charge= returned_to_origin*RTO_charge
Expected COD Charges
A percentage of the item’s price or the rate shown in COD charge column is applied.
Expected GST
After adding the anticipated advance fee, anticipated RTO charge, and anticipated COD charge, the GST is applied to the total.
Expected Final Amount
The expected final sum is calculated by adding the forward charge, anticipated RTO fee, anticipated COD costs, and anticipated GST.
Blowhorn Courier Charges Invoice Verification Result
The software does the appropriate calculations for each order after verifying the expected rate, weight, and estimated charges. This shows if the anticipated rate and weight are used for billing and whether the amount charged is more or lesser as a result.
Order Management System, Rate Card Verification
Found in Unicommerce
These are the orders that are listed in the Unicommerce system, so the software can check the weight of these products.
Not Found in Unicommerce
Orders shown here are not included in the Unicommerce system, hence the software cannot confirm the weight of these products.
Found in Rate Card
Since the rate card is available for these orders, the software can check the rates for them.
Not Found in Rate Card
The rate card is not present for these orders. This implies that it is impossible to verify the rates on these orders.
Invoice Verification (SKU weight, Invoice weight)
Correctly Charged: Total Amount [SKU Wt]
These are the orders on which the fee charged by Blowhorn matches the fee amount calculated. The SKU weight and the rate is found to be correct on these orders.
Correctly Charged: Total Amount [Invoice Wt]
On these orders, the fee charged by Blowhorn matches the fee amount calculated. The invoice weight is used for calculation on these orders.
More Charged: Total Amount [SKU Wt]
Using the SKU weight for fee calculation the software compares and finds out that the fee charged is more than what was supposed to be charged.
More Charged: Total Amount [Invoice Wt]
Here using the weight applied in the invoice by Blowhorn, the software makes the fee calculation. It is seen that the fee amount charged is more than what was required.
Less Charged: Total Amount [SKU Wt]
These are the orders on which it is seen that the fee charged is lesser than what was supposed to be charged. Here is the SKU weight is used for calculations.
Less Charged: Total Amount [Invoice Wt]
For these orders, the fee charged is lesser that the calculated amount. The invoice weight is used for fee calculation on these orders.
As shown above the software presents the results of Blowhorn Courier Charges Invoice Verification by checking the fee charged on each order. This result can be used by your finance teams to analyze and track the fee payment. This way they do not need to spend extra time and effort verifying the invoice. In turn, they will be able to claim the overpaid amount from Blowhorn and avoid making any loss.
