Intercompany Billing Rate Settings for Journal Entries

When you process intercompany billing, the rate methods and related information that DPS uses to calculate the journal entries for the transactions can come from several sources:

  • Intercompany Billing tab of the Projects hub
  • Intercompany Billing Setup form
  • Intercompany Billing tab of the Individual Organization Setup form

The remainder of this topic describes how DPS determines which rate method and multiplier to use for each type of charge.

Labor Charges

  1. Check project-specific labor rate settings on the Intercompany Billing tab in the Projects hub.

    If labor rate settings exist for the project charged, DPS uses those settings.

  2. Check company override settings in the Journal Entry Override table on the applicable labor tab of the Intercompany Billing Setup form.
    • If the table contains a row for the correct target and originating companies, and Rate Method contains Multiplier, DPS checks for an override multiplier for the corresponding labor transfer type for the project’s organization on the Intercompany Billing tab of the Individual Organization Setup form.
      • If an override multiplier exists for the organization, DPS uses that multiplier.
      • If an override multiplier does not exist for the organization, DPS uses the multiplier from the Journal Entry Override table.
    • If the table contains a row for the correct target and originating companies, and Rate Method contains a method other than Multiplier, DPS uses the settings from that row.
  3. Check company settings in the Journal Entry Information table on the applicable labor tab of the Intercompany Billing Setup form.
    • If Rate Method contains Multiplier on the row for the target company, DPS checks for an override multiplier for the corresponding labor transfer type for the project’s organization on the Intercompany Billing tab of the Individual Organization Setup form.
      • If an override multiplier exists for the organization, DPS uses that multiplier.
      • If an override multiplier does not exist for the organization, DPS uses the multiplier from the Journal Entry Information table.
    • If Rate Method contains a method other than Multiplier on the row for the target company, DPS uses the settings from that row.

In cases in which the applicable labor rate method is one of the rate table methods but the specified rate table does not contain rate information that applies to the labor charge, DPS uses a 0.0000 billing rate.

In cases in which the applicable regular labor rate method is Billing Terms and no billing terms exist for the project, DPS uses the reporting default billing terms in Billing Configuration.

Regular Expense Charges

  1. DPS checks project-specific expense rate settings on the Intercompany Billing tab in the Projects hub.
    • If expense rate settings exist for the project charged, and Rate Method contains one of the rate table methods, and the specified table contains an entry for the expense, DPS uses the multiplier from the table.
    • If expense rate settings exist for the project charged, and Rate Method contains one of the rate table methods, but the specified table does not contain an entry for the expense, DPS uses the multiplier from the Intercompany Billing tab in the Projects hub.
    • If expense rate settings exist for the project charged, and Rate Method contains a method other than one of the rate table methods, DPS uses the settings from the Intercompany Billing tab in the Projects hub.
  2. DPS checks company override settings in the Journal Entry Override table on the Regular Expense tab of the Intercompany Billing Setup form.
    • If the table contains a row for the correct target and originating companies, and Rate Method contains Multiplier or one of the rate table methods, DPS checks for an override multiplier for the corresponding expense transfer type for the project’s organization on the Intercompany Billing tab of the Individual Organization Setup form.
      • If an override multiplier exists for the organization, DPS uses that multiplier.
      • If an override multiplier does not exist for the organization, and Rate Method contains Multiplier, DPS uses the multiplier from the Journal Entry Override table.
      • If an override multiplier does not exist for the organization, and Rate Method contains one of the rate table methods, and the specified table contains an entry for the expense, DPS uses the multiplier from the rate table.
      • If an override multiplier does not exist for the organization, and Rate Method contains one of the rate table methods, but the specified table does not contain an entry for the expense, DPS uses the multiplier from the Journal Entry Override table.
    • If the table contains a row for the correct target and originating companies, and Rate Method contains Billing Terms, DPS uses the settings from that row.
  3. DPS checks company settings in the Journal Entry Information table on the applicable labor tab of the Intercompany Billing Setup form.
  • If Rate Method contains Multiplier or one of the rate table methods on the row for the target company, DPS checks for an override multiplier for the corresponding expense transfer type for the project’s organization on the Intercompany Billing tab of the Individual Organization Setup form.
    • If an override multiplier exists for the organization, DPS uses that multiplier.
    • If an override multiplier does not exist for the organization, and Rate Method contains Multiplier, DPS uses the multiplier from the Journal Entry Information table.
    • If an override multiplier does not exist for the organization, and Rate Method contains one of the rate table methods, and the specified table contains an entry for the expense, DPS uses the multiplier from the rate table.
    • If an override multiplier does not exist for the organization, and Rate Method contains one of the rate table methods, but the specified table does not contain an entry for the expense, DPS uses the multiplier from the Journal Entry Information table.
  • If Rate Method contains Billing Terms on the row for the target company, DPS uses the settings from that row.

In cases in which the applicable expense rate method is one of the rate table methods but the specified rate table does not contain rate information that applies to the expense charge, DPS uses a 0.0000 billing rate.

In cases in which the applicable regular expense rate method is Billing Terms and no billing terms exist for the project, DPS uses the reporting default billing terms in Billing Settings.

Overhead and Promotional Expense Charges

  1. DPS checks project-specific expense rate settings on the Intercompany Billing tab in the Projects hub.

    If an expense multiplier exists for the project charged, DPS uses that multiplier.

  2. DPS checks settings on the Intercompany Billing tab of the Individual Organization Setup form.

    If an override multiplier exists for the corresponding expense transfer type for the project’s organization, DPS uses that multiplier.

    If an override multiplier exists for the corresponding transfer type for the project’s organization, DPS uses that multiplier.

  3. DPS checks company override settings in the Journal Entry Override table on the Overhead Expense tab or Promotional Expense tab of the Intercompany Billing Setup form.

    If the table contains a multiplier for the correct target and originating companies, DPS uses that multiplier.

  4. DPS checks company settings in the Journal Entry Information table on the Overhead Expense tab or Promotional Expense tab of the Intercompany Billing Setup form.

    DPS uses the multiplier on the row for the target company.

Balance Sheet/Other Charges

  1. DPS checks settings on the Intercompany Billing tab of the Individual Organization Setup form.

    If an override multiplier exists for the corresponding transfer type for the project’s organization, DPS uses that multiplier.

  2. DPS checks company override settings in the Journal Entry Override table on the Balance Sheet/Other tab of the Intercompany Billing Setup form.

    If the table contains a multiplier for the correct target and originating companies, DPS uses that multiplier.

  3. DPS checks company settings in the Journal Entry Information table on the Balance Sheet/Other tab of the Intercompany Billing Setup form.

    DPS uses the multiplier on the row for the target company.