Loading...

Timesheet Settings

Timesheet Settings

1. Login to Hour Timesheet as an admin

2. Navigate to the Settings menu

3. Click the Timesheet tab

Timesheet Settings Tab

Timesheet Settings Timesheet Type

This is the timesheet period displayed in the My Timesheet menu for each employee. Changes to this setting after timesheet data exist in your site will cause a conflict of reporting data. Please contact customer support at support@hourtimesheet.com before changing this setting if your account already has existing timesheet data. Timesheet options are:

Weekly

Biweekly

Semi-monthly

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. [Do not change this setting]

Business Rules

Timesheet Settings Business Rules

Capture reason for any changes made in previous day

When this box is checked, users will be prompted to insert a reason for editing a prior day on the timesheet or failing to enter time on the current day. NOTE: This box should be checked for DCAA compliance.

Restrict Employees from charging work hour in advance

When this box is checked, users will not be allowed to enter time entries for billable items on the timesheet. NOTE: This box should be checked for DCAA compliance.

Allow employees to enter negative work hour on timesheet

This option only appears to customers using “Custom” integration. QuickBooks users are not allowed to enter negative values on timesheet.

Track and export leave hours against charge codes

This option applies to QuickBooks users who need to associate job codes and service items to leave types.

Restrict Employee to edit/delete clock in/out value once added

This option (when checked) restricts the employee from editing in/out punches. These punches can come from mobile app, web clock or time clock.

Restrict manual entry of in/out times on timesheet for employees

This option (when checked) restricts the employee from entering in/out punches. These punches can come from mobile app, web clock or time clock.

Adding a Web Connector File From QuickBooks

Are you a current Hour Timesheet software user?

If yes, click here. If not, continue reading to learn more about Hour Timesheet and how we use the web connector!

 

The Intuit QuickBooks Web Connector (QWC) is a Windows application developed by Intuit that allows data to be exchanged between QuickBooks Desktop users and service providers like Hour Timesheet. The QWC is a go-between application which enables data sharing with SaaS applications on the internet

QWC Requirements

To enable a web service to access your QuickBooks, you must use a QWC file provided by Hour Timesheet. You must have the QuickBooks company file open and you must be logged on as the QuickBooks administrative user for the initial installation of the QWC file. During the sign up process of your Hour Timesheet account, you are asked to create an admin-level password. That password is required to active the web connector service in QuickBooks.

Why use a web connector?

1. Auto-sync QuickBooks data into Hour Timesheet.

Because Hour Timesheet offers easy QuickBooks integration, manual entry of data is not required in your Hour Timesheet account. The web connector will successfully auto-populate all of your data from your company QuickBooks Desktop file.
  – Customer/Job list
  – Payroll Items
  – Service Items
  – Class
  – Employees
  – 1099’s

2. Auto-populate employee timecard data in QuickBooks.

All timesheet details import and populate the employee timecard in QuickBooks making it simple to process your payroll and create your customer invoices. The QuickBooks timecard includes:
  – Employee time by job code and by day
  – Comments entered by users in Hour Timesheet
  – Leave (PTO, Sick, Holiday, etc..) entered on the Hour Timesheet

NOTE: The Web Connector is designed to access only one company file on a Windows desktop computer.  If you have multiple companies and/or Hour Timesheet accounts that sync with QuickBooks, you will need a separate web connector file for each account and/our admin user.

Right Networks Users click here -> https://helpdesk.rightnetworks.com/s/article/QuickBooks-Web-Connector


Adding a QuickBooks Web Connector File Manually

Who is this article for:

Customers who host their QuickBooks in the cloud and need to add the web connector file manually

Customers looking to replace an existing web connector file (new computer, new admin, etc.)


Follow the steps below once an Hour Timesheet support rep has emailed you a QuickBooks Web Connector file (**.qwc file) with your HTS credentials. If you need to request a new web connector file, email support@hourtimesheet.com with the following information

> HTS account URL

> Email address of the person needing to run the web connector. Note, this admin must already be a user in your existing HTS account.

NOTE: You will need to be logged in to your company QuickBooks file with ADMIN permission and logged in to QuickBooks in Single User Mode initially to successfully set up the web connector file.


1.Save .qwc file from email to your local computer

2. Open your QuickBooks company file and navigate to the File/Update Web Services menu

3. Click the Add an Application button

4. Locate the .qwc file saved in step 1 above and click OK to begin the process

5. An “Authorize New Web Service” screen will pop up asking you to grant HTS access to your QuickBooks company file. Click OK

6. If prompted with an application certificate allowing HTS to read and modify your company file select the Yes, Always allow access even if QuickBooks is not running (LAST RADIO BUTTON)

7. Select the Admin user from the drop down box and click Continue. At this step in the process, you should now see the HTS web connector appear in the Web Connector box

8. Enter your password that you use to login to your HTS account into the Password field

9. Click the check box next to the HTS web connector file and click the Update Selected to successfully run your new web connector file.

timekeeping software free

For additional instructions about installing a QuickBooks Web Connector visit here

Web Connector Troubleshooting Guide

Web Connector Troubleshooting Guide

STEP A.  End all background processes related to QuickBooks using Task Manager.

  1. QuickBooks (Right click – End Task)
  2. Web Connector (Right click – End Task)

Task Manager

Step B. Delete Existing Web Connector File from Computer Using Registry Editor

  1. In Windows, enter “regedit” in the Windows search
  2. Expand the tree in this order [HKEY_CURRENT_USERSoftwareIntuitQBWebConnector].
  3. Right click QBWebConnector, click Delete

regedit

Step C. Set QuickBooks and related files to run as Administrator

  1. In Windows, search for Web Connector, right click, check “Run as administrator”.
  2. In Windows, search for QuickBooks, right click, check” Run as administrator”

run as admin

Step D. Set HTS QuickBooks Integration file to run as administrator

  1. Right click on HTS QuickBooks Integration icon from your desktop
  2. Click properties
  3. Click the Compatibility tab and check that option “Run this program as administrator”

Run QB as admin

Step E. Run the HTS QuickBooks Integration file (double click on desktop icon) from #4 above. When you see the screenshot below, make sure you change the selected option to the one highlighted below.

QuickBooks Authorization Prompt while setting up HTS

Step F. From your browser, login to your account of Hour Timesheet (URL used in signup process.

  1. Navigate to the Setting Menu
  2. Click the Connect to QuickBooks tab. You should now see a green text that states “Connected

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).