Reporting & Expense

1-CP sends your company's transaction data automatically to your systems for reporting, expense, ERP, CRM, business intelligence and duty of care. Manual exports and imports are no longer needed.

Benefits

• Less effort: You no longer need to export and import data manually.

• Correct data: Your finance, CRM and reporting systems always have the correct transaction data. Errors from manual entry become less frequent.

• Central analysis: You combine travel and expense data with other business systems, e.g. ERP, CRM or BI tools.

• Duty of care: Location and travel data go automatically to your security and safety partners.

How to set up reporting

Webhooks in self-service

You set up webhooks yourself in the Corporate portal under Configurations > Reporting. Via New Reporting you create the interface. With a webhook, 1-CP sends transaction data automatically in real time to your application, including custom or in-house solutions.

For a webhook you define the following:

• Events: which events make 1-CP send a POST request, e.g. Create, Update, Confirmed, Paid or Canceled

• Payload URL: the address 1-CP sends the data to

• Content type: the format of the data sent

• Secret: optionally a secret for securing the connection

• SSL verification: whether SSL verification is active

• Data scope: status updates only or all data

• Data field mapping: optionally you map internal field names to your target system's field names

• External ID: optionally you store an external ID per company

You can find the technical documentation in our developer docs at docs.one-cp.com/webhooks.

Other connectors via 1-CP

1-CP activates all other reporting connectors for you. Use the integration request form in the Help widget.

You create one-off or scheduled exports in the Corporate portal, see Transactions and exports in the Corporate portal.

Supported connectors

1-CP supports these systems for reporting and data export.

Duty of Care

• NP4

• International SOS

• A3M

Expense, ERP & Accounting

• Amadeus Cytric E-Receipt

• SAP Concur Quick Expense v4

• Mobilexpense

• SAP Hana / Hana Cloud

• DATEV

• RadiusTravel

• Xero

• Sage

• Chromeriver

• Oracle Netsuite

• SAP R/3 ERP

• SUN Accounts

CRM & Marketing

• Salesforce

• Marketo

• Hubspot

• Zendesk

• Oracle Eloqua

• Microsoft Dynamics 365 Sales

Travel Data & Management

• travelbasys RBS

• Ta.ts IBIZA

• travelogix

• Traxo

Databases & Business Intelligence

• Google Cloud Spanner

• Amazon RDS

• Google BigQuery Standard SQL

• Microsoft Azure Synapse Analytics

• Heroku Postgres

• Amazon Redshift

• Microsoft Azure SQL Database

• Google BigQuery

• Snowflake

Related articles

• Connectors at a glance

• Transactions and exports in the Corporate portal

• Profile synchronization