In this topic
Introduction
There are several flat file types that can be imported into Ready pay (powered by ePayroll). Each file type typically requires codes that are unique to your account and as such we generally need to be involved before you can start using them.
This page is intended to provide a brief overview of the options available so that you can ascerain whether they are likely to be suitable for your needs. Please note that this functionality is geared towards clients who wish to integrate data between two systems, rather than clients who want to create import files by hand/in Excel.
If you believe these formats are useful for your situation, please contact the ePayroll Support Team for further discussions on moving forward to implement these.
Employee Master File Data
There are options for importing employee changes and new employees into .
Please contact the ePayroll Support Team to learn more.
Interpreted Payroll Data
The payroll data format can be used to import fully interpreted payroll data into a payroll. This format is typically used by organisations who are using a third party time and attendance solution to calculate employee payments.
This format has the following columns:
| Column Name | Description |
|---|---|
| Employee Code | Identifies the employee that the row belongs to. |
| Cost Centre Code | Identifies the cost centre that the payment should be allocated to for reporting purposes. |
| Paycode Code | Identifies the kind of payment being made. |
| Units | The number hours/units or the amount to be paid at this paycode (depends on the configuration of the paycode). |
| Period Start Date | The pay period start date (optional). |
| Period End Date | The pay period end date (optional). |
| Leave Start Date | For leave paycodes, the start date of the leave (optional). |
| Leave End Date | For leave paycodes, the end date of the leave (optional). |
| Number of pays | The number of pay periods that the row covers. This is generally ‘1’, but can be higher for example when leave is being paid in advance. This impacts the tax calculation. |
| Alternate Rate | The hourly/unit rate to be applied to the payment. Generally left blank as the employee’s normal rate of pay should be applied. |
A detailed specification document can be supplied, please contact the ePayroll Support Team.
Limitations
This format does not allow:
- Tax amounts to be overidden
- A particular payment method to be specified (all rows will default to the employees normal payment method)
- Cannot adjust amounts that are deducted through the salary packaging module, only those that are deducted through a paycode
Exporting Data
There are a number of methods available to export information from Ready pay (powered by ePayroll) back into a third party system.
At a high-level:
- Employee Info - The Employee Info (Excel) report in on demand reporting includes basic employee details and current leave balances.
- Tranaction data - The Transaction Data (Excel) report in on demand reporting lists all of the transactions for payrolls with an accounting date between two chosen dates.
Limited data is also available via API. API access is granted on a case-by-case basis after assessing the client needs and the other available options.
