Skip to Content
Cargoo Cargoo Support
Submit a Ticket
Cargoo Support › Knowledge › Special Features: Cost Estimation Report Category

Special Features: Cost Estimation Report Category

The Cost Estimation Report category provides a report on all costs.

In addition to the overall cost of the shipment, you can find the breakdown of the costs per container, Ocean Freight costs, Additional Charges, Origin and Destination DND costs (respectively, O-DND and D-DND in the report column). All the cost types are calculated separately.

To view the Cost Estimation Report category

  1. Navigate to Business Intelligence>Reports.
  2. Select Cost Estimation Report.

Figure 1

Figure 2

Before generating a report, make sure that

  1. You’re using the right Company account.
    (For more details, please see Business Intelligence: Reports Section article.)
  2. You have checked the Data for multiple companies: section and have selected all the companies for which you are looking to get the data .
    (For more details, please see Common Features: Data for Multiple Companies article.)
  3. All Filters and Additional Filters are set.
    (To set the Filters and Additional Filters follow the steps described in Filters and Additional Filters.)

Tip

Save the filter configurations as a template in case you use the same filter configurations repeatedly, or use existing templates if any.
(For more details, please see Common Features: Save Your Filter Configurations as a Template article.)


Once all filters are set, generate a report and use report table features to view and analyze the report online or use the provided options to download or save it to preferred file formats.
(For more details on report table features, please see Common Features: Report Table article.)

Figure 3

Filters

To set the filters

  1. Select Currency. 
    Below the searchable drop-down menu, you can find currency exchange rates, the information on the latter is given relative to the currencies used in your contracts.
    For example
    If you have used different currencies in your contracts, e.g., EUR, USD, RMB, and JPY, and you choose to convert them to USD, you will see the exchange rates for all 3 (three) – EUR to USD, RMB to USD, and JPY to USD rates.
  2. Select the date criteria (see Table 1: Date Criteria ).
  3. Upon necessity, select Alternative Container Type Cost Calculation checkbox. This checkbox, 
  • if not selected, then container type exact match will be displayed in the calculation of ocean freight rates, additional charges, storage, demurrage and detention costs, both in origin and destination;
  • if selected, then container type broad match will be displayed, which means that the estimated costs can be alternatively applied for 40GP container type instead of 40HQ (and vice versa) and for 40RF container type instead of 40RQ (and vice versa);

    4. Select the date range from the provided options, or select Custom and use the 

        calendars to select From and To dates.

    5. Use the drop-down menus of the following filters to narrow down the search results 

        and filter the data accordingly:

  • Carrier, 
  • Commodity,
  • Shipment Status,
  • Origin Country,
  • Destination Country.

   6. Type in the Location Names or the UN Codes (UN/LOCODE) for the Origin and 

       the Destination.


Note

All is the default selected option for the filters mentioned in Steps 5 and 6. If you skip Steps 5 and 6 the generated report will include all the shipments available.


Figure 4

Figure 5
 

Table 1: Date Criteria

DATE CRITERIA

DESCRIPTION

ETD
(Selected by Default)

Estimated Time of Departure

When selected Exclude empty ETD shipments filter appears.

ATD

Actual Time of Departure

ETA

Estimated Time of Arrival

ATA

Actual Time of Arrival

Shipped on Board Date

Date the cargo was loaded on the board of the vessel or the POL departure date

Shipping Window

When selected Search Criteria filter appears.  

Select one of the two options.

For detailed information on how Exact search and Range search filters work, please see the Special Features: Orders Report Category article on https://support.cargoo.com/support/solutions 

 

Additional Filters

Additional Filters allow you to filter the data per your role in the shipments.

Select Your Role in Shipment

  1. Select Additional Filters.
  2. Select one of the three filter options:
    • My Shipments — Shipments created by you or by companies selected in Data for Multiple Companies.
    • Observer — Shipments where you or the companies selected in Data for Multiple Companies are added as Further Parties.
    • All — This option includes the above-mentioned two filter options and is selected by default.
  3. Click Apply.

Figure 6

Show in Report: Parties (Business Partners)

To add more Parties to the report

  1. Select Additional Filters.
  2. Open the drop-down menu for Parties and select more Parties or deselect the default selected option. 

By default, the following parties are selected:

  • Buyer
  • Consignee
  • Shipper
  • Supplier
  • Freight Payer

    3. Click Apply. 

Figure 7

Show in Report: Checkboxes

In Additional Filters, the following two checkboxes are available: 

  • Shipment Costs – if checked, the simplified shipment costs retrieved from Track&Trace will appear as a separate column in the report. 
  • Company Codes: this is organization's internal shipment party's company code and if checked, column for every shipment’s party will be displayed in the report (including rate consumer).

Figure 8


To download the print version of this article click the PDF icon: 

← Back to Help CenterStill need help? Submit a Ticket