Do You Use Excel for Timekeeping Under Your Government Contract? BEWARE!

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.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s