New Integration Set Up or Configure Existing Integration
To enable Corpay One Mastercard transactions to sync to Xero, a set up step is required in the integration.
On the left hand navigation go to Settings > Integrations and click on the Xero tile. If the integration has never been set up click the Connect button, if it has been set up click the Configure button. For full instructions on how to set up the integration refer to the help article.
In order to successfully pass the transaction information permission is required. Click the Allow button on the permissions request screen.
In the integration process there is a section called Configure credit card transaction sync. Move through the integration process by clicking Next after each step.
The first step in the card transactions integration process is to toggle on the Turn on Credit Card transaction sync feature. Once it is on, a series of configuration options will appear.
Configure Credit Card Mapping to Xero
The first step in the configuration process is to indicate which account the transactions will sync to in Xero. The system provides two options.
Allow Corpay One to create a new liability account in Xero.
With this option, Corpay One will create a new liability account named Corpay Mastercard.
If the integration is being set up for the first time the account will automatically be created upon completion of the set up process
If the integration was already set up the account will be created after the next transaction made with the Corpay One Mastercard has Posted.
Once the account is created no further action is required.
Choose an existing account in Xero to map the transactions into. Use the Select Account dropdown to pick an existing account.
With this option all future transactions, once Posted, will sync into the selected account.
Sync Historical Transactions
A limited number of historical Corpay Mastercard Transactions can be synced to Xero. If historical transactions are desired toggle on the Sync historical transactions feature. Using the Calendar, choose how far back to sync the transactions (up to 3 months).
Once the credit card transaction sync confirmation is complete, click the Finish button to complete the set up and trigger the historical transactions to sync.
Changing Sync Set Up Options
In the case that the integration is set up with one of the sync set up options and later changed to the other sync set up option please note the following:
Historical transactions were previously synced to Xero and will not be synced again
A change to any transaction made prior to updating the integration sync set up will result in the transaction syncing to the new account location in Xero. This may result in a duplicate record in Xero
One in the old account
One in the new account
Transactions made after the change in the integration set up will only sync to the new account
Other Things to Note:
Returns - when an item is returned, a return transaction appears in Corpay One and is synced to Xero
Rebates, Late Fees, and Interest - Rebates and Late fees are not available at a transaction level and are not synced to Xero
Vendors - Merchants do not come into Corpay One as Vendors at this time. A possible future enhancement can be considered, the lift is considered high effort from the initial review.
Payment Method Mapping
To ensure that the Payment Sources in Corpay One use the correct corresponding GL account in the accounting system, a mapping feature is available to map the Bank Accounts and Credit Cards payment sources to their funding accounts. This is an optional feature, yet valuable to those who use a different account for Credit Cards.
If the mapping is not done within the integration, the payment source will be the default payment source initially set up in the Xero Integration set up process.
The payment source mapping can be done after the integration is set up and after the Corpay Mastercard is available.
Using the configure feature in the integration, the user will navigate to the Payment Method Mapping feature. Payment accounts appear in the drop down (pulled from Xero).
The Payment Method includes all Payment Sources as defined in Corpay One and then maps the corresponding GL accounts.