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:
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:
- Select the next to the settlement office
- Select an address from your organization in the address book dialog box
- Click the
button - 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:
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.
- 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.
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 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.
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:
| Model | No revenue is linked |
|---|
| No Model Applied | No revenue is linked |
| At Cost | Revenue is created at the same price as the cost entered |
| Cost Plus | This adds x % to the cost to create the revenue |
| Fixed Total Revenue | This fixes the linked revenue at specified total |
| Fixed Unit Cost | This 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.
Removing Rates
Right click on the rate that you want to remove and select the
option.