Multi Employee Timesheet (MET) allows for fast transaction entry. You add transactions for multiple employees into the grid before processing all the transactions at once, speeding up data entry.
Multiple copies of the MET grid can be saved and used to create a roster or standard pay template. Open the saved templates in the grid, and enter the exceptions before processing.
When you use MET depends on what you use it for:
To process normal hours and leave use MET before generating autopays.
To process additional payments, e.g. overtime or additions, use MET after generating autopays.
To include Penalty in MET, add both Penalty and Penalty Rate to the grid. Penalty Rate is used to enter the overtime factor, e.g. for time and a quarter, enter 1.25.
To add leave, for each leave type, include Leave Hours, Leave Reason, Leave Start and Leave End, in the grid. E.g. for Annual Leave you would include Annual Leave Hours, Annual Leave Reason, Annual Leave Start and Annual Leave End. The exceptions are:
For User Defined Leave you also need to include User Defined Leave class.
For RDO, include RDO Hours and RDO Amount if required. The start and end dates will default to the period end date.
You can't process transactions for terminated employees through Multi Employee Timesheet, instead use Express Timesheet, Extended Timesheet or Manual Calculation.
Transactions entered into MET will be appended (added) to an existing timesheet. If a timesheet doesn't exist one will be created.
Process transactions in Multi Employee Timesheet
Go to Payroll, Transactions, Processing, Multi Employee Timesheet.
Customise the grid to include your required pay components, by adding and removing columns.
Right-click anywhere on the grid and select:
Customise Grid Columns to drag Pay Components, Additions or Deductions into the grid. To remove unwanted columns, drag them to the Customise window.
Clear Values to clear data but retain Employees.
Clear Grid to remove ALL values (including Employees).
Reset Form Defaults to reset the grid to the default layout.
Select or enter the Employee.
Fields in MET are customisable. Right-click in the field, select Lookup Field and choose to sort by code or description/name.
Enter the transaction details for the employee. This may include hours, leave (including dates and reasons), additions and deductions.
If the components required are not available, use Customise Grid Columns to add columns.
The keyboard's down arrow or <TAB> through the row to create a new line.
Repeat Steps 3 and 4 until all transactions have been entered.
Click Options. Tick the options that you want to use and click OK. The options are:
Bypass Standard Additions and Deductions - this will stop any default additions or deductions from being included in the transaction.
Bypass Bank Splits - this will stop the allocation of Net Pay to multiple bank accounts, the total value will be allocated to the employee's primary bank account.
Add Balance of Hours - this will add Normal Hours to the transaction so that the total hours for Normal and Leave equal the Normal Hours Paid on the employee record.
Click Process or Ctrl + P to process transactions.
All processed transactions will be included in reports and can be edited through Extended or Express Timesheets.
Autopays will not generate for Employees with existing timesheets.
Standard pay templates/rosters
Multi Employee Timesheet can be used to record rostered hours. You can create multiple pay periods to be used for future pay periods.
Customise Grid Columns so the grid shows required fields.
Select each Employee rostered to work and key in their rostered hours and scheduled additional payments.
Click Save. Save the file with a relevant File Name and as type Text (*.txt) or Micropay Employees File (*.mef)
Click Open and locate the file when it is time to create transactions for the period.
Edit any components before clicking Process to generate transactions for the period.
The Multi Employee Timesheet toolbar
Close will close Multi Employee Timesheet.
New returns Multi Employee Timesheet to the default settings.
Open button will open a previously saved MicrOpay Employee File.
Save button saves data to either a .txt (Text) or .mef (Micropay Employee File) file.
Process button creates transactions from the data that has been entered.
Clear Values button clears data that has been entered into the Multi Employee Timesheet. The Employee Code will remain.
Clear Grid button clears ALL values from the grid.
Save Grid button allows you to save the grid as a report, and can be used to create a .csv file.
Import button allows you to import data from a CSV file. From the Open window, locate and select your file.
Add button at the bottom will add a row below the selected row. This will contain the same Employee from the row above.
Tip: When importing from a file, the order of the columns in the CSV file must match the grid. If they don't, the data will be imported into the incorrect component. If the CSV file contains a header record, this will error when imported.