Exporting Timesheets for Payroll
Export Timesheets from JobFlow
Open the Timesheets Report
You can access your templates from the main menu.
- Open the Hamburger Menu
- Navate to Reports β Timesheets
This page lists all timesheets submitted for the selected week.
Change the Week or View All Users
- When using this report for the first time:
- Set your Week Ending Day
- Choose how many Weeks to Display, using the drop downs in the top right.
- To navigate between weeks:
- Use the date selector arrows in the top right
- To filter users:
- Select All Users to view or enter timesheets for users who have not submitted one, or
- Type a User's Name into the filter box to search for a specific person
- Ensure the week ending selected is the last day of your pay period. For example, if your pay period runs Monday to Sunday, select Sunday as the week ending.
- If you pay fortnightly, select Show 2 weeks. For weekly pay periods, select Show 1 week.
- Confirm that the date range displayed in the top right corner matches your intended pay period.
Review and confirm all timesheets
- Click the timesheet entry for the user and day you want to update
- If needed time entries can be overriden and corrected.
- Choose one of the following actions:
- Override
- Reject
- Approve A Day
- You can export all timesheet data for the selected week:
- Click Summary CSV
Creating the CSV file to download
- Click Download CSV at the left bottom of the pop up box to create a CSV file
- A pop-up box will appear:
- Confirm the dates are correct.
- From the drop-down box, select Hours and minutes with colons.
- Click Download CSV.
- Save the file on your computer in your designated payroll folder.
- Open the CSV file and map the columns to match your payroll programme to reduce data entry errors and streamline processing.
Upload Timesheets into your Payroll Programme
- Log in to your payroll programme and navigate to the screen where timesheets are entered.
- Select the correct pay period
- If CSV import is Available, chose Import Timesheet and upload the file.
- Otherwise, mannual enter hours using the JobFlow CSV as your reference.
- Continue through the standard process of processing your pay run, following the procedures of your payroll programme.