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:

Not ready to connect? Learn more about Accelo's Xero integration

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 Xero 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 options 123

  • 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.

  • Sync bills created in Xero: Turning this option on will sync all bills created in Xero with your Accelo deployment. Purchases in Accelo will always be synced, regardless if this option is enabled or not. 

  • 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.

Edit Invoice2

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.




Understand what information syncs between Accelo and Xero


Tax Codes

Accelo Field

Xero Field

Title

Display Name

Rate (%)

Total Tax Rate

 

Account Ledger Codes

Accelo Field

Xero Field

Title

Name

Code

Code

Can Purchase?

Show in Expense Claims?

Can Receipt?

Enable Payments to this Account?

 

Product/Material and Service Items

Accelo Field

Xero Field

Item Name

Item Name

Item Code

Item Code

Item Type

I purchase this item

Description

Sales Description & Purchase Description

Sale Account

Sales Account

Sale Tax Code

Sales Tax Rate

Purchase Account

Purchases Account

Purchase Tax Code

Purchases Tax Rate

Sale Price (excl. Tax)

Sales Unit Price

Purchase Price (excl. Tax)

Purchases Unit Price

 

Tracking Categories

Accelo Field

Xero Field

Tracking Category

Tracking Category Name

Category Option

Category Option

 

Invoices

Accelo Field

Xero Field

Invoice Title

Reference

Raised

Date

Due

Due Date

Invoice Number

Invoice #

Line Item Item

Line Item Item Code

Line Item Description

Line Item Description

Line Item Quantity/Rate

Line Item Quantity

Line Item Rate/Sale Price

Line Item Unit Price

Tracking Category 1

Tracking Category 1

Tracking Category 2

Tracking Category 2

Line Item Tax Code

Line Item Tax Rate

 

Purchases/Bills

Accelo Field

Xero Field

Purchase Number & Title

Reference

Purchase Date

Date

Payment Due

Due Date

Line Item Item

Line Item Item Code

Line Item Description

Line Item Description

Line Item Quantity/Rate

Line Item Quantity

Line Item Rate/Sale Price

Line Item Unit Price

Line Item Ledger Code

Line Item Account

Tracking Category 1

Tracking Category 1

Tracking Category 2

Tracking Category 2

 

Payments

Accelo Field

Xero Field

Reference

Reference

Received On

Payment Date

Payment Method Account

Paid To

Amount

Amount Paid

 

Credit Notes

Accelo Field

Xero Field

Reference

Credit Note #

Received On

Date

Amount

Amount

 

Customers & Vendors

Accelo Field

Xero Field

Company Name

Contact Name

Contact First Name

Primary Person First Name

Contact Last Name

Primary Person Last Name

Contact Email Address

Email

Contact Phone

Phone

Contact Mobile

Mobile

Company Primary Address Street1 & Street2

Postal & Street Address

Company Primary Address City

Postal & Street City/Town

Company Primary Address State

Postal & Street State/Region

Company Primary Address Zipcode

Postal & Street Postal / Zip Code

Company Primary Address Country

Postal & Street Country

How helpful was this page?
4.17 (Based on 13 ratings)
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