Xero integration for Tourwriter

Xero integration for Tourwriter

InfoFor customers who use Xero as their business accounting software, you can automate a lot of transaction reconciliations by using the Xero integration for Tourwriter. Once the integration is enabled Incoming payments and/or Suppliers payments can be sent and synced to Xero invoices and/or Bill payments. 

Incoming payments, supplier payments, and agency payments each behave differently, and the sync rules are determined by payment stages. Follow the setup and configuration steps below to get started.
Notes
Note: Customers will need to go through accounting setup to ensure correct mapping of data. Details can be found here. 


Setting up the Xero integration

A User with Admin permissions can connect their Tourwriter organisation to a single Xero organisation.

  1. Click the Organisation option in the sidebar in Tourwriter.
  2. Click the Integrations tab.
  3. Click the Connect button alongside the Xero integration option.
  4. You will be prompted to authorise your Xero account by logging in and then selecting the Xero organisation you wish to connect to.
  5. Click the blue Allow access button and you will be returned to the Integrations tab.
  6. After successfully authorising, your Xero organisation will be listed next to the Xero label and the red Disconnect button will display.
Notes
Note: A Xero organisation can only be connected to one Tourwriter organisation at a time.

Configure Xero to enable sync

Once you have successfully connected your Xero account to your Tourwriter organisation you can Configure Xero to enable or disable the:
  1. Sync for Incoming payments - How to sync details are here
  2. Send and Sync for Supplier payments - How to send and sync details are here
  3. Sync for Agency payments. - How to sync details are here
By disabling the checkbox the integration will no longer create new invoices or bill payments and any previously synced items will no longer sync between Tourwriter and Xero.
Notes
Note: Disabling a sync may result in a payment going out of sync. Any payment that is out of sync cannot be resynced and will need to be deleted so another payment sync can be started.

Xero integration data flow 

The integration moves data between Tourwriter and Xero.  Some data is created in Tourwriter, can be edited in Xero and also created in Xero. The below list details which fields are mapped and indicates the potential data flow.

Data mapping when creating a Invoice in Xero

Tourwriter – Incoming paymentData flowXero – Invoice
Payment name (reqd)Description
Amount due (reqd)Price
Due date (reqd)Due date
Bill to (reqd)Contact
Itinerary ID – Itinerary nameReference
Created dateIssue date
Invoice numberInvoice number
StatusStatus
Amount paidPaid
Date paidPaid Date
Notes
Note: Incoming payment creation date in Tourwriter becomes the Issue date in Xero

Data mapping when creating a Bill payment in Xero

Tourwriter – Supplier paymentData flowXero – Bill payment
Organisation-> Accounting-> Supplier payment settingsReference
Supplier nameContact
Date of creationDate
Due dateDue date
Amount dueUnit price/Total
Quantity x Item name (Option name)Description
1Quantity
Product account codeAccount

Data flow when syncing with a bill payment

Tourwriter – Supplier paymentData flowXero – Bill payment
ReferenceReference
Due dateDue date
Amount dueAmount due
Date paidDate paid
Amount paidAmount paid
StatusStatus

Xero integration for Incoming payments

When the sync for Incoming payments is enabled the creation of an Incoming payment will automatically generate a Draft Invoice in Xero. 

Details for syncing Incoming payments can be found here.

Xero integration for Supplier payments

When the sync for Supplier payments is enabled Users can send supplier payments to Xero. Each supplier payment sent will create a Draft Bill payment in Xero.

Details for sending supplier payments can be found here

Xero integration for Agency payments

When the sync for Agency payments is enabled, saving an agency payment automatically creates a draft Bill payment in Xero. This only applies to organisations with Agency management enabled.

Details for syncing agency payments can be found here.

Disconnecting your Xero organisation from Tourwriter

If you no longer wish your Incoming payments to create and link with Xero invoices you can disconnect your Xero organisation. Disconnecting means creating an incoming payment will no longer create draft invoices in Xero. All previously linked incoming payments will display in Tourwriter however any updates in Xero will not longer push back into Tourwriter.

To disconnect:

  1. Click the Organisation option in the sidebar.
  2. Click the Integrations tab.
  3. Click the red Disconnect button alongside the Xero integration option.
  4. You are now disconnected and the grey Connect button will now display for the Xero integration option.
NotesNote: You can reconnect to a Xero organisation at any time. Once connected to a new organisation any new incoming payments will link with this new organisation.


FAQs

  • How to I know the Xero integration is active?
    • On the Integrations page the grey Connect button will instead be a red Disconnect button
    • When creating a new Incoming payment the blue Xero logo will display next to the Amount paid column.
  • Can I connect more than one Xero organisation to my Tourwriter account?
    • A Xero organisation can only be connected to one Tourwriter organisation at a time.
  • When I am in Xero, how do I know which Incoming payment created the Invoice?
    • The easiest way is to click the Go to Tourwriter quick link in Xero. This will open the Incoming payment directly in the Tourwriter app. Alternatively, when the Xero invoice is first created the Reference number in Xero stores the ItineraryID. Copy the first 4 digits and use the Global search in Tourwriter.
  • If I disconnect the Xero integration will I lose all the linked invoice data?
    • No. All previously linked incoming payments will display in Tourwriter however any updates in Xero will not longer push back into Tourwriter.
  • Why can’t I edit a Xero approved invoice in Tourwriter?
    • A Xero Invoice that is one of the Approved, Sent or Paid statuses can not be edited in Tourwriter because Xero approved invoices can only be updated in Xero. This is a restriction of the Xero API. Any changes to the Incoming payment will need to be made in Xero or the invoice will need to be updated to Draft status.
  • Can I sync agency payments if my organisation does not use Agency management?
    • No. Agency management must be enabled for your organisation before the Sync agency payments option has any effect.
Related article: Xero integration for incoming payments.

--
If you need help, please contact our Support team via email (support@tourwriter.com) or live chat.