Customer Knowledge Base

Space shortcuts

Page tree

Harmony supports standard/file-based integration with Deltek. You can easily import your GL entries. For more information about the fields from the import  file, refer to this link from Deltek: https://help.deltek.com/Product/Vantagepoint/5.5/UT_TF_Journal_Entry_Data_Entry.html

Import/Exporting GL Entries

Prerequisites:

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

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 “VISJE** - Vision Journal Entry” or "VISJE2D - Vision Journal Entry with Two Dimensions". 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. You can refer to the bottom of this article to determine which one to use.

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. Select the entries 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 required fields. 
    1. "Reference number" refers to the reference number of the journal posting. 
    2. "Master Description" refers to the description of the journal posting. 
    3. "Post Type" refers to the type of posting - either A, B, or C. It may also be "JE". Please clarify with your Deltek representative. 
    4. "WSB1" refers to your first dimension, such as a project number. 
    5. "Dimension Name" refers to your exported dimension name, such as the department. 

  8. 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 Deltek

  1. In Deltek, you can now import the file you exported from Harmony.


What's the difference between the two available exports for Deltek? 

VISJE** - Vision Journal Entry includes the standard integration to Vision/Deltek/Vantagepoint. 

VISJE2D - Vision Journal Entry with Two Dimensions should only be used for those who have the Labor add-on module for Harmony Payroll. This will allow you to export up to two (2) dimensions in your GL export.