Reducing stressful and repetitive tasks is really easy with ShippyPro, in particular when you manage your Invoices.
Click on the button below to discover if this feature is supported for your Carrier.
At the moment Invoice Analysis is available for the following Carriers:
Bartolini / BRT
Spring / Spring XBS
Let's see how it works! 🔍
- 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.
1. Upload the Invoice
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:
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.
2. View Total Costs
On the top left, you'll have a useful recap of the Total amount paid and the Total Revenue.
2. Get report with Complaints 📊
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.
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.
What if my tariffs or extra costs are wrong?
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.
Are you Shipping via API?
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.
📌 Ask your Carrier person to supply you with the invoice containing the following values as header:
CSV, name “Invoice number.csv”, first 5 columns: Line Type, billing search, original invoice number, invoice number, station code
CSV, second column is UPS Account Number, fifth column is Invoice Date, sixth is Invoice Number, eighteen is Tracking Number.