Xero Payroll (UK) Endpoint: PaySlips

From OdataLink
Jump to navigation Jump to search

Overview

The Xero PaySlips endpoint provides the list of payslips. You can join data from this endpoint with PayRunsExpanded to access additional information belonging to the Pay Run.

As this endpoint cannot be filtered, it is optimised to pull payslips based on the model's Default Start Date and Default End Date. See Editing a model's details for more information.

Note that this endpoint is more performance heavy as it will need to query each detailed pay run. You should only integrate with this endpoint if required. The GetPaySlip endpoint is easier to optimise.

To make full use of the data in this endpoint may require using endpoints belonging to a Xero Accounting Model.


Fields

The following fields are available for the PaySlips endpoint.

paySlipID
A guid field that provides the id of the pay slip.
payRunID
A guid field that provides the id of the pay run.
employeeID
A guid field that provides the employee id associated with the payslip.
firstName
A text field that provides the first name of the employee.
lastName
A text field that provides the last name of the employee.
paymentMethod
A text field that provides the way in which the pay slip was paid.
totalEarnings
A decimal field that provides the total earnings amount of this payslip.
grossEarnings
A decimal field that provides the gross earnings amount of this payslip.
totalPay
A decimal field that provides the net pay.
totalEmployerTaxes
A decimal field that provides the total employer taxes of this payslip.
totalEmployeeTaxes
A decimal field that provides the total employee taxes of this payslip.
totalDeductions
A decimal field that provides the total deductions of this payslip.
totalReimbursements
A decimal field that provides the total reimbursement amount of this payslip.
totalCourtOrders
A decimal field that provides the total court ordered earning orders of this payslip.
totalBenefits
A decimal field that provides the total benefits of this payslip.
bacsHash
A text field that provides the BACS service user number.
lastEdited
A date time field that provides the last date this payslip was edited.
earningsLines
A table field that provides the earnings lines of the payslip. These represent earnings recorded as default pay.
See EarningsLines Fields for more information.
leaveEarningsLines
A table field that provides the leave earnings lines of the payslip. These represent earnings paid from accrued leave.
See LeaveEarningsLines Fields for more information.
timesheetEarningsLines
A table field that provides the leave earnings lines of the payslip. These represent earnings captured from timesheets.
See TimesheetEarningsLines Fields for more information.
deductionLines
A table field that provides the deduction lines of the payslip.
See DeductionLines Fields for more information.
reimbursementLines
A table field that provides the reimbursement lines of the payslip.
See ReimbursementLines Fields for more information.
leaveAccrualLines
A table field that provides the leave accrual lines of the payslip.
See LeaveAccrualLines Fields for more information.
benefitLines
A table field that provides the benefit lines of the payslip.
See Benefit Lines Fields for more information.
paymentLines
A table field that provides the payment lines of the payslip.
See PaymentLines Fields for more information.
employeeTaxLines
A table field that provides the employee tax lines of the payslip.
See TaxLines Fields for more information.
employerTaxLines
A table field that provides the employer tax lines of the payslip.
See TaxLines Fields for more information.
courtOrderLines
A table field that provides the court ordered earnings lines of the payslip.
See CourtOrderLines Fields for more information.


EarningsLines Fields

The EarningsLines Fields include the following sub fields. This is applicable to earningsLines, leaveEarningsLines and timesheetEarningsLines.

earningsLineID
A guid field that provides id associated with the pay slip line.
earningsRateID
A guid field that provides the earnings rate id associated with this payslip line.
displayName
A text field that provides the name of the earnings rate.
ratePerUnit
A decimal field that provides the rate per unit of this payslip line.
numberOfUnits
A decimal field that provides the number of units of this payslip line.
fixedAmount
A decimal field that provides the fixed amount of this payslip line.
This only applies to certain PayItemsEarningsRates.
amount
A decimal field that provides the amount of this payslip line.


DeductionLines Fields

The DeductionLines Fields include the following sub fields.

deductionTypeID
A guid field that provides the pay item deduction id associated with this payslip line.
displayName
A text field that provides name of the deduction.
amount
A decimal field that provides the amount of this pay slip line.
percentage
A decimal field that provides the percentage rate if applicable.
subjectToTax
A true/false field that indicates if the amount was subject to tax or not.


ReimbursementLines Fields

The ReimbursementLines Fields include the following sub fields.

reimbursementTypeID
A guid field that provides the pay item reimbursement type id associated with this payslip line.
description
A text field that provides the description for this payslip line.
amount
A decimal field that provides the amount of this payslip line.
ratePerUnit
A decimal field that provides the rate per unit of this payslip line.
numberOfUnits
A decimal field that provides the number of units of this payslip line.


LeaveAccrualLines Fields

The LeaveAccrualLines Fields include the following sub fields.

leaveTypeID
A guid field that provides the pay item leave type id associated with this payslip line.
numberOfUnits
A decimal field that provides the number of units applicable for this payslip line.


BenefitLines Fields

The BenefitLines Fields include the following sub fields.

benefitTypeID
A guid field that provides the benefit type id associated with this payslip line.
displayName
A text field that provides the name for the pay slip line.
amount
A decimal field that provides the amount.
fixedAmount
A decimal field that provides the fixed amount (if applicable).
percentage
A decimal field that provides the percentage rate used to calculate the amount (if applicable).
manualAdjustment
A true/false field that indicates if the amount was manually adjusted.


PaymentLines Fields

The PaymentLines Fields include the following sub fields.

paymentLineID
A guid field that provides the id of the payment line.
amount
A decimal field that provides the amount paid.
accountNumber
A text field that provides the account number for the payment,
accountName
A text field that provides the account name for the payment,


TaxLines Fields

The TaxLines Fields include the following sub fields. This applies to employeeTaxLines and employerTaxLines.

taxLineID
A guid field that provides the id of the pay slip tax line.
description
A text field that provides the description of the tax.
amount
A decimal field that provides the amount.
globalTaxTypeID
A guid field that provides the global tax type id of the pay slip tax line.
manualAdjustment
A true/false field that indicates if the amount was manually adjusted.


CourtOrderLines Fields

The CourtOrderedLines Fields include the following sub fields.

courtOrderTypeID
A guid field that provides the earnings orders type id associated with this payslip line.
amount
A decimal field that provides the amount.
fixedAmount
A decimal field that provides the fixed amount (if applicable).
manualAdjustment
A true/false field that indicates if the amount was manually adjusted.


Xero API

For a detailed run through of the endpoint, you can see the Xero API.


Related Fields

None


Related Endpoints

Accounts
Employees
GetPaySlip
PayItemsBenefits
PayItemsDeductions
PayItemsEarningsOrders
PayItemsEarningsRates
PayItemsLeaveTypes
PayItemsReimbursementTypes
PayRuns
PayRunsExpanded


Related Topics

Xero Payroll (UK) Models
Xero Payroll (UK) Endpoints