Rates Tab

Rates Tab

The rates tab is how the finance for the Consignment is managed.

Summary

The summary tab gives you an overview of the Consignment’s finances.

Credit Limit

This panel show the credit information from the finance account that the consignment is linked to through the customer and the currency selected for the Consignment.
A notice will be displayed here if:
  • There is no credit limit attached to the account for this customer
  • The account has been closed for this customer
  • The account is approaching its credit limit
  • The account is at its limit

If the account has a credit limit attached, the following information will be shown:

  • The balance of the account on invoices that have been issued
  • The balance of the account that has not yet been billed
  • The used credit
  • The credit limit

The uninvoiced balance shows to the total that is attached to consignments but has not been billed.

Settlement Terms

The settlement terms panel shows:
  • The office from which the costs should be billed
  • The currency the customer will be billed in
  • The payment terms for the consignment

You can change the currency and payment terms and then click the  button.


Info
The settlement office is automatically set to the billing address selected for your organisation in the address book.

To change the settlement office:

  1. Select the  next to the settlement office
  2. Select an address from your organisation in the address book dialog box
  3. Click the  button
  4. The click the  button to commit the change.

Cost & Revenue Summary

This shows a summary of the costs, including tax, that have been entered against the consignment and the associated revenue.
The costs and revue are shown in the reporting currency for your business.

Gross Profit & Net Profit

This panel shows:
  • The total forecast cost of the consignment to your business
  • The total revenue that will be charged to the customer
  • The gross profit on the consignment
    • In actual currency
    • As a percentage of the cost to you

Invoices

The invoices panel shows any invoice that are linked to the consignment.

You see the following information:

  • Reference
  • Status
  • When it was raised
  • When it was due
  • The total amount

Here you will also see credit notes here.

Costs

The cost tab shows the costs that are billed to your business from your suppliers.

This includes:

  • Rate code
  • Description of the rate
  • The supplier
  • State of the rate
    • E - Estimate
    • A – Actual
    • I – Invoiced
  • The tax point date for the cost
  • Any references associated to the cost
  • Comments
    This includes manually entered comments and any information on how the rate subtotal is calculated.
  • Currency
  • Subtotal

Revenue

  • Rate code
  • Description of the rate
  • State of the rate
    • E - Estimate
    • A – Actual
    • I – Invoiced
  • Comments
    This includes manually entered comments and any information on how the rate subtotal is calculated.
  • Currency
  • Subtotal

Managing Costs & Revenue

Both costs and revenue are rates so they have very similar options.

To add a cost, click the [ + ATTACH COST ] button on the costs tab.

To add revenue, click on the [ + ATTACH REVENUE ] button on the revenue tab.

Both buttons will open the properties for the rate you want to add. See the properties section below for more information.

Properties

The properties dialog is opened automatically when you attach a new rate.

You can also open it by right clicking on the rate you want to edit and selecting the  option.

Below is the properties dialog box for the revenue rates.


Notes
The base currency for the rate is shown in bold at the top of the rate properties dialog box. If the currency is changed in the dialog box, the rate will automatically be converted the currency show as the base.

Info
 For new costs/revenue, you can change the base currency for the rate by changing the Current Billing Currency on the summary tab.

Once you have finished entering the rate information click the [ SAVE ] button at the bottom of the dialog box.

Automatic Value Calculation

You can set a rate to automatically calculate a rate.
This is done using the BASED ON dropdown, which has the following options:
  • Fixed
  • Weight
  • Volume
  • Volumetric Weight
  • Chargeable Weight
  • Loading Metres
  • Factoring - % of total revenue
  • Distance - manually entered

The fixed option does not trigger an auto calculation of the rate. Use this option when you are managing the rate entirely manually.

The other options link the QTY field to the consignment total value for the selected metric. You then only need to set the cost per unit and then CocoonOPS will automatically calculate the rate value.

When these metrics are changed for a Consignment, all linked Consignments will automatically be updated until they are invoiced.

Foreign Currency

The default currency selected is the currency that is selected on the summary tab.
You can enter a rate in a different currency by selecting the CURRENCY dropdown and selecting the currency the rate is entered in.

This will then show the currency conversion options.

The exchange rate is pulled in from your settings and is automatically updated every 24 hours.

Enter the cost information in in the currency you selected and CocoonOPS will automatically convert it into the billing currency.

The foreign currency conversion information will be displayed in the comments section on the list of rates.


Notes
The base currency for the rate is shown in bold at the top of the rate properties dialog box. If the currency is changed in the dialog box, the rate will automatically be converted the currency show as the base.

Automatic Revenue Calculation

For costs there is also the COST TRANSFER MODEL option at the bottom of the properties dialog box.

This allows you to automatically create a linked revenue item based on the cost.

There are several models to choose from:

ModelNo revenue is linked
No Model AppliedNo revenue is linked
At CostRevenue is created at the same price as the cost entered
Cost PlusThis adds x % to the cost to create the revenue
Fixed Total RevenueThis fixes the linked revenue at specified total
Fixed Unit CostThis sets the unit cost for the linked revenue

Then these models are used, the corresponding revenue item will be created and maintained based on the model selected and the parameters entered.


Info
Revenue items that are linked to cost, cannot have their properties edited directly as they are managed by the linked cost.

Removing Rates

Right click on the rate that you want to remove and select the  option.

Creating Invoices

 Only users with the FinanceFinance Manager or System Admin role are able to create invoices
From the Revenue rates tab you can create invoices.

To do this:

  • Check the check boxes next to the rates that you want to include on the invoice (or use the box at the top of the column to select all)
  • Click the button
  • Select the  button

All of the selected revenue is then attached to the invoice, the invoice document is created and attached to the consignment and you will be taken to the invoice preview in the finance module.

Creating Credit Notes

Credit notes are treated as invoices in the system.
They are created the same way an invoice is created.

When you create an invoice, in the total value of the invoice has a negative value, a credit note is created instead of a sales invoice.

Exporting Rates

You can export both cost and revenue rates to a spreadsheet file.

You can do this by clicking on the [ EXPORT RATES ] button.

This will export all rates attached to the consignment.


Info
 This is only available when you have rates that are finalised in the ACTUAL state


    • Related Articles

    • Rates

      The rates tab is how the finance for the quote is managed. Summary The summary tab gives you an overview of the quote’s finances. Credit Limit This panel show the credit information from the finance account that the consignment is linked to through ...
    • How to Create an Invoice in CocoonOPS

      This guide explains how to create, issue, and send an invoice from a consignment in CocoonOPS. Before creating an invoice, make sure you have added both the costs and revenue to the consignment on the Rates tab. Creating Invoices Only users with the ...
    • Carrier

      This tab is used to manage the information for the primary carrier. Here you can set: Primary carrier Organisation Address Contact Carrier’s INCO terms Rates agreement reference Quote Reference Booking Reference Service frequency Transit time Carrier ...
    • Documents Tab - Consignments

      Document can both be attached to and generated for Consignments. Attaching a document to a Consignment. Select the Consignment the document should be attached to Drag the document onto the page in your browser Select the document type in the dialog ...
    • Managing Consignments

      The Consignments are managed through the button on the INSTRUCTIONS tab. To open a new Consignment: Click on the on the left-hand side of the page Enter the instruction information provided by the customer. Click the button Editing Instructions To ...