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

• Set up data mapping – An MYOB Partner or consultant needs to associate MYOB Advanced records with imported timesheet records.
• Update data maps – When your company adds a new employee or pay item, you need to add them to your data maps.
• For casual employees that don't have timesheet hours every pay run, you can set them to be excluded from new pay runs. This lets you easily only add employees with timesheet hours.

Importing timesheets

When it's time to do a pay run, importing timesheets is a two-step process:

1. Prepare a batch of timesheet records – Some of these steps differ depending on your timesheeting system.
2. Import a timesheet batch into a pay run.

Editing timesheets and data maps

• Remove timesheets from a pay run – For when you need to make changes to a timesheet batch that's been imported into a pay run.
• Missing data map warnings – Learn why you might be seeing the warnings and how to get fix them.