The following Service Fee Types are available:
Assignment Status
The user has the option to choose the Assignment Status. The Assignment Status list displays the active system level Assignment Statuses.
This rule will be applied to all assignment records that have a Relocation/Assignment Status equal to the rule Assignment Status with the assignment record status date is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Comp Accumulator
If the Comp Accumulator Service Fee is active, then, for every unique and approved row in the Comp Accumulator table with a payment date after the Service Fee Billing Rule, a new receivable will be generated for that assignment, with the appropriate account for the row.
The receivables created by these billing rules are subject to Funding Allocation rules.
Cost Estimate
The user enters the amount of Free Cost Estimates.
This rule will be applied for each cost estimate created that is greater than the number of Free Cost Estimates and where the Cost Estimate Create Date is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
This rule is applied with a frequency of once, meaning that once a cost estimate has been billed per this rule, it will not be billed again. Of course subsequent cost estimates for a particular assignment record may be billed.
Custom
This allows the user to create customized conditions for generating service fee receivables using a conditions grid:
This rule type will be applied for each relocation with a Create Date that is:
greater than the rule's Effective Date
and less than the Up To And Including Date used when the new Receivables Batch is created.
The Custom service fee billing rule allows users to associate business rules with billing rules, allowing greater customization and flexibility on service fee billing rule parameters.
General Ledger Transaction
When this rule type is selected, each unique General Ledger Transaction ID is processed once. It automatically maps General Ledger Account IDs to Equus Accounts using predefined system mappings.
The effective date of the receivable is determined by the Posting Date of the General Ledger transaction.
Note, only approved General Ledger transactions are processed, and each transaction is billed only once.
Home Buying Recovery Fee
This allows users to generate a service fee when you acquire the property from the employee based upon the home sale program type and calculated as a percentage of the acquisition price.
The user enters the amount of the fixed amount fee
The user enters the Number of Days
The service fee will be generated when the number of days is reached in the amount specified.
Home Buying Referral Rebate
This allows users to generate a negative service fee if you receive a referral fee for the employee purchasing a new home. This allows you to share referral fee revenue with a client.
The user enters a Referral Fee Rebate Fixed Amount and currency or the Referral Fee Rebate Percentage which will be the percentage of the Actual Collected Amount as shown on the Destination Buyer Service Details screen.
The service fee will be generated when the home purchase is complete (when Actual Collected Amount is entered) at the fixed amount specified or the percentage of the referral fee specified.
The amount generated is the negative of the amount entered in the rule, or calculated percentage. For example, if you want a $1,000 rebate, your rule should contain the amount $1,000. The receivable is then generated as -$1,000.
Home Sale Acceptance
Allows users to generate a service fee when you acquire the property from the employee based upon the homesale program type and calculated as a percentage of the acquisition price.
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
The user enters the Fee Percentage.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Cancellation
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
This rule will be applied to all assignment records that have a Homesale record where the Cancel Date exists and is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
It will also verify the Property Homesale Program Type matches the Homesale Program Type of the rule, if set.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Closing
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
This rule will be applied to all assignment records that have a Homesale record where the Property Closing Detail Actual Close Date exists and is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
It will also verify the Property Homesale Program Type matches the Homesale Program Type of the rule, if set.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Initial Employee Listing
Allows the user to generate a service fee when the employee’s property is listed based upon the homesale program type and calculated as a percentage of the list price.
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
This rule will be applied to all assignment records that have a Homesale Property Listing record where the Listing Date exists and is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
It will also verify the Property Homesale Program Type matches the Homesale Program Type of the rule, if set. Note, a Homesale Program is not required to be set on the rule or the property.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Initiation
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
This rule will be applied to all assignment records that have a Homesale Property Status record where the Property Create Date exists and is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
It will also verify the Property Homesale Program Type matches the Homesale Program Type of the rule, if set. Note, a Homesale Program is not required to be set on the rule or the property.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Property Offer
Allows users to generate a service fee when they make the employee an offer for their home based upon the homesale program type and calculated as a percentage of the offer price.
The user has the option to choose the Homesale Program Type. The Homesale Program Type list displays the active system level Homesale Program Types, unless a Company is selected. If a particular company is selected, the list displays the active company level Homesale Program Types.
This rule will be applied to all assignment records that have a Homesale Property Offer record where the Property Offer Date exists and is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
It will also verify the Property Homesale Program Type matches the Homesale Program Type of the rule, if set. Note, Homesale Program is not required to be set on the rule or the property.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Home Sale Recurring Carrying Fee
Ability to generate a service fee every selected frequency after acquiring the property from the employee until the closed date, calculated as X percent of the acquisition price.
The user selects the Frequency as Once, Monthly, Annually, or Every X Days
Selecting a frequency of once means that once the fee has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the fee can be billed once each calendar month. Selecting a Frequency of Annually means the fee can be billed once each calendar year. A frequency of Every X Days means the fee can be billed once every X number of days. Recurring starts on the maximum of the relocation Create Date and rule Effect Date, and has no stop date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Home Sale Referral Rebate
Allows users to generate a negative amount service fee, if a referral fee is received for the employee selling a home. This allows you to share referral fee revenue with a client.
Specify the Referral Fee Rebate Fixed Amount and currency or the Referral Fee Rebate Percentage. The percentage is calculated from the Actual Collected Amount as shown on the Listing Details screen.
The service fee will be generated once the home sale is complete (when the Actual Collected Amount exists), based upon a percent of the referral fee or the flat amount entered in the rule.
The amount generated is the negative of the amount entered in the rule, or calculated percentage. For example, if you want a $1,000 rebate, your rule should contain the amount $1,000. The receivable is then generated as -$1,000.
Home Selling Recovery Fee
Allows users to generate a fixed amount recovery fee if you are not going to receive a referral fee for the employee selling their home in a timely basis.
The user will specify the Service Home Sale is associated with
The user will specify an amount and number of days
The service fee will be generated when the number of days is reached without the home selling.
Non Compliance – Home Buying
This rule is similar to the Non Compliance – Home Sale Service Fee Type. It has the same triggers, but relates to the Destination Buyer service order Actual Collected Amount, and service order Referral Due checkbox and Destination Buyer Actual Close Date.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Referral Due Checkbox
|
Referral Actual Collected Amount
|
Referral Due Rule
|
Collected Amount Rule
|
Checked
|
<= 0
|
|
Fee Charged
|
Checked
|
> 0
|
|
|
Not Checked
|
<= 0
|
Fee Charged
|
Fee Charged
|
Not Checked
|
> 0
|
Fee Charged
|
|
Non Compliance - Home Sale
The user has the option to choose a Billing Trigger of <Collected Amount>. This will check if there is an Actual Collected Amount recorded on the service order associated with the home sale closing, once the home sale is closed (Contract status is Closed and an Actual Close Date exists) for the Employee Listing.
There is a second Billing Trigger of <Referral Due> available. This trigger will check if the Referral Due checkbox is marked on the service order associated with the home sale service, once the home sale is closed (Contract status is Closed and an Actual Close Date exists).
The user can specify the Billing Rule Days Overdue (must be greater than or equal to 0), which is equal to the number of days after the home sale Actual Close Date when the rule should be applied.
This rule will be applied to all assignment records meeting the above specified criteria, the Contract Status is Closed, and the Actual Close Date plus rule Billing Rule Days Overdue is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
This rule is applied with a frequency of once (meaning that once an assignment record has been billed per this rule, it will not be billed again).
Referral Due Checkbox
|
Referral Actual Collected Amount
|
Referral Due Rule
|
Collected Amount Rule
|
Checked
|
<= 0
|
|
Fee Charged
|
Checked
|
> 0
|
|
|
Not Checked
|
<= 0
|
Fee Charged
|
Fee Charged
|
Not Checked
|
> 0
|
Fee Charged
|
|
Pay Register
If the Pay Register Service Fee Type is selected, then for every unique and approved row in the Pay Register Table with a pay date after the Service Fee Billing Rule, a new receivable will be generated for that assignment, with the appropriate account for the row.
The receivables created by these billing rules are subject to Funding Allocation rules.
Relocation Phase
The user is prompted to select the Relocation Phase to apply the rule to. The Relocation Phase drop down list will display the list of system level Relocation Phases, unless a Company is selected. Once a particular Company is selected, the Relocation Phase list will display the appropriate list as applicable to the selected Company.
This rule will be applied according to the Relocation Phase of the assignment at the time the Receivables batch is created.
This rule will be applied for each relocation with a Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually>, or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. A frequency of Every X Days means the assignment record can be billed once every X number of days. Recurring starts on the maximum of the relocation Create Date and rule Effect Date, and has no stop date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Relocation Phase by Billing Entity
The user is prompted to select the Relocation Phase to apply the rule to. The Relocation Phase drop down list will display the list of system level Relocation Phases, unless a Company is selected. Once a particular Company is selected, the Relocation Phase list will display the appropriate list as applicable to the selected Company.
Company has to be selected when using Billing Entities. If one is not selected you will see a message “This Fee Type is by Billing Entity and therefore must be added to a specific Company.”
This rule will be applied according to the Relocation Phase of the assignment at the time the Receivables batch is created.
This rule will be applied for each relocation with a Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually>, or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. A frequency of Every X Days means the assignment record can be billed once every X number of days. Recurring starts on the maximum of the relocation Create Date and rule Effect Date, and has no stop date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
The Amount will be a table containing the Billing Entities you have setup at company configuration. The currency that you selected for each Billing Entity will be shown and you specify the amount of the fee.
Relocation Policy
The user has the option to choose the Company. Once the Company is selected, the Policy drop down list displays the active policies for that Company.
This rule will be applied for each relocation with a Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually> or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. Recurring starts on the maximum of the relocation Create Date and rule Effective Date, and has no stop date.
A frequency of Every X Days means the assignment record can be billed once every X number of days.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Note that services fees will not be generated if the assignment/relocation is in a status of Canceled, or Archived at the time the Receivable Batch is created. If On Hold assignments also need to be excluded, the Relocation Policy and Relocation Policy by Billing Entity Service Fees Exclude On Hold Records can be set to Yes.
Relocation Policy by Billing Entity
The user has the option to choose the Company. Once the Company is selected, the Policy drop down list displays the active policies for that Company.
Company has to be selected when using Billing Entities. If one is not selected you will see a message “This Fee Type is by Billing Entity and therefore must be added to a specific Company.”
This rule will be applied for each relocation with a Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually> or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. Recurring starts on the maximum of the relocation Create Date and rule Effect Date, and has no stop date.
A frequency of Every X Days means the assignment record can be billed once every X number of days.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
The Amount will be a table containing the Billing Entities you have setup at company configuration. The currency that you selected for each Billing Entity will be shown and you specify the amount of the fee.
Note that services fees will not be generated if the assignment/relocation is in a status of Canceled, or Archived at the time the Receivable Batch is created. If On Hold assignments also need to be excluded, the Relocation Policy and Relocation Policy by Billing Entity Service Fees Exclude On Hold Records can be set to Yes.
Relocation Type
The user has the option to choose the Company. Once the Company is selected, the Policy drop down list displays the active Assignment Types for that Company.
This rule will be applied for each relocation with a Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually> or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. Recurring starts on the maximum of the relocation Create Date and rule Effect Date, and has no stop date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Note that services fees will not be generated if the assignment/relocation is in a status of On Hold, Canceled, or Archived at the time the Receivable Batch is created. There is a System Preference under the category of Billing and the sub category of Service Fees to Limit Relocation Type Service Fee Generation by Assignment Status if you want Service Fees to be generated even when the assignment/relocation is in a status of On Hold, Canceled, or Archived set the System Value to “No”.
Service
The user is required to choose the Service. They also have the option to choose the Billing Trigger. The trigger can be <Service Authorized> or <Service Complete>.
Service Authorized trigger will create a billing if the service is Authorized and the Authorized Date of the service is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
Service Complete trigger will create a billing if the service is Complete and the Complete Date of the service is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually> or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. The Service Complete Date on the Services detail screen (click View/Edit for a particular Service within an assignment) will stop the billing of a recurring Service Fee for the Service.
Recurring starts on the maximum of the service Authorized/Complete Date and rule Effective Date, and has no end date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Service by Billing Entity
Company has to be selected when using Billing Entities. If one is not selected you will see a message “This Fee Type is by Billing Entity and therefore must be added to a specific Company.”
The user is required to choose the Service. They also have the option to choose the Billing Trigger. The trigger can be <Service Authorized> or <Service Complete>.
Service Authorized trigger will create a billing if the service is Authorized and the Authorized Date of the service is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
Service Complete trigger will create a billing if the service is Complete and the Complete Date of the service is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, <Annually> or <Every X Days>. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year. The Service Complete Date on the Services detail screen (click View/Edit for a particular Service within an assignment) will stop the billing of a recurring Service Fee for the Service.
Recurring starts on the maximum of the service Authorized/Complete Date and rule Effective Date, and has no end date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
The Amount will be a table containing the Billing Entities you have setup at company configuration. The currency that you selected for each Billing Entity will be shown and you specify the amount of the fee.
Service Order
The user can choose the Service Order Type.
There are two Billing Triggers available: <First One Created> or <Each One Created>. If First One Created, the rule will apply only to the first service order of the particular type selected (if selected; else all service orders), and none of the subsequent service orders. If Billing Trigger of Each One Created is selected, the rule will apply to each service order created of the particular type selected (if selected; else all service orders).
The rule will NOT apply to service orders in status Canceled nor Not Ordered.
This rule will create billing for all service orders service orders that have a service order Create Date that is greater than the rule Effective Date and less than the Up To And Including Date used when the new Receivables Batch is created.
The user can also specify a Frequency for this rule to be applied. Options are <Once>, <Monthly>, Annually, or Every X Days. Selecting a frequency of once means that once an assignment record has been billed per this rule, it will not be billed again. Selecting a Frequency of Monthly means the assignment record can be billed once each calendar month. Selecting a Frequency of Annually means the assignment record can be billed once each calendar year.
If frequency of Monthly or Annually is selected, the recurring starts on the maximum of the service order Service Due Date and rule Effective Date, and ends on the service order Service Complete Date.
Begin Creating Receivables On can be used to prevent the generation of receivables prior to that date. This will only be available for service fees with a Frequency more frequent than Once.
Service Fee Types and Associated Dates for Inclusion
This is a list of all the Service Fee Types and the associated date for each which will be compared to the Effective Date of the rule for inclusion. The Effective Date must be prior to the associated date for the Service Fee Type.
Assignment Status
Active – ASSIGNMENT.CREATE_DATE
On Hold – ASSIGNMENT.ON_HOLD_UNTIL_DATE
Cancelled – ASSIGNMENT.CANCELLATION_DATE
Complete – ASSIGNMENT.COMPLETE_DATE
Archived – ASSIGNMENT.ARCHIVE_DATE
Cost Estimate – COST_ESTIMATE.CREATE_DATE
Home Buying Recovery Fee – ASSIGNMENT.SERVICES_AUTHORIZED_DATE
Home Buying Referral Rebate – DESTINATION_BUYER_SERVICE.ACTUAL_CLOSE_DATE
Home Sale Acceptance – PROPERTY_OFFER_DETAIL.RELO_COMPANY_ACCEPTANCE_DATE
Home Sale Cancellation – PROPERTY.HOMESALE_PROGRAM_CANCEL_DATE
Home Sale Closing – PROPERTY_CLOSING_DETAIL.ACTUAL_CLOSE_DATE
Home Sale Initial Employee Listing – PROPERTY_LISTING_EMPLOYEE.CREATE_DATE
Home Sale Initiation – PROPERTY.CREATE_DATE
Home Sale Property Offer – PROPERTY_OFFER_DETAIL.OFFER_SENT_DATE
Home Sale Recurring Carrying Fee – PROPERTY_OFFER_DETAIL_ACCEPTANCE.RELO_COMPANY_ACCEPTANCE_DATE
Home Sale Referral Rebate – PROPERTY_CLOSING_DETAIL.ACTUAL_CLOSE_DATE
Home Selling Recovery Fee – ASSIGNMENT.SERVICES_AUTHORIZED_DATE
Non-Compliance Home Buying – DESTINATION_BUYER_SERVICE.ACTUAL_CLOSE_DATE + BILLING_RULE_SERVICE_FEE.REFERRAL_DAYS_OVERDUE
Non-Compliance Home Sale – PROPERTY_CLOSING_DETAIL.ACTUAL_CLOSE_DATE +
BILLING_RULE_SERVICE_FEE.REFERRAL_DAYS_OVERDUE
Relocation Phase – ASSIGNMENT.CREATE_DATE
Relocation Policy – ASSIGNMENT.CREATE_DATE
Relocation Type – ASSIGNMENT.CREATE_DATE
Service
Authorized – ASSIGNMENT_SERVICE.AUTHORIZED_DATE
Completed – ASSIGNMENT_SERVICE.COMPLETE_DATE
Service Order
Frequency Once – SERVICE_ORDER.CREATE_DATE
Frequency Recurring – SERVICE_ORDER.DUE_DATE
Generic Requirements for All Rules, in Order For Rule to Be Applied
Service Fee Billing Rule must not be Inactive. If the rule is Inactive, it will no longer be applied.
Service Fee Billing Rule Effective Date must be less than current date (today)
Service Fee Billing Rule Begin Creating Receivables On must be less than current date (today)
Assignment must not be Inactive. If an assignment is Inactive, service fee billing rules will no longer be applied to that assignment record.
Assignment Company/Policy must match if the rule specifies a Company/Policy
Resolving the Service Fee Rules Hierarchy
Apply all rules defined for a policy.
Apply all rules defined for a company that do not have a rule defined for a policy.
Apply all rules defined for the system that do not have a rule defined for a policy or a company.
Things to Note
For Relocation Policy, Relocation Policy by Billing Entity and Relocation Type, a validation behind the scenes for the prevention of receivables being generated is controlled by the system codes of the statuses. If the names of those statuses have been changed receivables will not be generated where the system code is EQASOH (System Name - On Hold), EQASIA (System Name – Canceled), or EQASAR (System Name – Archived).