Hi!

Our direct integration with Xero allows us to have full control over the data exchanged between Payhawk and Xero. If you haven't connected your Xero organization to Payhawk, you can follow this guide.

Here's a diagram of all the data that Xero and Payhawk are sharing.


Transactions automatically exported to Xero's bank feed

For accounting reasons, we export only settled transactions. Hence, if the payment has been authorized but not settled, we will not export it. Once a transaction is settled, its settlement date and the amount will be automatically exported to the Payhawk bank account in Xero as a bank line item. This includes:

  • Card transactions

  • Bank transfers

You can read more details about our integration with Xero bank feed here.


Types of expenses exported to Xero

Whem you Mark as reviewed an expense this will push the expense to Xero.

  • Card expenses are exported as Paid Bills from the corresponding bank account.

  • Cash expenses are exported as paid Bills.

  • Reimbursable expenses are exported as Bills to pay.

  • Bank expenses are exported as Bills to pay.

When unpaid Bills are marked as paid or paid directly through Payhawk, they will automatically be updated as paid Bills if we manage to match it to a payment on Xero.


Payhawk data fields that are exported to Xero

  • Supplier - if the supplier is not in Xero, we create a new contact automatically

  • Category - mapped to the Xero chart of accounts.

  • Document number

  • Document date

  • Due date - for all bank expenses Payhawk exports the due date. If there is no due date entered, the date of the expense is used as due date.

  • Note - the cardholder's explanatory note for the expense is shown in the Description field of the expense in Xero.

  • Document image

  • Amount - this is the total minus the tax rate for the expense.

  • Currency

  • VAT Rate - the tax rate provided from Xero.

  • Tracking Categories - Payhawk imports Xero tracking categories and let's use them as expense fields

  • Fees - when there is a fee to the transaction, the fee is applied a line item to the bank transaction in the account Fees that Payhawk created.

 

More questions? Feel free to write to us in the chat 💳

Did this answer your question?