Importing Timesheets

MYOB Acumatica — Payroll can import timesheets generated from MYOB Acumatica — Workforce Management, employee time cards entered in MYOB Acumatica, 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 Acumatica time cards, for employees who are configured for time-based payroll allocations.

Note:

Wages are reported based on physical pay date. If you import timesheets with hourly values for each worked day, MYOB Acumatica — Payroll doesn’t allow the wages to be accrued in one month and then reported in another month. If you want this to be a feature, upvote it in the Ideas Portal.

Setting Up MYOB Acumatica — Payroll

Set up data mapping – An MYOB Partner or consultant needs to associate MYOB Acumatica 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.

Setting Up Employees

For casual employees that don't have timesheet hours every pay run, you can exclude them from new pay runs. This lets you easily only add employees with timesheet hours.
(NZ only)Define an employee's working day – This ensures that the employee is paid the right amount for FBAPS leave and that their leave balance reduces correctly.
(NZ only) If your company uses workforce management, set up how midnight shifts affect an employee's timeshift hours.

Importing Timesheets

CAUTION:

(Australia only) Always check that your annual leave and public holidays are mapped correctly. Annual leave timesheets that fall across public holidays must be manually overridden using the Days Taken dialogue.

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

Prepare a batch of timesheet records – Some of these steps differ depending on your timesheeting system.
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 fix them.