.iif File Import Instructions

Importing to QuickBooks without the Import Tool

An alternative to using the TeamKeeper Import Tool is to directly import using the .iif file extension.
To Change the file extension of the timesheet export file that was created from the customer's site:
1. Open the file in Notepad and "Save As" and select "All FIles (*.*)" for the "Save as Type".
2. Type ".iif" at the end of the file name and click Save.


It's important to ensure that all items match between TeamKeeper and QuickBooks before importing timesheets to QuickBooks.
Importing with the .iif file extension is non-discriminative. The main benefit of using the TeamKeeper Import Tool is that it checks to make sure there is an exact match for the employee/vendor names and items (Customers:Jobs, Payroll Items, Service Items, Class) before importing.
Importing directly with .iif will create new employees/vendors and items if there is not an exact match in QuickBooks.
For Example, John A Smith in TeamKeeper does not match John A. Smith in QuickBooks. After importing you will have both "John A Smith" and "John A. Smith" in QuickBooks with the hours imported to John A Smith's timesheet.

Create a custom report for each type of item that can be exported from TeamKeeper so the customer can compare items between TeamKeeper and QuickBooks before importing.

Attached are SQL queries that will create stored procedures in the customer's database. Replace the site name in the queries before executing.
To make the reports added to the database available on the customer's TeamKeeper site:
1. Go to Administrator>Reports and click on "Custom Report Administration".
2. Click "New".
3. Type the name of the report in the Name field.
4. Select "Stored Procedure" for the Data Type.
5. Copy the site name with the store procedure name from the query that was executed and past it in the "Proc Name/ SQL String" field (i.e. [s_SITENAME_online].[proc_ActiveEmployeeList] ).
6. Select Admin, Accountant, and Reporter in Report Roles.
7. Click "Save".
8. There are no parameters for these reports. For the report to work, you must add one parameter with a criteria and then click Save.
9. Now delete both parameter and criteria and click Save.
10. Test the report to make sure it works.

When importing the .iif file to QuickBooks, make sure that you are in Single-user mode.
In QuickBooks, go to File>Switch to Single-user Mode. If there is an option "Switch to Multi-user Mode" instead, QuickBooks is in Single-user mode.

To Import the .iif file, go to File>Utilities>Import>IIF Files... and select the file and click Open.
QuickBooks may ask to define rates if there are any new items that were imported. If needed, have the customer fill in the rates