-
November 3, 2026
-
4 Views
Odoo Timesheets to Invoices: How to Bill Clients by the Hour Without Spreadsheets
Turning Odoo timesheets to invoices takes three moves: you set up a service product that is invoiced based on timesheets, let your team log time against a project or task, and then create the invoice straight from the sales order. That is how you bill clients by the hour without spreadsheets. Odoo pulls the hours, the rate and the customer into the invoice, so nobody retypes a number from a spreadsheet. A services business can run this flow with the Sales, Project, Timesheets and Accounting apps.
This guide shows the setup in the order you would do it, from the service product to the finished invoice, with a worked example and the mistakes that cause wrong bills. If you are leaving spreadsheets behind and want the apps connected properly from day one, our Odoo implementation services team sets up Sales, Project, Timesheets and Accounting as one flow.
The idea in one line: every hour is logged against something billable, a manager checks it, and the invoice is built from the logged hours. If an hour is not linked to a billable item, it never reaches the invoice.
- Employee
- Timesheet
- Project or task
- Sales order item
- Invoice
A note on versions: the steps follow Odoo’s documentation for Odoo 18 and 19. Menu names differ in older versions, so check the documentation for yours if a button is not where we say.
The spreadsheet way
- Hours live in each person’s own file
- Someone collects and adds them at month end
- Rates are typed in by hand
- The invoice is rebuilt in a separate tool
The Odoo way
- Hours are logged once, against a project
- Totals update as people log time
- Rates come from the sales order item
- The invoice is created from the sales order
What you need first
- The Sales, Project, Timesheets and Accounting apps installed.
- Every person who logs time set up as an employee. Odoo’s documentation says users must be registered as employees to log timesheets.
- Timesheet access rights set for each user, which we cover in step 04.
- A clear list of the services you sell and the rate for each.
Then switch timesheets on for each project that should be billable. In the Project app, open the project’s settings, go to Time management and enable Timesheets. Employees can only log time on a project that allows it.
Create billable service products
Go to Sales › Products and create a product with the type Service. The Invoicing Policy on that product decides how Odoo bills it. Odoo’s documentation lists the main choices:
| Billing model | Invoicing policy | Best for |
|---|---|---|
| Hourly, billed after the work | Based on Timesheets | Consulting, support, agencies where scope changes |
| Fixed price or prepaid hours | Prepaid/Fixed Price | Retainers and packages paid before work starts |
| Billed by stage | Based on Milestones | Projects with agreed delivery stages |
For hourly billing, set the policy to Based on Timesheets and the unit of measure to Hours. Then choose what Odoo creates when the order is confirmed. The Create on Order setting can build a project and a task automatically from each sales order, so the work has a place to log time from the first day.
Choose the model per client, not per company. A client with an unclear scope suits hourly billing, because the work can grow. A client who wants a known price suits a fixed or prepaid product. Many firms use both, and Odoo lets each sales order hold whichever mix a client agreed to.
One product per rate. If a senior consultant and a junior consultant bill at different rates, create two products, for example “Senior consultant, per hour” and “Junior consultant, per hour”. It is the cleanest way to keep rates visible on the invoice.
Handle different rates and non-billable time
Odoo’s timesheet features page says you can change the sales order item a timesheet is linked to, so you can adjust the rate by person or even by day. The sales order item is the link between an hour and a price. Three rules keep it tidy:
- Billable hour: link the timesheet to the sales order item with the right rate.
- Different rate: add another product at the new rate to the same sales order, and link that hour to it.
- Not billable: leave the sales order item empty. The hour is recorded but never invoiced.
That third rule matters more than people expect. Internal meetings and unpaid fixes still cost you money, and logging them as non-billable keeps your profitability reports honest instead of hiding the time.
Make time logging easy to do
People log time wrongly when logging is a chore. Odoo gives them several ways, so let them choose.
- Timer: in the Timesheets app, click Start, pick the project and task, add a short description, then click Stop. The time is added automatically.
- Grid: a weekly view where you type hours straight into the cell for each project and day.
- Tasks: start and stop the timer from the task itself, or add a line in its Timesheets tab.
For a timesheet on a billable project, include the sales order item so the hour can be invoiced. Write a real description too. A line that says “work” is useless when a client asks what they paid for.
Set access rights in Settings › Users. Under the Services section, the Timesheets field has four levels: no access, own timesheets only, all timesheets, and administrator. People who validate time need the all-timesheets level or higher, so give it only to the managers who will review hours. Odoo also offers reminders for people who forget to enter time, which saves chasing on Friday afternoon.
Approve time before it is billed
A wrong hour on an invoice is expensive, because correcting it means a credit note and an awkward email. Odoo lets you decide whether every recorded timesheet can be invoiced, or only the validated ones. Look under Timesheets › Configuration › Settings for the invoicing policy and choose approved timesheets only if you want a manager to check the hours first.
Then use a simple weekly routine:
- Employees finish logging by a set day and time.
- The team lead opens the grid, reviews each person’s hours and validates them.
- Finance invoices only after validation.
Odoo describes the timesheet tools, including validation and access levels, in its Timesheets documentation. Note that Odoo’s standard flow validates in one step. If you need a layered approval, such as team lead first and finance second, plan for an add-on or a custom rule.
Create the invoice from the sales order
Open the sales order and click Create Invoice. Choose Regular invoice, click Create Draft Invoice, check the lines, and click Confirm. The draft shows the hours spent as the quantity, so what you bill matches what was logged. Odoo’s documentation also tells you to pay attention to the Analytic Distribution column on the invoice, because other time and materials steps depend on that information.
A worked example
Say a consulting firm sold 40 hours of support to one client. By month end, a senior consultant logged 12 hours and a junior logged 20. The numbers below are made up to show the arithmetic.
| Item | Hours | Rate | Amount |
|---|---|---|---|
| Senior consultant, per hour | 12 | $150.00 | $1,800.00 |
| Junior consultant, per hour | 20 | $95.00 | $1,900.00 |
| Total billed | 32 | $3,700.00 |
Eight hours of the 40 sold are still unbilled, and Odoo shows them as remaining on the order. That visibility is the real gain. You can see at a glance whether a client is about to use up their hours.
The invoice also needs to look professional. If clients ask for a breakdown of hours or for your branding, see our guide on changing the Odoo invoice template before you send the first one.
Bill expenses next to the hours
Many service jobs include travel, hotels or software costs that you pass on. Odoo can put these on the same sales order. In the Expenses app, an expense can point to the sales order under Customer to Reinvoice, if its category allows re-invoicing. Once approved, the cost appears as a line on the order, and you bill it together with the time. Our guide to setting up Odoo Expenses shows how to configure those categories.
One detail from Odoo’s documentation: the sales order only appears as an option on the expense if it contains a service billed based on timesheets, milestones or delivered quantities. If the order is missing from the drop-down, check the product’s invoicing policy first.
Retainers and prepaid hours
Not every client pays after the work. For prepaid support, Odoo uses a separate product with the Prepaid/Fixed Price policy, so you can invoice and collect payment before any hours are logged. Time is then logged against that order and counted down. Odoo’s Helpdesk documentation describes this flow for support hours, and the same logic suits retainers.
Keep prepaid and hourly products separate. Mixing them on one product makes it hard to tell which hours were already paid for.
Reports that show where money leaks
Once time flows through Odoo, the same data answers questions that spreadsheets never could. Odoo’s Timesheets app offers graph and pivot views, and statistics by task, project, team member and billing type. Three checks are worth running every month:
- Billable against non-billable hours. A rising non-billable share means free work is creeping in.
- Time logged but not invoiced. These are hours someone worked and nobody billed.
- Hours by person against what was sold. If one project keeps running over, its price was too low.
Odoo also lets you compare logged timesheets with planned time and attendance, which helps when you suspect hours are being under-logged.
Before you press Create Invoice
- All hours for the period are logged, and validated if you use approval.
- Every billable timesheet has the correct sales order item.
- Non-billable work has no sales order item.
- Each line has a description a client would understand.
- Expenses to pass on are approved and linked to the order.
- The remaining hours on prepaid orders are noted.
Mistakes that lead to wrong bills
- Timesheets enabled on the wrong project. Time cannot be logged, so people use spreadsheets again.
- No sales order item on a billable hour. The hour is recorded but never invoiced.
- One product for every rate. The invoice cannot show who billed what.
- Invoicing before validation. A disputed hour becomes a credit note.
- Vague descriptions. Clients query the invoice, and you search for answers.
- Ignoring unbilled time. Hours worked but never invoiced are lost revenue.
Odoo timesheet invoicing FAQ
Can Odoo invoice clients automatically from timesheets?
Odoo builds the invoice from the logged hours, but a person still creates it from the sales order and confirms it. That gives you a chance to review it first.
Which apps do I need to bill by the hour in Odoo?
Sales, Project, Timesheets and Accounting. Expenses is also needed if you pass on costs.
How do I bill different hourly rates in Odoo?
Create a service product for each rate and link each timesheet to the right sales order item. You can change the linked item if a rate needs adjusting.
How do I make sure only approved hours are billed?
In the Timesheets settings, choose to invoice approved timesheets only. Managers then validate hours before finance creates the invoice.
What happens to non-billable hours?
Leave the sales order item empty. The hours stay in your reports as time spent, but they are not invoiced.
Can I invoice time and expenses together?
Yes. Link approved expenses to the same sales order, and both appear on the invoice.
Final thoughts
Billing by the hour goes wrong at the links: between the hour and the project, the project and the order item, and the item and the invoice. Set those links up once, review hours before billing, and the monthly invoice run becomes a short task instead of a spreadsheet hunt.
Want timesheets and invoicing working as one flow? Tell us how you bill clients today, and we will tell you what to set up first.
Related Articles
Odoo Year-End Closing: Fiscal Year, Lock Dates and Opening Entries Explained
-
November 21, 2026
-
5 Views
FBR vs PRA vs SRB: Which E-Invoicing System Does Your Business Actually Need?
-
November 20, 2026
-
8 Views
FBR Digital Invoice Error Codes Explained: What Each API Error Means and How to Fix It
-
November 19, 2026
-
15 Views
Leave a comment