Customer Knowledge Base

Space shortcuts

Page tree

Clarity can export data to different versions of ADAGIO software. In order to setup Clarity to export data to ADAGIO you should follow these steps.

Step 1 - Choosing the Interface

The first step to export data from Paymate to your general ledger software is to choose the right interface. In order to do make the correct selection for the interface do the following

Steps:

  1. Go to Setup> Preferences> Interfaces.
  2. Choose the Correct Interface.
    1. Adagio (Default template- Detail only)
      This interface can be used for Adagio Ledger versions older than 8.0A (2004.02.23). There is no significant advantage or disadvantage of this method over the Header/Detail style.
    2. Adagio (Default template- Header detail)
      This method can be used for Adagio Ledger versions older than 8.0A (2004.02.23). There is no significant advantage or disadvantage of this method over the Detail Only style.
    3. Adagio (Designed for Adagio) Consolidated
    4. Adagio (Designed for Adagio) v.8.0x
      In order for this interface the following must be followed.
           The file name of the export file must be to the same location where the companies Adagio data directory is located, it should also be a TXT FILE!
      The import will fail if the user sets the extension to be the same as their Adagio data extensions.
           The Customers Adagio Data extension should EXCLUDE the period. 
    5. Adagio (Designed for Adagio) with Cheque number
  3. These are more commonly used interfaces. These are the easiest to use and warns the user there is a payroll batch to retrieve when Adagio Ledger is started. This method is supported by Adagio Ledger 8.0A (2004.02.23) and newer. If you have an older version of Adagio Ledger, you must use the Header/Detail or Detail Only style export/import method.
  4. Click on save to save the changes when you are done.
  5. Close the window.

Step 2 - Setting Up G/L Codes

Once you have selected the correct interface, you must enter the G/L codes for each payroll category, and for each department. This can be done in many ways.

Option 1: Enter the G/L codes for each payroll category

  1. Under the Setup> Payroll Settings> Payroll Categories> Others Tab.
  2. Reset Account Chart Button on the Setup> General Ledger> G/L Accounts> GL Accounts Tab
  3. Populate G\L codes for all the payroll categories. If required, a suffix or prefix can be assigned to each G\L code.

Options 2: Use the GL Code Finder File which contains all the approved G/L Codes from your accounting software.
Such a file can be created from your G/L Chart of Accounts using the G/L software provided Paymate is connected seamlessly to your accounting software.  If not then the file can be manually created.

  1. Under Setup> Preferences> Interface> Default general ledger interface frame.
  2. To import this file containing the G\L codes, go to Setup> General Ledger> Refresh GL code finder
  3. Enter the required parameters and then click Refresh.

Option 3: Enter the G/L codes directly

  1. Setup> General ledger> G/L Accounts> GL Accounts Tab.
  2. To use this method, the use code finder flag should not be checked.  You must make sure that you enter the G/L for each department that you have created.

Step 3 - Entering G\L Code For Cost Center

If required, Job Cost centers can be setup and the G/L codes for cost centers can be entered while setting up the cost center

  1. Go to Setup> Job Cost> Cost center. 
  2. If the G/L codes are not known until the payroll data entry time, then these can be entered directly on the Job Cost work details records.

Step 4 - Exporting to General Ledger

After posting the payroll data you can chose to export it to your general ledger software. There are two options to export to General ledger:

  1. Payroll> Export> Export to G/L
  2. Payroll> Export> Export to G/L Special

The first option is used to export all the payroll data which has not been exported yet.

The Export to G/L Special option allows you to select specific payroll records to be exported based on department, payroll group, or date range.  This option also allows you to re-export records that have already been exported

The export file path and name have to be specified here (except in case of Seamless interface). The specific date range or department or payroll group can be selected here to select which data has to be exported.

For seamless interfaces you will need to provide the server name, database name, user name and password to allow connection between Paymate and your accounting software.