Rates

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 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.

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
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.

Add

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.

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.
 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  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

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.

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.

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

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


    • Related Articles

    • 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 ...
    • 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 ...
    • Exchange Rates

      CocoonOPS automatically imports currency exchange rates daily from freecurrencyapi.com which provides the intra-bank exchange rates. Use the Base Currency drop down to select the currency you want to work with. You can set a percentage adjustment for ...
    • Managing Rates

      You manage the rate codes for costs and revenue through this screen. Each rate consists of the following elements: Label Cost Account Code Revenue Account Code Category Rates require one or both cost and revenue codes. If a rate has a cost code, it ...