Sage 50 Payroll Employee Deductions XML
The Importing Employee Deductions Into Sage 50 Payroll task allows you to insert or update Deductions associated with Employees in Sage 50 Payroll.
For an Employee Deduction to be imported, the Employee and the Deduction must already exist in Sage 50 Payroll.
Employee Matching
The Employee is matched based on the provided EmployeeReference
in the XML.
<?xml version="1.0"?>
<Company>
<EmployeeDeductions>
<EmployeeDeduction>
<EmployeeReference>1</EmployeeReference>
</EmployeeDeduction>
</EmployeeDeductions>
</Company>
EmployeeReference
Required
Employee Reference
The numeric identifier of the Employee that you would like to associate the Deduction with.
Deduction Matching
The Deduction is matched based on the provided DeductionReference
or DeductionName
in the XML.
<?xml version="1.0"?>
<Company>
<EmployeeDeductions>
<EmployeeDeduction>
<DeductionReference>1</DeductionReference>
<DeductionName>Pension</DeductionName>
</EmployeeDeduction>
</EmployeeDeductions>
</Company>
DeductionReference
Optional
Ref
The numeric identifier of the Deduction that you would like to associate with the Employee.
DeductionName
Optional
Deduction Name
The name of the Deduction that you would like to associate with the Employee.
Employee Payment Fields
The following Employee Deduction fields can be set using Zynk.
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Deductions-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeeDeductions>
<EmployeeDeduction>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
=======
<Company>
<EmployeeDeductions>
<EmployeeDeduction>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-deductions-xml.md
</Company>
Hours
Optional
Hours/No
The number of hours to set on the Employee Deduction.
Rate
Optional
Rate
The hourly rate to set on the Employee Deduction.
Samples
Sample import file for importing a new Employee Deduction
If the Deduction is already associated with the Employee then the import of the record will fail
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Deductions-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Insert">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
=======
<Company>
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Insert">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-deductions-xml.md
</Company>
Sample import file for updating an existing Employee Deduction.
If the Deduction isn't already associated with the Employee then the import of the record will fail
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Deductions-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Update">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
=======
<Company>
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Update">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-deductions-xml.md
</Company>
Sample import file for updating an existing Employee Deduction otherwise inserting a new Employee Deduction
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Deductions-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Upsert">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
=======
<Company>
<EmployeeDeductions>
<EmployeeDeduction RecordOperation="Upsert">
<EmployeeReference>1</EmployeeReference>
<DeductionName>Pension</DeductionName>
<Hours>7.5</Hours>
<Rate>5</Rate>
</EmployeeDeduction>
</EmployeeDeductions>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-deductions-xml.md
</Company>