There are several different methods that allow you to get your employees' hours and earnings data from Teachworks. You can find more details about each of these methods below:
Method 1 - Employee Hours (Basic)
If you just need the total hours and earnings for a specific period for each employee, you can follow the steps below:
Click on "Employees" and then click on "Employee List".
Using the filters at the top of the page, select a date range.
Click on the "Download Hours" link on the right-hand side to download the hours to Excel.
The Excel file will include the number of lessons, number of hours, earnings and payments for each of your employees.
Method 2 - Employee Hours Detailed (Single Employee)
If you need the hours for a specific employee's lessons, you can follow the steps below:
Click on "Employees" and then click on "Employee List".
Click on the "View" icon next to the employee to view their individual hours.
Using the date filters at the top, select a date range.
Click on the "Download Hours" on the right-hand side to download the hours to Excel.
The Excel file will only include the data for a single employee within the selected date range.
Method 3 - Employee Hours Detailed (Multiple Employees)
It's also possible to get the data from Method 2 for all of your employees at once. You can do this by following the steps below;
Click on "Calendar" and then click on "Lesson History".
Select a date range using the filters at the top of the table.
Click on the "Download Lessons" link on the right-hand side to download the hours to Excel.
You can then open the Excel file and sort the data as needed. You can also use Excels Subtotal formula to get the totals for each of your employees within the file.
Method 4 - Lesson Summary Report
You can use the Lesson Summary Report to generate a list of lessons to get your employees' hours for the selected period of time. You can do this by following the steps below:
Click on "Reports" and then click on "Lesson Summaries".
In the "Data Type" field, select "Lessons".
Select a date range, choose any filters you'd like to use and select which columns to include using the "Columns" field.
If you're running the report for all employees, you can set the "Group By" field to "Teacher".
Click on the "Run Report" button to generate the report.
Click on the "Excel" or "CSV" button at the top to export it to Excel.
Need some more help? Watch a video here.