TransPost Help

Timesheets

The Timesheet import records timesheets in MYOB. Timesheets can only be imported using Transpost Plus or TransPost Premier.

These fields correspond to the fields on the AccountRight "Enter Timesheet" form.

Timesheets must identify an employee, and the PayRoll Category, date and total hours for each activity.

A group of records for the same employee and dates within the same pay week will be treated as that employee's timesheet for the week.

For chargeable activities, a customer must be identified. If a job is specified without a customer then TransPost will default to the customer associated with the job.

• Employee Identification
• Timesheet Entry Details
• Time billing details
• Customer Identification

Action

Action code - The only valid code for timesheets is A to add detail lines to an existing timesheet.

This is because the MYOB API treats timesheet posts as replacements of whatever exists so far of the employee's timesheet for that week so, for historical reasons, i.e. consistency with version 3.3, the default is that if two separate groups of activities for the same employee week are imported the second overrides the first.

If the action code is A, to add, then TransPost retrieves whatever is there already and adds the new input. Thus if the Action code is A, possibly set as a default, new records, or later groups of records in the same input file, will not override old ones.

Employee identification

The Employee card must be identified somehow so at least one of these fields is required:

EmpCardID

MYOB Card ID of the employee to whom the timesheet applies. If supplied this will be used and other provider identification fields will be ignored.

EmpCoLastName

Name of the employee to whom the timesheet applies.

EmpFirstName

If the employee is an individual then the firstname is also required to identify them.

Timesheet Details

Each line represents a particular activity on a specific day. A group of such lines for the same employee for dates within the same working week represent a timesheet.

EntryDate

Date of the activity. Mandatory. If the data contains start and stop time fields in a date-time format one of them may be used for this.

PayrollCategory

A valid payroll category, applicable to the employee, is mandatory for timesheets.

Notes

Notes on the activity.

Units

This is the units to be recorded, i.e. quantity of activity being recorded.

Note that if the supplied data does not contain this but does contain start and stop times they can be mapped instead and TransPost will calculate the difference.

The remaining fields are optional.

StartTime

The time at which work started on this activity. This may be in a date-time format. For example "23:30" and "Thurs, 25/05/2023 11:00 PM" are both valid values.

StopTime

The time at which work stopped on this activity. This too may be in a time or date-time format. If time format only is used then an apparently earlier time will be deemed to be the next day.