General Ledger Interface

Clarity has the capability to export your payroll data to your general ledger software. There are presently more than twenty five different interfaces available in the Paymate software.

 

G\L Software: ACCPAC

Paymate Clarity can export data to different versions of ACCPAC software. In order to setup Clarity to export data to ACCPAC 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

  1. Go to Setup->Preferences->Interfaces
  2. Choose the Correct Interface
    • ACCPAC 6.0 DOS-If you are running ACCPAC version 6.0
    • ACCPAC 5.0-If you are running ACCPAC version 5.0
    • ACCPAC 6.0 DOS- Summary Format
    • ACCPAC Advantage Series (Standard)
  3. Click on the checkmark button to save the changes you have done.
  4. 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
  2. Navigate to the Others Tab.
  3. Go to the Setup > General Ledger > G/L Accounts > GL Accounts Tab.
  4. Use the Reset Account Chart Button.
  5. Populate G\L codes for all the payroll categories. If required, a suffix or prefix can be assigned to each G\L code.

Option 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. To use Code Finder option:

Steps:

  1. the Use Code Finder flag should be checked off under Setup > Preferences > Interface.
  2. Head to the Default general ledger interface frame.
  3. To import this file containing the G\L codes, go to Setup > General Ledger > Refresh GL code finder.
  4. Enter the required parameters and then click Refresh.

Option 3: Enter the G/L codes directly

  1. Head to Setup > General ledger > G/L Accounts > GL Accounts Tab.
  2. To use this method, the use code finder flag should not be checked.
  3. 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 under Setup->Job Cost->Cost center. 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:

  • Payroll->Export->Export to G/L
  • 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.

 

Be the first to review this article