You can import hours and amount amounts from CSV file to Clarity.
- You need to delete the header record from the Excel file
- Change Excel file type to CSV (Comma delimited )
- 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
- First Sample: Layout2.csv
...
...
...
- Go to Configuration > Interfaces > Paycard import interfaces
...
- Click + sign at the top and create a new import interface.
...
- 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
...
- .
...
- Select your Pay period by Payroll > Select pay period.
...
- Go to Payroll > Process paycards > Batch payroll
...
- .
- Select only the first option and click next.
...
- Select your import interface name and your import file location.
...
- Click at the top tab codes and mapping payroll categories codes.
...
- Click Next
...
- .
- Run Payroll,
If you get Paycard creation complete this means paycard batch has imported successfully. - You can check the paycards hours on Payroll > Process Paycards > Edit Paycards
Note: Please try this setup in a "SANDBOX" TEST company then if the test is ok you can do in your live company.