Customer Knowledge Base

Space shortcuts

Page tree

Harmony now supports standard/file-based integration with all versions of QuickBooks® Desktop. 

Note: Only standard integration is available for all versions of QuickBooks® Desktop. If you have QuickBooks® Online, file-based/standard integration is available through a separate application.

Table of Contents:

Prerequisites:

  • Have posted the payroll you’d like to export from Harmony
  • Have created your account codes/numbers in QuickBooks® Desktop
  • Know if you require export in detail or summary

Solution:

I. Setting Up Your GL Export Interface

  1. In Harmony, navigate to the Payroll module.
  2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
  3. Find “QB19TDET - QuickBooks Detail” or “QB19TSUM - QuickBooks Summary”. Toggle on either one of these to activate it and set it as your default export interface. If you're not sure what the difference between these two are, see the bottom of this article.

II. Define Your GL Account Codes

  1. In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Account Setup.
  2. Define your debit/credit account numbers for each department and/or payroll category that you have identified in your application.
  3. Click the save icon to save your changes.

III. Define Your GL Account Structure

  1. In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Structure.
  2. You can either create a new structure, or modify the pre-existing one that comes default in Harmony. By default, the structure is “Category GL” only. If you require departments code and/or department GL account numbers, you can make this change.

IV. Export Your Payroll / GL Entries

  1. In Harmony Payroll, navigate to Processing > Create GL Records.
  2. Select the appropriate filters for “Payroll Group” and “Filter by”.
  3. Click the refresh icon to pull up a list of employees according to your filters.
  4. Select the employees you want to create GL records for.
  5. Click “Create”. A document icon will appear next to your employees’ names. Click this icon to view their GL record.
  6. Select the employees you want to export. Ensure that the correct GL Export Interface is selected in the far right dropdown list and click “Export”.
  7. Select the appropriate “Employee Identification”: This is how you want your employees to be identified in the transaction.
  8. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. If this is not the computer that has QuickBooks® Desktop installed, transfer this file to the correct computer.

IV. Import Your File to QuickBooks® Desktop

  1. In QuickBooks® Desktop, navigate to File > Import > Import .IIF File.
  2. You will be given a File Select dialogue box in which you need to select the file you exported.


You can also view this video guide: 

What is the difference between detailed and summary exports?

If you are using the Detailed GL export layout, then the interface will create transactions in your "Check" section of QuickBooks® showing the complete check and GL Details.

If you are using the Summary GL export layout, the entire transaction will appear as a single journal entry in QuickBooks®.