Rates Tab

Rates Tab

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 the customer and the currency selected for the quote.

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 organization 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 quote 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

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
  • Payable in original currency
Revenue
The revenue tab shows the costs that are billed to your customers.
This includes:
    • 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  button on the costs tab.

    To add revenue, click on the  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 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  button at the bottom of the dialog box.


    Paying Costs In Original Currency 

    Costs can be processed in the original billable currency or the billing currency for the quote. 
    When are entering a cost and you select a currency that is not the quote billing currency, the Payable in original currency option will be available as shown below. 



    If the Payable in original currency is set the cost will be displayed and reported on in the currency entered rather than the quote billing currency. 



    The costs tab will show the total of each currency used on the quote for costs, as shown above.

    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
    • % Total - This calculates a percentage of the total for the consignment for the selected rate category - typically used for surcharging

    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 quote, all linked quotes 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.

      • Related Articles

      • 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 ...
      • Default Settings

        Set the home country for you organisation, this is used as the default country for pick lists. Here you can set the default units of measurement used in the system. You can also turn on audit logging here. Here you can configure how the references ...
      • Quotes

        Quote are used to manage potential business in CocoonOPS. Import information about the quotes is show on the right-hand side of the screens. This shows the status of the quote: Red indicates there is an issue and immediate action is needed Orange ...
      • Duplicating Quotes

        Duplicating Quotes You can duplicate a quote to create and identical quote to issue to the customer. To duplicate a quote: Click on the on the INSTRUCTIONS tab Select the option A new quote will be generated, that is identical to the original. The ...
      • Deleting Quotes

        Deleting Quotes If a quote is raised in error, you can delete it by: Click on the on the INSTRUCTIONS tab Select the click on delete option Click the Deleted Quote button in the confirmation box that appears