Overview
Preparation
Connection
Configuration
Advanced options
Export an expense
Overview
The integration supports the following:
- Export of card expenses, reimbursements & invoices
- Vendor-based bookkeeping
- Multi-entities
- Tags, Categories and Tax codes
- Customer Description
Preparation
Create the following accounts in NetSuite
- Pleo Bank Account - to track transactions made with Pleo Cards and Pleo Account.
Type: Bank Account - Pleo out-of-pocket Account - to track any out-of-pocket expenses or reimbursements made by employees
Type: Other Current Liability - Pleo External Reimbursement Account - to track any reimbursements made outside of Pleo's direct reimbursement functionality
Type: Other Current Liability
To create the accounts
- In Netsuite, access the Set up page
- Click on Accounting
- Select Chart of Accounts
- Click New
Connection
- In Pleo, navigate to Settings
- Click Accounting
- Search for NetSuite
- In the NetSuite app, click Connect
- Authorise Pleo and NetSuite for the transfer of data
- Update Script deployments in NetSuite
- Access Customisation
- Click Scripting and Scriptdeployments
- Add a Scheduledfilter for the deployment Type
- Make the following edits for the Pleo - Scheduled checks and Pleo - Receipt Schedule scripts:
- Set PRIORITY to High
- Change STARTTIME to 12:00 AM
- Ensure REPEAT is set to Every 15 min
- Save
Configuration
Accounting configuration
- In Netsuite, go to Transactions
- Select Pleo
- Access Dashboard
- Click on the edit pencil
- Connect the accounts
Tax codes
You can apply VAT in Pleo by creating a tax code and attaching it to a specific category.
- In Netsuite, go to Transactions
- Select Pleo
- Access Dashboard
- Click on Data Mapping Information
- Select Tax Codes
- In Pleo, go to Settings
- Click Accounting
- Select Setup
- Under Tax codes, map the NetSuite Internal ID to Code
- In the tax code table, add all the VAT rates
Categories
- In Netsuite, go to Transactions
- Select Pleo
- Access Dashboard
- Navigate to Advanced Options
- Click Sync Chart of Accounts
- Wait 15 minutes for the chart of accounts to be synced
- In Pleo, go to Settings
- Click Accounting
- Select Categories
- Create categories
- For every category:
- Map NetSuite Internal ID to Account
- Select a tax code from the dropdown
Good to know: Chart of accounts will synced once a day.
Tags and Tag groups
- In Netsuite, go to Transactions
- Select Pleo
- Access Tag Management
- Decide if you want the tags to be populated on Netsuite’s Transaction Body fields or Transaction Line fields (see below)
- Under Transaction Body or Line fields, select the Dimensions
- Click Create tag group and Update
- Wait 15 minutes for the tag group to be created in Pleo and the tags to be synced
Transaction Body and Line Fields in Netsuite
Custom or standard dimensions in NetSuite are fields that can be added to transactions. They are categorised as either Transaction Body fields or Transaction Line fields.
- Transaction Body fields apply to the entire transaction. Tags will be part of the body description of the transaction.
- Transaction Line fields apply to specific lines (debit and credit) within a transaction. Tags will appear per line in a transaction.
To verify a record's type, you can navigate to Customisation > Lists, Records, & Fields and select either Transaction Body Fields or Transaction Line Fields.
Good to know: NetSuite allows standard dimensions like Class, Location and Departments to appear on both Transaction Body and Line Items fields.
Advanced options
- Upload receipts
- Bypass transaction date
- Scheduled export run
- Populate tax code
- Customise Memo
- Passing Employee information
- Vendor tagging
Upload receipts
- In Netsuite, access Documents
- Under Files, select Files Cabinet
- Under Pleo, click Receipts
- Under the subtab Pleo within a Journal Entry, click Download External Pleo Document
Note: If you decide not to upload your receipts to NetSuite, your receipts will have a URL to the expense on Pleo
Bypass transaction date
Import transactions from Pleo where the original transaction date is within a closed accounting period.
- In Netsuite, check the box Bypass transaction date
- Access the Setup page
- Select Accounting
- Click Set Up Accounting
- Set Default posting period when transaction date is in a closed period to: Current Period or First Open Period
- Set Allow transaction outsideof posting period to: Allow or Warn
Schedule export run
After you trigger an export, Suiteapp will process the information every 15 minutes, or according to the timeframe set in the configuration.
Populate tax code
Check the populate tax code to populate the tax code on the same journal line instead of a separate journal line.
Add customise Memo
- In NetSuite, go to Transactions
- Select Pleo
- Select Customise Memo
- Pick a Subsidiary and field(s) to add to the Memo
Passing Employee information
To automatically populate the employee name in NetSuite, make sure the Employee Code in Pleo matches the Employee’s Internal ID in NetSuite.
- To find the Employee's Internal ID in NetSuite:
- In NetSuite, go to Lists
- Select Employees and click Employees
- Click Customize view
- Add Internal ID to the overview
- Click Save
- Add Employee code in Pleo
- In Pleo, navigate to People
- Select the Employee you want to add the employee code for
- Click Edit next to Employee code
- Enter the Internal ID from NetSuite
Vendor tagging
- Admins can choose the bookkeeping method (Journal or Accounts Payable) for card expenses
- Select a vendor for each card expense and invoice
- Vendors are synced from NetSuite into Pleo
- New vendors can be created from Pleo into NetSuite
Turn on Sync Vendors
- In NetSuite, go to Transaction
- Select Pleo
- Access Advanced Configurations
- Turn on Sync Vendors
Activate Vendor Tagging
- In Pleo, go to Settings
- Access Accounting
- Click Activate Vendor Tagging
- Select a default vendor from the list
Note: This vendor will be used automatically if no specific vendor is selected for an expense or invoice
Select a relevant vendor
- On Pleo, access an expense detail
- Select Bookkeeping Method
- Select a vendor
Export an expense
After setting up the integration, 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
Feedback sent
We appreciate your effort and will try to fix the article