QuickBooks Timesheet Integration

Why Use Hour Timesheet

Instead of the QuickBooks Timesheet feature?

Detailed audit trail of all timesheet entries. Hour Timesheet contains an activity log that tracks each entry made to the employee time card. The QuickBooks Online time card feature does not.

Multiple supervisor signatures. Hour Timesheet allows for more than one supervisor to sign or approve each time card. Employees in a cross functional (matrix) organization can have each manager approve or reject each timesheet. The QuickBooks timesheet feature does not.

Authorized charges. Hour Timesheet includes the ability to limit employees to only see charge codes they are authorized to record hours worked against. Limiting what the employee can see on the timesheet eliminates the possibility of employees charging to unauthorized codes. The QuickBooks timesheet feature does not.

Reason required. Employees and contractors who don't log time worked daily can be prompted to enter a reason for the tardy entry. Hour Timesheet also requires the user to enter a reason for editing previously entered time on a timesheet The QuickBooks timesheet feature does not.

Correction timesheet process. Hour Timesheet includes a correction time tracking process providing alerts (emails) to supervisors and site admins when correction timesheet data is created. This feature assures that payroll is notified of any changes that effects payroll cost from prior payroll periods. The QuickBooks timesheet feature does not.

DCAA Compliant. Hour Timesheet is a fully featured software app that checks all of the boxes for DCAA compliance for both small businesses and large. The QuickBooks timesheet feature does not.

Free 30-day trial

Visit our listing in the Intuit Marketplace

QuickBooks Online | QuickBooks Desktop

With a click of a button Hour Timesheet syncs all of your QuickBooks Timesheet data to/from QuickBooks. Enter new employees, job codes, service items and class list in QuickBooks and use the sync tool to populate the same data into Hour Timesheet. Once time cards are submitted and approved by supervisors, all employee time data is populated back into QuickBooks Timesheet entries.

Question? What kind of data does the Web Connector sync with Hour Timesheet?

Answer: Employee List, Vendors (1099's), Customers & Jobs, Payroll Items, Service Items, Classes

Enter data ONCE in QuickBooks. Use the import tool inside Hour Timesheet to populate your site. The import tool can be used to update your data ANYTIME you add new data to QuickBooks.

After timesheets are completed, Hour Timesheet will import the data back into your company QuickBooks file by using the import tool as an admin from within Hour Timesheet.

Question: What does Hour Timesheet Send to QuickBooks?

Answer: The Timesheet Export process will populate the weekly time cards in your company QuickBooks file with the following data.

Employee Name, Date of Entry, Hours by Day/date, Customer, Job, Service Item, Class, and Payroll Item charged to on timesheet.

DCAA Approved Timekeeping System

Is Your Company Ready?

Most likely, your answer to this question is, “I don’t know”. It's often the case that a company thinks maybe they could be ready for a DCAA audit, but has little confidence that they would pass. On the other end of the spectrum, are you a company who thinks you're definitely ready for DCAA because you have an expensive or robust accounting and/or timekeeping system?

Unfortunately, if you never had DCAA in your office before, then you probably are not ready, regardless of your systems.

Contrary to what you may have heard, you cannot “buy” a DCAA-approved accounting system. No accounting or timekeeping system has ever, or will ever, receive DCAA’s stamp of approval. As a government agency, they will not endorse a product in that manner. In addition, DCAA never “approves” your systems anyway. Instead, they test your end to end system, policies and procedures and determine if it is “adequate”. In a nutshell, they want to make sure that you walk the talk and you do it according to regulation.

How can you prepare for an Audit?

Test yourself

Internal audits (or as we call them “mock audits”) are an ideal way for you to determine where your gaps are and correct those gaps. They are also great to get you ready for an audit as practice. Having an outside party review your accounting system, timekeeping system, chart of accounts, policies and procedures, then test you on those, is the only way to ensure you are ready. Without such a test, you are walking into the battlefield blind. - Arrowhead Solutions, LLC,

What do they test (or look for)

Daily time entry for every employee
Are all employees capturing all hours worked (paid and unpaid)
A detailed audit log or audit trail of every entry made to the employees time card
A system that tracks time by project or job codes
The ability to capture both direct labor cost and indirect labor cost
Supervisor submissions and approvals
Documented timekeeping procedures
All time worked (on government contracts) and overhead

Learn More

Read similar post about DCAA Compliant Timekeeping Practices

DCAA Compliant Timekeeping Key Requirements

Advice from the Experts

Tired of Deltek Timesheets?

For more information becoming a referral partner, visit our partner or visit us in the QuickBooks marketplace listing.

Referral Partner Listing

DCAA Compliant Timekeeping Checklist

Best practices

Timekeeping continues to be a hot item for government contractors including DCAA Compliance. Adequate timekeeping practices are crucial to successfully securing or maintaining a government contract accounting system. Often deficient timekeeping is the reason for failing a DCAA (defense contract audit agency) audits.

The timekeeping system or procedures must be documented in a timekeeping policy or procedure provided to all employees.

All of the key elements of an adequate timekeeping and compliant accounting system must be addressed.

Every employee must record their time daily.

Recording time in advance or days after the fact such as at the end of the week is not acceptable.

All time must be charged

Time must be charged by day and by project and/or indirect accounts. This includes direct labor cost, indirect labor cost and uncompensated overtime.

Employees must record all indirect time.

Hours not identifiable to a given project must be charged to a proper indirect cost account.

All employee leave time must be recorded.

Employees must record all vacation, sick, holiday and other leave time to the proper accounts.

Job codes that appear in the system should be initiated by finance or the system administrator.

Job codes must be provided to employees authorized to work on a given project.

Under no circumstance may personnel work on one project and record time to a different project.

Under no circumstance may personnel work on indirect tasks and record time as direct costs to a project or vice versa.

Corrections are approved by the employee’s supervisor.

Under unusual circumstances where the employee cannot make the changes to timesheet, the accountant or administrator may make such changes with the employee’s consent.

All employee time must be signed by the employee.

All employee time must be approved by the employee’s supervisor.

All employees should be provided at least documented time keeping training awareness.

Periodic monitoring of compliance with time tracking requirements should be conducted by "practice" dcaa audits or floor checks.

Time sheets and all corrections must be maintained for a period of at least 2 years.

However, project records under a government contract must be maintained for audit purposes for a period of three years after final payment. The requirements for record retention are contained in FAR Subpart 4.7.

Check out more about DCAA Compliant Timekeeping @ Edward D. Moore, CPA dcaaConsulting LLC

Learn More

Hour Timesheet includes all the features for a DCAA compliant time tracking software for both small businesses and large. Employee timesheets are in the cloud are available real time with an online approval timesheet process for supervisors.

Hour Timesheet Partner Listing

Read similar post about DCAA Compliant Timekeeping Practices

DCAA Compliant Timekeeping Key Requirements

Advice from the Experts

Tired of Deltek Timesheets?

Time Card Features for Employees In Hour Timesheet

Timesheet Sections The “My Timesheet” can be subdivided into 4 sections

Clock In/Clock Out – this section is OPTIONAL
Hours Worked – this section is required for QuickBooks timesheet integration
Notes/Summary – section for entering daily hours worked notes or viewing leave balance data or timesheet summary overview.
Timesheet Audit Log – non-editable activity log of all entries on the employee timesheet.

Section 1. Clock In/Clock Out

This section is auto populated with employee who clock in/out utilizing the web clock on the Hour Timesheet login page. Daily hours are totaled by calculating the time between “clocked in” and “clocked out”. A user may have as many in/out pairs as required. This feature is optional and is hidden by default if no values are present in the in/out section of the timesheet.

Section 2. Adding Work Hours and Leave Hours

Adding Work Hours - this section contains a set of drop down boxes that are available once the user clicks the “Add Work Hours” button on the timesheet. These codes are referred to as “Employee Authorized Charges”. These selections are designed limited to codes each user is “authorized” to use when charging time on the timesheet.
Adding Leave Hours - this section contains a set of drop down boxes that are available once the user clicks the “Add Leave Hours” button on the timesheet. These codes are the leave types that are available to each user of Hour Timesheet.
Copy Previous Timesheet Codes – this feature allows the user to copy the codes from the previous timesheet period to the current period.

Section 3. Timesheet Notes/Hours Summary/Leave Balance

Adding Notes – there are two types of notes that may be entered in the timesheet. General notes are notes that apply to the entire timesheet. Daily hours worked notes apply to the single entry of time entered for a specific authorized charge code on a specific day.
Hours Summary – This graphic shows the breakdown of hours worked on the current timesheet divided into the following categories 1) Regular Hours 2) Leave Hours 3) Overtime Hours
Leave Balances – Displays the current leave balance for each employee.

Section 4. Timesheet Audit Log

This section of the timesheet is auto populated with each entry into the employee timesheet. The audit trail captures the username of the person who made the timesheet entry, the IP address of the person who made the entry along with a time and date stamp of the entry made. The audit trail is not editable.

Hour Timesheet Simple Time Tracking

What Makes Hour Timesheet a DCAA Compliant Time Tracking Software

What Makes Hour Timesheet

a DCAA Compliant Time Tracking Software Solution

DAILY EMAIL REMINDERS

Hour Timesheet will send daily email reminders to those employees who don't enter hours worked daily.

REASON REQUIRED

Employees who don't enter daily time entries can be prompted to enter a reason for the tardy entry. Hour Timesheet also requires the user to enter a reason for editing worked hours previously entered data on a timesheet.

CORRECTION TIMESHEET PROCESS

Hour Timesheet includes a correction timesheet process providing alerts (emails) to supervisors and site admins when correction timesheets are created.

DETAILED AUDIT LOG

Hour Timesheet includes a real-time detailed employee timesheet audit trail that captures all entries, edits and corrections. The detailed audit trail captures an IP address and a time and date stamp of each entry made to the time card.

CUSTOM SETTINGS

Hour Timesheet includes the option of having an 8-day timesheet for those hourly employee needing to track 9-10 hour days without charging to overtime.

Try Now

Need some help with setting up your accounting software to integrate with your DCAA (Defense Contract Audit Agency) Compliant timekeeping Software Solution? Ask one of our many referral partners who have decades of experience with DCAA timekeeping requirements and timekeeping procedures and DCAA audit procedures.

Government contracting requires all hours to be tracked by both hourly and salaried employees. Hour Timesheet includes the ability for employees are able to track time again overhead, G&A, B&P as well as any other non-billable codes and billable labor cost.

Check out Hour Timesheet with full DCAA compliance and allow your employees to track time on the internet, mobile app or any remote device.

Check out our DCAA Compliant Time Tracking Software Solution listing in the Apps for QuickBooks Desktop Marketplace website.

$8/user with NO setup Fees, NO support fees and NO contract.

Start your 30-day free trail now.

Additional Resources

Can managers change employee timesheets?

Google Play Timekeeping App Listing