How to Integrate QuickBooks Time with Sage 50

Install the integration

From the left menu under Reports, select Sage 50 Export.
Next to Report Dates, select a pay period and date range.
Do one of the following:
- To include all employees in the spreadsheet: Leave Filter by set to all employees.
- To include select employees in the spreadsheet: Select all employees, select the employees or groups, then OK.
Select Download CSV, and save the file.
In Sage, select File, then select Import/Export.
Select Time/Expense, then Time Ticket Register and Import.
Select the Options tab, and select the .csv file you exported from QuickBooks Time.
Select the First Row Contains Headings checkbox, then OK.

Employee/Vendor: 0 (zero)
Recorded by ID: The employee’s QuickBooks Time Payroll ID (default). If one was not set, the report will use their QuickBooks Time username. These need to match the Employee ID in Sage.
Ticket Number: A unique ID assigned by QuickBooks Time for the timesheet
Ticket Date: The date the work was performed.
Has been used in Sales/Invoicing: Always “false”
Invoice Number Used: Blank
Activity Item ID: Always “LABOR-QUICKBOOKS TIME.” In Sage create a new Inventory Item with the Item ID named “LABOR-QUICKBOOKS TIME” and the Item Class set to “Activity Item.”
Customer/Job/Adm: Always 2, which coincides with Job.
Completed for ID: The job code in QuickBooks Time. Must match a Job ID in Sage.
Pay Level: 1 = regular time. 2 = overtime and double time.
Has been used in Payroll: Salaried employees: True; Otherwise: False
Manual/Timed Option: 0 = manually entered (total hour), 1 = clock in/out timesheet
Start Time: Clock-in time; Blank if hours entered another way
End Time: Clock-out time; Blank if hours entered in another way
Break: Paid breaks only
Duration: If hours were entered manually
Internal Memo: Blank
Billing Type: 2: Corresponds to Activity Range in Sage
Billing Status: In QuickBooks Time, 1: If the job code is billable; 2: Not billable
Unit Duration: Blank
Billing Amount: 0.00 (calculated by Sage during import)
Ticket Description for Invoicing: Blank