Versions Compared

Key

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

You can import hours and amount amounts from CSV file to Clarity.

  1. You need to delete the header record from the Excel file
  2. Change Excel file type to CSV (Comma delimited )
  3. Keep the CSV file. Sample below is an example with two employees and two payroll categories (In this example Column A contain Employee code, Column B is the first Payroll category and column C is second.

First

  1. First Sample: Layout2.csv

...

  1. Image Modified

...

   

...

  1. Go to Configuration > Interfaces > Paycard import interfaces

...

  1. Click + sign at the top and create a new import interface.
    Image Modified

...

  1. Click at the top” Field mapping tab” and include field mapping by the add button. Include as much as you want depending on your import layout requirements

...

  1. .
    Image Modified

...

  1. Select your Pay period by Payroll > Select pay period.

...

  1. Go to Payroll > Process paycards > Batch payroll

...

  1. .
  2. Select only the first option and click next.
    Image Modified

...

  1. Select your import interface name and your import file location.
    Image Modified

...

  1. Click at the top tab codes and mapping payroll categories codes.
    Image Modified

...

  1. Click Next

...

  1. .
  2. Run Payroll,
    Image Modified
    If you get Paycard creation complete this means paycard batch has imported successfully.
  3. You can check the paycards hours on Payroll > Process Paycards > Edit Paycards
    Image Modified

Note: Please try this setup in a "SANDBOX" TEST company then if the test is ok you can do in your live company.