Skip to content

Sage 50 Payroll Employee Payments XML

The Importing Employee Payments Into Sage 50 Payroll task allows you to insert or update Payments associated with Employees in Sage 50 Payroll.

For an Employee Payment to be imported, the Employee and the Payment 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>
  <EmployeePayments>
    <EmployeePayment>
      <EmployeeReference>1</EmployeeReference>
    </EmployeePayment>
  </EmployeePayments>
</Company>

EmployeeReference

Required
Employee Reference
The numeric identifier of the Employee that you would like to associate the Payment with.

Payment Matching

The Payment is matched based on the provided PaymentReference or PaymentName in the XML.

<?xml version="1.0"?>
<Company>
  <EmployeePayments>
    <EmployeePayment>
      <PaymentReference>1</PaymentReference>
      <PaymentName>Expense</PaymentName>
    </EmployeePayment>
  </EmployeePayments>
</Company>

PaymentReference

Optional
Ref
The numeric identifier of the Payment that you would like to associate with the Employee.

PaymentName

Optional
Payment Name
The name of the Payment that you would like to associate with the Employee.

Employee Payment Fields

The following Employee Payment fields can be set using Zynk.

<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <EmployeePayments>
        <EmployeePayment>
            <Hours>7.5</Hours>
            <Rate>10</Rate>
        </EmployeePayment>
    </EmployeePayments>
=======
<Company>
  <EmployeePayments>
    <EmployeePayment>
      <Hours>7.5</Hours>
      <Rate>10</Rate>
    </EmployeePayment>
  </EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>

Hours

Optional
Hours/No.
The number of hours to set on the Employee Payment.

Rate

Optional
Rate
The hourly rate to set on the Employee Payment.

Samples

Sample import file for sage-50-payroll-xml Employee Payment
If the Payment 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-Payments-XML.md
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <EmployeePayments>
        <EmployeePayment RecordOperation="Insert">
            <EmployeeReference>1</EmployeeReference>
            <PaymentName>Expense</PaymentName>
            <Hours>7.5</Hours>
            <Rate>15</Rate>
        </EmployeePayment>
    </EmployeePayments>
=======
<Company>
  <EmployeePayments>
    <EmployeePayment RecordOperation="Insert">
      <EmployeeReference>1</EmployeeReference>
      <PaymentName>Expense</PaymentName>
      <Hours>7.5</Hours>
      <Rate>15</Rate>
    </EmployeePayment>
  </EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>

Sample import file for updating an existing Employee Payment
If the Payment 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-Payments-XML.md
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <EmployeePayments>
        <EmployeePayment RecordOperation="Update">
            <EmployeeReference>1</EmployeeReference>
            <PaymentName>Expense</PaymentName>
            <Hours>7.5</Hours>
            <Rate>15</Rate>
        </EmployeePayment>
    </EmployeePayments>
=======
<Company>
  <EmployeePayments>
    <EmployeePayment RecordOperation="Update">
      <EmployeeReference>1</EmployeeReference>
      <PaymentName>Expense</PaymentName>
      <Hours>7.5</Hours>
      <Rate>15</Rate>
    </EmployeePayment>
  </EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>

Sample import file for upserting a Employee Payment
If the Payment isn't already associated with the Employee then one will be created, otherwise the existing Employee Payment will be updated

<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <EmployeePayments>
        <EmployeePayment RecordOperation="Upsert">
            <EmployeeReference>1</EmployeeReference>
            <PaymentName>Expense</PaymentName>
            <Hours>7.5</Hours>
            <Rate>10</Rate>
        </EmployeePayment>
    </EmployeePayments>
=======
<Company>
  <EmployeePayments>
    <EmployeePayment RecordOperation="Upsert">
      <EmployeeReference>1</EmployeeReference>
      <PaymentName>Expense</PaymentName>
      <Hours>7.5</Hours>
      <Rate>10</Rate>
    </EmployeePayment>
  </EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>