--- title: "Export timesheet data to QuickBooks Desktop" slug: "export-timesheet-data-to-quickbooks-desktop" tags: ["IIF File", "Payroll Import", "QuickBooks Export"] updated: 2026-08-14T16:22:41Z published: 2026-08-14T16:22:41Z canonical: "help.workeasysoftware.com/export-timesheet-data-to-quickbooks-desktop" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.workeasysoftware.com/llms.txt > Use this file to discover all available pages before exploring further. # Export timesheet data to QuickBooks Desktop **Audience:** Payroll admins, accountants, and managers who export timesheet hours from WorkEasy Software and import them into QuickBooks Desktop. **What you will learn:** How to generate the QuickBooks Desktop export, download the `.iif` file, preview it in Notepad, and import the file into QuickBooks Desktop for payroll. ## Step 1: Generate the QuickBooks Desktop export 1. Go to **Exports** in the left navigation. 2. Select **QuickBooks Desktop** from the exports list. 3. In the **Execution** panel, under **General**, choose: - **Use pay period**, then pick the pay period and dates, or - **Use date range** and select custom dates. 4. (Optional) Open the filter drawers like **Job costing filter**, **Employee general**, **Employee groups**, or **Employee custom fields** to narrow the export. 5. Click **Preview** to review the lines. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image(954).png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) 6. If all looks correct, click **Run**. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image(955).png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) ## Step 2: Download the .iif file 1. When the task completes, click the **Notifications** bell in the top bar and select **Background Tasks**. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image-1223O65Q.png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image-PYVI7832.png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) 2. Open the latest **Export task** entry and select **File** to download. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image-PC4UGVA3.png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) 3. Locate the downloaded file in your Downloads folder. The file name looks like `QBD_Timesheet_MM-DD-YYYY.iif`. ## Step 3: Open and review the file in Notepad 1. Double-click the downloaded `.iif`. If prompted, choose **Notepad** or another text editor. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image(958).png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) 2. The file begins with a header like `!TIMEACT DATE JOB EMP ITEM PITEM DURATION PROJ NOTE XFERTOPAYROLL BILLINGSTATUS` followed by one time activity per line. ![](https://cdn.us.document360.io/88d7ebef-752e-45d9-95e1-ee13bd7279c5/Images/Documentation/image(959).png?sv=2026-02-06&spr=https&st=2026-11-01T14%3A51%3A57Z&se=2026-11-01T15%3A51%3A57Z&sr=c&sp=r&sig=pq6LHDckUdHnqjBydpI5xTY8jEGpbuQA8gESv2T265U%3D) ## Step 4: Import the .iif into QuickBooks Desktop 1. Open **QuickBooks Desktop** and the correct company file. 2. Go to **File** then **Utilities** then **Import** then **IIF Files**. 3. Browse to the exported `.iif` file and select **Open**. 4. Review the confirmation. If QuickBooks reports issues, download the error report, correct the lines, and import again. This process loads the time activity lines into QuickBooks so they are available for payroll and reporting. ## Best practices - Keep the original `.iif` file unchanged as your source of truth. - Validate totals in WorkEasy reports before import. - Confirm service items and payroll wage items are mapped consistently between WorkEasy and QuickBooks. - If your QuickBooks Desktop is 2019 or later, use the improved IIF import flow for better error checking. ## Troubleshooting - **Import errors about list names:** Ensure employee, customer or job, and service item names in the file exactly match names in QuickBooks. - **Time is missing after import:** Recheck your date range or pay period in WorkEasy, rerun the export, and import the new file. ## Sources - [Intuit QuickBooks Desktop Help: Export, import, and edit IIF files](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/export-import-edit-iif-files/L56LT9Z0Q_US_en_US) - [Intuit QuickBooks Desktop Help: Improved IIF Import in QuickBooks 2019 and later](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/improved-iif-import-quickbooks-2019-later/L1K3ZQDX9_US_en_US) - [Intuit QuickBooks Desktop Help: IIF overview, import kit, sample files, and headers](https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US) > If you have questions, please call us at (888) 783-1493, email [support@workeasysoftware.com](mailto:support@workeasysoftware.com), or [submit a ticket](https://www.workeasysoftware.com/resources/submit-a-ticket)