Imagine any spreadsheet data automatically transferred into payroll at the touch of a button.
Shifts, new employees, any pay item or scheme – and from any format Excel or CSV. That’s what integration with paiyroll® achieves.
Update payroll in minutes, not hours, and as often as you wish. We believe this is the most advanced integration between spreadsheets and a payroll system.
Finally, your spreadsheets can now drive paiyroll®.
- Any payroll data can be uploaded from spreadsheets
- Built-in processor to auto-modify dataset format
- Data is validated before being uploaded
- Starters can have pay items automatically added from template employees
- Leavers merely require a level date upload
- Companies, departments, and reports can be uploaded
- Synchronises salary, benefits and non-salary compensation data
- Synchronises holiday data
- Supports multiple companies
Scroll down to read more about each feature
Spreadsheet upload features
Upload any format shift file from your Time and Attendance (T/A) system. Employees can have any number of shifts with unlimited pay rates and shift descriptions. Once uploaded, live pay is visible on the employee app.
Add new employees
Load new employees with all tax, address and any details. Automatically send welcome emails.
Set up template employees which automatically adds standard pay items when adding new employees.
Automatically update all employee fields. This includes leaver dates.
We use 3 forms of spreadsheet uploads: direct, data-feed and bulk employee edits. No matter what format.
Automatically checks every data field before adding it, flagging errors early to provide maximum time for corrections, such as mistyped bank details or incorrect NI numbers.
Use our programmable processor to auto-modify any spreadsheet column e.g. date format, combine multiple columns, remove characters from columns etc.
If your spreadsheet includes missing fields, these can be hard-coded in the uploaders. These fields can be modified in paiyroll® and not overwritten on subsequent uploads.
Load new salaries directly from a multi-sheet salary planning tool, or export from HR software. Excel. Changes can be mid-period or backdated and this is automatically calculated.
Upload any non-salary pay items e.g. Bonus, Commission, Accommodation, Car Allowance, Cycle to work, Health cash plan, Holiday Buy/Sell, Lift Assurance Flex, and Allowances.
Synchronise an unlimited number of non-cash benefits items. Multiple pension schemes with differing % contribution and Salary Exchange, Net Pay Arrangement and Relief at Source types are supported. Other examples are health plans, life assurance, child-benefit, vouchers etc.
New, changed and deleted holidays can also be transferred into paiyroll®.
Upload spreadsheets as often as required during the payroll cycle. Payroll changes are completed in minutes.
Direct uploaders support multiple companies (multiple PAYE references) in paiyroll® in one file.
Any data type in paiyroll® can be uploaded for rapid configurations e.g. Companies, Departments, Schedules, Defintions, Reports and Workflows.
Reports can be uploaded.