---
title: .iif File Import Instructions
description: 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 ex
---
[Skip to content](https://knowledge.teamkeeper.com/kb/article/371#main-content)
English
Show submenu for translations
/teamkeepr_logo.png?width=191&height=45&name=teamkeepr_logo.png)
Open main navigation
Close main navigation
- English
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://knowledge.teamkeeper.com/?hsLang=en)
2. [QuickBooks](https://knowledge.teamkeeper.com/quickbooks?hsLang=en)
# .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
"
- [Business Rule Management](https://knowledge.teamkeeper.com/business-rule-management?hsLang=en)
- [CLOCKS - ATS](https://knowledge.teamkeeper.com/clocks-ats?hsLang=en)
- [Configuration](https://knowledge.teamkeeper.com/configuration?hsLang=en)
- [Customer Sites](https://knowledge.teamkeeper.com/customer-sites?hsLang=en)
- [DCAA Compliance](https://knowledge.teamkeeper.com/dcaa-compliance?hsLang=en)
- [Employee Management](https://knowledge.teamkeeper.com/employee-management?hsLang=en)
- [Genus Clocks](https://knowledge.teamkeeper.com/genus-clocks?hsLang=en)
- [GMS Notes](https://knowledge.teamkeeper.com/gms-notes?hsLang=en)
- [Guides and Pieces](https://knowledge.teamkeeper.com/guides-and-pieces?hsLang=en)
- [Help Guides](https://knowledge.teamkeeper.com/help-guides?hsLang=en)
- [Imports Exports](https://knowledge.teamkeeper.com/imports-exports?hsLang=en)
- [Leave](https://knowledge.teamkeeper.com/leave?hsLang=en)
- [Login](https://knowledge.teamkeeper.com/login?hsLang=en)
- [MFA - Multi Factor Authentication](https://knowledge.teamkeeper.com/mfa-multi-factor-authentication?hsLang=en)
- [Mobile App](https://knowledge.teamkeeper.com/mobile-app?hsLang=en#main-content)
- [Android](https://knowledge.teamkeeper.com/mobile-app?hsLang=en#android)
- [Notifications](https://knowledge.teamkeeper.com/notifications?hsLang=en)
- [Prepopulation](https://knowledge.teamkeeper.com/prepopulation?hsLang=en)
- [QuickBooks Knowledge](https://knowledge.teamkeeper.com/quickbooks-knowledge?hsLang=en)
- [QuickBooks](https://knowledge.teamkeeper.com/quickbooks?hsLang=en)
- [Questions / Inquiries](https://knowledge.teamkeeper.com/questions-inquiries?hsLang=en)
- [Reports](https://knowledge.teamkeeper.com/reports?hsLang=en)
- [Task Management](https://knowledge.teamkeeper.com/task-management?hsLang=en)
- [TeamKeeper Components](https://knowledge.teamkeeper.com/teamkeeper-components?hsLang=en)
- [TeamKeeper End User](https://knowledge.teamkeeper.com/teamkeeper-end-user?hsLang=en#main-content)
- [W2](https://knowledge.teamkeeper.com/teamkeeper-end-user?hsLang=en#w2)
- [Training Employee Guides](https://knowledge.teamkeeper.com/training-employee-guides?hsLang=en)
- [User Guides](https://knowledge.teamkeeper.com/user-guides?hsLang=en)
- [W2 Forms](https://knowledge.teamkeeper.com/w2-forms?hsLang=en)
- [Timesheet Data Backup Options](https://knowledge.teamkeeper.com/timesheet-data-backup-options?hsLang=en)
- [Version Release Notes](https://knowledge.teamkeeper.com/version-release-notes?hsLang=en)
# TeamKeeper
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, TeamKeeper