Skip to content

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>