Shared staff on federal grants: build a defensible time-allocation record

A program manager starts the month expecting to split her work between two grants. A vacancy then pulls her into organization-wide scheduling, while a delayed program launch reduces work on one award. Payroll still arrives on schedule. The finance problem is deciding which activities should carry that compensation after the work has happened.

For federal awards subject to 2 CFR Part 200, build the allocation from supported activity and the applicable award terms. Private grants, other contracts, and payroll-law records can have different requirements. A grant budget helps plan staffing; it does not, by itself, establish the final distribution of actual personnel expense.

Section 200.430 requires personnel records that reflect work performed, connect to official records and internal controls, and encompass the employee's compensated activities. Budget estimates can support interim accounting under specified conditions, including subsequent review and necessary adjustments. The final record needs to explain the work, rather than merely repeat the approved percentage.

Use activity codes that staff can distinguish during an ordinary working day. Separate the two programs from administration, fundraising, and other material activities. Write short examples for ambiguous work, such as a meeting that serves several programs. Give employees a place to ask about classification before every uncertain hour goes into the largest grant.

Keep compensation periods aligned. A calendar-month activity summary must have a documented connection to payroll periods that cross month-end. Record how paid leave and related benefits are handled under the organization's policy and applicable requirements, instead of forcing those amounts into productive hours to make a worksheet balance.

Section 200.405 links allocation to the relative benefits received. It also restricts moving a cost from one federal award to another merely to cover a funding shortfall or avoid a restriction. A grant with unused money is not an alternative activity code for work that supported a different objective.

Have a supervisor review unusual changes while the work is still recognizable. Ask what changed, which program benefited, and where the support is retained. A brief description of a cancelled workshop or temporary reassignment can be more useful than a late signature on an unexplained percentage. Finance then checks the distribution against payroll and the award's charging rules.

Suppose, hypothetically, an employee has $9,600 of salary for the period. The initial distribution charges 60% to Grant A, 30% to Grant B, and 10% to administration: $5,760, $2,880, and $960. The supported final activity distribution is 50%, 30%, and 20%, respectively. Assume the classified work and salary are otherwise eligible under the relevant terms.

The corrected amounts are $4,800, $2,880, and $1,920. Transfer $960 from Grant A to administration. Total salary remains $9,600; the correction changes its destination. Benefits or other associated charges may also need review under their own allocation policy. Do not assume they are included in this salary-only example.

Connect the correction to any reimbursement request or grant report that already included the original amount. Changing the ledger without checking the submitted report leaves two versions of the same expenditure. Record whether an amended submission, credit on the next request, or another funder-approved process resolves the difference.

Review missing periods, identical percentages despite known role changes, overlapping activity totals, and corrections entered just before a grant closes. These patterns are reasons to ask for evidence, not proof that the underlying work was improper. Retain the original submission and document the correction rather than overwriting the trail.

A staff departure creates a particular risk. Recover open activity records, the supervisor's explanation, and unresolved coding questions before access disappears. Keep a separate list of entries awaiting support so the close does not silently treat uncertainty as confirmed grant expense.

Assign one owner to collect activity records, another to review the allocation where practical, and a named finance reviewer to reconcile the payroll total. Set the review timetable around reimbursement deadlines and the organization's close. A routine completed promptly is more useful than an elaborate process that produces explanations months later.

The finished file should let someone follow a salary amount from payroll to activity, allocation, journal entry, and grant report. It should also show unresolved questions and their treatment. That traceability supports review without claiming that a particular spreadsheet format alone guarantees compliance.