QuickBooks Integration Q&A

Common Q&A for Timesheet integration with QuickBooks and Hour Timesheet

Question 1. How does QuickBooks sync data with Hour Timesheet?

Answer. We utilize the Web Connector (provided by QuickBooks) to sync company data between QuickBooks Desktop and Hour Timesheet in real time. The version of QuickBooks Online offers a direct sync between the two systems making timesheet integration with QuickBooks simple!

Question 2. What type of data does QuickBooks sync with Hour Timesheet?

Employees: The sync tool will import all “active” QuickBooks employees and vendors (optional) into your Hour Timesheet account. Only vendors that have a First and Last Name field value in QuickBooks will be imported.

Customers/Jobs: The sync tool will import all “active” Customer/Jobs in to your Hour Timesheet account.

Service Items: The sync tool will import all “active” Service Items in to your Hour Timesheet account.

Classes: (optional) The sync tool will import all “active” Classes in to your Hour Timesheet account.

Payroll Items: (optional) The sync tool will import all “active” Payroll Items in to your Hour Timesheet account.

Question 3. How do I add a new data in Hour Timesheet (employees, customers, jobs, etc.)?

Answer – New data will need to be entered into your QuickBooks company file first. Once the new data is entered, you can use the web connector tool to import your new data in to your Hour Timesheet account.

Question 4. How will my employees receive their Hour Timesheet login credentials?

Answer – Hour Timesheet will send an email invitation to each employee with the link and login ID to the Hour Timesheet account included in the body of the email. Once the employee accesses the link, the employee will be prompted to create an initial password to login to Hour Timesheet.

Question 5. Can my employees track time against customers and jobs, service items, classes and payroll items?

Answer – Yes, your employees will be asked to select from a list of authorized charges. Employee authorized charges (EOC) are defined by the admin at the employee level. This feature enables the employees to only see EOC’s that are assigned to each user.

Question 6. How do I delete information in my Hour Timesheet account?

Answer – Once you mark the data (employee, customer, job, etc.) as inactive in QuickBooks, the data will be updated in your Hour Timesheet account upon performing the data sync.

Question 7. How does Hour Timesheet identify billable vs non-billable items on the timesheet?

Answer – By default, any EAC that includes a service item will be marked as billable time in QuickBooks.

Question 8. Can employees add comments to a timesheets?

Answer – Yes, Hour Timesheet includes a feature to allow employees to input general comments and daily comments.

Question 9. I exported my employee’s time into my company QuickBooks file, but now I need to make corrections. How do I do this?

Answer – Hour Timesheet does not allow processed timesheet data to be edited. Hour Timesheet will display a link on the Timesheet Review page that will allow the user to create a “corrected” copy of the timesheet. The detailed audit trail will show the log of all changes made to the revised timesheet.

Question 10. Can multiple supervisors approve a single timesheet?

Answer Yes. Hour Timesheet will allow for multiple supervisors to approve a timesheet.

Question 11. We have a requirement for our employees to enter hours worked daily, does Hour Timesheet include daily reminders?

Answer – Hour Timesheet includes the option to turn on daily notifications to serve as reminders for those employees who forget to enter time daily.

Question 12. I track my employee leave balance data manually in an Excel spreadsheet because QuickBooks doesn’t include all of the options I need, can Hour Timesheet manage leave?

Answer – Hour Timesheet has a full-function leave management feature that will allow accrued and earned types of leave tracking.

Learn More

Visit us in the marketplace

QuickBooks Online

QuickBooks Desktop

Additional Resources

QuickBooks Tutorials for Accountants

Attend a QuickBooks Training Class Near You

DCAA Compliant Timekeeping Software

Having been in the industry for over 25 years, there are a number of key topics that continue to come up when talking with a government contractor about DCAA compliant timekeeping software and requirements and guidelines. One common theme I hear time and time again is centered around managing correction previously entered time entries as well as enabling someone other than an employee to update an employee’s timesheet. There are many sources on the web and in your google searches that are willing to charge you for FAR training, consulting fees or “compliant bookkeeping. Go ahead, do a little “google research” or just ask one of our many referral partners.

Advice from the experts about DCAA Compliance and Timekeeping Software

Everything needs to be tracked – Time spent on overhead tasks, bid and proposals, training, leave (paid or unpaid) and yes, even uncompensated time should be recorded on a timesheet. Bottom line, all hours worked by employees are required to be tracked by a companies’ timesheet software.

Timekeeping isn’t just for hourly employees -Employees working on contract and in the corporate office need to track hours in order to properly manage DCAA compliance and timekeeping Software . This includes salaried and hourly employees. This includes both labor cost and indirect labor cost (overhead, G&A, B&P)

Corrections on timesheets are okay – Budgets change, mistakes are made, people forget.. that’s why documented timekeeping procedures that include a correction process is imperative.

DCAA Compliant Timekeeping Software: Audit logs are the key – With the internet, all things are possible. Anywhere. Anytime. A detailed audit trail real time edits to all timesheet entries. The time, the place as well as the details.

Do practice floor checks – let your employees know what to expect in the event that the defense contract audit agency does to a floor. Quarterly planned practice floor checks will put your employees at ease.

Just saying it doesn’t make it true – Any software can claim that their software meets DCAA Compliance and Timekeeping Software regulations but we don’t just say it, we guarantee it. Our experts of 20+ years will make sure!

Additional Resources

Measure Costs Right: Make the Right Decisions

How To Calculate And Track Overhead Costs

How do I Calculate Overhead Costs?

Federal Acquisition Regulation Full Download

Federal Timekeeping Policies for Government Contractors (chron.com)

Record-keeping Requirements under the Fair Labor Standards Act

Sign Up today to experience the best DCAA Compliance and Timekeeping Software

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,

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 is tracked

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

Hour Timesheet: The Ultimate Solution for DCAA Compliant Employee Time Cards

DCAA Timekeeping

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 and Gusto Payroll 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.

When it comes to time tracking, user-friendly features are crucial. Imagine a clean interface, intuitive buttons, and straightforward navigation.

Newer Posts →