Importing timesheets

MYOB Advanced Payroll can import timesheets generated from Advanced Workforce Management, employee time cards entered in MYOB Advanced, and external timesheet systems not provided by MYOB. When you import timesheet data into a pay run, pay items based on the timesheet data are created or updated automatically.

Where payroll expenses are allocated to projects of GL accounts, allocation information can be imported from timesheets or MYOB Advanced time cards, for employees who are configured for time-based payroll allocations.

Setting up for timesheet imports

Data mapping

As a one-time setup task, an MYOB Partner or consultant needs to set up data maps that associate MYOB Advanced records with imported timesheet records.

When your company adds a new employee or pay item, you need to update the data map to include the employee or pay item.

(Optional) Excluding employees from new pay runs

If your company has a lot of casual employees, they might not have timesheet hours every pay run. To save yourself the hassle of manually removing each employee without timesheet hours from every new pay run, you can set those casual employees to be excluded from new pay runs.

This lets you easily only add employees with timesheet hours.

Importing timesheets

Preparing timesheet batches

Before you can import timesheets into a pay run, there's a few steps you need to complete to prepare a batch of timesheet records.

Importing a timesheet batch into a pay run

Once your timesheet batch is ready, importing it into a pay run is simple, one-click process.

Editing timesheets and data maps

If you need to make changes to a timesheet batch after importing it into a pay run, start by removing the timesheets from the pay run.

If you're getting warnings about missing data maps, see the MYOB Advanced support knowledge base.