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.