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 9 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?