Wages Export File Format

Field Name

Description

Field Length

Field Type

Export Batch ID

Auto-generated ID that uniquely identifies the export batch in which the file was generated.

Integer

Export Date

Date on which the export batch was processed.

Date/Time

Posting Date

Date that identifies the financial reporting period to which the export corresponds, as specified when the export batch was created.

Date/Time

Export Status

Is one of the following depending on the status of the export batch in which the export file was generated:

1. – generated

2. – regenerated

3. – deleted.

1

Integer

Pay Batch Number

Pay batch ID that uniquely identifies the pay batch to which the transaction line corresponds.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

Integer

Pay Period Start Date

Date on which the pay period, to which the transaction line corresponds, begins.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

Date/Time

Pay Period End Date

Date on which the pay period, to which the transaction line corresponds, ends.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

Date/Time

Transaction Date

Transaction date to which the transaction line corresponds.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

Date/Time

Pay Company

Name of the pay company to which the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

100

Variable Character

Pay Company Export Code

Export code that uniquely maps the pay company, to which the transaction line is linked, to the corresponding record in the finance system, as specified on the header of the Pay Company record.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

50

Variable Character

Payee First Name

First/given name of the payee to whom the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

50

Variable Character

Payee Surname

Surname/family name of the payee to whom the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

50

Variable Character

Candidate No

Candidate ID that uniquely identifies the candidate to whom the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

9

Integer

Payee No

Payee ID that uniquely identifies the payee to whom the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

9

Integer

Job Order No

Job order ID that uniquely identifies the job order to which the transaction line is linked.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set blank where the corresponding line item is not derived from a job order (i.e. is a manual item or a leave item from a leave request), is a BS transaction or if this line represents the rounding line.

9

Integer

Item Type

Identifies the type of transaction the transaction line represents. This is set to one of the following:

• Ordinary

• Overtime

• Allowance

• Reimbursement

• Leave Accrued (PL)

• Leave Accrued (BS)

• Leave (PL)

• Terminations

• Deductions

• Tax BS

• GST PL

• GST BS

• Employee Benefits PL

• Employee Benefits BS

• Superannuation PL

• Superannuation BS

• Payroll Tax PL

• Payroll Tax BS

• WorkCover PL

• WorkCover BS

• KiwiSaver PL

• KiwiSaver BS

• ACC Employer Levy PL

• ACC Employer Levy BS

• Bill Oncost PL

• Bill Oncost BS

• Pay Oncost PL P

• ay Oncost BS

• Net

• Rounding

20

Variable Character

Item Date

Date of the pay item that corresponds to the the transaction line.

This field is only written to the export file if it is applicable to the wage transaction grouping that is configured in Finance Integration maintenance.

This field is set to blank for the line in the export file that represents the rounding line.

Date/Time

GL Account Segment 1

Account segment value that is configured in Finance Integration Maintenance for account segment 1 or, if this line represents the rounding line, the corresponding rounding line export code.

50

Variable Character

GL Account Segment 2

Account segment value that is configured in Finance Integration Maintenance for account segment 2 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 2 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 3

Account segment value that is configured in Finance Integration Maintenance for account segment 3 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 3 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 4

Account segment value that is configured in Finance Integration Maintenance for account segment 4 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 4 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 5

Account segment value that is configured in Finance Integration Maintenance for account segment 5 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 5 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 6

Account segment value that is configured in Finance Integration Maintenance for account segment 6 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 6 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 7

Account segment value that is configured in Finance Integration Maintenance for account segment 7 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 7 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 8

Account segment value that is configured in Finance Integration Maintenance for account segment 8 or, if this line represents the rounding line, the corresponding rounding line export code.

This field is set to blank if Segment 8 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

Account Number

Profit/loss or balance sheet account number to which the transaction line is to be exported.

For information about where the relevant account number will be derived from depending on the item type to which the transaction line corresponds, see Appendix B: Account Number Mapping for Wages Export.

If the line represents the rounding line, this field will be populated with the account number specified in the Rounding Account field in Finance Integration General Maintenance.

50

Variable Character

Credit/Debit

Identifies if the listed transaction line represents a credit or debit.

This field is set to Debit if any of the following conditions apply to the transaction line:

• the transaction is a PL transaction & the transaction amount is a positive value

• the transaction is a BS transaction & the transaction amount is a negative value.

This field is set to Credit if any of the following conditions apply to the transaction line:

• the transaction is a BS transaction & the transaction amount is a positive value

• the transaction is a PL transaction & the transaction amount is a negative value

• the line represents the rounding line.

6

Variable Character

Amount

Identifies the monetary amount that will be posted to the corresponding account for the transaction line.

Numeric

GST Amount

The GST amount that is applicable to the transaction line. Alternatively, where this line represents the rounding line, this is the rounding remainder on the GST amount in the corresponding pay batch.

Numeric