The Multi Employee Timesheet in MicrOpay allows for fast transaction entry, and data can be input from a CSV file. Before importing the data, you need to 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 for the Penalty hours, e.g., for Time and a Quarter, enter 1.25 as the Penalty Rate.
To import the CSV into the Multi Employee Timesheet:
Go to Payroll, Transactions, Processing, Multi Employee Timesheet.
Right-click anywhere on the grid section of the Multi Employee Timesheet window and select Customise Grid Column.
From the Customise box, drag additional Pay Components or Additions and Deductions into the grid or remove unwanted columns by dragging from the grid back to the Customise window. The columns need to match the CSV.
Once the columns are selected, you can choose to click Save and create a template to use when importing CSV files, if the files are the same each time.
You can use Clear Grid to clear any unwanted data in the grid.
Click the Import button, which will display the Open window.
Locate the CSV file and click Open.
The data in the file will be imported into the Multi Employee Timesheet. 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 Multi Employee Timesheet will not allow you to process a transaction for employees with a Termination date present on their Employee record. If you need to process a transaction for a terminated employee, you will need to use the Express Timesheet, Extended Timesheet, or Manual Calculation Transaction.