CData Python Connector for Xero

Build 25.0.9454

PaySlips

Allows querying payslips for a Xero organization. Payslips provide detailed breakdowns of employee pay, deductions, taxes, and other compensations for a specific pay period.

Columns

Name Type Filterable Description
PayRunID String The unique identifier for the payrun, which encompasses all the payslips for a specific payroll cycle. This ID links all payslips under the same payrun and is crucial for organizing payroll information across multiple employees.
PayslipID [KEY] String The unique identifier for a specific payslip, as assigned by Xero. This ensures that the payslip is distinctly identifiable and can be tracked separately within the payroll system.
EmployeeID String The unique identifier assigned to each employee in Xero. This connects the payslip to the employee, ensuring that payroll data is correctly attributed to the right person.
FirstName String The first name of the employee, as recorded in Xero. This field helps identify the employee when reviewing or generating payslips for individual workers.
LastName String The last name of the employee, as recorded in Xero. This is another identifier used to differentiate employees and is included on payslips for clarity.
EmployeeGroup String The name of the group or department the employee belongs to, as defined by the employer in the payroll system. This can be used to categorize employees for payroll or reporting purposes.
LastEdited Datetime The timestamp of the most recent modification to the payslip. This allows for tracking and auditing of any changes made to the payslip after it was initially created.
Wages Decimal The total wages earned by the employee during the pay period. This is the sum of regular earnings and any applicable allowances or bonuses, minus any deductions.
Deductions Decimal The total amount of deductions applied to the employee's wages, such as taxes, retirement contributions, and other withholdings as per the employee's pay details.
NetPay Decimal The total amount the employee takes home after all deductions are subtracted from the gross wages. This is the final pay amount the employee receives for the pay period.
Tax Decimal The total tax withheld from the employee's wages, including income tax and other statutory taxes, as required by the relevant government regulations.
Super Decimal The total superannuation contributions made on behalf of the employee, as required by the employer's superannuation obligations. This is typically a percentage of the employee's wages.
Reimbursements Decimal The total amount of reimbursements included in the payslip, covering expenses that the employee incurred during the pay period that are being reimbursed by the employer.
TenantId String The unique identifier for the tenant (organization) in Xero. This ensures that the payslip is associated with the correct organization and enables accurate payroll processing across multiple organizations or entities.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454