Overview
The Export API enables you to export the accounting data managed in Pleo to other external ERP/accounting systems. Some of the key features and benefits of this API include:- The accounting and the bookkeeping information contained in the accounting entries are transformed to exportable data items and packaged as export items. This is done to ensure accurate and transparent transmission of accounting entries from Pleo to the external ERP/accounting system.
- Managing the export workflow with
Export JobsandExport Job Events(for more information, see #What are Export Jobs? and #What are Export Job Events?). - Tracking the progress of each accounting entry included in an export job through export job items — an export job item tracks the export progress of a specific accounting entry in an export job.
What are Export Jobs?
AnExport Job is the task that manages the export workflow and provides insight with the additional information:
- Status and progress of the export workflow
- Export history logs
- Orchestrates the entire workflow, like locking the accounting entries being exported from any modification
- Orchestrates the change of status in expenses
What are Export Job Events?
The Export Job Events cause change in status of an export job. When an event is triggered, the status of the corresponding export job is impacted. This is returned in thestatus parameter of the export-jobs endpoint. For example, a specific export job is showing failed status; the reason of failure is also mentioned to understand what caused the problem and how it could be resolved.
The possible values are:
pending: The accounting entries are queued for export.failed: The accounting entries could not be exported to the external accounting system.completed: The accounting entries have been successfully exported to the external accounting system.completed_with_errors: The export workflow is complete, yet few accounting entries could not be exported to the external accounting system.
Webhook Notifications for Status Change in Export Workflow
When an Export Job Event is triggered, a webhook notification is generated and sent to the external accounting system. Thus, this helps the ERP/accounting system to act in accordance with the event status. For example, if you have subscribed to thev2.export.job-created event, a webhook notification is sent to the external system, notifying that an export workflow is already initiated and a specific set of accounting entries are being currently exported from Pleo to the target system. For more information, see Webhooks.
Vendor Tagging in Export Items
Adding vendors in an export item is a new functionality that is available only when the following criteria are met:- The specific company has synchronised the list of vendors existing in their ERP/accounting system and their Pleo account. For more information, see Vendors API Overview.
-
The integration supports the capability of vendor tagging. If yes,
vendorBasedBookkeepingis set toTruein thePOST Create a new export jobendpoint. -
Tagging vendors in an export item is available for the following expenses:
card_purchasefeechargebackrefundcashbackinvoiceinvoice_paymentoverdraft
- If the bookkeeping method is
accounts_payable, tagging vendors in an export item is mandatory — this helps to bookkeep the expense in the correct vendor account as maintained in the external ERP/accounting system. IfvendorBasedBookkeepingis enabled, theGET Get Export Itemsendpoint includes vendor and bookkeeping data points. - If the bookkeeping method is
journal, tagging vendors in an export item is optional.