Harmony now supports seamless or direct integration with Sage Intacct. You can easily retrieve all general ledger (GL) accounts codes and descriptions from Sage Intacct and export your GL accounting transactions into Sage Intacct as a draft payroll journal record.

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

Table of Contents:

Prerequisites:

• Have access to Sage Intacct 
  • Know your company ID 
  • Know your entity (if required)
  • Have created all classes/industries (if required)
  • Have created all projects and tasks/cost codes (if required)
• Have posted the payroll you want to export from Harmony

Solution:

I. Authorizing Web Services

1. In Sage Intacct, navigate to Company > 'Setup' tab > Configuration > Company. 
2. Navigate to the 'Security' tab. 
3. Click the "Edit" button. 
4. Click the "Add" button under Web Services Authorizations to add a new one. 
5. Enter "paymatesoftwareMPP" as the "Sender ID". 
   Note: The sender ID is case-sensitive. Ensure that you're entering it without quotation marks and in the correct letter-case. 
6. Add a "Description" if required. 
7. Set the "Status" to "Active". 
8. Click the "Save" button to save your changes.

II. 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 “SAGEINSM - Sage Intacct (Seamless)”. Toggle this to activate it and set it as your default export interface.
4. Click the three (3) dots to review the setup. This is where you will enter your Sage Intacct credentials to facilitate the integration.
5. Enter the required information. 
   1. "Company" refers to the name of the company that you enter into Sage Intacct in order to log in. 
   2. "Entity" identifies the entity that you're looking to post your GLs to. If you're not sure where to find your entity name, review the What's my Entity? section at the end of this article. If you leave this empty, it will post as a draft to the top level entity by default.
   3. "Username" refers to the username that you use to log into Sage Intacct. 
   4. "Password" refers to the password that you use to log into Sage Intacct. 
6. Click the save button to save your changes.

III. Testing Your Connection

1. In Harmony, navigate to the Payroll module. 
2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
3. Find “SAGEINSM - Sage Intacct (Seamless)”. Click the three (3) dots to review the setup. 
4. Click the "Test Connection" button. You will see a confirmation message if the test connection was successful or unsuccessful. If your connection was unsuccessful, view the Why did my connection fail? section at the end of this article. 

IV. Define Your GL Account Numbers

There are two (2) ways you can define your GL account numbers with the seamless integration to Sage Intacct. 

A. Using Harmony's GL Code Finder

1. In Harmony, navigate to Payroll > Admin Settings > Payroll Preferences. 
2. Tick the "Use GL Code Finder" checkbox. 
3. Click the save button to save your changes. 
4. Navigate to Payroll > Admin Settings > Interfaces > GL Export Interfaces. 
5. Find “SAGEINSM - Sage Intacct (Seamless)”. Click the three (3) dots to review the setup. 
6. Click the "Refresh Code Finder" button. This will enable Harmony to use your Sage Intacct account to provide you with a list of codes to select and input into Harmony. 
7. Navigate to Payroll > Payroll Setup > General Ledger Setup > Account Setup. 
8. Click the three (3) dots next to each payroll category. A pop-up window will appear with a list of all your account codes.
9. You can either select the entire account code, or if you have a more complex structure, identify the string of characters to input. Click “Select” next to the payroll category to insert the account code into Harmony. If you’re not sure which option to use, please contact Paymate Support.
10. Repeat steps 8 through 9 for each payroll category.
11. Click the save button to save your changes.

B. Manually Entering GL Accounts

1. In Harmony, navigate to Payroll > Payroll Setup > General Ledger Setup > Account Setup > 'Payroll Category' tab.
2. Define your debit/credit account numbers for each department and/or payroll category that you have identified in your application.
3. If you split your accounts into different departments, navigate to the ‘Department’ tab and enter the general ledger account codes that correspond to your departments. You can modify the structure later.
4. Repeat step 3 for each dimension or employee as required. If there are some GL account codes that do not follow the structure, or can be treated as an exception, you may enter it in the ‘Overwrite’ tab.
5. If you split your accounts in different dimensions, navigate to the corresponding dimension tab and enter the general ledger account codes that correspond to your dimensions. You can modify the structure later.
6. Click the save icon at the top right of this window to save your changes.

V. 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.
   Note: You can review the article found here for an example of how your GL accounts from Part IV and the structure in Part V work together to build your GL accounts to import into Sage Intacct.

VI. 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.
   Note: If you see a red checkmark or an error message, your GL records may not be balanced. Open the record to view the details and make changes as required. You will not be able to export unbalanced GL records.
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, such as a "Batch Date" and "Description". 
8. Click “Export”. Your GL records will be exported to Sage Intacct automatically. 

VII. Reviewing Your General Ledger Journal

1. In Sage Intacct, navigate to General Ledger > 'All' tab > Journal Entries. 
2. Click the "View Transactions" button for the Payroll Journal.
3. Your exported GL records will be listed here with the "Batch Date" and "Description" that you entered earlier in Part VI above. The state will be set to Draft, so you can post it here when needed after reviewing.

Frequently-Asked Questions

What's my entity?

In Sage Intacct, when you click the 'Top Level' or green dropdown field next to your company name, a list of your entities will be shown. You should enter the short name of the entity into the "Entity" field in Harmony's integration setup page in Part II above.

Why did my connection fail?

Find below the error messages and resolutions below: