Creating an External Timesheet System Batch

To import timesheets into MYOB Acumatica from an external system, you need a Microsoft Excel file with the timesheet data. The file must have the same column layout as the main table of the Import Timesheets form (MP.PP.70.30) in MYOB Acumatica, as shown in the table below.
Record Description
Ext. employee ID the employee’s ID in the external system
Ext. employee name the employee’s name in the external system
Ext. pay item ID the ID of the pay item in the external system
Ext. sub account the subaccount ID in the external system
Ext. Project the ID of the project in the external system
Ext. Project Task the ID of the project in the external system
Ext. Inventory Item the ID of the project in the external system
Timesheet date the date of the timesheet entry
Quantity the quantity (hours/days) for Rated pay items
Amount the amount for Amount pay items

The import headers are case-sensitive. The easiest way to create an import file template is to click the Export button on the main table toolbar to export a blank table to Microsoft Excel – this will create a file with the required column headings in the correct order. You can delete the columns after Amount, as these columns relate to data from the MYOB Acumatica system that will be filled in by the data mapping.

Uploading a Timesheet File

  1. Go to the Import Timesheets form.

  2. Select the correct Data source type.

  3. On the toolbar, click the three dots icon (. . .) and choose Upload Timesheet.

  4. In the Timesheet File Upload window, click Choose File and select the file you want to upload.

  5. Click Upload.