Connecting Xero

Find out how to connect and configure Airsquare to Xero.

Dave Quested avatar
Written by Dave Quested
Updated yesterday

What is Xero?

Xero is online accounting software. Find out more about Xero.

Why connect my Xero account to Airsquare?

If you are using Xero for your business, and are selling with Airsquare, it's a great idea to get them talking to each other. By connecting Xero, Airsquare will:

  • Create an invoice in Xero when an order is received.

  • Update an invoice in Xero when an order status is changed.

  • Attach an invoice to the order confirmation sent to the customer.

  • Allow you to download and print invoices from Airsquare.

  • Record payments against invoices.

  • Record inventory item codes against invoice line items.

  • Synchronise stock between Airsquare and Xero.

How do I connect Xero to Airsquare?

Connecting Xero is really simple:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Connect.

  3. You'll be redirected to Xero where you need to sign in (if not already logged in to Xero).

  4. In Xero, choose the organisation you'll like to connect and then click Authorise

  5. You'll then be redirected back to Airsquare where you can configure the Xero settings you want to use.

Can I connect multiple Airsquare sites to the same Xero organisation?

There can only be one connection between Airsquare and a Xero organisation/user combination.  If a second connection is authorised, then those connection credentials will overwrite the first. This is the way Xero works, it's not a requirement from Airsquare.

Ideally you should connect each Airsquare site to separate Xero organisations. 

However, you can create multiple Xero users for your Xero organisation and connect each Airsquare site using different Xero users. The downside of this is that the Xero API has rate limiting in place, so if the connections are active at the same time this could cause you to hit the 60 call per second limit much easier.

I get a message about a currency mismatch, what does this mean?

Any currencies you use in Airsquare, must also be added to Xero. 

How do I nominate the account any sales go into?

By default we use the first revenue account we find in your chart of accounts. Follow these steps if you would like sales to be added to a different sales account:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account code for sales you'd like to use.

  4. Click Update.

How do I nominate the account any sales go into for a specific pricing tier?

Follow these steps if you would like sales to be added to a different sales account for a specific pricing tier:

  1. In Airsquare, Go to Commerce > Pricing tiers.

  2. You'll see a list of pricing tiers. Click Edit next to the pricing tier you want to change.

  3. Choose the Xero sales account code you'd like to use.

  4. Click Update.

How do I use the sales account code for an inventory item set in Xero?

You may wish to use the sales account code already set against inventory items in Xero, rather than the generic sales account (see above). If you do this, you must have set the account code for each inventory item you have in Xero, otherwise it won't work:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Tick Override and use inventory item sales account codes instead.

  4. Click Update.

How do I nominate the account any shipping charges go into?

By default we use the first revenue account we find in your chart of accounts. Follow these steps if you would like shipping sales to be added to a different sales account:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account code for shipping you'd like to use.

  4. Click Update.

How do I nominate the account any credit card surcharges go into?

By default we use the first revenue account we find in your chart of accounts. Follow these steps if you would like credit card surcharges to be added to a different sales account:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account code for credit card surcharge you'd like to use.

  4. Click Update.

How do I nominate the bank account for credit card payments?

You may have multiple currencies set up in Airsquare which settle into different bank accounts in Xero. So you need to change the bank account for PayPal payments under each currency.

  1. In Airsquare, go to Commerce > Currencies.

  2. Next to the currency, click Edit.

  3. Choose the Xero account for PayPal payments you'd like to use.

  4. Click Update.

How do I nominate the bank account for PayPal payments?

You may have multiple currencies set up in Airsquare which settle into different bank accounts in Xero. So you need to change the bank account for credit card payments under each currency.

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account for PayPal payments you'd like to use.

  4. Click Update.

How do I nominate the bank account for external card payments?

  1. In Airsquare, Go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account for external card payments you'd like to use.

  4. Click Update.

How do I nominate the bank account for cash payments?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account for cash payments you'd like to use.

  4. Click Update.

How do I nominate the bank account for bank transfer payments?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Account for bank transfer payments you'd like to use.

  4. Click Update.

How do I change Xero tax rates in Airsquare?

When you connect Xero we do our best to automatically choose the correct tax rates. If you need to change these tax rates, there's two places you need to look.

  1. For No tax, Tax exempt and Zero-rated tax rates go to Account > Connected apps > Xero > Settings.

  2. For Standard and Reduced tax rates, go to Commerce > Tax zones and edit the appropriate tax zone you want to change.

How do I change the invoice status for purchase order payments?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Invoice status when paying by purchase order you'd like to use.

  4. Click Update.

How do I change the invoice status for on account payments?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Invoice status when paying on account you'd like to use.

  4. Click Update.

How do I change the branding theme used for invoices?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Choose the Invoice branding theme you'd like to use.

  4. Click Update.

How do I change the Xero contact used for 'Unknown' customer orders?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Change the Invoice 'Unknown' contact name.

  4. Click Update.

How do I create invoices for free orders?

By default we don't create invoices for free orders. But you can by following these steps:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Under Invoice options, tick Create invoice for free order.

  4. Click Update.

How do I use the purchase order number for the Xero invoice reference?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Settings.

  3. Under Invoice options, tick Use purchase order number for invoice reference.

  4. Click Update.

How do I create invoices in Xero for orders already received?

Once you've connected Xero to Airsquare, you can go back and create invoices for orders you've already received. You may also need to do this if Xero has disconnected for some reason:

  1. In Airsquare, go to Orders.

  2. Click on the order you'd like to create an invoice for.

  3. Under More, click Create invoice in Xero.

How do I associate Xero inventory item codes with things I sell in Airsquare?

For anything you sell in Airsquare, you'll see Xero inventory item code with a dropdown to choose any inventory code you have in Xero. Just choose the matching item code and click update. Now when invoices are created, you'll see the correct item code appear against line items in your invoices. 

Few things to note:

  • If you change any item code in Xero, you must change it in Airsquare too. 

  • To improve performance, we cache the list of Xero item codes for 5 minutes, so you might have to wait a few minutes for new item codes to appear in the list in Airsquare.

How does inventory work between Airsquare and Xero?

  • If you sell stock via Airsquare (an order is created), any associated Xero inventory items will go down based on the quantities sold.

  • If you sell items in Xero (by creating a manual sales invoice), we don't get told, so stock won't be deducted in Airsquare. 

  • If you add stock in Xero (via a purchase order), we don't get told, so stock won't go up in Airsquare.

How do I resync stock from Xero into Airsquare?

If you change stock in Xero, from selling items (sales invoice) or adding items (purchase order), Airsquare is never told.

You can manually resync everything by using our resync feature:

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Resync.

  3. This will then resync all stock from Xero into Airsquare.

If you want this to happen automatically (every hour) you can enable this under Account > Connected apps > Xero > Settings.

Note, we can't sync stock for products in Airsquare which can be oversold (e.g. customer can place order even if there's no stock). This is because Xero doesn't allow negative stock. Also if you oversell things in the POS, the stock values will sync incorrectly. In these scenarios we highly recommend you don't track stock in Xero and avoid resyncing. Instead use Airsquare to raise purchase orders to add stock and let us track inventory.

Can I do a bulk import/update to associate inventory items?

For products you can use the import products feature.

What do you use as the payment reference when recording payments?

If the payment is made by credit card or PayPal, we use the payment gateway transaction ID. This will allow you to cross reference the payment with the charge made by your chosen payment gateway. 

How do I set a tracking category for a location?

If you're using our POS, and have multiple locations, you may wish to use a Xero tracking category to allow for better reporting. Against any location you can assign a Xero tracking category.

  1. In Airsquare, go to Commerce > Locations.

  2. Find the right location, click Edit.

  3. Choose the Xero tracking category.

  4. Click Update.

Why is the organisation assigned as the customer in Xero?

If the customer supplies an organisation as part of their billing address (not shipping address) we assume they are purchasing on behalf of an organisation and therefore use them as the customer when creating the invoice in Xero.

Why does a customer have a number added to their name in Xero?

Xero has a flaw, it uses the contact name as a unique identifier, meaning you can't have two John Smith's. Tell them to fix it.

If a contact name already exists in Xero, we add the contact number to their name to ensure it is always unique.

How are payment terms set when paying on account or by purchase order?

If the customer pays on account or by purchase order we use the payment terms set against the contact in Xero. If no payment terms are set specifically against the Xero contact, we then use the default payment terms defined against your Xero organisation.

Why are invoices no longer being created in Xero?

Few things to check:

  • Is Xero still connected? Check in Airsquare under Account > Connected apps.

  • Have reached the limit of invoices you can approve in Xero? Please increase your Xero plan to allow for more invoices.

  • If you are tracking inventory in Xero, ensure you have quantity on hand for each of the items you are selling. Xero won't let you sell items you don't have.

Why are item codes no longer being recorded against invoice line items in Xero?

Few things to check:

  • Is Xero still connected? Check in Airsquare under Account > Connected apps.

  • If you've changed any item code in Xero, ensure the thing you're selling in Airsquare has the right Xero inventory item code assigned.

Can I stop the customer from receiving the Xero invoice?

No, at the moment we always attach the Xero invoice to the order confirmation email we send to the customer. If that's a deal breaker for you, let us know.

Why can't I edit an invoice in Xero created by Airsquare?

The most likely reason you can't edit an invoice in Xero is because a payment has been logged against the invoice. Airsquare does this for you if you've nominated a bank account for the payment method used (see above).

In order to change the invoice in Xero, you'll need to first remove the payment from the invoice. You'll then be able to make changes to the invoice.

Why don't I see discounts on Xero invoices?

We apply the discount to the unit price directly, we don't use the discount field. The reason for this is because Xero doesn't allow enough precision on the discount %. It's limited to 2 decimal places. We really need 4 decimal places to accurately apply a fixed amount discount.

I get a message saying Xero has been disconnected, what does this mean?

Xero can disconnect for a few reasons:

  • You've manually disconnected Airsquare from within Xero.

  • If not used, the Xero 'session' naturally expires.

  • The Xero user account used to connect to Airsquare has been deleted.

  • Xero have suffered a major outage and we were unable to renew your connection.

  • You've connected multiple Airsquare sites to the same organisation/user in Xero.

If you do get disconnected, simple re-connect following the steps above.

How do I disconnect Xero from Airsquare?

  1. In Airsquare, go to Account > Connected apps.

  2. You'll see a list of connected apps. Next to the Xero service, click Disconnect.

  3. Confirm you'd like to disconnect, by clicking Disconnect.

Did this answer your question?