Tables

The add-in models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.

CData Excel Add-In for Xero Tables


Name	Description
Employees	Allows you to query, insert, and update employee records. Employees are individuals working for the organization, and their data includes payroll, tax, and employment information.
LeaveApplications	Manages leave applications submitted by employees. It allows for querying, inserting, and updating leave requests for various types of employee leave.
PayItemsDeductions	Used to query, insert, and update deductions that are part of the employee's pay items, such as tax, union fees, or other voluntary deductions.
PayItemsEarnings	Used to query, insert, and update earnings that are part of the employee's pay items, such as regular wages, bonuses, and other forms of compensation.
PayItemsLeave	Allows you to manage leave-related pay items. It is used to query, insert, and update leave accruals, including annual leave and sick leave.
PayItemsReimbursements	Manages reimbursement-related pay items. It allows you to track and manage employee expense reimbursements within the payroll system.
PayrollCalendars	Stores and manages payroll calendars. It tracks the pay periods (for example, weekly, bi-weekly, or monthly) for the organization, helping to determine payroll schedules.
PayRuns	Used to query, insert, and update pay runs. A pay run represents the payroll process for a specific pay period and includes all employee payments, deductions, and taxes.
PaySlipDeductions	Manages payslip deduction line items for employees. It tracks the various deductions applied to an employee's pay, such as tax or superannuation.
PaySlipEarnings	Manages payslip earnings line items. It includes details about an employee's earnings, such as salary, wages, bonuses, and commissions.
PaySlipLeaveAccrual	Tracks leave accruals on the payslip. It helps manage and report on the amount of leave an employee has accrued over time.
PaySlipReimbursements	Manages payslip reimbursement line items. It tracks reimbursements made to employees for out-of-pocket expenses.
PaySlipSuperannuations	Manages payslip superannuation line items. Superannuation refers to the employer's contribution to an employee's retirement fund.
PaySlipTaxes	Tracks tax-related line items in payslips. It includes information on the tax deductions applied to an employee's pay, such as income tax and other levies.
PaySlipTimesheetEarnings	Manages payslip timesheet earnings line items. It tracks earnings that are calculated based on time worked, such as hourly wages or overtime.
SuperFunds	Used to manage payroll super funds for employees. It tracks the superannuation funds to which employees are contributing for their retirement savings.
Timesheets	Used to query, insert, and update timesheets for a Xero organization. Timesheets record the hours worked by employees, which are used to calculate pay for hourly workers.