Odoo

The Odoo integration in Tillor exports customers and booked invoices to Odoo. Payment reports to Odoo will follow in a later release; until then, use Admisol if you want payment reports sent on automatically.

InstallationCopy link to this section

1. Go to Settings and open the App Marketplace.
2. Find the Odoo card and click Install.
3. First fill in the following under Connection:
   • Odoo URL - for example https://mijnbedrijf.odoo.com or just mijnbedrijf (Tillor then completes the .odoo.com URL)
   • Username - a user with API access
   • API key - an API key (Odoo: user profile > API keys)
4. Click Continue to database. Tillor fetches the available databases (or lets you enter the name manually).
5. Choose the database under Database and complete the installation.

When you save, Tillor tests the connection.

Accounting parameters (Odoo app)Copy link to this section

After installation, you set the export parameters under Settings on the Odoo app (next to the URL, database, username and API key). Tillor fetches sales journals and income accounts live from Odoo; you pick them through a search field (code and name).

For each invoice line, Tillor first looks for an Odoo account with the same code as the line's ledger number; otherwise it uses the default income account. For VAT, Tillor looks for a sales tax in Odoo with the same percentage as on the line.

VAT regimesCopy link to this section

An invoice line with a regime without VAT, such as reverse charge, needs its own sales tax in Odoo: an ordinary 0% ends up in the wrong box of your VAT return. So in the export settings, for each regime you use, enter the name of the sales tax in Odoo, exactly as it appears in Odoo under Accounting > Configuration > Taxes (in a Belgian Odoo, for example, 0% EU S for EU services). There are five fields: reverse charge (EU services), reverse charge (co-contractor), intra-community supply, export outside the EU and VAT exempt.

If the field for a regime is empty or the tax does not exist in Odoo, the export of that invoice stops with an error message. Enter the name and send the invoice again.

Invoice PDF in OdooCopy link to this section

With Attach invoice PDF (on by default), Tillor uploads the same PDF as in Tillor. For a new export this happens before posting in Odoo, so the preview on the right of the invoice can be linked. The file name follows the Tillor invoice number (e.g. INV_2026_0001.pdf). Tillor also sets that PDF as the main attachment on the Odoo invoice.

On the Events of the Tillor invoice you can see whether the export succeeded, including customer, invoice, PDF and UBL.

• If the Odoo invoice already exists (same reference: the Tillor invoice number), Tillor updates the customer, lines, dates and payment reference. If the invoice was already posted in Odoo, Tillor first sets it back to draft, changes the data and posts it again when Post invoices automatically is on or the invoice was already posted.
• After that, PDF and UBL attachments are replaced or added when those options are on.
• If the upload fails after a newly created draft invoice, that Odoo invoice is deleted so a following export can try again.

Peppol UBL in OdooCopy link to this section

With Attach Peppol UBL (on by default), Tillor uploads the Peppol UBL as an extra attachment on the Odoo invoice. The file name follows the Tillor invoice number (e.g. INV_2026_0001.xml).

• Tillor does not generate UBL itself: the file only becomes available after a successful Peppol delivery.
• If the UBL is not ready at the time of export, Tillor skips the UBL attachment; as soon as the UBL arrives, it is still added to the existing Odoo invoice.
• If the UBL upload fails, the whole Odoo export does not fail (unlike the PDF). Only a PDF error after a new invoice rolls back the Odoo draft.

InvoicesCopy link to this section

• When you book or rebook an invoice, Tillor exports the invoice to Odoo automatically.
• Manually: invoice actions > export to accounting (the same button as for Admisol).
• Only invoices with the status Booked are exported.
• If an Odoo invoice with the same Tillor invoice number already exists, no second invoice is created. Tillor updates the customer, lines and dates on that invoice (for example after moving it to another customer or rebooking) and replaces PDF/UBL attachments when those options are on.
• If the invoice PDF changes after a payment (or another amount on the document), Tillor replaces the existing PDF attachment in Odoo as soon as the new PDF is ready. No second Odoo invoice is created and no payment is posted in Odoo.

CustomersCopy link to this section

Customers are updated or created in Odoo with the Tillor customer number as the reference. Existing partners with the same number are updated.

Payment reportsCopy link to this section

Sending payment reports to Odoo, automatically or manually, is not yet available. The daily payment report process skips Odoo without an error message.

Requirements in OdooCopy link to this section

• A sales journal with the configured code (default INV)
• G/L accounts with codes that match Tillor lines or the default income account
• Optional: sales VAT rates in Odoo with the same percentages as in Tillor

See alsoCopy link to this section