1. HCM Data Loading Business Objects
  2. Example of Loading Costing of Departments

Example of Loading Costing of Departments

Use HCM Data Loader to define payroll costing rules at the Department level. For example, in a large enterprise you might set up default accounts for departments where the managers commonly review and resolve their department's expenses.

When you load costs at the department level, you can specify the percentage each account receives of the cost. If the total allocation isn't 100 percent, then the application places the invalid cost in a default account.

Example

Vision Corporation's Payroll Manager wants to allocate costing at the department level to two cost centers.

As this figure shows, she allocates 35 percent of the costs of the Administration department to the Eastern District Office. She allocates the remainder to the Western District Office.

Here, the Payroll Manager allocates 35 percent of the cost to the Eastern District office and the remaining 65 percent of the cost to the Western District office.

The Payroll Manager loads these costing details for the Administration department to two district officers as below:

Parameter

Eastern District Office

Western District Office

Percentage

35

65

Fund (Segment1)

Pooled Cash Fund: 0900

Pooled Cash Fund: 0901

Appropriation (Segment2)

1001

1001

Funding Source (Segment3)

1010

1011

Further, she uses the payroll suspense account to store costed payroll run results and prepayment results with invalid account combinations. She loads these suspense account details.

Parameter

Value

Fund (Segment1)

All Funds; 0001

Appropriation (Segment2)

Balance Sheet; 0000

Funding Source (Segment3)

Balance Sheet; 0000

Department (Segment4)

Balance Sheet; 0000

Organization (Segment5)

Balance Sheet; 0000

Object (Segment7)

Unspecified; 0000

Project (Segment8)

Unspecified; 0000

As Vision Corporation's department managers review and resolve their department expenses, the Payroll Manager sets up default accounts for the Administration department. She loads these values for the default account.

Parameter

Value

Fund (Segment1)

Unspecified; 0000

Appropriation (Segment2)

Balance Sheet; 0000

Funding Source (Segment3)

Balance Sheet; 0000

Department (Segment4)

Balance Sheet; 0000

Organization (Segment5)

Balance Sheet; 0000

Program (Segment6)

Balance Sheet; 0000

Object (Segment7)

Unspecified; 0000

Project (Segment8)

Unspecified; 0000

This example dat file loads the costing details for the two departments. 

METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|DepartmentName|LegislativeDataGroupName
MERGE|CostAllocationV3|4712/12/31|2010/01/01|ORG|Administration|Vision Corp

METADATA|CostAllocationAccountV3|SourceType|DepartmentName|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3|Segment4|Segment5|Segment6|Segment7|Segment8
MERGE|CostAllocationAccountV3|ORG|Administration|Vision Corp|2010/01/01|COST|0.35|1||0900|1001|1010||
MERGE|CostAllocationAccountV3|ORG|Administration|Vision Corp|2010/01/01|COST|0.65|2||0901|1333|220||
MERGE|CostAllocationAccountV3|ORG|Administration|Vision Corp|2010/01/01|SUSP|1|1|0001.0000.0000.0000.0000.0000.0000.0000||
MERGE|CostAllocationAccountV3|ORG|Administration|Vision Corp|2010/01/01|DFLT|1|1|0000.0000.0000.0000.0000.0000.0000.0000||

Related Topics