Contents x
    Earnings Import Details
    • 14 Nov 2024
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Earnings Import Details

    • Updated on 14 Nov 2024
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The Earnings Import Details page displays the details for all valid and invalid rows of an earnings import file after it has been uploaded. Before the import has been completed, users can update the details for rows with errors, delete rows, and complete the import.

    The Earnings Import Details page is displayed as part of the Pay Run Import wizard and can be accessed from the Imports page after the Pay Run Import wizard is closed.

    Navigation

    The Earnings Import Details page is displayed as part of the Add Import wizard and can be accessed from the Imports page after the Add Import wizard is closed.

    Imports page

    1. Navigate to the Imports page.

    2. Select the desired earnings import.

    Security

    The following permissions are associated with the Earnings Import Details page:

    • Payroll

      • Workforce Payroll

        • Payments

          • View Payments

          • Edit Payments


    These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.

    Earnings Import Details

    Buttons & Fields

    Button/Field

    Description

    1

    Valid / Invalid Rows Count

    Number of rows in the import that are valid and the number of rows in the import that have errors.

    • Green Checkmark - Rows without errors that will be imported when the import is completed.

    • Red Exclamation Mark - Rows with errors that will not be imported when the import is completed.

    2

    Search

    Filters the table for the entered text.

    3

    Smart Grid Controls

    Table ViewsSave/edit table views.
    FilterFilter column information.
    ColumnsRearrange table columns.
    ExportExport the table to a .csv file.
    RefreshRefresh the table.

    Learn more about working with Smart Grids.

    When the import has not been completed, the following filter is automatically applied:

    • Column = Status

    • Filter = Equals

    • Value = Invalid, Fixed

    4

    Validity Indicator

    Indicates if the row is valid for import.

    In Review:

    • Green Checkmark - Row does not have errors and will be imported.

    • Red Exclamation Mark - Row has errors and should be fixed or deleted. Rows with errors will not be imported when the import is completed.

    After Import Completion:

    • Green Checkmark - Row does not have errors and was imported.

    • Red Exclamation Mark - Row has errors and was not imported.

    5

    Trashcan (Delete) Button

    Removes the row from the import.

    This button only appears for imports in review.  

    6

    Import Row

    Earning details for a single employee and earning type. The details of a single row can be edited prior to completing the import.

    7

    Field Error Icon

    Indicates that the field has an error. Hover over the icon to view the specific error.

    8

    System-Updated Value Icon

    Indicates that the amount entered in the import file did not match the calculation of (Pay Rate * Hours) and that the amount for the row was updated by the system.

    9

    Complete Import

    Completes the import and adds the earnings from rows without errors to the associated pay run.

    This button only appears for imports in review.  

    This button is disabled if all rows have errors.

    This button is disabled if the associated pay run has already been approved.  

    Grid Columns

    Column

    Inline Editing

    Description

    Row

    No

    Row number from the import file.

    Employee ID

    No

    Unique numerical ID for the employee associated with the imported earning.

    Employee Name

    Yes

    Legal name of the employee associated with the imported earning.

    Job Title & Location

    Yes

    Job associated with the imported earning and the location associated with that job.

    Earning Type

    Yes

    Type of the earning being added to the employee’s payment.

    Pay Rate

    Yes

    Pay rate for the employee associated with the listed job and location.

    Required for hours-based earnings and cannot be 0.00, except when the earning type is ‘Unpaid Leave’.

    Will be 0.00 for amount-based earnings and cannot be edited.  

    Hours

    Yes

    Hours for the employee associated with the earning.

    Required for hours-based earnings and cannot be 0.00.

    Will be 0.00 for amount-based earnings and cannot be edited.  

    Amount

    Yes

    Amount of the earning being imported.

    For hours-based earnings, the amount is calculated by the system using the values entered for Pay Rate and Hours and cannot be edited.

    Was this article helpful?
    What's Next