QuickBooks integration using QBTimer

What are the requirements for QuickBooks integration?QuickBooks 2006 or newer for Windows is required for Quickbooks integration.QuickBooks Mac and Quickbooks Online are not supported because they do not allow time activity to be imported.How does data get from Intervals into QuickBooks?Intervals exports time data as IIF files for importing the data into QuickBooks QBTimer. Follow the instructions below to set up QuickBooks and your Intervals account. Once the setup is complete you will see the QuickBooks export icon appear to administrator level users on the following pages:

• Timesheet
• Edit Time
• Summary Report
• Project Activity Report

How do I set up QuickBooks?First, you will need to make sure that you have QBTimer installed in QuickBooks (it is not installed by default). If you don’t, follow these steps to install it and get QuickBooks set up for importing time from IIF files.

1. Load the QuickBooks CD on the computer
2. Browse to the CD and open the QBTimer folder
3. Run the install.exe file
4. Follow the onscreen instructions

How do I set up Intervals?Now that you’ve set up QuickBooks, follow these steps to extract the COMPANYCREATETIME variable from QuickBooks (Intervals will need this value to properly export time data into QuickBooks).

1. Enable the QuickBooks functionality by clicking on the "Enable QuickBooks" button on the left
2. Open QuickBooks and go to File > Utilities > Export > Timer Lists
3. Save the IIF file and open it in Excel or your favorite text editor
4. Look for the value listed under COMPANYCREATETIME. It will appear at the end of the line beginning with TIMERHDR.
5. Copy and paste the COMPANYCREATETIME into the "Company Create Time" value on the above left and click update

Notes:

1. QuickBooks time export only works with the QuickBooks Windows edition.
2. The COMPANYCREATETIME and COMPANYNAME variables must match exactly between QuickBooks and Intervals.
3. Once you have enabled QuickBooks and entered the COMPANYCREATETIME value in the site settings section, the QuickBooks time export icon will appear on the above-mentioned pages with exportable time data.
4. QuickBooks Mac does not allow time activity imports.

How does Intervals map exported time data to QuickBooks?…and which fields are required?It is essential that data between QuickBooks and Intervals matches, otherwise, QuickBooks will error out when trying to import the time data. For example, Quickbooks will give an error if a customer name you are trying to import matches a vendor name. The spelling and spacing of all items must match exactly for the fields in bold.If there QuickBooks does not find a match, it will treat the data as a new client, project, etc without warning you. It's difficult reverse the data once imported (i.e. all data entries must be deleted one by one) so it's best to make sure the fields match beforehandIntervalsQuickBooks

Client	Customer
Project	Job
Person	Employee
Worktype	Item
Module	Payroll Item
Task & Description	Note

Support for mapping work types to QuickBooks sub itemsAre you a QuickBooks power user? If so, we’ve updated the QuickBooks functionality for exporting time tracking data to IIF formatted files to support mapping work types to sub items. When creating your work types, use a colon to format the work type as an item/sub-item. For example, creating a work type labeled as “Web Design:HTML” will translate to QuickBooks with “Web Design” being the item and “HTML” being the sub-item. While this feature doesn’t add the ability to create sub work types, it does allow QuickBooks power users to take advantage of the items/sub-items feature within QuickBooks.Importing Intervals time data into QuickBooksAfter you have downloaded and saved an IIF file from Intervals, follow these instructions to import the file into QuickBooks.

1. We strongly recommend backing up your QuickBooks data before doing your first import.
2. Open QuickBooks and go to File -> Utilities -> Import -> Timer Activities
3. Find the saved IIF file on your computer and select it for import.
4. If QuickBooks warns you that the import file was created with an older version, click OK (Intervals can’t guess which version of QuickBooks you are running).
5. A small timer window will open showing the results of the import. Click “View Report” to verify your time data was imported correctly.
6. Close the status window and you are done!

Just wanted to report on my experience in hopes that it'll save others some troubleshooting time. I am using Quickbooks 2008 Premier Professional Services edition, and I found that when I imported projects/jobs, worktypes/items that did not already exist in Quickbooks, Quickbooks simply created a new one. This was pretty handy because I had added some new projects/jobs along the way, and it saved me some time not to have to add it in both places.

However, when I tried to import a client/customer that did not already exist in Quickbooks, it did error out and close Quickbooks as this original post says. Of course once I went into Quickbooks and created matching clients, the import worked perfectly.

Update. We'll be changing the QuickBooks IIF export slightly so that module is exported as payroll item. For those companies that use payroll items in QB this may be a better way to align Intervals with QuickBooks. As for the QB Class, we've researched that and the conclusion is that it will not be implemented. The reason for this is that Class is not an allowable header for the TIMEACT item in IIF files.

Intervals does not have any sort of mechanism that identifies which time entries have already been exported to QuickBooks. Our advice is to include the QB export as part of the timesheet approval process and not export a timesheet until it has been approved. Once approved, the date range of each timesheet can no longer be updated by that person. This effectively makes it safe to export the timesheet without worrying about individual time entries being exported multiple times.

We use Quickbooks online and QBTimer doesn't work with it -- only with the desktop versions. In fact, only with the Windows version, as far as I can tell. Is there any, any other way to export time and expenses to QB besides QBTimer? I really like the intervals interface, but I chose it primarily because I thought it integrated with Quickbooks. This seems like a serious functionality issue.

In addition to time data, can data for expenses be exported from Intervals and moved into QuickBooks as well?

Is there a way to prevent Modules from being exported to QuickBooks as Payroll Items?

Based on the suggested usage of Modules in Intervals, and the suggested usage of Payroll Items in QuickBooks, I'm actually having a hard time seeing how they relate. For our business, I intend to use Modules to designate different phases of projects (e.g. "Phase 1 - Design", "Phase 2 - Development", etc). However, in QuickBooks, our existing "Hourly Wage" Payroll Items are simply "Hourly Rate A". I don't see "Phase 1" as conforming to QuickBooks' intended usage for Payroll Items.

That being said, is there any way to simply ignore the Modules on export, or to have them mapped to a different field? I can certainly see their value when generating reports and invoices, just not as Payroll Items.

-Dan

Great, thanks for the quick reply jreeve. It's nice to know that there is a workaround, although I'd much rather have this available as an option on the QuickBooks export page - any chance of having this added as a feature request?