Customer Knowledge Base

Space shortcuts

Page tree

Clarity incorporates a ‘GL Export’ function, which allows you to export your posted payroll information to an external file, which can then be imported into your Accounting package for General Ledger purposes.
Out of the box, Clarity contains pre-designed layouts for many of today’s most popular GL packages. Be sure to check our website intermittently for information on new layouts and functions which may be available.
This section offers instructions on exporting GL information from Paymate Platinum. For information on importing into your GL software, please contact your Accounting software vendor.

To Export newly posted Payroll Data:

Steps:

  1. Ensure that your paycards have been properly processed, and posted (unposted information will not export).
  2. Go to Payroll > Export > Export to GL.
  3. In the ‘Destination’ field (normally located on the Preferences tab), enter the proper file name and location of the file to be exported. It is recommended that you make a note of this name/location, as it will be required when you import into your GL software.
  4. In the ‘Batch Date’ field, enter the date that you would like this transaction batch to use in your GL package. It should be noted that the Cheque dates, as entered in Paymate Platinum, will remain as is.
  5. (If Applicable) Enter the proper information into all GL Parameter fields.  NOTE: Not all GL export interfaces have GL parameters, but where GL parameters exist, they MUST be filled in, as the GL software requires them.
  6. When you are satisfied that all information has been entered correctly, click on ‘Export’. The system will then create the external file, based on the information posted in Paymate. 

To Export previously posted/exported Payroll Data:

  1. Ensure that your paycards have been properly processed, and posted (unposted information will not export).
  2. Go to Payroll > Export > Export to GL Special.
  3. On the ‘Export Parameters’ tab, enter select which Department, Payroll Group, and/or EI Group you wish to include. You can select none of these, or any combination. To include all, simply leave the selection unchecked. Select ‘Company Totals’ if you wish only to see company totals for items exported.
  4. In the ‘Date Range’ section, select the range of dates you wish to use. This can be done by Quarter, for a specific Pay Period, or for a range of dates. If you wish to include your Cost Allocation details, select this flag here.
  5. On the ‘Preferences’ tab, choose the method you would like to use in applying the date range. ‘By Period Ending date’ will sort by items posted between the period dates specified, and ‘By Cheque date’ will sort items by cheque date used.
  6. In the ‘Destination’ field (normally located on the Preferences tab), enter the proper file name and location of the file to be exported. It is recommended that you make a note of this name/location, as it will be required when you import into your GL software.
  7. In the ‘Batch Date’ field, enter the date that you would like this transaction batch to use in your GL package. It should be noted that the Cheque dates, as entered in Paymate Platinum, will remain as is.
  8. (If Applicable) Enter the proper information into all GL Parameter fields (on the GL Parameters tab).  NOTE: Not all GL export interfaces have GL parameters, but where GL parameters exist, they MUST be filled in, as the GL software requires them.
  9. When you are satisfied that all information is correct, click on ‘Next’.
  10. This will display a list of transactions that fall within the specified date range. Here, you can specify exactly what items to include in the export file, by selecting or de-selecting the ‘Selected’ box as desired.
  11. Once all selections have been made, you can preview the file by clicking on the ‘Preview’ button, or view the GL Report for transactions included by clicking on ‘GL Report’.
  12. Once you are satisfied all information is correct, click on ‘Export’ to create the file. 

NOTE: The Export to GL Special function will include all transactions for the specified date range, regardless of whether or not they have been previously exported. In order to make sure that information is not duplicated, it is advised that you use the Export to GL function, unless absolutely necessary.