Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

Use this page to review and import data from an external provider.

Usage

Uploaded payslips will not be visible to users until they have been approved. If Pay Date To Live Days is entered on Company Details, payslips will not show until this is also met (this can be negative).

Image Removed

  1. Select a payslip XML file to upload.
  2. Select the Upload Type
    1. Normal - Upload payslip data, create company if not on the system.
    2. Overwrite - Overwrite payslips that match employees and periods in the upload.
    3. Employee Data Only - Only update and insert employees on the file, no payslip data.
  3. Click the Report button to review the uploaded payslip data. 
  4. Click the approve button to approve the upload.
  5. Once an upload is approved, employees with email payslip set may be emailed by clicking the email button.

...

Image Added

Click the orange download button Image Added to download the uploaded data in .csv files meeting the standard import formats in InPay.

If the uploaded data is incorrect, there are two options:

  1. Request a new upload from the external provider
  2. Alter the data in the .csv files and upload using the Import page

If the uploaded data is acceptable, click the green import button Image Added to import the data into InPay. Each import format will then be validated and imported into InPay if it passes validation. If there are any errors on the files, these may be viewed by clicking the import status. 

Errors

No External Id in InPay

When an employee is added manually, the ExternalId column (external providers employee Id) must be populated. 

If it’s not known at the time, it can be updated afterwards. It must be updated before the import is run. 

The ExternalId can be inserted in the Employee Starter import format and updated in the Employee Basic import format. 

To fix, request the employee’s ID from the external provider and update using the Employee Basic import format. It will then be possible to download the zip file and import using the Import page.

Multiple payments with the same amount

This can be an issue with the data from the external company. This may require them to send a new submission without duplicates.