Cost categories (also referred to as cost splits) are not the same as cost centres, though these terms are often confused.

In SelectHR, cost categories can be created and assigned to an employee either at the employee level (via their Appointment record) or the pay history level. Once assigned, they are automatically sent to SelectPay without requiring any mapping.

However, the nominal codes in SelectPay must be set up correctly for the integration to work. If you're unsure whether this has been done properly, please raise a case with the SelectPay support team and reference this article.

It's also important to note that cost splits will only be submitted to SelectPay once their effective date has been reached. Any future-dated cost splits will not be sent until they are no longer in the future.

Check Cost Category/Cost Split submissions

You can perform a data export from SelectHR to verify what Cost Categories/Cost Splits have been submitted for an employee:

Log in to the SelectHR Administrator Tool.
Click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR and log in.

Copy and paste the following SQL into the query window:

SELECT 
    p.[First Name],
    p.Surname,
    epr.[Employee Payroll Request Number],
    epr.[Audit Number],
    epr.[Payroll Company],
    epr.[Submitted Date],
    epr.[Response Date],
    epr.Error,
    epr.[Payroll Number],
    epr.Period,
    epr.[Person Number],
    epr.[Tax Year],
    ecr.[Appointment Number],
    ecr.ClearCostCategories,
    cc.[Category Change Number],
    cc.[Employee Change Request Number],
    cc.[Paytype Change Request Number],
    cc.Code,
    cc.EffectiveDate,
    cc.Name,
    cc.Nominal,
    cc.Notes,
    cc.SplitPercentage
FROM PayrollAudit.[Employee Payroll Request] epr
INNER JOIN PayrollAudit.[Employee Change Request] ecr
    ON epr.[Employee Payroll Request Number] = ecr.[Employee Payroll Request Number]
INNER JOIN PayrollAudit.[Category Change] cc
    ON ecr.[Employee Change Request Number] = cc.[Employee Change Request Number]
INNER JOIN Person.Details p
    ON epr.[Person Number] = p.[Person Number]
WHERE p.[First Name] = 'FIRST NAME'
  AND p.Surname = 'SURNAME'
ORDER BY epr.[Employee Payroll Request Number] DESC;

In the export tool, click Options (top left) and select Paste SQL from clipboard.
Change the First Name and Surname in the query to match the employee you want to check.
Click Data to run the query.
The results will show all Cost Category/Cost Split submissions for that employee, with the newest first.

If you have further questions, please raise a new case online and reference this article’s title.

Audit: Sickness changes submitted to SelectPay for a specific employee

View submissions to SelectPay for an employee

Using the Audit Log for SelectPay integration

Data Export: All pay changes submitted to SelectPay for a specific employee

Approved timesheets are not sent to SelectPay

Cost Split/Cost Category has not been sent to SelectPay

Check Cost Category/Cost Split submissions