External timesheet import

The Payroll module in MYOB Advanced can 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.
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.

Process overview

The process of setting up the Payroll module for timesheet imports and importing involves several steps:

1. Set up data maps that map records from timesheet data to records in MYOB Advanced.
2. Generate timesheet data. Either:
   
   • Export data from an external timesheeting system and format it as required, or
   • Enter time card information on the Employee Time Cards screen in MYOB Advanced (EP305000).
3. Import timesheet data into the Payroll module:
   • Create a timesheet batch in MYOB Advanced.
   • Import data into the batch (upload a timesheet CSV and/or import time cards).
   • Perform mapping on the imported data, based on the data maps you set up previously.
   • Validate the data mapping and make corrections as necessary.
4. Import timesheet data into an individual pay run:
   • Open a pay run for a pay period covered by the timesheet data.
   • Import timesheet data into the pay.
   • Validate and correct the data if necessary.
   • Process the pay as normal.

Each of these steps is detailed in the sections that follow.

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 Data Maps screen (MPPP7020).

Importing timesheet data

Importing records

Mapping records

Validating imported values

Pay run timesheet import

Validating pay run changes

The pay run life cycle

Undo timesheet import

Additional tips

Standard pay configuration

Leave item configuration

AUSTRALIA ONLY

NEW ZEALAND