Skip to content
English
  • There are no suggestions because the search field is empty.

How to break down costs from a master to houses

You are working with a master shipment that has several house shipments linked to it and, for example, you receive an incoming invoice that you want to break down across the individual house shipments. Below, we explain all the required settings and the procedure.

To ensure that amounts are automatically distributed across all house shipments of a master shipment, you must first define, for each cost type, on which basis this break down should take place.

To do this, go to Master Data > Finance > ChargeTypes and open the charge type for which you want to configure the breakdown. By default, the breakdown by option is set to No breakdown. From the drop-down menu, select the basis on which this cost type should be broken down.

Following basis are available:

  • CPA Profitshare
  • Chargeable Weight
  • Equally
  • Number of Containers
  • Number of pieces
  • TEU
  • Total Gross Weight
  • Volume

As soon as you create, for example, an estimated payable (EP) on a master shipment for the cost type OF (ocean freight), it is supplemented with the prefix T (for “transferred”) and automatically broken down to the house shipments. On the house shipments, the type TEP (Transferred Estimated Payable) also indicates that these estimated payable have been broken down.

The same applies to all jobcostingtypes. You can find a complete list of all jobcostingtypes here: Which jobcostingtypes are available and what do they mean?


Example:

An incoming invoice from the shipping line “Schiff Ahoi AG” was booked against the master shipment, and for the charge types THC and OF it is defined that they are to be broken down by the chargeable weight. On the master shipment, the breakdown is indicated by the type TP (Transferred Payable), and the distribution of the amounts to the consolidated house shipments takes place automatically. In addition, a contra-payable(P) is automatically created for each charge type so that the master shipment is balanced and does not show any profit.

Screenshot from the master shipment:

On the two linked house shipments, the amounts are also marked with the type TP, making them identifiable as transferred amounts.

Screenshots from the house shipments: