For teams that run on Factorial
Factorial overtime balance for the whole year
Factorial shows the hours balance on each timesheet per period, and depending on your settings the balance can reset each month. The annual balance export is on the Business and Enterprise plans and arrives by email per team. So a year view per person often means adding months up by hand.
How it goes today
- Open the timesheet of each person and note the balance for each month.
- Download the time tracking report per period and paste the months together.
- Work out the running total per person in a spreadsheet.
- Check by hand who is above the limit your company agreed on.
How it can go
Overtime per person for the year so far, in one sheet each month.
On the first working day of each month you get one sheet with a row per person: planned and worked hours for each month of this year as Factorial records them, the difference per month and the running total. People above the limit you set are at the top, and team leads get the rows for their own team.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Factorial key in the portal, never in the chat.
With Hypamoon, on the first working day of each month, take from Factorial for each person the planned hours and the worked hours of every month this year. Put them in one sheet with a row per person, show the difference per month and the running total, and put people above 40 extra hours at the top. Email the sheet to HR, and send each team lead the rows of their own team.
An administrator creates an API key in Factorial under Settings, API keys, and picks no expiry date, because new keys expire after 24 hours unless you choose otherwise. It stays yours.
More for teams on Factorial
- I want each team lead to see their own team's absences and hours, without asking HR for a report.
- I want a team calendar with only absences, including requests that still wait, and a whole year at a glance.
- I want the org chart as a PDF or image, not as a spreadsheet.
- I want people reminded of their own remaining days before the carried over days expire.
- I want approvers reminded of requests that have been waiting too long.
- I want to know which sick leaves still have no doctor's note attached.
- I want a list of who still has not handed in a document we need.
- Everything for Factorial