Exporting to Intuit QuickBooks Desktop
Shoshana Fleischmann avatar
Written by Shoshana Fleischmann
Updated over a week ago

Conducting payroll can be one of the most tedious and time-consuming processes for organizations. At Connecteam, we have made it our mission to simplify that process and make it as quick and easy as possible so that you can focus your efforts on what matters the most. In this article, we will walk you through the key steps to streamline your payroll by exporting timesheets from your Connecteam Time Clock to QuickBooks Desktop (QBD) by downloading a QBD formatted timesheet Intuit Interchange Format (IIF) file.

Tip: Using QuickBooks online? We have an integration! Check out this article.

Before we get started, let’s go over what will be exported so you can make sure this is relevant to you!

What Is Exported

Before we start showing you how to configure the export let’s go over what can/can not be exported using. This will ensure that the rest of the article is relevant to you and make the best use of your time.

CAN be exported

CAN NOT be exported

Regular hours, Time & half, and Double Time

Overtime that is not a multiplier of 1.5X or 2X

Sick Leave

Paid Time Off (PTO)

Now, let's jump into the steps of how to create this file, and conduct payroll!

What You Need to Do Before Using the Export

Below is a list of things that you should do before using the export

  1. Make sure the first and last names of your employees in Connecteam and in QuickBooks Desktop appear exactly the same.

  2. Make sure to have already set up your overtime policies in Connecteam.

  3. Make sure to have already set up your time off policies in Connecteam.

Setting Up Your Export

Step 1: Click on Export and Click on Discover Integrations

Step 2: Open the time clock integration settings tab and click on Set Up QuickBooks Desktop

Step 3: Naming the File

Now, you can rename the report.

Step 4: Set Up the Job

Select the fields in QuickBooks Desktop that relate to your Job and Sub-job in Connecteam. If you have not configured Sub-jobs in your time-clock settings, you need to match only the Job in Connecteam to the related field in QBD.

Below you can see how it looks when setting up just the job.

Below you can see how it looks when setting up both the job and sub-job.

Step 5: Name the Working Hour Items

These fields refer to the payroll items that will be shown in your export. For example, you and as seen below, I choose to call my Time & Half hours Overtime rate. I could have chosen to call it Time & Half, Holiday, or anything else. Note that the QBD export only supports Regular Rate and Overtime rates of 1.5X and 2X. Any overtime hours that are not a multiplier of 1.5X or 2X will be excluded from the timesheet.

Step 6: Name the Sick Leave

Here in the drop-down all your existing PTO policies appear, and you can select all the policies you want to be marked in the export as sick leave.

Step 7: Name the PTO

All your existing Time Off Policies that were not selected as sick leave, will be assigned as PTO hours. You have the option to rename the policy to anything you like, for example, vacation or holiday.

Step 8: Check BILLABLE If Needed and Make Sure to Save Changes

If you would like to indicate whether the time is billable to a customer or project. If you do not want all the items to be billable we recommend leaving this box unchecked.

Exporting Timesheets to QuickBooks Desktop

Now that you have configured your QBD export it’s time to export it! To export head to the time clock, to the time sheets tab, and click on export. Then click on export to Quickbooks Desktop. Your IIF file will download and you can upload it to QuickBooks Desktop.

💡Tip: Make sure to go over your employees' time sheets and resolve any conflicts in Connecteam before exporting them!

For more information on how to import.IIF files please go over this QuickBooks Desktop information.

Understanding Your Export

Now that you have successfully exported your timesheets in the form of an IFF file, let’s take a look at how the file looks below.

Now, let's go over what each field means.

  • !TIMEACT

    • An indicator for QBD that this is a time activity transaction

  • DATE

    • The date the activity was performed

    • Format: MM/DD/YYYY

  • JOB

    • The name of the job or customer for whom the activity was performed

    • Format:

      • Job = If there is no sub-job associated with the activity

      • Sub-job:Job = If the configuration in step 4 is Job (Connecteam) = Job (QBD) and Sub-job (Connecteam) = Customer (QBD)

      • Job: Sub-job = If the configuration in step 4 is Job (Connecteam) = Customer (QBD

    • Both the job and the sub-job names must be on the QBD Customers & Jobs list (CUST)

  • EMP

    • The name of the employee who performed the activity

    • Format: First name + Last name

    • The employee's name must be on the QBD Employee list (EMP)

  • ITEM

    • The name of the service item assigned to the activity

    • The empty field in Connecteam

  • PITEM

    • The payroll item associated with the work performed, meaning regular rate, time & half, double time, sick leave, or PTO

  • DURATION

    • The duration of the activity in hours and minutes

    • Format: HH:MM

  • PROJ

    • The QBD class assigned to the activity

    • The empty field in Connecteam

  • NOTE

    • The activity notes left by managers or employees

    • Format: Manager[ Manager notes ]:Employee[ Employee notes ]

  • BILLINGSTATUS

    • Indicates the billing status of the activity

    • Format:

      • 0 = The activity is not billable to the customer or job specified in the Job field

      • 1 = The activity is billable but has not yet been billed to the customer or job specified in the Job field

Need more guidance? 🙋 Our LIVE support team (at the bottom right corner of your screen) replies to ANY question.

Did this answer your question?