Example of Loading Costing of Payroll
Use HCM Data Loader to assign account information to payrolls. You can select this highest level for segments that seldom change for the people assigned to the payroll, such as company and line of business.
As a best practice, set up a suspense and default account at the payroll level. Otherwise, you must set up a suspense and default account for every department to ensure you charge invalid costs to an account.
Example
Vision Corp has multiple payrolls, such as weekly and monthly and loads costing details at the payroll level. And they use the costing information to report labor cost and generate journal entries for all their employees for the specified payroll.
Load these costing details for the monthly payroll Vision Corp Monthly.
|
Parameter |
Value |
|---|---|
|
Fund (Segment1) |
All Funds; 0001 |
|
Appropriation (Segment2) |
Salaries Appropriation;1001 |
|
Funding Source(Segment3) |
Original Funding Source;1010 |
|
Department(Segment4) |
General Government Agencies;1000 |
|
Organization(Segment5) |
Payroll; 1003 |
|
Program(Segment6) |
Balance Sheet; 0000 |
|
Object (Segment7) |
Unspecified;0000 |
|
Project(Segment8) |
Unspecified; 0000 |
Load values for both suspense and default accounts.
|
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 allocation details for the monthly payroll.
METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|PayrollCode|LegislativeDataGroupName
MERGE|CostAllocationV3|4712/12/31|2010/01/01|PAY|Vision Corp Monthly| Vision Corp
This example .dat file loads the costing account details for the monthly payroll.
METADATA|CostAllocationAccountV3|SourceType|PayrollCode|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3|Segment4|Segment5|Segment6|Segment7|Segment8
MERGE|CostAllocationAccountV3|PAY|Vision Corp Monthly|Vision Corp|2010/01/01|COST|1|1||0001|1001|1010|1000|1003|0000|0000|0000
MERGE|CostAllocationAccountV3|PAY|Vision Corp Monthly|Vision Corp|2010/01/01|SUSP|1|1|0000.0000.0000.0000.0000.0000.0000.0000||
MERGE|CostAllocationAccountV3|PAY|Vision Corp Monthly|Vision Corp|2010/01/01|DFLT|1|1|0000.0000.0000.0000.0000.0000.0000.0000||