The Multi Employee Timesheet (MET) allows for fast transaction entry, and data can be import from a CSV file. Before importing the data, ensure that:
The column order of the MET timesheet matches the column order of the CSV.
The CSV file has the employee code as the first column.
Any header record is removed from the CSV.
If you want to import Penalty, then both the MET timesheet and the CSV need to include both Penalty and Penalty Rate. Penalty Rate is where you specify the factor you want to use, e.g., for Time and a Quarter, enter 1.25.
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, 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 Multi Employee Timesheet in the current period.
The MET will not allow you to process a transaction for terminated employees. If you need to process a transaction for a terminated employee, use Express Timesheet, Extended Timesheet, or Manual Calculation.