Timesheets - Ability to Import Timesheet templates from excel
Could we have the ability to update timesheets each payrun from and excel spreadsheet.
This is so that admin staff can data enter timesheet information without necessarily having access to the payroll system. This is also in the case of Company's who do not want the Xero Me function.

Appreciate raising the idea here, Mona
With improvements to XeroMe our intention is to make it simpler for employees to self enter this sort of information.
Is there a particular reason why you'd prefer not to use this function? Would be good to be able to share this back with our team or perhaps there's another idea I could be connecting you in with here
-
Ryan Erasmus commented
We are desperately needing an import function for Timesheets / Payroll.
In one client's case we have just over 30 staff, does not sound like much, but each employee has on average 15 pay line items. That is 450 manual entries per pay cycle.
We use a spreadsheet to prepare our data and it will be easy to then simply create a format for import purposes. Yet, the function is not available. Why not? -
Kristin Schmidt commented
This is a desperately needed function!
Our business uses alternative software for job scheduling & timesheets, so XeroMe would not work for us.
We currently enter timesheet data into a spreadsheet, then enter into Xero.
To be able to skip this second manual step would be amazing!(on a side note, XeroMe does not have great functionality, it has poor levels of permission & team management making it unusable from a business running over 70 staff in multiple teams.)
-
Peter Barrett commented
XeroMe isn't ideal for us, because a lot of our employees are not sophisticated enough to - or just don't want to - use it. We have a manager reviewing the times and updating into Xero for each employee. The spreadsheet short be importable. Pretty obvious feature that seems necessary.
-
Jonathan Cawood commented
this is a very basic option that should be implemented ASAP. Every payroll program has an import function. The use of Xero payroll is frustrating. make it easier!!!!
-
Nick Maxwell commented
for me I work with a team across the UK to say they are not completely on board with IT is an understatement.
they have just got to grips with a basic forms sheet to give me their claim they get paid for each complete response so we need to check at our end if responses are complete and this is done company wide by project managers using a excel sheet I provide. importing this froma CSV would make it so simple.
-
Naomi Hodgson commented
Xero me doesn't appear to be clock in clock out, but rather enter and submit later. Our staff must clock in and clock out, and they currently do this in a separate system. We've just converted from MYOB which has the timesheet import capability.
-
Michaela Webb commented
Quite basic really. Disappointing that Xero don’t have this functionality. May have to consider alternatives
-
Tally Kerr commented
Just boosting this function request - this would save us hours of staff time and potential errors manually entering 100+ staff's hours each month.
-
Timothy Percy commented
We have over 100 staff, with multiple payroll categories and our award is quite complex, so we calculate our payroll balances in excel and then upload to our current erp.
Our employees base hours are tracked in a different software platform which captures their hours by project by day. The Xero Me app wouldn't work for us as it doesn't allow time sheet entry by project in the app and doesn't correlate to our allocations software.
We critically need to be able to upload a batch of timesheets & payroll entries for our employees. See attached an example of our fortnightly timesheet data entry
-
Beam ABA Finance Department commented
Save time manually entering data and removing the error rate
-
Nabila Khan commented
Hi, I would like to request Xero to update the product team to prepare an excel time sheet template that we could automatically upload into the time sheeting function. We have a client and we have to do the payroll every week. The payroll process is that we have to prepare an excel from their time sheet to calculate the hours and then have to enter the total hours in Xero to process their pay. If Xero could come up with a template of time sheet suitable for Xero then we can upload the times heet straight to Xero and Xero will do the hours calculation.
-
David Klineberg commented
Desperately need to import external pay run information e.g. hours, earnings rates, into Xero in either the Timesheets function or directly into the pay run.
We use an ERP system and today need to manually enter all payroll times by employee. Not really acceptable for payroll!