top of page

6. How To Change Timesheet History in Bulk

Updated: Jan 12


This action can only be performed by someone with an Administrator licence.


  1. Go to the Hamburger Icon> Reporting > Reports and click on the Timesheets sub navigation



2. Run the UniPhi Timesheet Export report for all resources and all activities for project inception to date



3. Save the report as an Excel spreadsheet by changing the Format to Excel and then clicking View on the left hand side


4. Remove the resources who do not require a change from the spreadsheet


5. Remove any entries after the last invoice from the spreadsheet


6. Set the hours column to 0 for all resources who do require a change



7. Import the 0 hour records in the Upload interface from the screenshot below – this effectively clears the timesheet records in UniPhi for those people



8. Modify the client invoice data so you have a column for Project ID, Contact ID, Activity ID, Timesheet Task (hard code to “B” for billable time), Hours and Date



9. Press the validate button first and if there are errors just hover the cursor over any red cell and information about the specific error will appear.


10. Import the historical invoiced time by clicking the Save button.


You have now successfully changed the timesheet history.

Comments


bottom of page