WorkGuru can take approved timesheets, round them up to a daily total, and send them through to Xero ready to populate your payrun.
There are a number of requirements that need to be fulfilled before you can send timesheets to Xero:
- Ensure that the Connect to Xero Payroll? option was selected when connecting WorkGuru to Xero. You may need to disconnect and reconnect to enable this feature.
- Make sure that the user who set up the connection from WorkGuru to Xero has the Payroll Admin privilege (in Xero). If this is not set up correctly, you will get an error when you try to export payroll data.
- Ensure your Week Starts On setting in WorkGuru (Administration -> Settings -> General -> Week Starts On) is the same as your pay run schedule in Xero (Monday to Sunday, Wednesday to Thursday etc)
- Staff in WorkGuru are Matched on their Email address and/or their full name to their Payroll Employee in Xero.
- Each payroll employee's Ordinary Earnings Rate in Xero must match the default pay rate selected in WG.
- Draft pay run opened in Xero.
To send timesheets to Xero:
- Confirmed all timesheets have been entered correctly for the payrun period
- Open the Xero dashboard Accounting -> Xero
- In the Timesheet and Payroll section, click Get Employee Ids from Xero. This will ensure any additional staff in Xero and WorkGuru are matched via their email address.
- Click Send Timesheets after reviewing the following information:
- Xero Payrun - Ensure that the dates match your currently open Xero payrun.
- Default Pay Rate - Select the default pay rate to match the timesheets to in Xero.
- Timesheet data - Confirm the daily and total timesheet entries look correct for the selected payrun period.
- If you encounter any errors, review the integration requirements above.
- Once the timesheets are sent to Xero, they will appear as drafts to review in Xero -> Payroll -> Timesheets. From here you can review and confirm the timesheets sent from WorkGuru. You can also add additional lines such as Overtime and adjust the time entries accordingly.
- Approve all the timesheets in Xero and they will be added to the Xero payrun for processing via your normal payrun process in Xero
Timesheet Integration Notes:
- The current integration can only sent across one Pay Item type. If you need to track multiple types, such as overtime etc, you need to complete this within Xero from the draft Timesheet page before approval. (Eg if you work a standard 8 hour day and one day 10 hours is submitted via WorkGuru, you need to edit the Xero timesheet data to display 8 for Ordinary time and 2 for Overtime)
- Timesheets can only be submitted from WorkGuru to Xero once. If an incomplete week of timesheets have been submitted, you need to edit Xero directly.