First page of the DCAA Compliant Timesheet TemplateExcel workbook preview

FAR, CAS and DCAA

DCAA Compliant Timesheet Template

DCAA timesheet template in Excel: daily hours by charge code, total time with uncompensated overtime, late entry flags, a corrections log and sign-off.

Excel workbook · 20 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A DCAA compliant timesheet is the source document for every labor dollar a government contractor bills or claims. Auditors expect each employee to record all hours worked, paid or not, every day, against the cost objective actually worked on, and expect the employee to certify and the supervisor to approve each timesheet. Small contractors often meet a first preaward survey or floor check with a spreadsheet that totals hours but cannot show any of that. This template gives them a timesheet built around those expectations.

The workbook has a weekly timesheet, a charge code list, a corrections log and a labor summary. Formulas total the hours by cost type, calculate uncompensated overtime for exempt employees and flag late entries and unknown codes. The structure follows the timekeeping criteria in DFARS 252.242-7006, the documentation rule in FAR 31.201-2(d) and the timekeeping guidance in the DCAA Information for Contractors manual, all free on acquisition.gov and dcaa.mil.

Who it is for

The controller or office manager at a small government contractor who was told by DCAA or a prime that the current timesheets do not hold up.

What is inside

  • Weekly timesheet with 16 charge lines (8 worked sample lines) and daily dates that follow the week ending date
  • Charge code dropdown linked to a Charge Codes sheet of 14 sample codes plus 16 blank rows, with an inactive code warning
  • Total time accounting: direct, indirect, unallowable, paid leave and unpaid leave hours, all by formula
  • Uncompensated overtime for exempt staff and hours above the standard week for non-exempt staff, calculated live
  • Daily entry check that flags a late or missing entry for any day with hours
  • Employee certification and supervisor approval block with a ready for payroll status
  • Corrections Log with 8 sample changes and 16 blank rows, showing the original and corrected charge, employee concurrence and approval
  • Labor Summary sheet with hours by charge code and by cost type, built on SUMIF formulas

How to use it

Replace the sample charge codes on the Charge Codes sheet with your own, then copy the Timesheet sheet once for each employee and week.

Files

  • XLSXdcaa-compliant-timesheet-template.xlsx20 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

What makes a timesheet DCAA compliant?

There is no single approved form. DCAA looks for daily recording of all hours worked, paid or unpaid, charges to the cost objective actually worked on, employee certification, supervisor approval, and a documented trail for every change that shows the original entry, the corrected entry and the employee's concurrence. The timesheet must also feed a labor distribution that reconciles to payroll and the general ledger.

Do exempt employees have to record more than 40 hours?

Yes, if they worked them. DCAA guidance says all hours worked should be recorded whether they are paid or not, because labor costs and the related overheads depend on total hours worked. The extra hours of a salaried exempt employee are uncompensated overtime. This template records them and shows them separately so payroll and pricing can treat them consistently.

Can a supervisor fill in a timesheet for an employee?

DCAA guidance says a supervisor should not complete an employee's timesheet unless the employee is absent for a prolonged period on authorized leave. In that case the timesheet should show that the supervisor entered it. Supervisors who are accountable for contract budgets should also not be able to initiate time charges for their staff.