Overhead Labor Tab of Intercompany Billing Setup

Use the Overhead Labor tab to specify how to handle overhead labor intercompany transactions.

Contents

Field Description
Reclass Intercompany Suspense as Receivable/Payable only Select this option to move overhead labor amounts from a company's Intercompany Suspense account to its Intercompany Accounts Payable or Intercompany Accounts Receivable account, when Intercompany Billing is run.
  • Selecting this option disables the other two options on this tab.
  • If you leave this option cleared, you must select at least one of the other options on this tab.
Create Labor Adjustment to transfer Labor to originating Company Select this option to have DPS create a labor adjustment transferring an employee's overhead labor cost from the target company to the originating company, when Intercompany Billing is run.

The labor adjustment clears out the Intercompany Suspense account and reverses the employee's overhead labor cost.

This option is enabled only if Reclass Intercompany Suspense as Receivable/Payable only is not selected.

Create Journal Entry Select this option if you want DPS to create a journal entry in the amount of the markup when Intercompany Billing is run. The markup is based on the transfer price defined by the applicable Rate Method and Multiplier fields. DPS posts the journal entry to the following:
  • The credit account specified for the employee company.
  • The debit account specified for the project's company.

When you select Create Journal Entry, fields in the Journal Entry Information grid and the Journal Entry Override grid are enabled so you can provide information DPS uses to create the journal entries.

This option is enabled only if Reclass Intercompany Suspense as Receivable/Payable only is not selected.

Journal Entry Information Grid

Field Description
Journal Entry Information drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Company This column displays the name of the company for which you are entering journal entry information. The grid contains a row for each company in your enterprise. DPS uses information from different rows to create journal entries between originating and target companies.
Credit Account Click and select the account to receive the credit entry when this company is the employee's company (the originating company).
Debit Account Click and select the account to receive the debit entry when this company is the project's company (the target company).
Rate Method If you selected Create Journal Entry, select one of the following rate methods for the company:
  • Multiplier — Select this option to calculate intercompany labor charges based on cost and a cost multiplier.
  • Rate Table— Select this option to calculate intercompany labor charges based on a labor rate table. Specify the billing rate table in Rate Table.You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table.
  • By Category— Select this option to calculate intercompany labor charges based on a labor category table. Specify the billing rate table in Rate Table.You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table.
  • By Labor Code— Select this option to calculate intercompany labor charges based on a labor code table. Specify the billing rate table in Rate Table. You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table. (If DPS is not configured to use labor codes this option is not available.)

If you want to use a different rate method for transactions between specific companies, you can specify that method in the Journal Entry Override grid. You can also override this global rate method for a specific project on the Intercompany Billing tab of the Projects hub.

Rate Table If you selected Rate Table, By Category, or By Labor Code in Rate Method, select the labor rate, labor category, or labor code table in this field.

If the user configuring intercompany billing has not been given access to all billing rate tables in role security, only the rate tables to which their role has access are available for selection.

Multiplier If you selected Create Journal Entry, enter the default global multiplier for the company. You can apply a multiplier regardless of the rate method you select. Enter 1.00 if you do not want to apply a multiplier.

A 0.00 multiplier means that the cost or billing amount will be multiplied by 0.

If you want to use different global multipliers for transactions between specific companies, you can specify those multipliers in the Journal Entry Override grid. You can also override this global multiplier for a specific project on the Intercompany Billing tab of the Projects hub. In addition, if you select Multiplier in Rate Method, you can override this multiplier at the organization level on the Intercompany Billing tab of the Individual Organization Setup form.

Journal Entry Override Grid

Field Description
Journal Entry Override drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Insert Click this option to enter a new row of journal entry override information.
Copy To create a new row of journal entry override information by copying an existing row, select the existing row and click this option.
Delete To delete a row, select the row and click this option.
Target Company If you want to enter override rate information for a pair of companies, select the company that will receive the intercompany billing.

If you also want to enter override information for this company as the originating company and the company in Originating Company as the target company, insert another row in the grid and enter that information.

Originating Company Select the company that will bill the target company for the labor. For labor, this is the employee's company.
Rate Method Select one of the following rate methods for these companies:
  • Multiplier — Select this option to calculate intercompany labor charges based on cost and a cost multiplier.
  • Rate Table — Select this option to calculate intercompany labor charges based on a labor rate table. Specify the billing rate table in Rate Table.You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table.
  • By Category — Select this option to calculate intercompany labor charges based on a labor category table. Specify the billing rate table in Rate Table.You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table.
  • By Labor Code — Select this option to calculate intercompany labor charges based on a labor code table. Specify the billing rate table in Rate Table. You can specify a multiplier for this method if you want to apply a discount or premium to the normal billing rates defined in the rate table. (If DPS is not configured to use labor codes this option is not available.)

You can override this rate method for a specific project on the Intercompany Billing tab of the Projects hub.

Rate Table If you selected Rate Table, By Category, or By Labor Code in Rate Method, select the labor rate, labor category, or labor code table in this field.

If the user configuring intercompany billing has not been given access to all billing rate tables in role security, only the rate tables to which their role has access are available for selection.

Multiplier Enter the override multiplier for these companies. You can apply a multiplier regardless of the rate method you select. Enter 1.00 if you do not want to apply a multiplier.

A 0.00 multiplier means that the cost or billing amount will be multiplied by 0.

You can override this multiplier for a specific project on the Intercompany Billing tab of the Projects hub. In addition, if you select Multiplier in Rate Method, you can override this multiplier at the organization level on the Intercompany Billing tab of the Individual Organization Setup form.