Invoice Data

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.

Fields specification

Field	Type	Description	Example
Invoice Month	Date	Always the last day of the month the invoice is created for. Indicates the performance period.	2021-03-31
Parcel Invoice Date	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.	2021-03-12
Invoice Number	String	The number of the Seven Senders invoice the line was charged on.	AR21/00011XX
Account Number	String	The account number of the customer at Seven Senders. Also listed on contract and invoice document.	7506224
Account Name	String	Name of the customer account.	Company
Sub Account	String	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.	Pack Angels
Account Hub	String	Name of the pickup location of the account. Can be used to differentiate parcels from different warehouses.	Kamp-Lintfort
Carrier	String	Name of the carrier delivering the parcels to the final destination according to contract. Usually the last mile carrier.	BRT IT
Target Country	String	Destination country of the parcel. Not necessarily the country the parcel was injected in.	IT
Tracking ID	String	The tracking id of the parcel.	005851179396421
Reference Number 1	String	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.	1202155166644454
Reference Number 2	String		1-2021-5516664454
Reference Number 3	String
Weight in Kg	Number	The weight of the parcel used as invoicing basis. Usually weighted by the carrier.	2.2
Parcel Value	Number	The value of the parcel as transferred to the carrier. Can be the basis for surcharge calculations (e.g. Cash on Delivery).
Product Type	String	The type of parcel product. Three possible options: Outbound Return Undelivered	Outbound
Product	String	The specific product of the parcel. Depends on the contractual agreement and carrier.	Post Pac Prio
Charge Type	String	Defines the nature of the price component in the respective row. The type is specified in the `Charge Specification` column. Currently the following values are possible: Base Rate Fixed Rate Volume Floater Density Floater [PAC/PAL] Density Floater [PAC/PICKUP] Additional Kilo Claims Center & Insurance Pallet Places Surcharge	Base Rate
Charge Specification	String	Specifies the logic behind the `Charge Type`.	Kg per Parcel
Calculation Rule	String	Specifies how the price component is calculated. Can currently be one of the following values: Fixed Rate → a fixed agreed rate Perc. of Rate → a percentage on the rate Perc. of Value → a percentage on the parcel value Perc. of Rate and Surcharge → a percentage on the parcel rate and all surcharges linked to the parcel	Fixed Rate
Floater Basis	String	Can be one of the following values: Outbound Inbound Total If a floater (e.g. volume floater) is applied the floater basis defines the agreed quantity used to calculate the floater. In case of an outbound floater basis the number of outbound parcels per month is used in a volume floater. The floater basis links back to the charge specification.	Outbound
Calculation Basis	Number	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.	2.2
Percentage	String	The field is only filled when there is a percentage based surcharge and indicates the percentage used for calculation.	5%
Range From	Number	The range specifies the agreed classes of the price components. For base rates it will show the weight class and for floaters the floater classes. They are directly linked to the contractual agreement.	0
Range To	Number		5
Raw Amount	Number	The calculated amount for the price component. The field is only relevant for tariffs linked to another currency like rates for parcels to Switzerland.	6.25
Charged Amount	String	The raw amount adjusted for changes in the exchange rate. Depends on `reference exchange rate` and `current exchange rate`.	5.14
Currency	String	The invoice linked to the charged amount and also the invoice currency. Usually EUR.	EUR
Reference Currency	String	Indicates whether the contractual prices are linked to another currency.	CHF
Reference Exchange Rate	Number	The exchange rate at the point of price definition. Linked to the `reference currency.`	1.107
Current Exchange Rate	Number	The ECB exchange rate on the last working day of the invoice month. Linked to the `reference currency.`	1.345

Did you find it helpful? Yes No