Connect your Xero Account with Accelo

Keep your accounting and production teams on the same page by automatically syncing invoices and payments between your Accelo and Xero accounts.

Using this guide, you can:

What does the Xero integration actually do?

  • Imports current and historical customers from Xero into Accelo

  • Imports historical invoices from Xero into Accelo
  • Imports data for more accurate invoicing in Accelo, including:

    • Inventory items
    • Ledger codes
    • Tax codes
    • Tracking categories
  • Syncs new invoices which are created or edited in either Accelo or Xero between the two systems

  • Syncs those invoices' contact information with Accelo and Xero
  • Syncs those invoices' payments with Accelo

  • Void Approved/Paid Invoices & delete Draft invoices in Xero when deleted in Accelo
  • Syncs new purchases which are created or edited in Accelo with Xero

 

How does Accelo’s two-way synchronization work?

When an invoice is created in either system, Accelo will automatically check for the same contact in the opposite system.  If a matching contact is found, then we'll list the new invoice under that contact. If no matching contact is found, we'll automatically create a new contact for you.  With that invoice we'll also sync several key data points, which include:

  • The contact's First and Last Name
  • The contact's Company/Client
  • The contact's physical address, email address and phone number
  • The Invoice Title and Description
  • Individual line item Descriptions, Subtotal, and Tax Amounts
  • The Tax and Ledger Codes used for each line item
  • The Service or Material Item used for each line item
  • The Tracking Category used for each line item
  • Payment Amounts, Methods, Dates and Recording Staff Person

Connecting Xero to Accelo

Important things to note before integrating your accounts:

  • Connecting your Xero account will begin automatically syncing new invoices created either in Xero or Accelo between the two systems

  • Connecting your Xero account will not import any previous invoices to Accelo automatically. You will have the option to Import previous invoices.

  • Only an Accelo Administrator is able to connect to Xero

  • Only a Xero Administrator is able to authorize the integration within Xero


To connect your Accelo account to Xero:

  1. Open the Integration page by clicking your User Profile Icon in the Navigation Bar and selecting Integrations.

    accelo.integrations2

  2. Select Xero and click the Connect button.  

    accelo.connect to xero

  3. If you're not already logged in to your Xero account, a window will pop up with a prompt to log in.

  4. Confirm the Xero Organization that you'd like to integrate with and click the Authorize button.

Screenshot from 2017 02 24 13 29 16

Congratulations!  You've successfully connected your Accelo and Xero accounts.

Importing your data from Xero

Now that you've connected your Xero and Accelo accounts, your accounting codes, customer, invoice and payment history can be imported from Xero!

xero import options2

Your import options include:

  • Import Account and Tax Codes from Xero:
    Pull your existing ledger and tax codes from Xero into Accelo.  This is a vital step to ensure your invoices sync accurately. Staff can then select from these ledger and tax codes when creating invoices in Accelo, which will ensure that your invoices are listed properly in Xero.

    • Accelo will only import and sync with Item Codes whose Type is "Income"
    • Accelo requires at least one Tax Code be synced with Quickbooks in order to sync invoices.  If you don't charge tax, a tax code set to 0% can be used instead.
  • Import Products and Services from Xero:
    • Pull your existing inventory items from Xero into Accelo as Materials and Services.  Similar to the account and tax code import, this is a vital step to ensuring that your invoices sync accurately.  Staff can select from these items when creating invoices in Accelo, ensuring that the correct inventory item is attributed to each line item, updating your inventory on hand, and creating more detailed invoicing reports.
      • Items in Xero which are only marked as I sell this item will be imported as Services in Accelo
      • Items in Xero which are marked as both I sell this item and I purchase this item will be imported as Materials in Accelo
      • The I track this item setting does not affect the import
  • Import Tracking Categories from Xero:
    Pulls your active Tracking Categories and their options from Xero into Accelo.  These Tracking Categories can be applied to your invoices' line items when creating invoices in Accelo, giving you more detailed reports when the invoices sync with Xero.  
  • Import Companies from Xero:
    Pull your existing company and supplier records from Xero into Accelo, creating new Company & Contact records for them.  

    The Company import includes the following details:

      • The contact's First and Last Name
      • The contact's Company/Client name
      • The contact's physical Address, Email Address and Phone number
  • Import Invoices and Payments from Xero:
    Pull your existing invoices and any payments which have been applied to those invoices from Xero into Accelo, creating new invoice  and payment  records for them.

    The Invoices and Payments import includes the following details:
    • The Invoice Title and Description
    • Individual line item Descriptions, Quantity, Rate, Subtotal, and Tax Amounts
    • The Tax and Ledger Codes applied to each line item
    • The Inventory Item applied to each line item
    • The Tracking Category applied to each line item
    • Payment Amounts, Methods, Dates and recording Staff Member
    • The invoice's customer-facing Notes
    • The invoice's Internal Notes

 

Choosing your Xero Integration Preferences

Now that you've connected your Accelo and Xero accounts, new invoices will begin to automatically sync between the two systems.  You'll also have several options available to control what information is included in that sync:
xero sync options2

  • Sync invoices created in Xero: Determines whether Accelo will automatically pull new invoices into Accelo which are created in Xero.  This setting does not affect Accelo's push of new and updated invoices to Xero.

  • Default invoice status: Determines the status which will be applied to invoices which are pushed from Accelo to Xero.   

    Status Options:
             1. AUTHORISED: The invoice will be marked as Approved/Authorized in Xero. Users can only edit invoices within Accelo.
             
    2. DRAFT: Users can continue to edit invoices in Xero & Accelo, until that invoice has been Approved in Xero.

  • Push Payments Created in Accelo: Determines whether payments can be entered in Accelo and automatically synced with Xero, or can only be entered in Xero.  When enabled, you'll also be prompted to select a default payment account:
    xero push payment option
    • Default Payment Account: Determines the income account which will be used when payments are pushed from Accelo into Xero.
  • Import Xero Contacts when Importing Xero Invoices: Automatically creates a new Company and Contact in Accelo if a new invoice is created in Xero, but the invoice's contact has not been imported into Accelo.  Invoices created in Xero with new contacts while this setting is disabled will not be imported.  This setting requires Sync Invoices Created in Xero to be enabled.
  • Status to Import Companies With: Status which will be used in Accelo when importing new companies from Xero
  • Status to Import Suppliers With: Status which will be used in Accelo when importing new suppliers from Xero

 

Editing Your Invoices

Edit your invoices in Accelo using the Edit Invoice button.

accelo.Edit Invoice Xero

This button appears when viewing an invoice that has not yet been paid or approved in Xero

Note - once your invoice has been Paid or Approved in Xero, you will no longer be able to push changes from Accelo to Xero, as Xero locks the invoice to prevent further changes.

Using the Edit Invoice page you're able to edit the full range of invoice details, including:

  • Invoice Contact

  • Invoice Title

  • Invoice Description

  • Raised & Due Dates

  • Line Item Descriptions

  • Line Item Prices

  • Line Item Tax and Ledger Codes

  • Line Item Service and Material Items
  • Line Item Tracking Categories

 

Recording Payments

Payments must be manually recorded in Xero.

Once an invoice has been synced to Xero, a Xero drop down button will appear in Accelo that allows you to view the invoice in Xero as well as Sync from Xero and Push to Xero.

accelo. record xero payments

When a payment has been recorded against an invoice in Xero, these details will be synced back into Accelo, including the payment amount, date recorded, reference field, and the user that recorded the payment.

Please note - Overpayments and Prepayments are not supported, so you will not see any credits being pulled back into Accelo.

Accelo uses cookies to give you the best possible experience - by clicking 'Continue' you agree to our use of cookies. Refer to our Privacy Policy for details. Continue