How to update Exact Online integration

This article is intended for existing users of the Pleo–Exact Online integration who want to upgrade to the new version. If you’re setting up the integration for the first time, please refer to the set-up guide to get started with connecting Exact Online to Pleo.


Prerequisites 

Ensure that your Exact Online account has the required user permissions:
  • View and manage the following scopes :
    • Account Management
    • Financial Accounting
    • G/L Accounts & Journals
    • Document Management
  • View the following scopes: 
    • Cost Centres & Cost Units
    • Administration & Operational Management
    • Project Management


If you do not have the required user permissions - you need to add them or request your Exact Online admin to add them to your account.

How to check user permission in Exact Online 
  1. In Exact Online, click on the account name
  2. Select My Exact Online
  3. Access the Rights tab
  4. Ensure that you have the following user permissions:
    • In General tab:
      • System section:
        • Create, update, and delete documents
        • View company data
    • In Financial tab:
      • Accounts section:
        • Manage accounts
        • View accounts
      • Bank section:
        • Enter, modify and delete bank entries
      • Financial entries section:
        • Enter, modify and delete purchase entries
    • In Project tab (if Projects are used):
      • Project section:
        • View projects


Complete the update

Existing configurations (journals, categories, accounts, and tax codes) have been migrated automatically. To finalise the update and access the new features, additional configuration is required.



1. Review accounting configurations

Confirm that all configurations are set up correctly on the Accounting set-up page. 

  • Pleo bank journal - Main bank journal used for recording payment entries made from your Pleo Wallet. Re-use and map the existing Pleo bank journal.
  • Expense purchase journal - Record purchase entries for card expenses and invoices. Re-use and map the existing Pleo purchase journal. 
  • Transitory bank journal - Record reimbursements made outside of Pleo. You need this journal if you use pocket expenses and reimbursements.
     How to create a new journal? 
    1. In Exact Online, navigate to Financial
    2. Go to Baking & Cash, select Overview under Bank accounts
    3. On the Bank Accounts page, click New
    4. Enter any number into the Bank account number field (this won't impact anything) 
    5. Name the Journal
    6. In Advanced options, choose the currency - ensure that the selected currency matches your Pleo Wallet currency
    7. Click Save
  • Default supplier account - If an actual supplier is not selected on an expense in Pleo, it will be booked on this generic supplier account. Re-use and select the existing Pleo Supplier Account here. 


If you created a new Journal in Exact Online, click Sync with Exact Online to have it imported into Pleo


2. Enable projects

In addition to Cost Centers and Cost Units, Projects synchronisation is now supported. Select the Dimensions from Exact Online which you want to synchronise with Tags in Pleo.


3. Save settings

After completing all configurations on the Set up page, be sure to click Save settings to avoid losing your settings.



4. Confirm contra accounts

Access Contra Accounts and confirm that one is selected (learn more about Contra Account in Pleo). If no Contra Account is selected, follow these steps: 

  1. In Pleo, go to Settings
  2. Access Accounting
  3. Select Set Up 
  4. Find the Expense Bank Journal under Accounting configurations
  5. Access Contra Accounts 
  6. Select an account which corresponds exactly to the Expense Bank Journal


What to do if you are using Multi-currency in your account?
Learn how to use multi-currency in your Account, and follow these steps:
  1. In Exact Online, create a new Pleo Bank Journal for each additional currency contra account
  2. Make sure the Expense Bank Journal has variable Currency and Exchange Rate enabled (see below)
  3. Wait for the automatic sync between Exact Online and Pleo (runs every hour)
  4. In Pleo, go to Contra Accounts 
  5. Map the new accounts to their respective Pleo contra accounts

How to check Currency settings of the Expense Purchase Journal?
  1. In Exact Online, navigate to Financial
  2. Go to Banking & Cash
  3. Select Overview under Bank accounts
  4. On the Bank Accounts page, click New
  5. Enter any number into the Bank account number field (this won't affect anything)
  6. Name the Journal
  7. In Advanced options, choose the currency
    Note: Ensure that the selected currency matches the respective Contra Account currency
  8. Click Save


5. Enable vendor tagging

Learn how to activate Vendor tagging in Pleo.


6. Review categories

Access your Categories page and confirm that account numbers and tax codes are in place.


7. Export an expense

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



 Enhancements in the new integration 
  • Export
    • Purchase and bank entries are automatically reconciled
    • Exporting of invoices & external reimbursements is now supported
    • Exporting of expenses from a closed financial period. Custom periods in Exact Online are also supported
    • Description field on Exact Online is now populated with info about merchant, Pleo user and note
    • Book exported expenses on actual Vendors in Exact Online
  • Tags Sync
    • Projects are now supported and can be synced with Tags in Pleo
    • Inactive (expired) Cost Centers & Cost Units will not be imported in Pleo 
  • Tax Sync
    • Inactive (expired) tax codes will not be imported into Pleo
  • Vendor Sync
    • Vendors from Exact Online are imported and synchronised with Pleo
    • New Vendors can be created in Exact Online from Pleo
  • Multi-Currency
    • Enable multi-currency in Pleo and export expenses paid in different currencies into Business Central

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