How Do Labor Cost Transfers Work?

This example shows how labor cost transfers work.

In this example, Amy Green was paid weekly for the period of July 31 to August 6, 2005. Her labor distribution template splits her labor costs between two grants. However, one of the grants expired on August 4 and the template for the new grant was not yet approved when Amy’s payroll was processed. The portion of Amy’s salary that could not be charged to the new grant was charged to her home department. The grant administrator has since approved the new labor distribution template, but now needs to reallocate Amy’s time charged to her department to the new grant.

Two templates applied to Amy’s pay records for July 31 to August 6:

Labor Distribution Template 1 - Effective Date 11/13/2004

Activity Acct Cat Co Account End Date Sal % Status
SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries 08/03/2005 40 Approved
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries 11/12/2005 60 Approved

Labor Distribution Template 2 - Effective Date 08/04/2005

Activity Acct Cat Co Account End Date Sal % Status
SleepApnea-Y2 Labor Metro Hospital Cardio Research Salaries 08/03/2006 40 Released
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries 11/12/2005 60 Approved

The existing wage expense distribution records for Amy look like this:

Time Record (Transaction) Date Activity Acct Cat Co Account Amount
08/01/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/01/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
08/02/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/02/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
08/03/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/03/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
08/04/2005 Metro Hospital Cardiology $160
08/04/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
08/05/2005 Metro Hospital Cardiology $160
08/05/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240

The distributions for August 1 – 3 are correct, but the distributions for August 4 - 5 need to be charged to the new award year. To correct this, the grant administrator created this labor cost transfer template:

Labor Cost Transfer Template - Effective Date 08/04/05 to 08/05/05

Activity Acct Cat Co Account Sal % Status
SleepApnea-Y2 Labor Metro Hospital Cardio Research Salaries 40 Approved
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries 60 Approved

The grant administrator processes labor cost transfers with the following results on the existing distributions:

Time Record (Transaction) Date Activity Acct Cat Co Account Amount
08/01/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/01/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
Result No eligible cost transfer template for August 1, original distributions are maintained
08/02/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/02/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
Result No eligible cost transfer template for August 2, original distributions are maintained
08/03/2005 SleepApnea-Y1 Labor Metro Hospital Cardio Research Salaries $160
08/03/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
Result No eligible cost transfer template for August 3, original distributions are maintained
08/04/2005 Metro Hospital Cardiology $160
08/04/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
Reversing Distributions Metro Hospital Cardiology ($160)
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries ($240)

New Distributions

SleepApnea-Y2 Labor Metro Hospital Cardio Research Salaries $160
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
08/05/2005 Metro Hospital Cardiology $160
08/05/2005 CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240
Reversing Distributions Metro Hospital Cardiology ($160)
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries ($240)

New Distributions

SleepApnea-Y2 Labor Metro Hospital Cardio Research Salaries $160
CardiacRegen-Y3 Labor Metro Hospital Cardio Research Salaries $240

Note that the template is applied to each individual distribution record. The reversing and new records contain the original time record date but are posted using the date specified on the labor cost transfer processing parameters. Transactions are summarized for posting to Project Accounting and General Ledger.

Note: This example shows wage reversals and redistributions. When you view the Labor Cost Transfer Processing Report, you will see reversing and adjusting transactions by check ID.