Skip to main content
All CollectionsAdminsPayroll
Bulk upload multiple pay items for payroll
Bulk upload multiple pay items for payroll
Michael Colley avatar
Written by Michael Colley
Updated over a week ago

What is this for?

If you use a scheduling tool or keep track of certain pay items (overtime, commissions, bonuses, etc) throughout the month, you can now upload them in bulk in Onfolk to speed up your payroll process.


​

How it works

You'll need to create a file in csv format with specific fields (see below for the detail).

Once this is done, head to your Payroll tab in Onfolk and upload your file πŸ‘‡

That's it, you're done βœ…


​

How to fill out the multiple pay item file

πŸ”΄ You'll need to create a file that looks like this example - the columns need to be in the same order. If you change the order of columns, the upload won't work properly.


​

See below an explainer of each field:

  1. Payroll ID: This can be found on the employee's page under the "Work & Pay" tab. You can also download a custom report with everyone's payroll IDs from the Reports tab.

  2. Gross/Net: The value of this should be either "gross" or "net".

  3. Addition/Deduction: The value of this should be either "addition" or "deduction".

  4. Is Pensionable: The value of this should be either "true" or "false". If true, the amount of the line item will be factored into pension calculations. This is only possible for gross line items and must be "false" or empty for net line items.

  5. Amount: The amount of the line items in pounds and pennies. For example, ten pounds and twenty pence would be entered as "10.20". This should be left empty if you'd like the amount of the line item to be calculated based on hourly rates and minutes.

  6. Description: The description for the line item which will appear on the payslip.

  7. Minutes: The amount of minutes the employee is being paid for. For example, for 2 hours you would enter a value of 120.

  8. Hourly rate: The hourly rate the employee will be paid at. If none is provided, Onfolk will default to the default hourly rate set for the employee.

  9. Is NI-able: The value of this should be either "true" or "false". If true, the amount of the line item will be factored into National Insurance calculations. This is only possible for gross line items and must be "false" or empty for net line items.

Any questions? Head to [email protected] πŸ‘‹

Did this answer your question?