CSV format for multi-timesheet imports
Description
Cause
Resolution

The CSV file uses a fixed column order. Each row defines one payment or deduction.

  1. Enter 2 in column A for payments.
  2. Enter D in column A for deductions.
  3. Enter the employee number in column B.
  4. Enter the payment or deduction number in column C.
  5. Enter the department code in column D.
  6. Enter the cost centre code in column E.
  7. Enter hours or value in column F.
  8. Enter the hourly rate in column G when required.
Steps to duplicate
Related Solutions