2020.1 Release Notes
Introduction
The 2020.1.0 release introduces Employee Self Service features, and contains a range of updates to the Payroll module, including public holiday processing, employee transfers, new reports and the ability to import timesheet information into the Payroll module. The Self Service and Payroll modules are fully integrated, so employees can make leave requests in the Self Service module, which are then approved and processed in the Payroll module. This release also includes updates to Bank Feeds and Fixed Asset features, and resolves issues identified in previous releases.
Significant new features are highlighted below, and video overviews are available for the new Payroll and Self Service features. For full information on all of the changes, see the 2020.1 Release Notes document:
New Features
Employee Self Service
The release introduces that Self Service module to MYOB Advanced. This module allows employees to view and manage their own details, and to submit leave requests, which are then managed and processed in the Payroll module.
With the exception of the Employee Calendar and Team Calendar screens, all Self Service screens are available in the MYOB Advanced mobile app.
Setting up Employee Self Service
The Employee Self Service module is a separately licensable feature. If you have ESS included in your licence, the ESS features can be enabled by ticking the “Employee Self Service” feature on the Enable/Disable Features screen (CS10000). Once enabled, the Employee Self Service module becomes available, but before it can be used, the system must be set up to use the various Self Service functions.
Self Service Preferences
The Self Service Preferences screen (MPES1010) lets you configure settings that affect the operation of the Employee Self Service module as a whole, including the Numbering Sequence, Approval Map and Notification Template to use for leave requests; and options that determine how records will appear on the Employee and Team Calendars.
Setting up Leave Types
To make leave types visible in the Employee Self Service module, tick the Allow Leave Request option on the Additional Info tab of the Pay Items screen (MPPP2210) for each accrual pay item that should be available to employees when making a leave request (see page 8). If you want to require employees to attach a document when they request leave, tick the Require Attachment Upon Leave Request option.
To make leave balances visible on the Leave Balances or Projected Leave Balance screens (see page 7), tick the Show Leave Balances and/or Show Projected Leave Balances options on the Rules tab of the Entitlements screen (MPPP3300) for each leave entitlement that you want to display.
Setting up Employees
To give an employee access to the features of the Employee Self Service module, a user record, including login and password details, must be created for the employee on the Users screen (SM201010). The user record must have the “People ESS” role selected on the Roles tab and the “People User” licence type on the Licence Types tab. The employee can be linked to the user record via the Linked Entity field on the Users form.
You must also set the default Pay Group for each employee—this is the pay group that will be associate with any leave requests they make. On the Employee Pay Groups screen (MPPP2250), make sure that the Default Pay Group box is ticked for the group that should be the employee’s default.
Employee Details
Employees who have been given access to the Self Service Portal will be able to log in and access a variety of self-service screens:
- On the Contact Details screen (MPES3011), employees can view and edit their own personal and contact details.
- The Employment Details screen (MPES3011) allows employees to view details of their employment in the company, their tax details and their year-to-date balances. These details are all read-only.
- The Pay Distribution screen (MPES3012) shows employees read-only information about how their pay is paid to them.
- The Superannuation screen (MPES3013) shows employees read-only information about the superannuation contributions included in their pays.
- The Payslips screen (MPES3014) lists all of the employee’s available payslips. The employee can click on the link in the Pay Date column to download the payslip for that date.
Employee and Team Calendars
The Self Service module includes two calendar screens:
- The Employee Calendar (MPES4001), which lets an employee view a schedule of their own leave requests and enter new requests.
- The Team Calendar (MPES4003), which lets a manager view the leave schedules for the employees that they manage.
Employee Calendar
The Employee Calendar screen shows a calendar month, with any leave requests made by the employee highlighted. Hovering the mouse over a leave request shows additional details in a popup.
Employees can double-click on a day to request leave on that day, or click and drag across a range of days to request leave for the range.
Team Calendar
The Team Calendar screen contains a calendar that shows the leave requests relating to the employees that are managed by the logged in user. Employees are selected for display on the calendar in one of two ways:
- The calendar displays all employees who are below the logged in user on the Company Tree screen (EP204061).
- The calendar displays all employees who have the logged in user selected for their Reports to field on the Employees screen (EP203000).
The Team Scheduler Employees Source option on the Self Service Preferences screen (MPES1010) determines which of these methods will be used.
As with the Employee Calendar screen, employees’ leave requests are highlighted on the calendar, with additional details available when the mouse is hovered over a leave request. The Team Calendar includes extra controls for viewing a week, fortnight or month, and for selecting a specific date to display (or just “Today”).
Requesting Leave
The introduction of the Self Service module adds new workflows for requesting leave and then processing it in one or more pay runs. Leave requests made in the Self Service module flow through to the Payroll module for processing; leave requests’ statuses are then reported back to the Self Service module so employees can track the progress of their requests.
Employee Leave Balances
Employees can view their current leave balances on the Leave Balances screen in the Self Service module (MPES3022):
Clicking one of the Leave Request links next to a leave type makes a new leave request for that type (see “Making Leave Requests” on page 8).
The Projected Leave Balance screen (MPES4012) lets employees enter a future date to check how much leave they will have by then, so that they can plan their leave requests more easily.
Making Leave Requests
Employees can make a new leave request from the Self Service module using the Submit a Leave Request screen (MPES3020). Managers can also use this screen to make leave requests for the employees they manage. The screen can be accessed in several ways:
- On the Employee Calendar screen, by double-clicking on a day, or clicking and dragging across a range of days.
- On the Leave Balances screen, by clicking one of the Leave Request links in the main table.
- On the Projected Leave Balance screen, by clicking the New Leave Request toolbar button.
- On the Leave Requests screen, by clicking the + toolbar button.
Using this screen, a user (employee or manager) can enter all of the details for the leave request, including the leave type, and leave start and end dates. The user can also attach documents to the request (this may be required, depending on the leave type’s configuration.
Approving and Paying Leave
Reviewing Leave Requests
Employees can use the Leave Requests screen in the Self Service module (MPES3021) to see the status of any leave requests they’ve made. Managers can also use this screen to view the leave requests for any of the employees they manage.
Managers can use this screen to view the requests for any employees they manage.
Leave Request Statuses
A leave requests can be in one of the following statuses:
- Open – The request has not yet been submitted for approval.
- Submitted – The request has been submitted for approval. It can still be edited or deleted at this stage.
- Approved but not paid – The request has been approved, but has not yet been processed as part of pay run. It can no longer be edited.
- Declined – The request has been declined and will not be processed further.
- Ready To Pay – The request has been marked as ready for inclusion in a pay run (or pay runs, if the amount of leave spans more than one pay period).
- Processing – The request has been added to a pay run, which is currently being processed.
- Cancelled – The request has been cancelled and will not be processed further.
- Partially Paid – If the requested leave spans more than one pay run, this status indicates that one or more of those pay runs has been processed, but there is still some of the request that has not yet been paid.
- Paid – All days of the request have been paid, across one or more pay runs.
Approving Leave Requests
Leave requests that have been submitted for approval appear on the Leave Administration screen in the Payroll module (MPPP5040).
A payroll administrator can select leave requests on this screen and use the toolbar buttons to approve requests, decline requests or set them as ready to include in a pay.
The approvals process uses the built-in approval features of MYOB Advanced—leave requests can also be approved on the existing Approvals screen (EP503010).
Leave requests in the “Ready to Pay” status will be added to pay runs based on the dates that leave was taken on. The Set Pay Period Date button allows you to specify a new date for the selected leave request(s). For instance, if a pay run that covers the date of the request has already been run, you can include the leave request in a future pay run by setting a new Pay Period Date.
Paying Leave
To add approved leave to a pay run, click the new Import Leave action on the Pay Run Details screen (MPPP3120). Clicking this action imports any leave requests for employees in the pay run that fall within the pay period’s start and end dates (partially or in full) and have the “Ready to Pay” status.
If a leave request spans multiple pay periods, only the portion of the request that falls within the pay’s start and end dates will be imported. After the pay is completed, the request’s status will be “Partially Paid”.
Once leave requests are added to a pay, leave pay items for the request appear on the Employee’s Current Pay screen (MPPP3130) for the affected employees.
Once leave has been imported into a pay, it can be viewed and managed in the same way that leave has been managed in previous releases: details of the leave appear in the Days Taken window (opened from the Employee’s Current Pay screen), and in the Leave Summary (click Leave Summary on the Pay Run Details screen).
As leave is imported into a pay and processed, the status of the original leave request will be updated. The employee who made the request can check on its status using the Leave Requests screen in the Self Service module (see “Reviewing Leave Requests” on page 10).
Undoing Leave Imports
If you need to undo a leave import, you can click the Undo Timesheet Import action on the Pay Run Details screen to remove all data that was added to the pay run by the import process. You can also undo individual employees’ timesheet imports by selecting them and clicking the Reset button to reset their pay to the Standard Pay.
Timesheet Imports
The Payroll module can now import timesheets generated from external applications or from Employee Time Cards entered in MYOB Advanced. When timesheet data is imported into a pay run, pay items based on the timesheet data are created or updated automatically. The process of setting up the Payroll module for timesheet imports and importing involves several steps:
- Set up data maps that map records from timesheet data to records in MYOB Advanced.
- Generate timesheet data from an external timesheeting system or enter time card information on the Employee Time Cards screen (EP305000).
- Import timesheet data into the Payroll module.
- Import timesheet data into an individual pay run.
Data Mapping
Data maps are used to map the imported timesheet data to records in the MYOB Advanced Payroll module. Set up data maps on the new Data Maps screen (MPPP7020).
On this screen, you can select the kind of records to map from the Entity Type dropdown. Selecting an Entity Type populates the main grid with all records of that type.
Three types of record can be mapped:
- Employee – Main grid displays all active payroll employees
- Pay item – Main grid displays all active pay items that have a calculation method of “Rated” or “Amount”
- Subaccount – Main grid displays all active subaccounts
Each Employee, Pay Item, or Subaccount record can only have a single external identifier mapped against it.
To begin with, the grid contains details of the records in the Internal ID and Internal Description columns—to complete the mapping, you must supply the External ID and External Description that each records maps to. There are two ways of doing this:
- Enter mapping details directly into the External ID and External Description columns for each record.
- Click the Export button to export the grid to an Excel file. Open the file in Excel, complete all mappings, then use the Upload button to upload the completed Excel file back into the grid.
You don’t need to map all records to be able to save the mapping—any unmapped records will be ignored when mapping imported timesheet data.
Importing Timesheet Records
Once data maps have been set up, use the Import Timesheets screen (MPPP7030) to import external records and apply the mappings you’ve set up.
Timesheet import files should be Excel files with the same column layout as the main table of the Import Timesheets screen. The easiest way to create an import file template is to click the Export button ( ) on the main table toolbar to export a blank table to Excel—this will create a file with the required column headings in the correct order. You can delete the columns after Amount, as these columns relate to data from the MYOB Advanced system that will be filled in by the data mapping.
Select the Data Source Type that matches the source chosen to be the same as the source of the appropriate data mapping configuration.
Next, create a new batch using the + button and upload timesheet details by clicking the Upload Timesheet option in the Actions dropdown.
Immediately after importing data, warning messages appear saying that data is missing (see screenshot above). These warnings will disappear once the data is mapped.
If the Data Source Type supports MYOB Advanced Time Cards, an Import Time Cards option is also available in the Actions dropdown. Select this option to import timesheet data from MYOB Advanced time cards.
The Upload Timesheet action is still available in this case—it is possible to import data from time cards and from a CSV file into the same batch.
Time cards are generated against a specific week, which is displayed for the time card on the Employee Time Card screen (EP305000). When importing time cards, you will need to specify the range of weeks to import time cards from.
Data from all approved and released time cards within the range of weeks you selected is imported.
The records on the Import Timesheets screen can be edited manually if necessary, e.g. to correct mapping errors or to enter details for records that aren’t included in the data map. Any manual edits you make can be applied to the data map for the selected Data Source Type.
Mapping Timesheet Records
Once timesheet data has been imported, click Map Imported Items from the Actions dropdown to apply the mapping set up for the selected Data Source Type to the imported data. The remaining fields are filled in automatically based on the data mapping.
Mapping pay items and employees is mandatory. Subaccount mapping is optional, however: if no subaccount is mapped, the default subaccount on the relevant GL Purpose code will be used.
Importing Timesheet Data into a Pay Run
Once timesheet data has been imported and validated, you can go on to import unprocessed timesheet batches into an open pay run from the Pay Run Details screen (MPPP3120). Click Import Timesheet in the Actions dropdown to import timesheet data related to the pay run.
The import process scans all timesheet batches for records that match the following criteria:
- Not associated with any other pay run.
- The Pay Effective Date on the timesheet record falls within the Pay Period of the pay run (including the start and end dates).
- The employee associated with the timesheet record exists in the pay run.
The Pay Item attached to imported timesheet data does not need to exist on the Standard Pay of the Employee. Where applicable, the timesheet import process dynamically adds these pay items to employees’ pays.
Validating Pay Run Changes
Click the Time Summary button on the Pay Run Details screen to display the Pay Run Time Summary window (MPPP7050), which shows all timesheet records that were imported into the pay run, including the source timesheet batches.
The Non Imported Details tab displays any records that were present in the imported batches, but were not imported into the pay run. This allows you to find and correct any problems that may have caused the records to be left out of the import.
Any difference in the Imported and Actual Quantity of the pay item will be highlighted in red.
Undoing Timesheet Imports
If you need to undo a timesheet import, you can click the Undo Timesheet Import action on the Pay Run Details screen to remove all data that was added to the pay run by the import process. You can also undo individual employees’ timesheet imports by selecting them and clicking the Reset button to reset their pay to the Standard Pay.
Once a pay run has moved into the “PROCESSING” or “COMPLETE” statuses, you can no longer alter the imported timesheet data; however if you can cancel or reverse the pay run, any timesheet imports in the pay run will be undone and you can create a new pay run to correct them.
Processing Public Holidays
This release adds the ability to add Public Holidays to employees’ pays in bulk. The new Public Holiday Processing screen (MPPP3110) lets you create a batch of Public Holiday transactions that can be added to employees’ pays. This screen lets you select the employees to pay, and creates a batch of Public Holiday transactions for those employees. The transactions in a Public Holiday batch are then added to pay runs from the Pay Details screen (MPPP3120).
The following records must be set up before you can use this form:
- One or more calendars giving the dates for Public Holidays must be set up on the Work Calendars screen (CS209000).
- One or more Public Holiday entitlements must be set up on the Entitlements screen (MPPP3300). Entitlements for Public Holidays should have the Leave and Non Accruing Entitlement options ticked.
- Pay items must be set up for each entitlement on the Pay Items screen (MPPP2210).
- Default Public Holiday pay items must be specified for each Pay Group using the new Default Public Holiday Pay Item column on the Pay Groups screen (MPPP2710).
- A numbering sequence must be selected for the Public Holiday Batch Numbering Sequence field on the Payroll Preferences screen (MPPP1100).
Generating Public Holiday Transactions
On the Public Holiday Processing screen, create a new transaction batch, then set the filters at the top of the screen. You must select start and end dates—any Public Holidays that appear on Work Calendars between these dates will be selected for adding to employees’ pays. Filters for company, pay group and calendar are also available—these filters are optional and can be used to restrict the employees for whom Public Holiday transactions will be created.
Click Generate Pay Items to create Public Holiday transactions for all holidays and employees that match the selected filters. The details of these transactions are displayed on the screen’s main table.
Any Public Holiday transactions that already exist in another Public Holiday batch will not be added to the new batch.
Once all of the transactions you want have been generated, save the batch and move it off Hold—the batch is now ready to be imported into one or more pay runs.
Importing Public Holiday Transactions into a Pay Run
Once a Public Holiday transaction batch has been created, you can import these transactions into an open pay run from the Pay Run Details screen (MPPP3120). Click Import Public Holidays in the Actions dropdown to import timesheet data related to the pay run.
The import process scans all Public Holiday transaction batches for transactions that fall within the Pay Period of this pay run. Pay items are added to the pays of all affected employees and populate the Days Taken window with details of the Public Holiday(s).
Public Holiday Batch Statuses
The Status field on the Public Holiday Processing screen shows the batch's current status, which can be one of:
- Hold –The batch can be edited but cannot be imported into a pay run.
- Open – The batch can no longer be edited and is ready for import into pay runs.
- Partially Processed – Some, but not all, of the transactions in the batch have been successfully imported into one or more pay runs.
- Closed – All of the transactions in the batch have been successfully imported into pay runs.
Transferring Employees
A new Employee Transfer screen (MPPP3115) is available to simplify the process of transferring an employee from one branch in the MYOB Advanced system to another. When an employee transfers between branches, their leave liabilities need to be reallocated. In previous releases, this had to be done manually by zeroing out the employee’s leave balance and creating GL journals to correctly allocate liabilities; with the new screen, these steps happen automatically.
To transfer an employee, select the employee on the new screen, then click Populate Entitlement Balances. This loads the details of all of the employees’ entitlements into the Document Details tab.
Only entitlements that have the Include Accrual in GL option enabled will be loaded into the table—if an entitlement does not accrue in the GL, there is no need to transfer it.
Select the employee’s new branch and GL posting class, then click the Release button to generate GL journals to reallocate their leave liabilities and update the employee’s details as follows:
- the employee’s branch is updated, as shown on the Employees screen (EP203000).
- the employee’s Payroll Posting Class is updated, as shown on the Pay Details screen (MPPP2310).
The Financial Details tab displays the details of the GL journals that were created for the transfer. Journals differ depending on whether the “Inter-Branch Transactions” feature is in use: If the feature is in use, a single batch of GL journals will be created; otherwise, the system will create one batch for transferring the employee out of the old branch and another for transferring them into the new branch.
Reversing a Transfer
Once a transfer is complete, it is moved to the “Closed” status. Closed transfers can be reversed by clicking the Reverse toolbar button. This returns the employee’s details to their original branch and posting class and generates a new GL batch to reverse the GL journals created by the transfer.
Employee Transfer Settings
A new Employee Transfer Settings tab has been added to the Payroll Preferences screen (MPPP1100). This tab contains the following settings:
- Account – the GL account that should be used by default for the batches created by employee transfers.
- Clearing Subaccount – the GL subaccount that should be used by default for the batches created by employee transfers.
A Numbering Sequence for employee transfers can also be selected on the Numbering Sequence tab of the Payroll Preferences screen.
Distributing Employer Super Costs
This release adds the ability to distribute superannuation costs according to the subaccount allocations of superannuation-liable pay items. This means that superannuation costs can be shared proportionally across the relevant Cost Centres.
This feature supports Super Guarantee employer contributions in Australia and KiwiSaver employer contributions in New Zealand.
Example
An employee, earning $60 an hour, works 40 normal hours a week to earn $2400. Their time is allocated as follows:
- 24 hours are spent at Cost Centre A ($1,440 – 60% of their pay)
- 16 hours are spent at Cost Centre B ($960 – 40% of their pay)
At a contribution rate of 9.5%, the total employer superannuation contributions for this employee will be $228, which should be distributed as follows:
- Cost Centre A: $136.80 (60%)
- Cost Centre B: $91.20 (40%)
Distributing Costs
To distribute superannuation costs, select the new Distribute Employer Super Costs option from the Action dropdown on the Pay Run Details screen (MPPP3120). This automatically distributes the super costs for all employees in the pay run and updates their Current Pay Accordingly.
The distribution takes into account all superannuation-liable pay items in each employee’s Current Pay.
After costs have been distributed, you can check employees’ pays on the Employee’s Current Pay screen (MPPP3130)—the “Employer Super Pay” pay item will display “Allocated” in the GL Account column. You can click the “Allocated” link to open the Allocate General Ledger Accounts window, where the pay item allocations can be viewed (and edited if necessary).
Improved Reporting and Data Analysis
This release adds a suite of generic inquiries and data views to the Payroll module, making it easier to view and extract information about your payroll system.
The following new generic inquiries are available for viewing and editing on the Generic Inquiry screen (SM208000):
- MP-PayActivitySummary
- MP-PayActivityDetail
- MP-Employee
- MP-EntitlementHistoryGI
New reports, data views and pivot tables that use these generic inquiries have been added. The reports are suited to producing report documents, while the data views are the best way of exporting data to external applications like Excel, and the pivot tables provide a useful way of grouping data.
Pay Activity Summary
The Pay Activity Summary data features use the MP-PayActivitySummary generic inquiry to show pay totals for one or more pay runs in a specified date range, optionally grouped by branch, department posting class and employee. Three Pay Activity Summary interfaces are available:
- A report, Pay Activity Summary (MPPP6024)
- A data view, Pay Activity Summary Data (MPPP6025)
- A pivot table, Pay Activity Summary Pivot (MPPP6026)
Pay Activity Detail
The Pay Activity Summary data features use the MP-PayActivityDetail generic inquiry to show detailed pay information for each employee in one or more pays. Three Pay Activity Detail interfaces are available:
- A report, Pay Activity Detail (MPPP6023)
- A data view, Pay Activity Detail Data (MPPP6027)
- A pivot table, Pay Activity Detail Pivot (MPPP6028)
Entitlement Movements
The Entitlement Movements data features use the MP-EntitlementHistoryGI generic inquiry to show details of all entitlement accruals and payments for one or more employees over a selected date range, including opening and closing balances, the accrual/taken amount and the movement value. Three Entitlement Movement interfaces are available:
- A report, Entitlement Movements (MPPP6032)
- A data view, Entitlement History Data (MPPP6033)
- A pivot table, Entitlement History Pivot (MPPP6034)
Employee Detail
Australia only
The Employee Detail report (MPPP2311) uses the MP-Employee generic inquiry to provide a one-page summary of contact, taxation and payment information for one or all payroll employees.
The data used by this report is also available on the Employee Detail Data screen (MPPP2312).
Resolved Issues
The following table details the issues that are addressed by this release.