One office of DCAA has rejected the use of Excel for timesheets where time is entered onto the spreadsheet given the flexibility of changing time after the fact, thus compromising the integrity of your entire accounting and billing system. While the method of creating a blank timesheet in Excel, printing out the template, recording time manually, and having the employee and supervisor sign off remains acceptable, direct entry of time in Excel through the computer is not.
To solve this problem, adopt a manual system, or look at DCAA-compliant, web-based applications to help your timekeeping system remain acceptable. When selecting any web-based timekeeping system that has round-tripping synchronization with Quickbooks, be careful as controls may be weakened if payroll item data is changed in Quickbooks.
For more information and helpful tips, visit our website at www.mokercpa.com.