Applies to versions: 1.4, 1.8, 1.9, 1.10, 1.11, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 3.0, 3.1, 3.2

QuickBooks Integration - Setup QuickBooks

Before running the QuickBooks^® Integration for the first time, you need to setup QuickBooks and TimeIPS. This article discusses the QuickBook settings that need to be adjusted prior to the integration.

Open your QuickBooks company file.

1. Verify that employee's First Name, Middle Name/Middle Initial, and Last Name match exactly (letter for letter including punctuation and capitalization) between QuickBooks and TimeIPS.
   
   NOTE: QuickBooks stores up to 5 characters of the middle name. You can set the number of characters TimeIPS should use during the integration. If the employee's middle name in QuickBooks and the shortened middle name in TimeIPS do not match, the integration will fail. Therefore, be sure to enter the middle names identically in both programs and indicate the number of characters TimeIPS should use during the integration when setting up TimeIPS.
   
   EXAMPLE: Johnathon Alexander Smith is an employee. His name is entered as Johnathon Alexa Smith in Quickbooks because QuickBooks will store only the first 5 characters. In TimeIPS, the entire middle name can be entered as long as the QuickBooks export is set to shorten the middle name to 5 characters.
   
   NOTE: To edit an employee's name in QuickBooks, double-click on the name in the Employee Center. Select "Personal Info" in the pull-down and click on the "Personal Tab". See the Edit Employee screenshot below.


2. Use Time Data to Create Paychecks.
   From the Employee Center, double-click on the employee's name.
   
   • Select Payroll & Compensation in the pull-down.
     
     
     
     Edit Employee Screen
   • Check the Use Time Data to Create Paychecks checkbox.
     
     TIP: TimeIPS can automatically select this option for you during the integration. See "SETUP TIMEIPS step 3" for more information.

1. Note how employee's names are listed in QuickBooks.
   Click on the Payroll & Employees icon.
   
   
   
   Company Option Screen
   
   
   • Note whether the Display Employee List by is set to First Name or Last Name.
   
   
   NOTE: For TimeIPS versions prior to 1.3, the "Display Employee list by" must be set to "First Name" for a successful integration. Subsequent versions allow users to define the employee name format.
2. Turn Time Tracking on.
   Click on the Time Tracking icon.
   
   
   
   Time Tracking
   
   
   • Select Yes in the Do You Track Time radio button.


3. Setup and write down your Payroll Items.
   Go to the Lists menu - Payroll Item List.
   
   
   Pay Item List
   
   
   • For each TimeIPS Payroll Type, setup QuickBooks payroll items for the following TimeIPS pay types: standardtime, vacation, overtime, holiday, doubletime, and sick.
     
     NOTE: Right-click and choose New to create a new Payroll Item. You can name each pay type however you wish. You will enter the exact QuickBook Payroll Item name into TimeIPS's Export Type Settings when Setting up TimeIPS.
     
     NOTE: For The Payroll Item List to appear under Lists menu you must activate payroll with in Quickbooks. See your Quckbooks help file for more information.
4. Determine the path of your QuickBook's Company File.
   Close down QuickBooks by going to the File menu - Close Company option, then open the Company file again.
   Go to the File menu - Open Previous Company option and write down the file path.
   
   
   
   Company File Name
   
   
   • Write down the path exactly as it is listed. You will enter this in the QuickBooks Company File Path when Setting up TimeIPS.
     
     NOTE: The file name ends with ".QBW" though the extension may not display in the Open Previous Company list. You must include this extension when you enter the file name in TimeIPS.

Setup Employee Information.

Go to the Employees menu - Employee Center.

The Employee List Screen

Setup QuickBooks Company options.

In QuickBooks, go to the Edit menu - Preferences option. Click on the Company Preferences tab.

You are now ready to Setup TimeIPS. Use the "See Also" links below to learn more.