Warning: Please, note that our Carrier Invoice Analysis tool is currently under maintenance and could work in unexpected ways. Please, reach out to our Support team if you need any assistance.

Reducing stressful and repetitive tasks is really easy with ShippyPro, in particular when you manage your Invoices.

At the moment Invoice Analysis is available for the following Carriers: 

Let's see how it works! 🔍
 

From Carriers > Invoice Analysis the merchant can immediately identify surcharges that the carrier has charged to him and keep track of how much you owe and how much is owed to you.

Firstly, it's necessary to upload the invoice clicking on Upload Invoice.

💡Note: The file needs to be in CVS or XLS/XLSX (Excel format).

💡Note: Please use the following Delimiters in the CSV file:
GLS: \t
DHL and FedEx: ,
All the other Carriers: ;

💡 Note: If you flag the option ''Send me an email with discarded rows'',
you need to be sure to have inserted the correct email address in the section
My Profile > Sender info.

On the top left, you'll have a useful recap of the Total amount paid and the Total Revenue.

Under the chart, it is possible to see a graphic recap of the total costs and in grey the additional costs of every single shipment. Identifying surcharges and wrong tariffs will be really easy.

Clicking on each column, you will be then redirected to the relative shipment.

The blue columns indicate the rates and the grey columns indicate the additional costs.

Then, it will be possible to see a chart with all the details of the invoices. 

Attention:

1. Total means the total the merchant has paid for that specific shipment.

2. Tariff is what has been paid by the merchant without additional costs, as taxes, fuel surcharges etc.. This surcharges are indicated just after, under the section Fuel Surcharge, COD Surcharge, Extra Costs.

It will be then possible to see the profit in green:

And the leak in red, instead:

It is possible to see estimated weight, the weight measured by the carrier parcels' dimensions and even the departure date and the delivery date of the shipment.
 

If you identified a hidden costs or a wrong tariff, you can add notes for the Carrier in just one click and then download a new Excel with your notes on it. 

You can then send it to your carrier and ask for a refund. 

No problem! 🙌 With ShippyPro APIs you'll be able to carry Invoice Analysis so to quickly identify surcharges and wrong tariffs.

What you need to do is to make GetRates call before each Ship in order to fill this latter RateID and OrderID fields with GetRate's response datas.

This way you can keep track of your Carrier's Rates more easily than ever before.

DHL Express
CSV, name “Invoice number.csv”, first 5 columns: Line Type, billing search, original invoice number, invoice number, station code

UPS
CSV, second column is UPS Account Number, fifth column is Invoice Date, sixth is Invoice Number, eighteen is Tracking Number.