Help Centre
/
Exporting Timesheets to iPayroll

Exporting Timesheets to iPayroll

← Back to category
  • You need Time permission to export time clocks and Payroll permission to be able to view pay rates. If you don't have access to this module, ask someone with Manager's permission to update your user permissions.

  • You will need to have set up your Staff Roles and Staff details correctly, and reviewed your Time Clocks in order to export accurately to your payroll system.

  • If this is the first time you have completed an import to your payroll system, please read the Exporting timeclock from Loaded article first.

Set up

  1. When setting up staff members in Loaded, ensure that the Staff Paycode in Loaded matches the Person ID of the Staff member in iPayroll.

    Loaded Staff editor

    Loaded Staff editor showing Staff Paycode field

    iPayroll Staff Editor. To access Person ID in iPayroll you need to click People > View People > click on the name of a staff member > scroll down to the Person ID text field.

    iPayroll Staff Editor showing Person ID
  2. Ensure that the Department Code of Roles in your Loaded account (Time > Manage > Roles) matches the Codes of Cost Centres in iPayroll under Setup > Costing.

    Loaded Roles Editor

    Loaded Roles Editor showing Department Code

    iPayroll Cost Centres Editor

    iPayroll Cost Centres Editor showing Codes

Importing to iPayroll

  1. Ensure you have successfully exported your timesheets from Loaded.

  2. Go to Payroll > Enter in iPayroll

    iPayroll Payroll > Enter menu
  3. The iPayroll will bring you to the Add Active People page where you will need to add people to the payroll run. Click the checkbox next to the relevant names and then click Add Selected

    iPayroll Add Active People page
  4. Click the + button in the left upper left side of the page, it will bring you back to the Add Active People page

    iPayroll plus button to add active people
  5. On the next page click Upload > Choose file > find & select the CSV file that you have exported from Loaded > click Upload File

    iPayroll upload CSV file
  6. Your staff members should then have their correct work hours imported. Now you can follow the guide in iPayroll knowledgebase to continue the payrun

    iPayroll knowledgebase guide to continue payrun

Errors

If the import doesn't succeed, you will get one of the following errors.

  • This suggests that there is something wrong with the Pay Code assigned to a staff member, either it doesn't match the Person ID of anyone in your iPayroll staff list or it's not entered at all (please refer to Set up, Step 1.)

    iPayroll import error: Pay Code mismatch
  • This error suggests that there is something wrong with the Department code of one of the roles being imported, i.e. it does not match the Code of a Cost Centre in iPayroll or is not entered at all (please refer to the Setting up paragraph, step 2)

    iPayroll import error: Department code mismatch
  • This error suggests that the person(s) you are exporting timesheets for were not added to the payroll run. Please check the Importing to Payroll paragraph, step 3 for instructions on how to fix this.

    iPayroll import error: staff not added to payroll run
  • If you have a different error notification or need further information, please visit the iPayroll Help centre to find more information.

Other articles and resources that you might find useful.

Questions? We're here to help.

Bring last month's numbers and we'll show you what this looks like in your venue — twenty minutes, no pitch deck.

Book a demoSee pricing