User manual

4-50 Time Guardian v4.0 User’s Guide
QuickBooks Compatibility
Note: Time Guardian is compatible with QuickBooks 2007 or higher for automatic integration.
Time Guardian is compatible with the following versions of QuickBooks for manual export:
• QuickBooks 2007 and Enterprise 7.0
• QuickBooks 2006 and Enterprise 6.0
• QuickBooks 2005 and Enterprise 5.0 (R5 and later)
• QuickBooks 2005 and Enterprise 5.0
• QuickBooks 2004 and Enterprise 3.0 (R7 and above)
• QuickBooks 2003
• QuickBooks 2002 (R2 and above)
• QuickBooks 2002
Excel
1. Select whether or not to:
The setup process to create an export file for Excel is as follows:
Show employees with no hours
Separate records by day
Pass wages
2. Enter the Payroll Number from the dropdown menu. Your choices are: Employee Number,
Badge Number, or Social Security Number.
2. Enter the Date Format from the dropdown menu. Your choices are: MM/dd/yyyy,
yyyy/MM/dd, or dd MM yyyy.
3. Enter the Hours Format from the dropdown menu. Your choices are: Hundredths, Minutes,
or Hours:Minutes.
4. Choose the location and file name for the CSV export file. This information is entered in the
select path field.
Example: C:\ProgramFiles\Time Guardian\ filename
5. Select the paycodes from the dropdown menus.
6. Select the employees to be included in the payroll file. Your options are:
• All: Every employee entered in Time Guardian will be included in the payroll file.
• Current: Only the employee currently highlighted in the Employee List box will be
included in the payroll file.
• Selected: Only the employee displayed in the Employee List box will be included in the
payroll export file.
7. The last screen (pg 4 of 4) shows a summary of the information contained in the payroll
export file.
8. Select the Save Payroll Settings
icon and then select the Run Payroll icon to
generate the export file.