Description
The existing Timesheet Import feature, located in Time & Attendance > Import, has been enhanced to provide users with the ability to include the following timesheet elements:
Reimbursements
Absence Items ie; Leave Items
Adjustment Timesheets
Minor changes have been made to the existing Timesheet Import process to include these items.
In stage 2 of the import process ‘Import Settings’ page, we have made some changes to the existing Field Mappings ‘Map to Fields’ to include these new items:
New / Updated Map to Fields | Description |
Attendance / Absence Item Name | Updated to provide ability to map to an Attendance Item Name or an Absence Item Name |
Attendance / Absence Item Import Code | Updated to provide ability to map to an Attendance Item Code or an Absence Item Code |
Adjustment Reason | Added to provide the ability to map to an Adjustment Reason where the timesheet to be imported is an Adjustment Timesheet (Adjustment Reason is mandatory for Adjustment Timesheets). |
Adjustment Reason Import Code | Added to provide the ability to map to an Adjustment Reason Import Code where the timesheet to be imported is an Adjustment Timesheet (Adjustment Reason is mandatory for Adjustment Timesheets). |
Reimbursement Date | Added to provide the ability to map to the date of a Reimbursement item. This value is required where a Reimbursement is to be imported with the timesheet. |
Reimbursement Item Name | Added to provide the ability to map to the name of a Reimbursement item. Must include this item OR Reimbursement Import Code where a Reimbursement is to be imported with the timesheet. |
Reimbursement Import Code | Added to provide the ability to map to the name of a Reimbursement Code Must include this item OR Reimbursement Item Name where a Reimbursement is to be imported in the timesheet. |
Net | Added to provide the ability to map to the net value of a Reimbursement item. Must include this item where a Reimbursement is to be imported in the timesheet where Currency Code and Currency Value do not apply. |
Tax (GST/VAT) | Added to provide the ability to map to the tax (GST/VAT) value of a Reimbursement item. Must include this item where a Reimbursement is to be imported in the timesheet where Currency Code and Currency Value do not apply. |
Currency Code | Added where Currency Conversion has been configured in the environment, and the Reimbursement Item value needs to include the Currency Code that it needs to be converted to in the payroll process. Where Currency is required, Currency Code and Currency Value are required. Net an Tax values are not required. |
Currency Value | Added where Currency Conversion has been configured in the environment, and the Reimbursement Item value needs to include the Currency Value that needs to be converted in the payroll process. Where Currency is required, Currency Code and Currency Value are required. Net an Tax values are not required. |
Reimbursement Project Code | Added to provide the ability to map a project code to a Reimbursement item. Where the Project Code is mandatory on a timesheet, this value must be included with any reimbursements. |
Benefits
These enhancement increase the scope of timesheet import, which will reduce the need to manually create Adjustment Timesheets within the product, and also remove the requirement to manually add Reimbursements and Absence items to already imported timesheets within Interpreter Review.