Customer Knowledge Base

Space shortcuts

Page tree

Harmony's standard GL export is compatible with Protractor. 

Prerequisites:

  • Have posted the payroll you’d like to export from Harmony
  • Have created your account codes/numbers in Protractor

Note: By default, you are not required to use account numbers in Protractor. It is your responsibility to create your GL account numbers in Protractor. Please contact Protractor for more information. Paymate can help you map it to the correct payroll category and/or department in Harmony, but  cannot help you with configuring Protractor.

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 “STDDTL** - Standard GL Detail”. Toggle it on to activate it and set it as your default export interface.

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 Protractor.
  3. Click the save icon to save your account numbers. 

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 and verify that the it is balanced and will be exported to the correct GL account. 
  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 correct "Batch Date" if required.
  8. If you want to enter a comment or memo, enter it into the "Memo" field. This is optional. 
  9. Select the appropriate “Employee Identification”: This is how you want your employees to be identified in the transaction.
  10. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder.

IV. Import Your File to Protractor

  1. In Protractor, navigate to General Ledger and use the 'Import' feature. 
  2. Import the file you downloaded from Harmony. You can use the 'Paymate Payroll Import' import format. Your transactions will be visible and show the complete check and GL details. 
  3. Review, then click "Next" to pull directly to the accounts.