Excel workbook previewTime and Effort Report Template (2 CFR 200.430)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A time and effort report records how each employee's paid time was split between Federal awards and other activities, so that salaries charged to an award are supported by records of the work actually done. 2 CFR 200.430(g) sets the standards, and personnel costs are usually the largest cost tested in a Single Audit, so missing or estimated records are a frequent finding.
This workbook follows 200.430(g) as published on eCFR. Each row splits one employee's pay for a period across three awards, non-Federal programs, indirect work and unallowable activities, checks that the total is 100 percent and computes the dollars charged. Separate sheets compare budget estimates with actual effort, record daily hours for nonexempt staff and summarise the charges.
Who it is for
The grants accountant who must support salaries charged to Federal awards after the auditor or a program officer asked for effort records.
What is inside
- Effort report with 10 worked employee periods and 20 blank rows
- 6 effort columns: 3 Federal awards, non-Federal programs, indirect work and unallowable activities
- Live 100 percent check and pay charged to each award by formula
- After-the-fact review sheet comparing budget estimates with actual effort, with the adjustment in dollars
- Daily hours sheet for nonexempt staff, as 200.430(g)(3) requires, with live totals
- Awards sheet, certification statement sheet and a formula-driven summary
- Dropdowns, colour flags, freeze panes and landscape print fit
How to use it
Enter your three awards on the Awards sheet, then record each employee's actual effort for the period on the Effort Report sheet.
Files
- XLSXtime-and-effort-report-template.xlsx22 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
Does the Uniform Guidance still require effort certifications?
The current 200.430(g) does not prescribe a certification form. It requires records that accurately reflect the work performed, are supported by internal control, cover all compensated activity up to 100 percent and support the split between awards. Many organizations keep employee and supervisor sign-off as their internal control, which this workbook records.
Can payroll be charged on budget estimates?
Yes, for interim accounting only. Section 200.430(g)(1)(vii) allows budget estimates if they produce reasonable approximations, significant changes are entered promptly and the organization reviews the charges after the fact and adjusts them so the final charge is accurate. The after-the-fact review sheet in this workbook supports that review.
Do nonexempt employees need timesheets?
Yes. Section 200.430(g)(3) says that, under the Department of Labor rules for the Fair Labor Standards Act at 29 CFR part 516, salaries and wages of nonexempt employees must also be supported by records of the total hours worked each day. The daily hours sheet in this workbook records them.



