Skip to main content

New Zealand - Update the ED or EI csv files for the IRD

Updated over 2 weeks ago

The ED (Employee Details) or EI (Employee Information) csv file has errored when trying to upload it to the IRD because:

  • An employee's IRD number is incorrect

  • The employee's finish date is invalid (will appear as 18991230 in csv)

It is recommended that you correct the source, e.g., the employee record in MicrOpay.

To recreate the EI (Employee Information) file:

  1. Restore the database to before you created your bank file (Payroll, Transactions, Import and Export, Generate Payments).

  2. Delete the employee's transactions (Payroll, Transactions, Processing).

  3. Update the employee record (Payroll, Maintenance, General, Employees).

  4. Re-enter the transaction (Payroll, Transaction, Processing).

  5. Repeat the payroll process, including:

    • Re-run reports and ensure that the values are correct

    • Generate Payments - don't upload the bank file if you have already done so; you will, however, need to generate the file in MicrOpay.

    • Payday Filing, etc.

If you are unable to restore your database to before Generate Payment, raise a case online for further assistance.

To recreate the ED (Employee Details) file, you can either:

  • Restore the database to before you completed Payday Filing (Payroll, Transactions, Import and Export), correct the error and recreate the ED file.

  • Remove the Date Last Reported on ED on the Taxation Details of the Employee record and correct the error. You will then be able to recreate the ED file when you open Payday Filing (Payroll, Transactions, Import and Export).

Where there is an invalid Termination Date in the csv file:

The Termination Date on the ED csv can appear as 18991230 when a Termination Transaction is entered and then deleted. You can refresh the employee record by:

  1. Update the employee record (Payroll, Maintenance, General, Employees) by ticking and entering a Termination Date and Termination Reason on the Termination Details.

  2. Click OK to save.

  3. Update the employee record and untick Termination Date. This will clear the date and reason.

  4. Click OK to save.

Did this answer your question?