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.
![](https://secure.gravatar.com/avatar/abc95a742cff88ffdda68fd95bd29302?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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
-
Wendy Clayton commented
This feature would be useful as we have an aviation-specific rostering system that maintains much more information other than timesheets. It would be handy to export these and import them into Xero without interpreting them and then manually taking out human error. Also, saving manual processing time.
-
Lynda Catchpole commented
We use BrightHR and their product Blip to capture timesheet data.
It outputs to excel easily but currently has to be rekeyed into Xero.
An upload would be fabulous…. or better still an API. -
Carmen Heber-Hall commented
This would be essential for us - please can we make this work?
-
Steve Middleton commented
Please can we have this functionality? There is already the ability to bulk import contacts (for example), could that be extended to timesheets?
-
Jenny Seymour commented
our scheduling / timesheets are produced in other system and it would would save a lot of time/double handling if we could import from this into Xero (say via csv).
Xero me does not work for us. It also is a very bad version of this type of functionality and has very poor permissions control.
Given the amount you charge clients for payroll it is a very poorly thought through part of the system. Time to spend dollars on improving payroll allround xero.
-
Lyn Jones commented
Support this idea
-
Breanna Owen commented
Fully support this idea to reduce manual entry
-
Anh Rutherford commented
I fully support this idea, this would reduce manual data entry for payroll and reduce human error as well as payroll compliance.
-
Russell Watt commented
I fully support the call for the ability to import Excel spreadsheet templates into Xero.
Staff have a daily check in and out register, time then gets transferred by them into an Excel spreadsheet which gets checked by supervisor, sent to finance and entered through timesheets by finance team for payment. Staff are on different awards and conditions and some work across programs, and the programs need to be reported to government departments - with some across five or six programs. It is confusing enough for the financial staff having to split up the hours between programs and reporting requirements, and to get staff to use XeroMe to try to record this information would be even more confusing for all concerned. As a charity, the time of our staff is better spent serving our community, not triple entering data and fixing up any human error that occurs. -
Robin Irwin commented
Many reasons as to why a simple timesheet doesn't work i.e. rely solely on XeroMe. For those projects that are complex and span months, finance needs to report accrued revenue based on CoS and % completion on projects. Labour is a major input into the CoS. Simply expecting engineers (as an example) to interface with Xero Me is unrealistic. As a further example, use of DevOps in SW teams. This includes time already , actual and expected. This needs to find its way to Xero. Why would you enter it twice. Furthermore, project management tooling may sit above that to abstract to work packages for PM purposes.
If you are asking why you need this feature you fundamentally don't understand how most business process works for tech and engineering companies.
-
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