1/ Setting up the connection
- Click on 'Integrations', under 'Settings' in the navigation bar:
- Choose Xero and click on the green 'Connect'-button.
- Fill in your Xero details and press 'Login'.
- Authorize the Application connection for the right 'Organisation':
2/ Choose your settings
- Choose the branch from Xpenditure (your company) that you would like to connect with Xero.
- If you do not have the multi-currency optionality in Xero, you have to make sure the currency of your Xpenditure branch matches the one from your Xero Organisation.
- Xpenditure will automatically import the chart of accounts for expense claims and purchase bills from your Xero organisation.
- Optional: If you use tracking categories within Xero, Xpenditure is able to import these as well. Please select them in the import section of the integration page.
- They will appear as custom fields on the expenses and in the mobile application.
- In the export section of the integration page you can choose how you would like your expenses to be exported.
- Personal/reimbursable expenses can be exported to the following sections of Xero: Expense claim: please make sure the Xpenditure users are all set as Xero users and that the email address is identical in both systems. Purchase bill (most common): all reimbursable expenses will be exported as (purchase) bills with the name of the Xpenditure user set as a supplier in the 'From'-field of Xero. You can choose which status you want the (purchase) bills to have in Xero.
- Company expenses can be exported to the following sections of Xero: Purchase bill (most common): all company expenses and invoices will be exported as (purchase) bills with the name of the merchant set as a supplier in the 'From'-field of Xero. You can choose which status you want the (purchase) bills to have in Xero. Transactions: With Xpenditure you can have your company expenses and invoices to be exported to the transaction section of Xero. So you can easily reconcile them with your direct datafeed of your bank into Xero. To make sure your company expense are going to the right bank account in Xero, you have to link the payment methods of your Xpenditure users to the designated bank account of Xero. You need to do this in the company settings of Xpenditure in the section 'Users'. By opening their details and linking the payment method to a Xero bank account.
- Please make sure you save your settings:
- And do not forget to synchronize so that we can import all of your relevant data:
3/ Link your bank account
If you have selected to export your data towards "transactions" of Xero, you have to link your payment method in Xpenditure towards the right Xero bankaccount. To do so, follow these steps:
- Go to the 'Company Settings'.
- Click on the menu 'User' and open the user for which you want to link his payment method towards a Xero bankaccount.
- Scroll down to the payment methods of the users detail screen.
- Click on the payment method and you will have the option to link it to the right Xero bank account.
4/ Export expenses to Xero
- Go to the Expenses overview, in the role of Finance.
- Click on the green button 'Sync to...' on top of the page.
- Fill in the end date and select a branch (if needed), before clicking on 'Sync'.
- Your expenses are being exported.
5/ Tips & Tricks
- When you delete categories and you sync to your accounting program, they will appear again. To prevent this, disable the unneeded categories.
- If you have multiple accounts in Xero that need to be linked to different branches in Xpenditure, you will need to set up a new connection per account.