On-Cycle Paystub Import Upload

Table of Contents:

• On-Cycle Paystub Import Template
• How to Complete an On-Cycle Paystub Import
• How to Map Fields From Your On-Cycle Paystub Import to DSPTCH

On-Cycle Paystub Import Template

DSPTCH accepts a strict format for On-Cycle Paystub Imports.

There are four columns in the On-Cycle Paystub Import template:

• Payroll ID (Required):
  • The unique Payroll ID for your User as it appears in DSPTCH
  • To find a User's Payroll ID click on the People tab from the main navigation bar and then click on the User's profile. Lastly, scroll down to the Employment Details section of their profile and locate the Payroll ID listed there.
    • For more detailed instructions on how to find a User's Payroll ID, read our documentation here.
• Field Name (Required):
  • The name of the line item as it appears in the external payroll system. Used to categorize amounts appropriately.
  • This will need to be manually mapped to a set Deduction/Contribution type within DSPTCH (instructions here).
• Contributor (Required):
  • Entity for which the amount is applicable. Acceptable values are EMPLOYEE or EMPLOYER only. Note that earnings such as wages should be marked as EMPLOYEE.
• Amount (Required):
  • The monetary value of the line item in the applicable currency.

Once the On-Cycle Paystub Import template has been completed, it can be uploaded to DSPTCH by following the steps directly below.

How to Complete an On-Cycle Paystub Import

Start by clicking on the Time Tab from the main navigation bar at the top of the screen. Then, navigate to the applicable Pay Period that the On-Cycle Paystub Import data corresponds to (by using the back and forward arrows next to the dates at the top right of the screen).

Once the correct Pay Period is open, click the "New Import" Button and then the "+ New On-Cycle Paystub Import" Button. Next, click the "Choose File" Button and upload the filled-out version of the On-Cycle Paystub Import Template.

Lastly, click the "Continue" Button to complete the upload. A success message reading, "Import was successfully initiated" will appear at the bottom right of the screen.

Please see the video below for a demonstration:

How to Map Fields From Your On-Cycle Paystub Import to DSPTCH

Start by clicking on the Time Tab from the main navigation bar at the top of the screen. Then, click the "Settings" tab from the sub-navigation bar near the top of the screen. On the menu on the left-hand side of the screen, click the "Integrations" Tab.

In the Unknown Mappings Section, there will be a list of all unknown External Names that are compensation line items found in the On-Cycle Paystub Import but have not been mapped to any known DSPTCH categories. External Names correspond to the Field Name from the On-Cycle Paystub Import.

Edit each unknown External Name to assign it to a known DSPTCH category by clicking on the pencil icon on the right side of the screen for each unknown External Name.

Examples of DSPTCH Category Mappings:

• Gross Pay = Earning - Gross Pay
• Net Pay = Earning - Net Pay
• Per Diem = Per Diem (pre-tax)
• Mobilization Payment = Earning - Day Rate

Please provide a mapping to each of these categories that applies within your On-Cycle Paystub Import.

Then, in the Deduction or Contribution field, click on the drop-down and select the most applicable category. Lastly, click "Save" to complete the mapping.