Exporting your contacts to Xero

Keeping your contacts in sync with Xero is easy with Okappy.

Whenever an invoice is exported to Xero from Okappy, Okappy will first check whether the invoice account existing in Xero and if not, it will create the contact in Xero.

However, what happens if you want to upload multiple contacts, i.e., when you are first setting up Xero.  This is also easy with Okappy.

To upload multiple contacts to Xero, follow the steps below:

1. Generating your list of contacts in Okappy

You can export your customers or subcontractors into Okappy.

  • Go to Reports
  • Click Other
  • Choose either to download either your Customers or Subcontractorts

Check our reporting support pages for more information on exporting your customers, or exporting your subcontractors.

2. Download the Xero export template

From within Xero,

  • Click Contacts

Xero Contacts

  • Click All contacts

Xero Contacts Import

  • Click Import
  • The import contacts download page will be shown

Xero Import Contacts Download Template

  • Download the Xero contacts template file

The template file will be downloaded to your computer.

3. Copy your list of contacts

  • Open the download file you created earlier with Okappy
  • Open the Xero template file

Xero Contacts Template

  • Copy and paste the contacts of the Okappy file into the Xero template file from row 2 onwards
  • Ensure the details are in the correct Xero columns

4. Import your contacts into Xero

From the import contacts page in Xero

Xero Import Contacts Download Template

  • Click Browse
  • Select the Contacts.csv file you have just saved
  • Choose whether to ignore empty fields.  If you don’t ignore empty fields, any existing contact information will be deleted from within Xero
  • Click Import

Xero Import Contacts Review

  • Review the import summary
  • If there are any issues,
    • Click < Go Back
    • Amend the details in the contacts.csv template
    • Once you are happy, click Import again.
  • In the summary page, click Complete import

Xero Import Contacts Success

Your contacts will be created in Xero.