Set up Odoo integration


Overview


Preparation


Connection


Configuration


Export an expense

Overview

The integration supports all Odoo hosting options and Odoo version 16 & 17.


Key features of the integration

  • Expenses (including receipts and other attachments) from Pleo are automatically exported to Odoo
  • Analytics Plans from Odoo are synchronised with Pleo Tag Groups
  • Taxes from Odoo are synchronised and will always be up-to-date in Pleo


Before you get started:
  • In Odoo you need to have the right user permissions to generate an API key

1. Preparation

Generate API Key 

  1. In Odoo, click on your profile in the top right corner
  2. Select My Profile
  3. Click on Account Security
  4. Within API keys click New API key
  5. Enter your password and confirm
  6. Enter a key name
  7. Click Generate key
  8. Copy and save the API key


Install the employees module

Note: If you already see Employees in your module overview, you don't need to install the module again.

  1. In Odoo, click Apps in the module overview
  2. Search for Employees
  3. Click Install
  4. Follow the on-screen instructions


Create journals in Odoo

  1. In Odoo, go to Accounting
  2. Under Configuration, select Journals
  3. Click New to add a journal
  4. Create the following journals:
    • If you don't want your card purchases to be stored as Vendor Bills: Journal for Pleo card expenses - with type Miscellaneous
    • Vendor bills - with type Purchase
    • Journal for out-of-pocket expenses - with type Miscellaneous


Create GL accounts in Odoo

  1. In Odoo, go to Accounting
  2. Under Configuration, select Accounts
  3. Click New to create an account
  4. Create the following accounts:
    • Pleo Wallet account - with any type
    • Pleo out-of-pocket account - with any type
    • Pleo contra account for external reimbursements - with any type
    • Accounts Payable account - with type Payable


2. Connection

  1. In Pleo, navigate to Settings
  2. Click Accounting
  3. Search for Odoo
  4. Select the Odoo integration and click Continue
  5. Add the follow details:
    • Instance location: Enter the URL of your Odoo, for example: https://pleo-integration.odoo.com/
    • Database: Enter the domain name. To find the database name:
      1. In Odoo, click your profile in the top right corner
      2. Select My databases
      3. For the data base your want to use select Domain name and copy the bolded domain name
    • Username: Enter the email address of the user that generated the API Key (step 1)
    • API Key: Enter the save API Key generated (step 1)
    • Click Check
  6. Select a company you'd like to connect to in Odoo
  7. Click Connect


3. Configuration

  • Accounting Mapping
    If you would like card expenses and/or out-of-pocket expenses to be recorded as vendor bills, switch the Bookkeeping mode toggle and add a journal

    Map the journals and accounts created in Odoo (step 1).

  • Tags
    If you would like your Analytical Plans to be synchronised with your Pleo tag groups, switch the toggle to Turn Tags sync on.
    • Configure the tag sync 
      • Select a sync rate or manually sync the tags now 
      • Select an Analytics Plan and map it to a new or existing Pleo tag group 
    • Good to know:
      • Only changes made in Odoo will be synced with Pleo. Changes made in Pleo will not be synced to Odoo
      • You can map up to 5 Analytics Plans to Pleo tag groups
      • Analytical Accounts are imported from the mapped Analytics Plans
  • Taxes
    If you would like your Taxes to be synchronised to your Pleo integration, switch the toggle to Turn Tax sync on. Select a sync rate or manually sync the taxes now.

  • Export
    • Export queue sync: Set how often the integration will be checking for expenses add to the export queue (5 minutes is recommended)
    • Bypass transaction date: If enabled the date for any expenses belonging to closed accounting periods will be changed to today, allowing them to be exported to
    • Odoo Export receipts: If enabled receipts and other attachments will be exported to
    • Odoo Export in draft status: If enabled expenses will be exported to Odoo in draft status instead of posted
       
  • Categories
    1. In Pleo, go to Settings 
    2. Click Accounting 
    3. Select Categories 
    4. Create categories
    5. For every category
      • Add the GL account numbers 
      • Choose a tax code from

4. Export an expense

After setting up the integrations it's important to export an expense to see if the integration is configured correctly.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article