Skip to end of metadata
Go to start of metadata

Harmony now integrates with the QuickBooks® Online.

Note: This article discusses the integration with QuickBooks® Online and how to use QBIS. If you have QuickBooks® Desktop, view this article instead. 

Prerequisites: 

  • Have posted the payroll you want to export from Harmony
  • Have QBIS downloaded, installed, and configured correctly (*included when you purchase QBIS)

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 “QuickBooks Online Detail” or “QuickBooks Online 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 Numbers/Names

  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. By default, QuickBooks® Online uses account names. To use account numbers, you will have to toggle this on in your QuickBooks® Online settings.
  3. Click the checkmark icon at the top right of this window 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 QBIS installed, transfer this file to the correct computer.

V. Use QBIS to Import Your File Into QuickBooks® Online

  1. Launch QBIS. 
  2. If you exported the detailed export from Harmony, select 'Single Transaction'. If you exported the summary export from Harmony, select 'Summary Transaction'
  3. Click "Browse" to open a window to select the exported file from Harmony. 
  4. Click "Read" to allow QBIS to read the file you selected. Your GL entries should not be visible. 
  5. Click "Verify" to allow QBIS to check that the file you selected is compatible. At the bottom of QBIS, it should read "Application complete to verify records". 
  6. Click "Sync" to transfer your GL entries into QuickBooks® Online. The 'Status' should now read "Create successfully". 


You can also view this video guide: 

What is the difference between detailed and summary exports?

If you are using the Detailed 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®.