Skip to main content
All CollectionsGlobal Payroll
Bulk uploading Global Payroll inputs
Bulk uploading Global Payroll inputs
Supriya VS avatar
Written by Supriya VS
Updated over 10 months ago

What are the inputs that can be bulk uploaded for employees in a given payroll cycle?

4 pay components can be used to upload bulk data: Times offs, Expenses, Pay supplements, Deductions

Time Offs

There are 6 mandatory fields in the time-off report:

  • TimeOff ID: This ID is a Unique Timeoff Identifier. This will be used to identify a particular time off in case you want to make any updates. The ID must be an alphanumeric value. For example: TO01

  • Employee ID: This ID is a Unique identifier for an employee. The ID must be an alphanumeric value. For example: AB101

  • TimeOff Type: This column indicates the nature of leaves such as annual leave etc. Possible values that can be entered are : Annual; Unpaid

  • No of Days: Indicates the duration of the entire leave. Values entered can be in multiples of 0.5.

  • TimeOff Start Date: Indicates the start date when the leave was taken. Should be in the format of DD/MM/YYYY.

  • TimeOff End Date: Indicates the end date when the leave was taken. Should be in the format of DD/MM/YYYY.

Expenses

There are 6 mandatory fields in the expense report:

  • Expense ID: This ID is a unique expense identifier. This will be used to identify the expense in case you want to make any updates. For example: Ex01

  • Employee ID: This ID is a Unique identifier for an employee. For example: AB101

  • Expense Type: You can use this to map the expense to a particular category of expense. Possible input values to select from:

    1. Meals and Entertainment

    2. Office Expenses

    3. Professional services

    4. Rent, Utility and phones

    5. Travel Expenses

    6. Per Diem

    7. Others

  • Expense Date: The date on which the expense was made. Should be in the format of DD/MM/YYYY.

  • Pay Currency: This is the currency in which an employee shall be paid. Note: this should match with the currency in which the employee is paid his salary.

  • Amount: This is the column that indicates the amount of the expense that needs to be reimbursed to the employee.

Deductions

  • Deductions ID: This ID is a unique expense identifier. This will be used to identify the expense in case you want to make any updates. For example: DE01

  • Employee ID: This ID is a Unique identifier for an employee. For example: B0101

  • Employee Name: This is an optional column. You can add the name of the employee.

  • Currency: This is the currency in which an employee shall be paid. Note: this should match the currency in which the employee is paid his/her salary.

  • Deductions Type: You can use this to map the expense to a particular category of expense. Possible input values to select from:

    • Salary Advance

    • Health Insurance

    • Others

  • Amount: Is the column that indicates the amount of the expense that needs to be reimbursed to the employee.

  • Comments: This is an optional column. You can add comments according to your requirements.

Pay Supplements

  • Pay Supplement ID: This ID is a unique expense identifier. This will be used to identify the expense in case you want to make any updates. For example: DE01

  • Employee ID: This ID is a Unique identifier for an employee. For example: B0101

  • Employee Name: This is an optional column. You can add the name of the employee.

  • Currency: Is the currency in which an employee shall be paid. Note: this should match with the currency in which the employee is paid his salary.

  • Pay Supplement type: You can use this to map the expense to a particular category of expense. Possible input values to select from:

    • Commissions

    • Bonus

    • Allowance

    • Others

  • Amount: This is the column that indicates the amount of the expense that needs to be reimbursed to the employee.

  • Comments: This is an optional column. You can add comments according to your requirements.

Did this answer your question?