Loading...

Web Connector Installer for QuickBooks Desktop Integration

Simple Timesheet Setup for QuickBooks Desktop Integration

The Web Connector is a built-in add on service that works with the following versions of Intuit and QuickBooks Desktop versions:

QuickBooks Enterprise Solutions (2015 or later)
QuickBooks Premier (2015 or later)
QuickBooks Pro (2015 or later)

If you have other applications exchanging data with your QuickBooks Desktop, you will already have a version of the connector downloaded. Use the link below provided in the setup wizard to connect your Hour Timesheet site to the Web Connector. Follow these steps to successfully download and integrate Hour Timesheet with your QuickBooks Desktop company file.

Before you begin. Make sure QuickBooks Desktop is running on your machine and the company file that you want to connect with Hour Timesheet is open. Follow the instructions below for QuickBooks Desktop Integration (setting up the web connector)

Screen 1 – Click Download Here to begin with execution of the Hour Timesheet QuickBooks integration setup Wizard. Once download is complete, Run or Open the downloaded file from  your browser.

 

Screen 2 – Click Next to continue with execution of the HTS QuickBooks Integration Setup Wizard

welcome installer SS

Screen 3 – Terms of Use Agreement. Place a check in the box “I accept the terms in the License Agreement box and click Next

End User Agreement SS

Screen 4 – Click Next to download the file to the location provided in the path. This location can be changed if required.

path ss

Screen 5 – Click Install to begin the installation process.

ready to install ss

Screen 6 – Click Finish to complete and exit the wizard.

completed installer ss

Screen 7 – You will now be prompted to enter the information captured during the completion of the  Hour Timesheet Sign Up form. Enter the domain (URL) along with the email address and password created in the 1st step of this process. Click Sign In then ‘Initiate Process’ to continue.

login creds ss

Screen 8 – You will now be prompted to allow Hour Timesheet to read and modify your company file  Make sure you change the default setting to the last option of radio buttons from the screenshot below  select Yes, always; allow access even if QuickBooks is not running (last option) from QuickBooks- Application Certificate popup window and click Continue.

timekeeping software for small business QBD Setup Instructions

 

Screen 9 – Click OK from ‘Authorize New Web Service’ to grant web service access to QuickBooks

authorize new web service

Screen 10 – After successfully adding the application to web connector, click Update Selected button from the web connector to start the import process connect to QuickBooks. If you have more than one application connected to your company QuickBooks file, you will need to locate the Hour Timesheet application from the list and place a check in the left-hand check box.

 

web connector update ss

 

Best Practice – set the check box to Auto Run and change the value in the Every_Min to 60. This will automatically sync your QuickBooks company file and your newly created Hour Timesheet site ever 60 minutes.

Final Connection Setup – Upon successful completion, the Hour Timesheet Setup Wizard will change the connection status on the screen to Connected and the Next button will be active (you can click it).

Site Setup for QuickBooks Desktop

Signing Up

Fill out the Sign Up form on our home page .  Once the form is complete, a setup wizard will walk you through the Hour Timesheet setup process. The form requires the following information:

  • First Name, Last Name
  • Cell Number
  • Email Address (this will be your primary admin user login)
  • Password
  • Company Name
  • Account Domain (this is your site URL, the system will generate your site url based on your company name)
  • Timezone

And your done! You now have your own Hour Timesheet URL

Setup Wizard

The wizard will direct you to the first step in the process. Don’t worry if you don’t have time to complete the setup now, you can come back to it at any time. You will also receive a confirmation email containing the URL and login information.  Save this email for a later date in case you don’t remember your Hour Timesheet site URL.

Display page while site is being created screenshot
Display Page While Site is Being Created

Configuration Wizard – Step 1 Timesheet Settings

Timesheet Type – This is the timesheet period. Your options are weekly, biweekly, semi-monthly and monthly.

Start Day of the Week – This is the day of the week that you would like your timesheet to begin on (Sunday, Monday, Tuesday,  etc).

Start Time – This is the start time of the day. The default time is set to 12am.

Capture reason for any changes made in previous days time (check box) – When this box is checked, users will be prompted to insert a reason for editing a prior days timesheet or failing to enter time on the current day. NOTE: This box should be checked for DCAA compliance.

Setting Hour Timesheet Preferences Screenshot
Step 1 – Timesheet Settings

Configuration Wizard – Step 2 Overtime Calculations

Calculate Weekly Overtime (check box)

Regular Hours per week* – This box should be checked for organizations who pay hourly employees. All hours exceeding the value entered in this box will automatically be classified as overtime.

Calculate Daily Overtime (check box)

Regular Hours per day* – This box is typically checked for organizations in California who are required to pay employees based on hours per day and not hours per week.

Setting Overtime Preferences Screenshot
Step 2 – Overtime Settings

Configuration Wizard – Step 3 Accounting Setup (QuickBooks Desktop)

Hour Timesheet will sync (import and export) data with your QuickBooks Desktop account using the QuickBooks Web Connector .  To sync your data, you will need access to your login credentials for your QuickBooks Desktop account.

Setting up link to QuickBooks Desktop screenshot
Step 3 – Accounting Setup

Configuration Wizard – Step 4 Import Preferences (QuickBooks Desktop)

You are now ready to select which data elements you will need to collect timesheet data against. Hour Timesheet will import Employee data by default (no check box required). You also have the ability to import Customer/Jobs, Payroll Items, Service Items, Classes and Vendors. Place a check in the box next to the data that you would like imported from your QuickBooks Desktop company file.

 

Configuration Wizard – Step 5 Setup Web Connector (QuickBooks Desktop)

The QuickBooks Web Connector is a software application that runs on Microsoft Windows that enables Hour Timesheet to exchange data with QuickBooks Desktop.

Download the Hour Timesheet QuickBooks Web Connector Installer File. (link provided in wizard). For detailed installer instructions, click the knowledge base link below.

Web Connector Installer Instructions

Upon successful completion, the Hour Timesheet Setup Wizard will change the connection status on the screen to Connected and the Next button will be active (you can click it).

Note: Once the import process is complete from QuickBooks Desktop a confirmation e-mail will be sent to you.

Automated email alert confirming successful import from QuickBooks
Automated email alert confirming successful import from QuickBooks

Configuration Wizard – Step 6 Identify Yourself (QuickBooks Online)

By default, you will only be given the Admin role. If you are also an end user and need to complete a timesheet, select your name in the box below. This process will give your username the employee role.

Setting up admin user as an employee
Setting up admin user as an employee

 Next Steps

Creating Groups (optional)

Assigning Supervisors to Groups

Creating Associations

Assigning Roles

Back to Knowledge Base Main

QuickBooks Desktop – Import & Export FAQ

Troubleshooting your web connector

Problem: New Data Not Showing up in HTS

I have updated my data in QuickBooks but the new data does not appear in HTS. The web connector looks like it’s running correctly.

Possible Fix

Password in web connector is incorrect.  The passwords in the web connector have to match your admin login to your HTS URL. If you have updated your password in your HTS account, you will have to manually update the password stored in the web connector.

Email in company QuickBooks file has been updated and no longer matches admin record in HTS.  If you have recently updated the admin email address in your company QuickBooks file, you will need to establish a new web connector file with the updated email address.

New data items have not been mapped.  New codes will not show up on the Accounting/Codes page until they have been mapped.  To create the required mapping, follow the instructions at https://www.hourtimesheet.com/knowledge-base/creating-associations/

Problem: Web Connector File Missing

I have a new computer and now I can’t find the web connector file for HTS.

Options to Fix

Follow the instructions on the Settings/Connect To QuickBooks page to download and configure a new web connector file

Email support@hourtimesheet.com and request a new web connector file.

Problem: Inactive Users Showing in HTS

I have marked a user as inactive several times in my HTS account and they continue to show up as Active

Fix

  1. If a user is still active in your company QuickBooks file, then each time you sync the data, the user will be marked active again. In order to make a user inactive in HTS, you will need to navigate to the Employee List/More  1) mark the user as inactive 2) Turn Off Sync

Problem: Nothing Showing Up on Export Page

Fix

Only approved timesheets will show up on the Export page.  To approve a timesheet, navigate to the Review Timesheet page and click Approve next to the completed timesheets.

The Export page defaults to the current week, if you are trying to export prior period timesheets, make sure you have the correct date selected in the date picker box.

Problem: My timesheet is missing from the Export page

Fix

Since you are not able to approve your own timesheet, you will need to assign a separate user access to approve your timesheet. To assign a supervisor to a group of employees view the link https://www.hourtimesheet.com/knowledge-base/setting-up-supervisors/

Problem: I Received an Email from HTS about Timesheet Export Failures

Possible Fix

Time record is marked as billable in HTS with no Service Item. If an item on the timesheet is marked as Billable then QuickBooks will expect that record to have a service item. To correct this issue, 1) the charge code association needs to be updated to include a service item or 2) the charge code association needs to be marked in HTS as non-billable.

Company Preferences is not set to track time in your QuickBooks file.  To make sure this setting is turned on, navigate to your company QuickBooks file and go to Edit/Preferences and locate the Time and Expense tab. Make sure the check box is checked for Do you track time?

An individual employee is not set to Use Time Data to Create PaychecksThis field must be checked for each employee for the timesheet export process to populate the time cards within your company QuickBooks file.

Supported Versions of QuickBooks (for web connector)

Hour Timesheet syncs with the Web Connector file provided by QuickBooks to exchange data. The following versions of QuickBooks are supported by Hour Timesheet:

QuickBooks Enterprise Solutions (2015 or later)

QuickBooks Premier (2015 or later)

QuickBooks Pro (2015 or later)

If you have other 3rd party applications exchanging data with your QuickBooks Desktop, you will already have a version of the connector downloaded. Use the link below provided in the setup wizard to connect your Hour Timesheet site to the Web Connector.

QuickBooks Desktop is not Running

QuickBooks and Hour Timesheet are not connected

Before you begin. Make sure QuickBooks Desktop is running on your machine and the company file that you want to connect with Hour Timesheet is open.

 


Back to Knowledge Base Main

Exporting Timesheet Data (CSV File)

Exporting Timesheet Data Using a CSV File

Menu Item: Export

Time entries created in Hour Timesheet can be exported to your accounting/payroll software.  Follow the instructions below for exporting timesheet data from Hour Timesheet.

Login to your Hour Timesheet login page as user with admin or accountant role

Navigate to the Export Timesheet menu item

Place a check in the box next to the timesheet(s) that you would like to export

Click the Export Selected button to begin the sync process.

A pop-up box will appear confirming the records to be exported.

Click the Export button to complete the export process request

Custom Export [Video clip]

Back to Knowledge Base Main

Supervisors – Purpose and Features

Global Level Supervisor vs Group Level Supervisor

The supervisor feature is created to provide specific users access to features and functions within Hour Timesheet. Supervisors have access to the following:

Review Timesheet – create, approve, edit and reject employee timesheet data

Run Reports – access to real-time reporting data

Receive Notifications – receive event-based and time-based email alerts


Assigning users to Supervisor Role

Global Level Supervisors – Users assigned the supervisor role will have access to the Timesheet Review menu once logged in. To assign a global level supervisor follow the steps below:

1. Login to Hour Timesheet as Admin

2. Navigate to Employee menu

3. Click the Assign Roles link next to the supervisor’s name

4. Select Supervisor from the drop down

assign supervisor role screenshot


Group Level Supervisors – to create a group level supervisor, follow steps 1-4 above then follow the additional steps below:

1. Login to Hour Timesheet as Admin

2. Navigate to Group menu

3. If group already exists, select group from box, click Edit this Group, begin typing name of supervisor identified in steps 1-4 above in Select Supervisor box

4. If group does not exist, click Create New Group and enter group details and user’s name in Select Supervisor box. Only users with assigned Supervisor roles will be available for selection. Groups may have multiple supervisors. NOTE: By default, Admins have access to Supervisor privileges.

Assigning supervisors to groups screenshoet


Timesheet Review Features for a Supervisor

Create, Approve or Reject an Employee Timesheet steps:

1. Login to Hour Timesheet

2. Navigate to Review Timesheet menu

3. Click the View Details icon to edit an employee timesheet.

4. Click the the Approve button to approve a timesheet for the period. This action will add a signature row to the timesheet along with a record in the audit trail. This action will also auto generate an email to the employee if notifications have been turned on in the Settings page.

Click the the Unapprove button to remove a supervisor’s signature from a timesheet. This action will add a record in the audit trail as well as auto generate an email to the employee if notifications have been turned on in the Settings page.

Click the Reject button to reject an employee’s timesheet for the period. This action will add a record in the audit trail as well as auto generate an email to the employee if notifications have been turned on in the Settings page.

Timesheet Review screenshot


Running Reports as a Supervisor

1. Login to Hour Timesheet

2. Navigate to Report menu

3. Complete the report criteria from the drop-downs

4. Name the report

5. Click the Generate Report

6. Your report will show Processing until which time report is available

Hour Timesheet Report Display Screenshot

 


Return to main Knowledge Base

Hour Timesheet Subscription

Monthly Charges by Hour Timesheet

Payments in Hour Timesheet are handled by Stripe. Stripe is an online payment service that accepts all major credit cards. Users of Hour Timesheet are by default given a 30-day free trial. Once the trail period is over, the admin user will need to access the payment page under the Settings menu and provide the appropriate credit card information to continue to use the Hour Timesheet software.  The site will prompt the users upon the expiration of the free trial and disable full functionality of the software.

Accounts are billed monthly and all payments are non-refundable.  To enter your payment details, follow the instructions below

1. Log in to your HTS account as an admin user

2. Navigate to the Settings Subscription/Payment tab

3. Enter your credit card information

4. Click Save

payment settings

NOTE: Once payment information is entered into HTS, the content is removed from the server for security purposes. Hour Timesheet does NOT store any payment information on the cloud. 

Pricing

For additional information on our pricing plans, visit https://www.hourtimesheet.com/pricing

Employee Overtime Options

Create and Assign Employee Overtime Rules

Overtime Rules

This feature allows the system admin to establish a business rule to set a threshold on the timesheet so that employees are forced to charge time to an “overtime” pay type once certain criteria is met (defined by the rule).  Once configured; the employees will be notified upon timesheet entry that hours must be moved to a pay type associated with overtime. These hours will be identified in RED on the timesheet to the employee


Options for capturing and calculating employee overtime on a timesheet

Calculate Weekly Overtime (check box) Regular Hours per week* – This box should be checked for organizations who pay hourly employees. All hours exceeding the value entered in this box will automatically be classified as overtime.

Calculate Daily Overtime (check box) Regular Hours per day* – This box is typically checked for organizations in California who are required to pay employees based on hours per day and not hours per week.

Hour Timesheet Overtime Settings


Assigning OT Rules

Once the overtime rule has been created, you will need to assign the rule to the appropriate users. To assign employees to the newly created overtime rule, follow the instructions below:

1. Click the rule from the drop-down box

2. Move the Employees from the “Available” box to the “Selected” box – these can be selected one at a time or be filtered by group.

3. Click Assign

Assign Overtime Rules

Smart Phone App

Hour Timesheet Mobile

Employee User Guide

Download Links

iOS Download: Apple iOS
Android Download: Google Play Store

Objective

Hour Timesheet Mobile provides remote employees access to the following functions.

  1. Clock In/Out
  2. Daily Timesheet Entries (job/leave codes)
  3. Leave Request

NOTE: Hour Timesheet Mobile includes employee features/functionality ONLY

Supported Devices

  • Android Smart Phones
  • iOS Phones
  • iPad Devices

NOT SUPPORTED: Android Tablets

Login Credentials

Only users with an existing Hour Timesheet account have access to successfully login to the Hour Timesheet Mobile App. Before logging in, users will have to create a password by clicking the link from the system generated email invitation (from the account admin). To login to your Hour Timesheet Mobile app you will need the following information:

  • Domain (DO NOT enter http:// or hourtimesheet.com)
  • Email
  • Password

Hour Timesheet Mobile Options

Option 1 Time Card

Employee Timekeeping On the Go Clock In/Clock Out without Job Tracking: Employees who are required to clock in/out daily will use this option. Users can have as many in/out pairs as needed (breaks, lunch, etc.).  This feature is optional. The default setting for this feature is OFF. To have this setting turned ON, please contact your Hour Timesheet Support Rep.           Actions Include

  • Clock In
  • Clock Out

Clock In/Clock Out with Job Tracking: Employees will be required to select a job code/project/dept/etc. upon clocking in.  Upon clocking out, the employee’s calculated time will be added to the “Hours Worked” section of the timesheet against the selected job code. This feature is optional and is hidden by default if no values are present in the in/out section of the timesheet. The default setting for this feature is ON. To have this setting turned OFF, please contact your Hour Timesheet Support Rep.  Actions Include

  • Clock “In” with job selection
  • Enter Notes (as part of Clock In process)
  • Clock “Out”

NOTE: This feature only allows the employee to see the current day’s activities. Employees can see previous day’s punches by accessing the account on a PC/Laptop using a browser-based account login.

Option 2 Timesheet HTS Mobile Timesheet

Add Hours Worked – this feature allows the user/employee to select from a predefined list of job codes to enter the duration of time (hours worked) on to the timesheet. Actions Include:

  • Selection of codes (list of customers/jobs/payroll items to charge time against)
  • Daily notes (optional)
  • Duration (hours worked)
  • Navigation buttons that allow the user to move from day-to-day to make timesheet entries for different dates (previous or future)
  • Cancel button
  • Save button

Add Leave Hours

This feature allows the user/employee to select from a predefined list of leave codes to enter on to the timesheet. Actions Include:

  • Selection of leave codes (list of leave items to charge time against)
  • Current leave balance
  • Notes (optional)
  • Duration (leave hours to be entered)
  • Navigation buttons allow the user to move from day-to-day to make timesheet entries for different dates (previous or future)
  • Cancel button
  • Save button

Submit Timesheet

This feature allows the user to submit/sign a timesheet for the current timesheet period. Actions Include:

  • Cancel button
  • Submit button

Option 3 Leave

Screenshot Of Hour Timesheet App - Leave Request Management Request Leave– this feature automates the workflow of requesting leave. Employees can:

  • Create/submit new leave request
  • View current balance
  • Add comments to leave request

ADP Integration

Before a csv file can be created from HTS for ADP, you must first provide the proper payroll items to the Hour Timesheet support desk so they can enter these codes on the back-end. 

Please send the pay codes that ADP requires to support@hourtimesheet.com

Saving ADP Exporting Settings (A One-time Requirement)

Timesheet data created in Hour Timesheet can be exported to ADP using a csv file.  To export data from Hour Timesheet, follow the instructions below.

Login to your Hour Timesheet login page as user with admin or accountant role

Navigate to the Export/Payroll Settings menu item

Complete the Payroll Settings data fields

  Payroll System – Select ADP

  File Identifier – Hour Timesheet will create a unique file name for you

  Pay Frequency – Select from Weekly, Bi-weekly, Semi-monthly or Monthly

Enter the Company Code/Client Code

If additional mapping is required, select the field that maps to the Pay Types in ADP from the Earning Code/Pay Type Mapping drop down provided

Click Save

ADP Export Settings screenshot

Exporting Timesheet Data to ADP

Navigate to the Export/Payroll Settings menu item

Place a check in the box next to the timesheet(s) that you would like to export

Click the Export Selected button to begin the sync process.

A pop-up box will appear confirming the records to be exported.

Click the Export button to complete the export process request

Custom Export [Video clip]

Inactive vs Active Users

Marking Users as Inactive in Hour Timesheet

Hour Timesheet will import your company’s employee and vendors (if selected) during the initial data import process as well as each time you sync your data. To set a user as inactive , follow the steps below:

1. Login to Hour Timesheet as a user with Admin role

2. Navigate to the Employee List menu

3. Click the More button next to the name of the employee you are wanting to terminate

4. Click the “Turn Sync Offif this user is active in your company QuickBooks file

5. Click the “Make Inactive

inactive users

This user will no longer show up on the active employee list.  You can use the Filter button on the top of the employee page to toggle the view between user types

Marking Inactive Users as Active

To set an Inactive user as Inactive , follow the steps below:

1. Login to Hour Timesheet as a user with Admin role

2. Navigate to the Employee List menu

3. Click the Filters button and select Filter by Employee Type then check the box next to Inactive Employees

4. Click the More button next to the name of the employee you are wanting to terminate

5. Click the “Turn Sync Onif this user is active in your company QuickBooks file

6. Click the “Make Active

inactive users

Timesheet Status Options

There are 3 different status’s file employee self-sign-up email invitations from Hour Timesheet

Pending Invite – the employee has not been sent an email invitation to sign up for Hour Timesheet. An email address must be in the email address field to trigger the Send Invite process.

Invitation Sent – the email invitation has been initiated from Hour Timesheet. The status will remain unchanged until the employee completes the sign-up process.

Signed Up – the employee has received the email and clicked the Sign-Up button to initiate the signup process. The link in the email will expire within 72 hours. If necessary, the Admin can resend the sign-up invitation to the employee.

View Video