Support > User Guide
Accounting : Fees
Settlement Fee

To create a settlement for a fee, go to Settlements and then to the Fees tab.

Both physical/paper contract fee and primary/secondary fee appears in the Fees tab. When a fee with fee status "Estimate", only provisional settlement can be created. When a fee with fee status "Final", final settlement can be created.

Paper deal created using settlement basis "Margin" will not appear in the Fees Tab. It is expected to be settled via exchange margin.

Create Provisional Settlement

Settlement Provisional Settlement

  1. Select the fee with fee status "Estimate".
  2. From the dropdown, select "Provisional" for provisional settlement.
  3. *You can only create "Provisional" Settlement when the Fee status is "Estimate"*

  4. Click on Create Settlement Button to create a settlement.
  5. Click "OK" to confirm settlement creation.
  6. From the pop up box, update the "Amount" box to the provisional price to be used. *The system will automatically calcuate the new settlement value.
  7. Settlement Provisional Settlement Pop Up

    *Alternatively, you can create provisional settlement using specific Price Series, Pricing From and To Date, Premium/Discount, Specification Adjustment. If specific Price series are used, you can click on Calc Price Buttonto preview the price.*

    Settlement Provisional Settlement Adjustment

  8. From the pop up box, click "Create" to confirm settlement creation.
  9. The provisional settlement will be created and can be viewed in Settlement tab.
  10. To edit fee details before creation, Click Edit Button
  11. Click Save Button to confirm update.
Create Final Settlement

Settlement Final Settlement

  1. Select the fee with fee status "Final".
  2. *Final settlement can be created directly or after a provisional invoice is created.*

    *If a provisonal invoice was created before the Final Invoice, the system will automatically calculate the balance amount to be paid/received.*

  3. From the dropdown, select "Final" for final settlement.
  4. Click on Create Settlement Button to create a settlement.
  5. Click "OK" to confirm settlement creation.
  6. The final settlement will be created and can be viewed in Settlement tab.
  7. To edit fee details before creation, Click Edit Button
  8. Click Save Button to confirm update.
View Pricing Calculation

After selecting the settlement item, you will also be able to view the pricing calculation that was used to calculate the price in the "Pricing Calculation" view/grid.

*When Price Status is "Final", this means this the final price for the day.*

*When Price Status is "Estiamte", this means this the price used is not final and that the price is a forward price*

Settlement View Pricing Calculation

Each Fee information are based on data created in Trading or updated in Operations. Below are the fields that are avaialable:

Settlement Create Fee Settlement Details

  1. Contract Ref., the contract ref of the fee.
  2. Book, the book name of the fee.
  3. Commodity, the commodity of the fee.
  4. Container, the container used for the fee. Only applicable to physical deal.
  5. Pay or Receive, indicate if the fee is payable or receivable.
  6. Counterparty, the counterparty of the fee.
  7. Fee Type, .the fee type of the fee. For Physical, the fee type is "Physical". For primary/secondary cost, the fee type is the selected fee type.
  8. Unit Amount, the unit amount of the fee.
  9. Type, indicate the type use for the fee.
  10. Fraction %: indicate that Fee Fraction is used for settlement value calculation.

    Lumpsum: indicate that Lumpsum amount is used for settlement value calculation.

    Unit Rate: indicate unit rate is used for the settlement value calculation. For Example: $2 per MT.

  11. Ccy, the currency of the unit amount.
  12. Unit, the unit used for the unit amount.
  13. Quantity, the quantity used for the fee (if applicable). Typically, when Type "Unit Rate" is used, Quantity will be displayed.
  14. Unit,the unit used for the quantity.
  15. Value, the value of the fee.
  16. Ccy, the currency of the fee value.
  17. Due Date Basis, the due date basis used for the fee.
  18. Specific Due Date, if specific due date is used, the date will be displayed.
  19. Due Date, the calculated due date based on Due date basis.
  20. Fee Status, indicate the status of the fee.
  21. "Estimate": For Physical, when price is not fully settled and/or actual quantity is not updated. For Fees, when fee status is in "Estimate".

    "Final": For Physical, when price is fully settled and/or actual quantity is updated.For Fees, when fee status is in "Final".

  22. Setl.Type, indicate the type of settlement that was created.
  23. "Provisional": When a provisional settlement has been created using this fee.

    "Final": When a final settlement has been created using this fee.

  24. Setl.Status, indicate the status of the settlement related to this fee. The settlement status will also increase/decrease credit exposure of a counterparty.
  25. "Pending": The oringinal status when a settlement is createed.

    "Invoice Sent": indicate an invoice has been sent.

    "Invoice Received": indicate an invoice has been received.

    "Cash Disbursed": indicate that cash has been disbursed.

    "Cash Received": indicatethat cash has been received.

  26. Actual Event, indicate the event which quantity is being used.
  27. Actual Event Date, indicate the date of the actual event.
  28. Settlement Date Event, indicate the event used for settlement due date calculation.
  29. Settlement Date Event Date, indicate the date use for settlement date event .
  30. Tax Type, indicate tax type used for this fee.
  31. Tax Inclusive/Exclusive, indicate tax is inclusive or exclusive.
  32. Tax Amount, indicate the calculated tax amount.
  33. Fee Num, system generated unique number for the fee.
  34. Actual Reference, enter any applicable reference for this fee.

Back to top
Hi! Have questions about CoreTRM? Chat with our AI or connect with our reps – we’re here to assist you!

CoreTRM Assistant