Previous page

Next page

Import Pay

Payroll | Import Pay command

Summary

Employee time information is processed in the Time & Attendance module, and then exported to Payroll as one of the following file types:

  • PayGlobal (ADT File)
  • PayGlobal PTCSV
  • PayGlobal PVCSV
  • PayGlobal DBF
  • CSV
  • CSVDBF
  • TimeMaster
  • Style 1
  • Maximise

If fully featured Workforce Management is enabled, then payroll transactions from Workforce Management can also be imported into PayGlobal. The transaction data is sourced directly from Workforce Management rather than using files for transfer.

Import files

The import file contains the hours employees worked, their allowances, and other information used to calculate employees' pays. Each import file is used only once.

The Import file values on the Company Settings - Import TA tab and Payroll Import Types - Details tab determine the types of files that you can see in the Import Pay | Import Files field. For example:

  • If you specify only *.adt on the Import TA tab, then you can see only ADT files.
  • If you specify *.adt on the Import TA tab and *.csv in a Payroll Import Types record, then you can see ADT and CSV files.

Pre-requisites

Before you run the Import Pay command, you must set an import path in Company Settings. After you import a file, new employee transactions will appear.

Preventing import re-use

After you import a file, PayGlobal changes the file extension to BAK to prevent re-use. If a file by that name already exists, then the extension will become .2.bak, or .3.bak, etc. so that a unique name is produced and unintentional data loss is prevented.

For the Workforce Management import type, since there are no files involved but instead pay run data objects, each pay run data object is marked as processed after import, thus preventing this pay run from appearing in the list of pay runs to import.

Re-importing Actuals

If you want to re-import Actuals into a pay period, then you must run Reset Pay before you rerun Export Actuals to Payroll and Import Pay.

If you do not run Reset Pay, then employees will receive duplicate payments because PayGlobal does not overwrite the original Actual Pay transactions in Payroll when you re-import pays.

Duplicated transactions

If you make changes to Time & Attendance data for a pay period and then re-import the file, then PayGlobal imports the entire file, not just the changes. As a result some transactions are duplicated.

Use one of the following solutions:

  • If you took a back up of your database before you imported the file, then restore from that backup.
  • Reset the pay.
  • In Company Settings, set Allow re-export to "No" to prevent this error happening again.

WAP data

Standard PayGlobal import file types include a WAP field; third party import file types do not. If you use the standard PayGlobal file types, then you can include WAP data when you run the Import Pay command. WAP codes were also added to the import file in the Self-Service module for some clients.

Date Validation

PayGlobal validates record dates when you use Import Pay, and does the following:

  • No dates - PayGlobal uses the Period Start Date and Period End Date, or just the Period End Date, depending on the type of transaction.
  • Start date, but no end date - PayGlobal uses the imported date for the End date.
  • End date, but no start date - PayGlobal uses the End date or Period Start Date for the Start date, depending on the type of transaction.
  • Start date occurs after end date - PayGlobal uses the End date as the Start date and the Start date as the End date, and adds a warning in the audit log.

Onboarding Employees

If the import file contains transactions for employees that have not yet completed onboarding these transactions will not be included in the pay. See Employee | Dates tab for more details about onboarding employees.

In This Section

Import Pay - Details