Importing Timesheets

Roubler now provides a new Importer tool which will allow you to Import Timesheets. This is a great tool for any businesses who utilise an external clocking system and need a quick and easy way to bulk upload timesheets so they can then be approved & submitted to payroll.

Importing Timesheets

1. Head to 'Time' in the top bar
2. Select the 'Import' button in the right hand corner
3. On this page, you can 'Download Template' and save to your computer 
   
4. We recommend using the template to ensure you are importing the correct details
5. Please note, when exporting the template, Excel will convert the 'Time' & 'Date' column to your computers system settings.
   - Date Format: Must be set to this configuration 2017-04-05
   - Time Format: Must be set to 09:40:07
   This can be done by heading to your computers 'Settings' and adjusting these settings or manually adjusting within the Excel and saving for future use. 
6. When you have added the timesheet entries into the template & cross checked all of the fields, you can then upload
7. To upload, you can either 'Drag & Drop' the file for your documents OR select 'Browse' to locate the file to upload
   
8. Select 'Next'
   
9. You will now be able to 'Review Timesheets' before officially importing them
   - On the left the page you will see 'Timesheet Rows', if any of these have a warning sign next to them, it means you need to update/adjust to resolve the issue e.g. incorrect date/time format
   - You can make adjustments on each timesheet if you need to
   
10. Import Timesheets:
    - Select 'Import All' to upload the full list of timesheets in the file
    - Select 'Import' if you only wish to import specific 'Timesheet Rows'
    - Select 'Confirm' on the popup box
    
11. Once successful, a pop up box will appear advising 100% of timesheets have been imported & you simply need to 'Close' the window
    
    
12. Head to 'Time' to review each timesheet for approval & submitting to payroll