Skip to main content

Payroll Reports: Export employee details to excel

Generate Excel file only for certain column

Updated over 2 months ago

To generate Excel file:

  1. Go to Miscellaneous, Export CSV/TXT format.

  2. Click Next.

  3. You can use the code below for the Variable / Field Name:

    • Employee Code: EMPNO

    • Name: NAME

    • Identification Number: NRICN

    • Job Title: JTITLE

    • Date Commence: DTOC (DCOMM)

    • Date Confirmed: DTOC (DCONFIRM)

    • Basis Rate: STR (PTR.BRATE,12,2)

    • All the Allowance Fix and Variable = STR (PTR.AW101) "Continue other allowances by changing the AW102, AW103"

  4. The end of the records must be CSVEND.

  5. Click Save.

  6. Click Export.

  7. Key in the date.

  8. Click Ok.

  9. Select the directory.

  10. Click Exit.

Did this answer your question?