18.02.02 Exporting Time to QuickBooks

Overview:

The QuickBooks Pro product has the capability of importing data from an external source. Data can include lists that correspond to QuickBooks’ lists, budgets, and individual transactions. We will be utilizing the IIF imports to facilitate the importing of time data into QuickBooks. This is facilitated by creating a comma (or tab) separated file in a format that QuickBooks can understand (the QuickBooks IIF format). This format includes the use of column heading tags (keywords) and row heading tags to help identify the beginning and end of each transaction.

IIF File Naming:

When you are exporting the data out of UNItekTIME, in preparation for the import into QuickBooks, the extension given to the file is important. QuickBooks is expecting the file extension to be “IIF” or “iif”. When on the Export — Time screen, one of the options is to supply the output filename. You can at this point provide the appropriate the file name with IIF extension.
For example, an appropriate file name may look like: june_time.iif

UNItekTIME —> Quickbooks Field Mapping (Time Entry Import) :

  1. UNItekTIME Project Clients —> Quickbooks Customer
  2. UNItekTIME Employee —> Quickbooks Employee
  3. UNItekTIME Billable Task Flag —> Quickbooks Billable Flag
  4. UNItekTIME Task Code —> Quickbooks Service Items

Preparing Data for input into QuickBooks:

The following steps may be followed to:
  1. Export Data from UNItekTIME in a Quickbooks ready format (IIF).
  2. Import the exported time data into Quickbooks.
  3. Define billing rates for [Items] in Quickbooks.
  4. Generate an Invoice in Quickbooks based on imported UNItekTIME Time data.

Step 1: Export Data from UNItekTIME in a Quickbooks ready format

The following steps may be followed to:
  1. Navigate to [Admin Options] —> [Import / Export CSV/Quickbooks] in [Import/Export] section.
  2. Select [Import/Export] type as “Export
  3. Select [File Type] as “Quickbooks
  4. Select [Data Source] as “Time Entry
  5. Define your data export start date and end date.
  6. Select your project whose time entries you want to export.

  7. Now click on [Proceed] button.
  8. Give some best name for your exported IIF file and note down your IIF file saved location.

  9. This is end of exporting time data to Quickbooks IIF File.

Step 2: Import the exported time data into Quickbooks.

The following steps may be followed to:
  1. Launch Quickbooks
  2. Open [File] —> [Import ]—> [IIF Files…]

  3. Select your exported IIF File in File open dialog box and then click on [Open].

  4. Quickbooks will show completed messaged after import.


Step 3: Define billing rates for [Items] in Quickbooks.

  1. Open [Customers] —> [Item List] in Quickbooks.
  2. Double click on all imported [Items] and define their [Account] and [Rate]

  3. Define item’s [Billing Rate] and [Account] in Quickbooks. Click on [OK] when done.

  4. Define billing rate and Account of all UNItekTIME imported items.

Step 4: Generate an Invoice in Quickbooks based on imported UNItekTIME Time data

  1. Open [Customers] —> [Create Invoices] in Quickbooks.
  2. Select your customer whose Invoice you want to create in [Customer:Job] dropdown.
  3. Quickbooks will prompt for importing all pending time and cost items.

  4. Click on [OK] to import all outstanding billable time and cost in Quickbooks Invoice.
  5. Quickbooks now show all outstanding billing items. Just click on [Select All] to select all time entries.

  6. Click on [OK] to import all selected time records in Quickbooks.
  7. Quickbooks will import all-time records in Customer Invoice. An accountant can then proceed this invoice as per their own defined organization policies.