Customer Knowledge Base

Space shortcuts

Page tree

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

Import/Exporting GL Entries

Prerequisites:

  • Have posted the payroll you’d like to export from Harmony
  • Have created your account codes/numbers in CDK
  • Know if you require the CDK Detail or the CDK Summary interface 

Solution:

I. Setting Up Your Default GL Export Interface

  1. In Harmony, navigate to the Payroll module.
  2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
  3. Find “CDKDET** - CDK Detail” or "CDKSUM** - CDK Summary". Toggle it on to activate it and set it as your default export interface. You can always change this at the time of your export. If you're not sure which one to use, view the end 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 at the top right 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 and verify that the amounts are going to the correct GL account. If not, return to section two, Define Your GL Account Codes, and section three, Define Your GL Account Structure, above to modify the accounts and structure respectively. You will need to recreate these GL records once you've made your changes.
  6. Enter the correct "Batch Date" if required.

  7. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. Make a note of where your file is exported.

IV. Import Your File to CDK

  1. In CDK, you can now import the file you export from Harmony.

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 CDK 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 CDK.