The Multi Employee Timesheet (MET) allows for fast transaction entry and data imports from a CSV file. Before importing the data, ensure that:
The column order of the MET timesheet matches the order of the CSV.
The CSV file has the employee code as the first column.
Any header record is removed from the CSV.
To import leave, include Leave Hours, Leave Reason, Leave Start and Leave End for each leave type in the grid. E.g. for Annual Leave, include Annual Leave Hours, Annual Leave Reason, Annual Leave Start and Annual Leave End. The exceptions are:
User Defined Leave also include User Defined Leave class.
RDO, include RDO Hours and RDO Amount if required. The start and end dates will default to the period end date.
If you want to import Penalty, then both MET and the CSV need to include both Penalty and Penalty Rate. Penalty Rate is where you specify the factor to use, e.g., for time and a quarter, enter 1.25.
You cannot process a transaction for terminated employees in MET; instead, use Express Timesheet, Extended Timesheet, or Manual Calculation.
Transactions processed through MET will be appended (added) to an existing timesheet. If a timesheet doesn't exist, one will be created
To import a CSV
Go to Payroll, Transactions, Processing, Multi Employee Timesheet.
Right-click anywhere in the MET grid and select Customise Grid Column.
From the Customization box, drag additional Pay Components or Additions and Deductions into the grid or remove unwanted columns by dragging from the grid back to the Customization window. The columns need to match the CSV.
Once the columns are selected, click Save and create a template to use when importing CSV files, if the files are the same each time.
Use Clear Grid to clear any unwanted data in the grid.
Click Import and the Open window will appear.
Locate the CSV file and click Open.
The data in the file will be imported into MET. Check that the data is correct.
Click Process or click <Control> and <P> to generate transactions.
All processed transactions can be viewed on the Transaction Report and edited through timesheet entry.
Autopays will not generate for Employees with transactions processed through MET in the current period.