Payroll import
Tip: You must open a pay period to use this feature / functionality. Click the Pay Period menu and click the Enter button for the pay period you want to work with. The Payroll and Process menus become available.
This offering provides an efficient method of populating employee profile, timesheet, direct deposit and deductions & contribution data within Powerpay, without the need to manually enter the information.
The benefits of this ongoing service include time savings for Powerpay users and a reduction in opportunity for errors occurring while transferring data into Powerpay manually from source documents.
How Does It Work?
Typically, customers export data from a third party Time and Attendance system that is mapped and customized to provide Powerpay import files as output. Once valid import files are available and the import process is initiated, messaging within the Powerpay application is used to monitor the process from end to end and users is alerted to any issues or complications. Data rules are enforced through import file validation as well as conventional validation in the Powerpay application in the form of error and warning messages.
A company's import files may be in an XML format that conforms to the Powerpay standard XML schema, or they may in a delimited file format (e.g. CSV - comma separated value) that is mapped and formatted to the XML schema. There are three different methods to import data.
- Automated Import - Customers transfer payroll data in XML format to an import queue on a secure file server and the files are automatically loaded into Powerpay.
- Manual Import - Customers transfer payroll data in XML format to a specific location that is accessible to Powerpay users. From within a payroll run, users browse for the file and manually initiate the import process.
- Custom Import - Customers transfer payroll in delimited file format to a specific location that is accessible to Powerpay users. Custom Import templates allow the user to define how their data should be mapped to Powerpay data. The customer then initiates a process that converts their import files into Powerpay's XML format and places them in the import queue to be loaded into Powerpay. For more information see the Powerpay Custom Import Client User Guide.
For more information see the Powerpay File Import Guide.
Prerequisites
Prior to using import functionality, your time and attendance vendor must complete the mapping of your hours codes and earnings codes, if applicable, and file creation. Once this is complete, import functionality in Powerpay can be activated.
To obtain a listing of your codes, go to the Payroll Setup Reports page.