Support Portal

Welcome
Login

Invoice Data

This page should help you understand the usage and benefits of the Invoice Data dashboard.


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