Skip to main content

Process hours using Multi Employee Timesheet

Pay leave, additions or hours using MET (Multi Employee Timesheet) for a number of employees

Updated over 2 months ago

Multi Employee Timesheet allows for fast transaction entry. You add transactions for multiple employees into the grid before processing all the transactions at one time. This speeds up the data entry process.
​
Multiple copies of the Multi Employee Timesheet grid can be saved and used to create a roster or standard pay template. The saved templates are opened in the grid, so only exceptions need to be entered before processing.
​
When you use Multi Employee Timesheet depends on what you use it for:

  • Process normal hours and leave via Multi Employee Timesheet before Generate Autopays.

  • Process additional payments, e.g. Overtime or Additions, after Generate Autopays.

To include Penalty in the Multi Employee Timesheet grid, 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 as the Penalty Rate.

Process transactions in Multi Employee Timesheet

  1. Go to Payroll, Transactions, Processing, Multi Employee Timesheet.

    • To facilitate fast data entry, the grid can be customised to include required pay components.

    • Columns can be removed and added to create a grid that meets your needs.

  2. Right-click anywhere on the grid to:

    • Customise Grid Columns to drag Pay Components, Additions or Deductions into the grid. To remove unwanted columns, drag them to the Customise window.

    • To clear data but retain Employees, select Clear Values.

    • To remove ALL values (including Employees), select Clear Grid.

    • To reset the grid to the default layout, select Reset Form Defaults.

  3. Select or enter the Employee for the first transaction.

    • Fields in Multi Employee Timesheet are customisable. You can choose to sort by code or description/name. Right-click in the field and select Lookup Field. Choose how to sort the field.

  4. 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, right-click and select Customise Grid Columns to add columns.

    • The keyboard's down arrow or <TAB> through the row will create a new line.

    • Repeat Steps 3 and 4 until all transactions have been entered.

  5. Click Process or Ctrl + P to process transactions.

    • All processed transactions will be on the Transaction Report and can be edited through Extended or Express Timesheets.

    • Autopays will not generate for Employees with existing transactions.

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.

  1. Customise Grid Columns so the grid shows required fields.

  2. Select each Employee rostered to work and key in their rostered hours and scheduled additional payments.

  3. Click Save. Save the file with a relevant File Name and as type Text (*.txt) or Micropay Employees File (*.mef)

  4. Click Open and locate the file when it is time to create transactions for the period.

  5. 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.

You can't process transactions for terminated employees through Multi Employee Timesheet. If you need to enter a transaction for a terminated employee, use Express Timesheet, Extended Timesheet or Manual Calculation.

Did this answer your question?