This page should help you understand the usage and benefits of the Invoice Data dashboard.
- What is the goal of this dashboard?
- What benefits does the dashboard provide me?
- How do I use the dashboard properly?
- Fields specification
What is the goal of this dashboard?
The dashboard helps you to gain insights into their shipment costs reflected in the last invoice.
What benefits does the dashboard provide me?
With the Invoice Data dashboard you can easily check the costs breakdown of each shipment.
A breakdown of the shipment costs.
Customer can extract data from the system in order to analyze the data in depth and run “what-if scenarios” to identify and verify optimization potentials (e.g. weight cluster, rejection costs, …).
Allows customer to perform detailed invoice check: monetary checks (“Is the invoicing amount per line item correct?”) as well as factual checks (“Are the right parcels invoiced?”).
Invoice data can be extracted/downloaded.
How do I use the dashboard properly?
1. Navigate to the Comms Center and click on Invoice Data dashboard to access the dashboard.
2. Review the data, explore it further with Explore form here option or Download it in one of many available formats.
Always the last day of the month the invoice is created for.
Parcel Invoice Date
Relates to the performance date of the parcel. Usually the first hub scan. Depending on the carrier chosen it can also represent other dates.
The number of the Seven Senders invoice the line was charged on.
The account number of the customer at Seven Senders. Also listed on contract and invoice document.
Name of the customer account.
Name of sub account. A sub account represents an level below the actual account entity that can be used for separate invoices per account. They usually refer to different shops or product types.
Name of the pickup location of the account. Can be used to differentiate parcels from different warehouses.
Name of the carrier delivering the parcels to the final destination according to contract. Usually the last mile carrier.
Destination country of the parcel. Not necessarily the country the parcel was injected in.
The tracking id of the parcel.
Reference Number 1
Some carriers allow the customers to transmit certain reference numbers with the parcel. Those can for example be internal order numbers. The number and meaning of available reference numbers depends on the carrier chosen.
Reference Number 2
Reference Number 3
Weight in Kg
The weight of the parcel used as invoicing basis. Usually weighted by the carrier.
The value of the parcel as transferred to the carrier. Can be the basis for surcharge calculations (e.g. Cash on Delivery).
The type of parcel product. Three possible options:
The specific product of the parcel. Depends on the contractual agreement and carrier.
Post Pac Prio
Defines the nature of the price component in the respective row. The type is specified in the
Specifies the logic behind the
Kg per Parcel
Specifies how the price component is calculated. Can currently be one of the following values:
Can be one of the following values:
If a floater (e.g. volume floater) is applied the floater basis defines the agreed quantity used to calculate the floater.
The calculation basis indicates the value used to calculate the correct price.
For base rates the calculation basis will show the weight of the parcel. For floaters the actual value of the current month is shown and for percentage based surcharges the base value for the percent calculation is shown.
The field is only filled when there is a percentage based surcharge and indicates the percentage used for calculation.
The range specifies the agreed classes of the price components.
The calculated amount for the price component. The field is only relevant for tariffs linked to another currency like rates for parcels to Switzerland.
The raw amount adjusted for changes in the exchange rate. Depends on
The invoice linked to the charged amount and also the invoice currency. Usually EUR.
Indicates whether the contractual prices are linked to another currency.
Reference Exchange Rate
The exchange rate at the point of price definition. Linked to the
Current Exchange Rate
The ECB exchange rate on the last working day of the invoice month. Linked to the