Skip to content
Hypamoon

For teams that run on Odoo

Odoo payroll export: hours and leave each month

Odoo runs payroll itself in a set of countries listed in its documentation. Elsewhere, and in many US states, salaries are paid through an outside provider, so the hours, overtime and time off recorded in Odoo get counted per employee and typed in again each month.

How it goes today

  1. Export the timesheets or attendances of the month per employee.
  2. Add up regular hours and overtime in a spreadsheet.
  3. Look up the approved time off of each employee for the same month.
  4. Type the totals into the payroll portal or send them to the payroll office.

How it can go

Hours and leave from Odoo, ready for your payroll provider each month.

A few days before your payroll deadline you get one file with a line per employee: worked hours split into regular and overtime by your own rule, approved time off per leave type, sick days and approved expenses to reimburse. The columns follow the layout your payroll provider or office asks for. Employees without hours or unapproved leave are listed first, so you can chase them before you send it.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Odoo key in the portal, never in the chat.

Your request

With Hypamoon, three working days before our payroll deadline, make a file from Odoo with one line per employee for last month: worked hours from attendances or timesheets split into regular and overtime by the rule I give, approved time off per leave type, sick days and approved expenses. Use the column layout I give you. List employees without hours or unapproved leave first and email me the file.

You create an Odoo API key yourself under Preferences, Account Security, for a user with the access you want to give. A key lasts at most three months, so you renew it in the portal. On Odoo Online and Odoo.sh this needs the Custom plan. It stays yours.

More for teams on Odoo