Overview
Installation
Connection
Configuration
Export an expense
Overview
Enhancements in the new integration
- Integration Type - new integration is an app installed inside Business Central
- Cloud & On-Premises Business Central is now supported
- Export
- Exporting of invoices
- Bookkeeping of expenses on a Vendor
- Recording exported Pleo expenses as Purchase Invoices in Business Central
- Creating Pleo Wallet as a Bank Account in Business Central
- Using any Journal type (template) in Business Central
- Tags Sync
- Blocked Dimensions Values are no longer synced with Tags in Pleo
- Both Tag's Name and Code can now be visible on expenses in the Export page
- Select which Dimension Values you want to see as Tags in their Pleo
- Tax Sync
- Both Product and Business VAT Posting Groups are now linked to Tax Codes in Pleo
- Tax Codes rates are now automatically assigned and updated
- Select which VAT Setups you want to see as Tax Codes in Pleo
Installation
Install the app
- Go to the Pleo app in Microsoft AppSource
- Click Get it Now
- Use your Business Central credentials to sign in (if required)
- Select the Business Central environment into which you want to install the app
- Follow the on-screen instructions to complete the installation
- Once installation is complete, close the Setup window
- Access Extension Management
- Click on the app's name (Pleo)
- Switch HttpsClient Request toggle
Connection
- In Pleo, access Accounting Settings
- Make screenshots of the existing integration configurations (Journals and Accounts)
- Click Disconnect
For Cloud Business Central
- In Business Central, open Pleo integration setup
- Click on the pencil icon to edit
- Click Connect
- Follow the steps of the authorisation process
Once the integration is connected, the Installation status will be ACTIVATED
For On-premises Business Central
- In Pleo, go to Settings
- Click Accounting
- Select Business Central On-Premises
- Allow the connection
- Copy and save the API Key
- In Business Central, open Pleo integration setup
- Click on the pencil icon to edit
- Enter the API key
- Click Connect
Once the integration is connected, the Installation status will be ACTIVATED
Configuration
1. Journals & Accounts configuration
Re-use and map the existing Pleo Journal for expenses to the new Journals:
- Expense Journal - all Pleo expenses will be recorded in this journal (except Invoices and expenses booked on a Vendor)
- Invoice Journal & Invoice Payment Journal - to record invoices, and/or to book card and out-of-pocket expenses on a vendor. Alternatively, you can create separate new Journals for them
How to create a new Journal in Business Central?
Journal Template - select the Journal Template and use any existing Journal template.
Note: Do not create a new Template for any journal
Journal Batch - create a new Journal Batch or map an existing one. To create a new Batch:
- Click on the Expense Batch field
- Click + New
- Add Name, Description, and, if needed, No. Series
Re-use and map the existing Accounts to the new Accounts:
- Pleo Wallet Account - to track expenses made with your Pleo cards. Map the existing Account for Pleo expenses.
Note: If you want to have Pleo Wallet Account as a Bank Account in Business Central, set Pleo Wallet Account Type to Bank Account and create a new account - Pleo Out-of-pocket Account - to track employee out-of-pocket expenses. Map the existing Balancing account for out-of-pocket expenses.
Note: If you want to book out-of-pocket expenses on a Vendor or Employee in Business Central, set the Out-of-pocket Account Type to Vendor or Employee, and create a new account the pocket Account type as Vendor or Employee, you will need to create a new account. - Pleo Contra Account - to track reimbursements made outside of Pleo. Map the existing Contra account for reimbursements.
- Default Vendor Account: this Vendor account will be recorded on all expenses when an actual Vendor was not specified in Pleo. Required if you intend to use Pleo Invoices feature and/or if you want to book card expenses on a Vendor in Business Central.
How to create new Accounts in Business Central?
Pleo Wallet Account
- Choose Pleo Wallet Account type
- You can use either a G/L Account or a Bank Account type
- Create a new account by clicking on the account field and then clicking + New
- Add account No. and Name
- If you are creating a Bank Account, ensure that Bank Acc. Posting Group is assigned to the Account
Pleo Out-of-Pocket Account
Choose an Account Type for Pleo Out-of-pocket Account and map Pleo Out-of-Pocket Account No.
G/L Account is a standard default choice, but you can also choose Vendor or Employee.
- If Vendor is chosen:
- All pocket expenses will be booked on a single generic Vendor account
- Choose Vendor to record pocket expenses as Purchase Invoices in Business Central
- If Employee is chosen:
- All pocket expenses will be booked on Employees from Business Central
- You will need to manually link Pleo Users to Employees from Business Central
Pleo Contra Account
- Click on the field
- Select New
- Add account No. and Name
Default Vendor Account
- Click on the field
- Select New
- Use existing template for creating a Vendor
- Add account No. and Name
- Ensure that:
- Gen. Bus. Posting Group is set
- Vendor Posting Group is set
2. Accounting configurations
If needed, adjust the accounting configurations of the integration.
Record Vendor on Card Expenses
- If disabled (default) - card expenses will be recorded as a single journal entry in the Expense journal
- If enabled - Pleo card expenses will be booked on a Vendor in Business Central
Good to know:
- If you enable this configuration, make sure you have the Default Vendor Account set up
- If Purchase Invoices is also enabled, card expenses will be booked as Purchase Invoices as Business Central
Purchase Invoices
- If enabled (default), invoices and all other expenses booked on a Vendor will be recorded as Purchase Invoices in Business Central
- If disabled, all expenses (inc. invoices) will be recorded in Business Central as Journal entries
Description
This configuration determines the contents of the Description and Comment fields on exported expenses in Business Central. To add a datapoint into the Description:
- Press the three-dotted sign
- Select the desired datapoint
- Click OK
Good to know: You can write any text in the field - it will appear in the Description and Comment fields for all exported expenses (do not use [ ] around your text)
3. Tax Codes & tags
Synchronise your VAT Setups to Pleo Tax Codes
- In Business Central, go to Pleo Integration Setup
- Access Tax Codes Setup
- Click Sync With Pleo
- In Pleo, access the Export page
- Click on Unexported
- Update Tax Codes on existing expenses to ensure correct export (filter or select the relevant expenses, and use bulk edit to update the tax codes)
Note: This only applies to existing expenses - new ones won’t require any changes
Good to know:
- To not import certain VAT Setups as Tax Codes in Pleo, un-click the Show in Pleo checkbox and click Sync With Pleo
- VAT Setups that are blocked or are Sales & Full Tax Type will not be synced. To import one, first uncheck the Block box, then select Show in Pleo
Synchronise your Dimensions to Pleo Tags
- To link Dimension to existing Tag Groups
- In Business Central, go to Pleo Integration Setup
- Click Tags Setup
- Add the Dimensions from Business Central you want to sync with Pleo
Note: The Dimensions which already exist as active Tag Groups are automatically pre-selected - Select a Dimension
- Click OK
- Click Sync With Pleo
- To edit the Dimension values synced to Pleo
- Next to the dimension field, click on the three dots icon
- Uncheck Show in Pleo for Dimension Values you do NOT want to have in Pleo as Tags
- Click Sync With Pleo
- Next to the dimension field, click on the three dots icon
Good to know:
- Dimensions are linked to Tag Groups
- Dimension values are linked to tags
- Blocked or non-standard Dimension Values can’t be made visible in Pleo
4. Categories
- In Pleo, go to Settings
- Click Accounting
- Select Categories
- Create categories
- For every category
- Add the account numbers (no names or other details needed, just the Account numbers)
- Choose a tax code from the dropdown
Good to know: If categories were already in place, you'll need to reassign Tax Codes to each one, as the new integration recreated them
Export an expense
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article