Importing multiple times import files into EXO Payroll (New Zealand)

Payroll information such as wages, leave to be paid and allowances can be imported into MYOB Exo Payroll New Zealand version through the Import Time Transactions item of the Pay menu. The format required for the file for importing this information can be found in the Help file under Time Transaction Import Format, with the standard file types being TXT, CSV or DBF.

Previously MYOB Exo Payroll would import a single time file into an open pay. With the 2013.01 release this process has been changed so that it is now possible to specify the directory to import the information from as well as being able to import multiple time files.

The details below can assist with setting up the options and the processing of Times files.

To enable the option to import a times file

Click on Utilities -> Setup Exo Payroll -> Setup Page 2 -> Special Options Setup button
Go to the Import tab then tick the Import Time Transactions option
Select the format to use for the import file and locate the directory that the Times file is to be imported from
Save from all of the screens using the Save:F10 button or by pressing F10

Importing the times file

The Import screen will show the Times files which can be imported into MYOB Exo Payroll under the Available column. These available files reflect those import files that have been put into the import folder specified in the Payroll Setup (see above).

Ticking the "Show previously imported files" option will mean that any previously imported files will also be shown in case they are to be imported again.

To import times file

Highlight the file or files in the Available column then move those files to the Selected column on the right using the arrows in the centre of the screen.
Click Next to proceed.
Click on the Import button to import the selected files.
The Backup screen will now appear. Click on the Backup button for the backup to be created. Note: If a backup is not done then the Import will not occur.
After the Backup has been done, a screen will appear for printing the Time Transaction Import Audit Report. Print or preview the report to see if there were any problems with the importing of the data.
Once the report has been printed the Import process will complete. Click on the OK button to finish the Import.
After the Times files have been imported, the software will rename the file from directoryname_timetran_id.ext to directoryname_imported_timtran_id.ext.

New import file name format

There is a new Import File Name Format which can be used when creating the Times files, allowing the import of multiple timetran files at the same time. The new name format is directoryname_timetran_id.ext where:

Directoryname is the company folder in the install location of MYOB Exo Payroll and can be found from the Support Report (see below)
id is the number of the TimeTran file that is to be imported
ext is the file extension that MYOB Exo Payroll has been told to expect in the Payroll Setup screen, e.g. dbf, csv or txt

To locate the directory that the company information is stored in, check the Payrolls.dbf section of the Support Report - this is often found on the second page of the report. The Payrolls.dbf section will show all of the companies that are currently installed in the payroll as well as the directory that they are located in.

To open the Support Report, click on the Support button if at the Login screen or, when in the Payroll company, select the Help menu then About then click on the Support button at the bottom of the window. In the Support screen, click on the Preview button at the bottom of the window to view the Support Report.

Need more help? You can open the online help by pressing F1 on your keyboard while in your software.

You can also find more help resources on the MYOB Exo Employer Services Education Centre for Australia or New Zealand.