Customer Knowledge Base

Space shortcuts

Page tree

Harmony supports supports standard/file-based integration with Sage Intacct. You can easily import your GL entries.

Note: This article outlines the standard/file-based integration with Sage Intacct. If you are looking for the seamless integration, please view this article instead.

Prerequisites:

  • Have posted the payroll you want to export from Harmony
  • Have created your account codes/numbers in Sage Intacct

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 “SAGEINT - Sage Intacct”. Toggle this to activate it and set it as your default export interface.

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. 
    1. If you only have one company, all your locations set up in Harmony will need to default to one location code, such as "E100". You can enter "E100" in the account numbers for all locations in the 'location' tab, then you'll need 
  3. Click the save 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. Enter the parameters at the bottom of the page as required. You my want to refer to the FAQ section below to determine what you need to select.
  8. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. Use this file to import into Sage Intacct.

Frequently-Asked Questions:

What does "Location Code" mean in my export?

If you only have one company,  you will have one defaulted location code to export, such as "E100". In this case, be sure to enter the Location GL in Part II above as "E100" and save. Then when you're exporting in Part IV, select 'Location GL' as the location code. 

If you have more than one company, you will want to separate your companies by location. Similar to above, be sure to enter the Location GL in Part II above as the correct GL codes, then save. When you're exporting in Part IV, select 'Location GL' as the location code.

What does "Department Code" mean in my export?

If you separate your chart of accounts by department, you will need to determine what the structure of your accounts are. Review this article for more information. 

Depending on how you have your structure set up, select 'Department Code' or 'Department GL' when you're exporting in Part IV.