3.12. Fanurio + QuickBooks

If you are a QuickBooks user, you can track time with Fanurio and then import it in QuickBooks to bill your clients. Fanurio can export time to an .iif file that can then be imported by QuickBooks Pro.

3.12.1. Initial setup

Before you can export time from Fanurio for QuickBooks Pro, you need to make some settings for the import to go smoothly. You can make these settings by hand or you can use a wizard to make them automatically. We highly recommend that you use the wizard as it can save you a lot of time.

In both cases, you will need an .iif file that has to be exported from QuickBooks. Make sure QuickBooks Pro is running and go to Timer » Export Lists for Timer (TimerList.iif) to export the file that will be used to configure Fanurio.

A. Automatic setup

Go to File » Import » Import from QuickBooks to launch the wizard. It will ask you to locate the TimerList file mentioned above.

The wizard will help you make all the settings, import the customers and items that you want to use from Fanurio. Please note that you can run this wizard at any time, existing customers and items will not be imported again.

B. Manual setup

  1. Go to Tools » Options and select the Third Party panel. Enable QuickBooks export and enter your QuickBooks company id in the Company Create Time field.

    You can get your company id from the TimerList file. Open it with a text editor and get the value of the COMPANYCREATETIME field from the TIMERHDR line.

  2. Go to Business » My Business Details and select the Company panel. Enter your QuickBooks company name in the Name field.

    You can get your company name from the TimerList file. Open it with a text editor and get the value of the COMPANYNAME field from the TIMERHDR line.

  3. Go to Business » My Business Details and select the Contact panel. Enter your QuickBooks employee name in the Attention field.

    You can get your employee name from the TimerList file. Open it with a text editor and get the value of the NAME field from the EMP line.

  4. Go to Business » My Business Details and select the Projects panel. Create task categories with the same names as those of the invoice items you have in QB.

    You can get the names of your invoice items from the TimerList file. Open it with a text editor and get the values of the NAME field from the INVITEM lines.

  5. Add one or more clients that have the same name as the ones you have in QuickBooks.

    You can get the names of your clients from the TimerList file. Open it with a text editor and get the values of the NAME field from the CUST lines.

Once you complete the initial setup, you can start recording time with Fanurio.

3.12.2. Exporting time from Fanurio

See this section to learn how to export time to an *.iif file that can be imported by QuickBooks Pro.

3.12.3. Importing time in QuickBooks Pro

Here's how to import time in QuickBooks Pro from an .iif file:

  1. Make sure QuickBooks is running

    We strongly recommend backing up your QuickBooks data before doing your first import.

  2. Go to Timer » Utilities » Import » Timer Activities

  3. Find the exported .iif file on your computer and select it for import.

    If QuickBooks warns you that the import file was created with an older version, click OK (Fanurio can't guess which version of QuickBooks you are running).

  4. A small timer window will open showing the results of the import. Click "View Report" to verify your time data was imported correctly.

  5. Close the status window and you are done!