Support : User Guide
Reference Data : Accounting

To add a new booking entities go to Reference Data and then to the Booking Entities tab.

In accounting, you can setup new booking entities and its related properties. In addition, settlement basis which is used to calculate due date and settlement period can be also setup here.

Setting up Booking Entities
Setting up Settlement Basis
Setting up Booking Period
Setting up Reference Mask
Setting up Booking Entities

Reference Data Accounting Booking Entities

To add a booking entities:

  1. Click on New Button to create a new line.
  2. In Booking Entity Name, enter the name of the booking entity.
  3. In Booking Entity Short Name, enter the name of the booking entity short name.
  4. In Company Registration id, enter the company registration id. Typically, this can be used to be printed on the invoice.
  5. In Tax Registration id, enter the tax registration id. Typically, this can be used to be printed on the invoice.
  6. In Booking Entity Currency Code, this defaulted to USD.
  7. In Booking Entity Tax Code, select the to tax currency of the company if it is different from USD.
  8. Click Save Button to confirm creation.
  9. To edit booking entity details after creation, Click Edit Button to edit.

Reference Data Accounting Booking Entities Address

To add a booking entities, from the address view:

  1. Click on New Button to create a new line.
  2. In Address name, enter the address name of the booking entity. Each address name has a set of address.
  3. In Active?, check the box to set the address name active.
  4. In Default?,check the box to set the address name as default. This address will use in settlement.
  5. Click Save Button to confirm creation.
  6. To edit address details after creation, Click Edit Button to edit.

*More than one address name (Set of addresses) can be created.*

Reference Data Accounting Booking Entities Address Line

To add a booking entities, from the address line view:

  1. Click on New Button to create a new line.
  2. In Line Order Num, enter the line order number. This will determine which address line to be display first and in this order.
  3. In Address Line, enter the address.
  4. Click Save Button to confirm creation.
  5. To edit address line details after creation, Click Edit Button to edit.

Setting up Reference Mask

Reference Data Accounting Reference Mask

Reference Mask is used to generate automatic reference number used in the system. There are contract ref. and settlement ref. which can be setup to use reference mask. Automatic reference number can be setup based on Contract Type Group, Contract Type, Buy/Sell and Pay or Receive criteria.

To setup reference mask:

  1. Click on New Button to create a new line.
  2. In Mask Type, select the type to use reference mask. Example: Contract or Settlement.
  3. In Contract Type Group, select the type group. This can be either Derivatives or Physical.
  4. In Contract Type, select the contract type if applicable. If this is blank, it applies to all contract type.
  5. In Buy/Sell, select buy or sell if applicable. If this is blank, it applies to all deal type.
  6. In Pay or Receive, select pay or receive if applicable. This is used for settlement mask type. If this is blank, it applies to all settlement type.
  7. In Order Num, enter the order number in which the reference should start with.
  8. In Mask Text, enter a text if a static text will be used as part of the reference generation.
  9. In Todays Date?, check the box if today Date will be used as part of the reference generation.
  10. In Todays Month?, check the box if today Month will be used as part of the reference generation.
  11. In Todays Year?, check the box if today Date will be used as part of the reference generation.
  12. In Contract Item Year?, check the box if the year of contract item Date will be used as part of the reference generation.
  13. In Date Format, enter the date format to use if Todays Date, Todays Month, Todays Year or Contract Item Year is used. For Example, YY or MM.
  14. In Running Number?, check the box if running number will be used as part of the reference generation.
  15. In Running Number Integers, enter the number of integer to use if Running Number is checked. For example, if 4 is used. The running number will start with 0001.
  16. In Active?, check the box to set the line active..
  17. Click Save Button to confirm creation.
  18. To edit reference mask details after creation, Click Edit Button to edit.

For example, the reference can be set with 5 component. Start with a static tex "STC", then follow by year of contract item date, then static text "P", then static text "B" for Buy and "S" for Sell and finally a 4 digit running number. The results will be for all Physical Buy deal reference will be STC22PB0001 and for all Physical Sell deal to reference will be STC22PS0001. The example below show this setup.

Reference Data Accounting Reference Mask Example

Setting up Settlement Basis

Reference Data Accounting Settlement Basis

To add a new settelment basis:

  1. Click on New Button to create a new line.
  2. In Settlement Basis Name, enter the name of the settlement basis.
  3. In Event, select the event for which this settlement bais calculation should be based on.
  4. *Events setup can be found in Reference Date -> Events*

  5. In Event Offset Num, enter the number of days to offset from the event.
  6. For Example, 10 days after Invoice Received, Event Offset Num = 10.

  7. In Include Event Indicator, tick the box if offset should start counting from event date itself or one day after the event date.
  8. In Offset Num Type, select the offset type. It can be either using Business Day (Mon to Fri Excluding holiday) only or Calendar Days (Every day of the week count).
  9. In Weekend Rule, select the Weekend Rule to use.
  10. *Prev : If Calculated Due Date falls on a Weekend, Friday will be used.*

    *Next : If Calculated Due Date falls on a Weekend, Next Monday will be used.*

    *Split : If Calculated Due Date falls on a Saturday, Friday will be used. If Calculated Due Date falls on a Sunday, Next Monday will be used.*

  11. In Holiday Rule, select the Holiday Rule to use.
  12. *Prev : If Calculated Due Date falls on a Holiday, Friday will be used.*

    *Next : If Calculated Due Date falls on a Holiday, Next Monday will be used.*

    *Monday Next Otherwise: If Calculated Due Date falls on a Holiday which is on Friday, Next Monday will be used. Otherwise, Thursday will be used.*

  13. In Calendar, select the calendar to used for Holiday checking.
  14. *Holiday setup can be found in Reference Date -> Calendar*

    *If the settlment basis required to do a comparision between two event dates, continue setup from step 10 to step 16. Alternatively, go directly to step 17.*

  15. In Event2, select the 2nd event for which this settlement bais calculation should be based on.
  16. *Events setup can be found in Reference Date -> Events*

  17. In Event Offset Num2, enter the number of days to offset from the 2nd event.
  18. For Example, 10 days after Invoice Received, Event Offset Num = 10.

  19. In Include Event Indicator2, tick the box if offset should start counting from event date itself or one day after the 2nd event date.
  20. In Offset Num Type2, select the offset type for 2nd event. It can be either using Business Day (Mon to Fri Excluding holiday) only or Calendar Days (Every day of the week count).
  21. In Weekend Rule2, select the Weekend Rule to use for 2nd event.
  22. *Prev : If Calculated Due Date falls on a Weekend, Friday will be used.*

    *Next : If Calculated Due Date falls on a Weekend, Next Monday will be used.*

    *Split : If Calculated Due Date falls on a Saturday, Friday will be used. If Calculated Due Date falls on a Sunday, Next Monday will be used.*

  23. In Holiday Rule, select the Holiday Rule to use for 2nd event.
  24. *Prev : If Calculated Due Date falls on a Holiday, Friday will be used.*

    *Next : If Calculated Due Date falls on a Holiday, Next Monday will be used.*

    *Monday Next Otherwise: If Calculated Due Date falls on a Holiday which is on Friday, Next Monday will be used. Otherwise, Thursday will be used.*

  25. In Earlier or Later of?, select the rule to use for the calculated due date based on event and event2.
  26. In Transaction Basis?, tick the box if this settlement basis can be used for transaction due date calculation.
  27. In Fee Basis?, tick the box if this settlement basis can be used for fee due date calculation..
  28. In Settlement Handling?, select settlement Handling type. Party-to-Party for buy/sell counterparty type. Margin for derivatives trading.
  29. Click Save Button to confirm creation.
  30. To edit settelment basis details after creation, Click Edit Button to edit.
Setting up Booking Period

Reference Data Accounting Booking Period

To add a booking period:

  1. Click on New Button to create a new line.
  2. In Booking Period Name, enter the name of this booking period.
  3. In Booking Period Name2, enter the 2nd name of this booking period.
  4. In Period Start Date, select the start date of this booking period.
  5. In Period End Date, select the end date of this booking period.
  6. In Year, enter the year of this booking period.
  7. In Period Type, select the period type. It can be either Month, Year or Quarter Month.
  8. Click Save Button to confirm creation.
  9. To edit booking period details after creation, Click Edit Button to edit.

Back to top
Need More Assistance?

Please get in touch.

Chat with

CoreTRM