Payroll Software & Integration with External Systems
Payroll Software
People Resolutions specialises in Human Resource Software solutions. Since we don’t have our own payroll software, we’ve partner with leading South African payroll providers that we can integrate with.
With these partners, we can provide a complete HR & Payroll solution to meet every client’s needs. The specific payroll that we’ll recommend will depend on the client’s size, needs, budget and hosting requirements (cloud or on-premise).
Both HR Systems and Payroll Systems are highly specialised products. Companies that develop both their own payroll and HR, usually tend to “neglect” or provide a watered down HR System. Thus our approach essentially provides clients with the best solution of both worlds.
Payroll Integration Overview
Regardless of whether we must supply the payroll with our HR system or if SAP or an existing payroll is already in place, we can seamlessly integrate.
Synchronise Biographic data from SAP or Payroll
HR Manage can integrate with virtually any payroll, either via importing exported files from the payroll or via direct importing from the payroll’s data source or through connecting to the payroll APIs. The available integration methods are dependent on the payroll being used. Where requested, we can also develop custom integration solutions that allows HR Manage to write data back to the payroll or even to other systems like gate access control, medical systems, etc.
HR Manage usually imports employee data and the specifications of what exactly gets imported, is determined by the client. Training data, unless part of a custom developed interface, can be imported as a once-off exercise from where it will further be managed in HR Manage.
Payrolls to Import From
We have clients using various popular South African payrolls and we’ve even integrated with older legacy payrolls like Pastel, Dynamique and Unique in the past. Our ability to interface with a payroll is dependent on what kind of “data exposure” the payroll offers. Newer payrolls expose integration through web APIs and even though the way these APIs work differ vastly from one payroll to the next, our Importer is powerful enough to accommodate all of them. For older payrolls, we can still integrate through SQL / ODBC connections or via scheduled imports from CSV, Excel, Json or Xml files.
The only requirement that we have is that the file to be imported at each interval, must contain the same field / column names as the previous file and contain at least one field that remains constant that can be used as the primary key (ID Number / SAP Number preferred). Records without a primary key will not be imported.
HR Manage Importer
The HR Manage Importer will retrieve the payroll data and transform it so that it matches up with the job titles, locations and other lookups in HR Manage. If a change in job title / location is detected during the import, the system will automatically create a new occupation so that movement history is saved. The Importer also allows you to manage Automatic Import Tasks and specify when and how often they should run. It is possible to import from multiple payrolls / data sources, each with their own structure and matching values.
After each import, the system will provide the user with a report of exactly who imported, which employees haven’t changed since the last import and which employees failed to import and the reason. For failed employees, the user can correct the conditions and do a re-import of the single employee without running the whole import again.
Handling Disconnected Scenarios
Cloud-based HR system, On-premise payroll
In a lot of scenarios, it makes sense to host HR Manage in the cloud while the payroll is hosted locally on-premise. Since there is no direct link possible between the HR and payroll systems in such a case, HR Manage has various functionality and tools available to handle this.
The HR Manage Importer has the ability to download files from a ftps site, extract encrypted files and even execute SQL scripts. We also have utilities that can be installed on the client network that extract data from a legacy payroll, compress & encrypt it and send it to HR Manage at specific intervals.
Available Import Tasks
The Importer can perform the following tasks before or after an import:
- Download file (ftps, https, API)
- Extract password protected zip archive
- Execute SQL script
- Execute a plugin / program
- Delete files (for clean-up)
Types of Import Formats
HR Manage can import from various sources and file formats:
- Web API
- SQL Server
- CSV / Text
- Excel Workbooks
- XML Documents
- Json Files
- SQL Scripts (Insert-statements)
Quick Setup for Popular Payrolls
Payroll Configuration Wizard
As of version 6.2, HR Manage boasts with a configuration wizard for quickly connecting to some of South Africa’s well-known payroll providers. The wizard simply asks for a couple of values and then configures most of the import template automatically. Configuration includes the import sources, column mappings and related options. This removes all the complexity of configuring the API connection and saves a lot of time for getting started with HR Manage.
At the moment, we’ve only included 3 payrolls in the wizard, but adding more (on request) is as simple as a server-side patch. The wizard currently supports:
- PaySpace
- Sage 300 People
- SimplePay
How we integrate with popular payrolls
Payspace
Payspace is our cloud-based payroll partner that has various Apis available for integration. This is simply configured in HR Manage by using the Payroll Configuration Wizard that will automatically generate a complete Import Template which will in turn call 3 Apis in accordance with Payspace’s api specifications. This all happens seamless in the background though.
Sage 300 People
We have a custom Generic-GET api that HR Manage connects with. To set up, we provide the script for the Api to configure within 300 People and once the api is running, HR Manage is simply configured using the Payroll Configuration Wizard and everything runs smoothly from there.
SAP
We can connect to a BAPI if one is developed / available, however, the usual integration method that companies prefer is for SAP to export the data at regular intervals to a FTPS site from where HR Manage download the file and import it. It is a bit of manual configuration to set up but once it is running, it is seamless.
SimplePay
SimplePay is a cloud-based payroll with a very simple structure and Api that HR Manage integrates with. As usual, the Payroll Configuration Wizard does all of the work and getting started is extremely quick.
Other & Legacy payrolls
For the older payrolls that don’t support Apis, we usually use one of the legacy methods for integration. If we’re able to connect to the payroll database, we’ll do that, otherwise as long as the payroll supports automatic exporting of data at regular intervals, we can achieve seamless integration. Our previous Importer module has been importing from legacy payrolls for over 10 years and the newly upgraded Importing module is even more powerful.