Xero
Sync Sequence invoices in real-time and streamline your accounting process.
Start guide
Connecting your Xero account to Sequence is simple. Go to the Integrations tab to get started.
- Click the button to connect to Xero.
- Select the organization to which you want to connect. For testing, it is recommended to connect to a test Xero Demo Company if you are using the sandbox environment.
- Authorize the connection.
- Set up your default ledger accounts. See more under ledger accounts ledger accounts
Import customers from Xero
You can import customers from Xero into Sequence in order to speed up your onboarding. In order for an invoice or credit note to be synced the end-customer must be linked to a customer in Xero.
You can import some or all of your customers directly from Xero using the customer import tool. In order to be valid for invoicing in Sequence every customer needs the following:
- A primary address
- A primary email address
The primary address must have the following fields:
- First line
- Town/city
- Postal/zip code
- A valid country (Sequence uses the alpha-2 country code format)
If a customer is invalid the reason will be provided, allowing you to update the customer in Xero and reload before importing.
If you want to link an existing customer to Xero you can select them in the Sequence customer view and choose to which Xero customer you want to link them.
To add and link a net new customer to Xero and Sequence, create them in Sequence first and then link them to the corresponding contact in Xero. Alternatively, you can create a mock invoice for the contact in Xero to turn them into a customer (at this point, this is the only way to create a new customer in Xero).
Ledger accounts
Whenever you create an invoice in Xero each line item is linked to a ledger account. This allows you to categorize the items.
Similarly in Sequence you will need to link each line item to a ledger account in Xero. In order to speed this up you can set a default ledger account in your integration settings. This can be overridden for individual line items.
When you create a new product, set its Xero ledger account. This will apply to any prices and generated line items on invoices.
Set a ledger account for a specific invoice line item:
If you have existing products, billing schedules, invoices and/or credit notes in Sequence at the time when you connect your Xero account then setting a default ledger account will allow the integration to begin working straight away. All existing line items will be linked to the default ledger account. These can then be updated on an individual basis either in a plan, invoice or credit note as shown above.
Tax
For taxable customers, Sequence will not provide a specific tax code when syncing invoices to Xero. Xero will apply the default tax code for a line item’s ledger account.
For tax exempt and reverse charged customers, Sequence will override the tax code to be ‘NONE’. You can change this value in your Xero settings.
Syncing invoices
Whenever an invoice is finalized or sent from Sequence it will automatically get pushed to Xero. The issue and due dates will be set to a dummy date of 1st January 3000 in Xero until you send the invoice, at which point we will update these. This will be overwritten with the correct dates when the invoice is sent. If you subsequently send the invoice via Sequence it will get marked as sent in Xero. Similarly if the invoice is marked as sent in Xero, then the status will be updated in Sequence.
Sending an invoice marks it as sent in Xero. You can navigate from the invoice in Xero to Sequence and vice versa.
Once an invoice has been pushed to Xero you can reconcile it against payments. For invoices with a Stripe payment link, Sequence will sync the payment status from Stripe (and ignore the payment status in Xero). You need to reconcile your invoice in Xero separately in this case and additionally mark as paid in Sequence if the payment landed directly in your bank account without going via Stripe. For regular invoices without a Stripe payment link, Sequence will sync the payment status from Xero.
Syncing credit notes
Whenever a credit note is finalized in Sequence it will automatically get pushed to Xero. The issue and due dates will be set to a dummy date of 1st January 3000 in Xero until you send the credit note, at which point we will update these. This will be overwritten with the correct dates when the credit note is sent. If you subsequently send the credit note via Sequence it will get marked as sent in Xero. Similarly if the credit note is marked as sent in Xero, then the status will be updated in Sequence.
You can navigate from the credit note in Xero to Sequence and vice versa.
Rounding behaviour in Xero
By default, Xero only supports two decimal points. When an invoice is pushed from Sequence into Xero, line item amounts with more than two decimal points (e.g. £0.0003 per event) are therefore flattened into a line item with a quantity of 1 to avoid discrepancies in the total. For example, an invoice line item with a quantity of 500 and a unit-rate of £0.001 will reflect in Xero as a quantity of 1 with a £0.50 rate.