Timesheets in Attaché used in Australia use the T6 format which is a timesheet import standard. The following figure shows an example of the Disk File Entries for a T6 input file for time sheets in Australia.
In the example above:
All of the employees work in the NSW location.
Each line represents a timesheet line.
The commas in the example represent the field separators for each field in the timesheet line.
The T6 file format must contain 23 fields.
If there is no entry between the commas, it means that the value for that field is blank in the timesheet line.
For each record where the Line Type is N, the software bases calculations on the normal rate from the employee Masterfile, from which it also obtains leave loading details when required.
For example, if the normal rate for an employee is $12.50 per hour, time-and-a-half based on the normal rate would pay the employee $18.75 per hour.
In the case where the Line Type is A, representing an allowance, the software looks up the allowance and uses its details to calculate the rate of pay.
The following table shows how to interpret the example above.
Employee Code | Pay Description | Line Type | Code | Hours | Cost Centre | Tax Periods | Remarks |
ANDG |
| N | NORMAL | 40 | PROD01 |
|
|
ANDG |
| N | OT1.5 | 4 | PROD02 |
| Time-and-a-half |
ANDG |
| N | OT2.0 | 2 | PROD02 |
| Double-time |
BARJ |
| N | NORMAL | 40 | PROD01 |
|
|
BARJ |
| N | OT2.0 | 2 | PROD02 |
| Double-time |
BURP | FOR LEAVE | N | NORMAL | 40 | PROD01 |
|
|
BURP | FOR LEAVE | N | AL | 40 | ADMIN02 | 2 | Annual leave |
BURP | FOR LEAVE | A | LOAD | 40 | ADMIN02 | 2 | Allowance (This is the only record whose Line Type is not "N") |
See also: