To bulk import pay element values for the current pay period, you can do this quickly and easily in SelectPay by using the Import Pay Details wizard.
Considerations
Before you create the import, there are few things you need to consider:
You can't add effective dates to pay elements using the importer.
Don't use the text 'acloud' in the file name, unless you're importing from Access Expense.
Import template
You must save the file as .CSV comma separated values, using the format below.
Pay period, employee code and pay element name must be present.
You can assign a pay element to the employee using the importer.
Only use column J and K in pairs for each category split.
Column | Field | Details |
A | Pay period | The current pay period. |
B | Employee code | Must be entered. |
C | Pay element name | Must be entered. |
D | Quantity |
|
E | PAYE flag | 1: Yes Leave blank: No change |
F | NIC flag | 1: Yes Leave blank: No change |
G | Rate | Value can be to 3 decimal places. |
H | Hours | The value is added to the current quantity. Value can be to 2 decimal places. |
I | RC-NIC | Enter a period for retrospective NIC calculation. |
J | Category code |
|
K | Category split value | If column J is used, leave blank to set as zero. |
Import
Once your .CSV file is finalised, you're ready to import the data into SelectPay. To this follow the steps below.
Take a backup of your data.
Click Utilities then click Import Pay Details.
To select the import file, click the magnifying glass
.Browse and select the import file, click Open.
Select your carry forwards check-boxes as required.
Click Next, then click Next.
Click Close.