Integrating with BMS and Xero

Introduction 

BMS integrates with Xero to keep your accounting data synced. You can export invoices from BMS, match payments to invoices in BMS, and add customer/supplier details directly in BMS. Using BMS with Xero integration keeps your accounting data synced. Use our Xero wizard to generate invoices in BMS and have everything synced with your accounting software. In your BMS, Navigate to Finance > Xero > Setup and follow through with the wizard to integrate to Xero successfully.

What's New!

  • BMS Integration with Xero now supports OAuth 2.0. Using this we have implemented the offline mode scope which allows the user to keep their integrated session active. This means that there will no longer be a 30 mins limitation to an active session. We use refresh tokens to keep the sessions activated. The session will be disconnected once the user manually chooses to Disconnect from Xero from the setup page.
  • Default Xero Purchases Account and Inventory Account in the Options tab. This is detailed in the Configure section. 
  • Modified Since filter now available when importing Items and accounts in BMS. 
  • You can access synced invoices from Xero in your BMS using the deep link we have created in Xero. 

mceclip0.png

mceclip1.png

Pre-requisites

  • Access to Finance module in BMS
  • Active Xero Integration account

Setup 

BMS setup with Xero involves the following 

Authenticate

  • In your BMS, Navigate to Finance > Xero > Setup
  • On the setup page, click on the Connect to Xero button.
  • This will redirect you to the Xero login page
  • Login to your Xero account
    • You will be asked to allow access to your organization data and user account
    • Choose Allow access
  • With a successful authorization, the wizard should show you the connection status and the company details, and the option to Disconnect from Xero. when you want. 

mceclip0.png mceclip1.pngmceclip2.png mceclip3.png

Configure

Once the setup is completed you will now see multiple tabs that allow you to set some basic rules for this integration that match your business process. The Options tab will determine the settings used when exporting invoices from BMS to Xero. The options available are as follows : 

  • Default Xero Sales Account
  • Default Xero Purchases Account
  • Default Xero Inventory Account

These options will be relied on when exporting an invoice having items with no defaults associated with it. When exporting an invoice if an item doesn't exist in Xero, the items will be created from BMS. We need to set some default options for it. The mapping is first checked for in Admin > Finance> Billing. If no mapping is found then the accounts are mapped using these settings here. This will correspond to your default sales and purchases account for a product in Xero.

    • For Income Account, the default sales account will be used instead.
    • For Expense Account, the default Purchases account will be used instead.
    • For Products, only when you are tracking an item in Xero the Inventory Asset account will be seen.
  • Xero Invoice Numbers
    • This option will specify which invoice number will be used when the invoices are exported to Xero. There are three invoice options:
      • Xero invoice numbers: This will follow the Xero incrementation scheme
      • BMS invoice number: This will keep the same BMS Invoice Number
      • BMS ID: This will use the BMS internal identifier.
  • Invoice Due Date:
    • This option will dictate how the Invoice Due Date will be set on the exported invoice in Xero.
      • BMS Due Date
      • BMS invoice generated date
      • 7 Days from the BMS invoice date
      • 14 Days from the BMS invoice date
      • 30 Days from the BMS invoice date
      • 20th of the invoice month
      • 20th of the month following invoice month
  • Insert PO numbers into the Reference field on Xero invoices
    • If enabled will allow the PO Number specified on the Invoice to be transferred to the reference field on the Xero Invoice.
  •  Don't update existing Xero Contacts (System will still insert new Xero contacts if they don't exist)
    • Setting this option to “No” will update the Xero contact, on the invoice, every time an invoice is exported.
    • Setting it to “Yes” will only link the invoice to the intended contact without updating any of his information.
      • Email and Postal Address info will be updated
      • In either case, if the contact was not found in Xero, it will be created automatically.

mceclip4.png


Importing Data from Xero

Once connected to Xero, you will be able to load and import Xero data to BMS, such as:

  • Contacts
  • Items
  • Accounts from the Chart of Accounts

mceclip5.png

Importing Accounts (Contacts)

In this section, you will be able to load contacts defined in a Xero account and import them as Accounts to BMS.

  1. In the Xero wizard, Choose Import >Accounts.
  2. Click on “Load Xero Contacts”, with or without filtration text.
  3. The Xero Contacts will be loaded into the grid.
  4. Select the desired contacts to be imported and hit Next.
  5. The following screen will show you status information about the import job created and when done you will be able to get more information about the import results.
  6. A “Show Transaction” button will be visible. Once you click it, a summary of events will appear.
  7. You can verify that the contacts have been successfully added to BMS by going to CRM>Accounts
Important!
  • If the Account in Xero has a default sales tax it will be imported as a Sales tax in BMS and link to its CRM accounts.mceclip6.png
  • Tax groups are not supported in BMS. All taxes imported from Xero will be imported as normal Tax, not Tax Group if it has multiple components. The reason behind this is that in Xero you can add the same Tax component for different taxes yet with different rates which are not allowed in BMS. 

Chart of Accounts

In this section, you will be able to load accounts defined in a Xero Chart of Accounts and import them as Account Codes to Chart of Accounts.

  1. In the Xero wizard, Choose Import >Chart of Accounts.
  2. Click on “Load Xero Accounts”, with or without filtration text.
  3. The Xero Chart of accounts will be loaded into the grid.
  4. Select the desired accounts to be imported and hit “next” to process this Job.
  5. The following screen will show you status information about the import job created and when done you will be able to get more information about the import results.
  6. A “Show Transaction” button will be visible. Once you click it, a summary of events will appear.
  7. You can verify that the Chart of accounts was imported by going to Admin> Finance >Account Codes

Items

In this section, you will be able to load accounts defined in Xero Inventory Items and import them to BMS as Work Types, Services, Products, Discount Types, Expense Type.

  1. In the Xero wizard, Choose Import > Items.
  2. Click on “Load Xero Items”, with or without filtration text.
  3. The Xero Inventory Items List will be loaded into the grid to select from.
  4.  Select the desired items to be imported and hit “next” to process this Job.
  5. You will be presented with a list of destination options to specify where the selected items will be imported.
  6.  The following screen will show you status information about the import job created and when done you will be able to get more information about the import results.
  7.  A “Show Transaction” button will be visible. Once you click it, a summary of events will appear.
  8.  You can verify that the items were imported into the selected destination. For example, Services can be checked under Admin > Finance > Services.

Exporting Data to Xero

Data can also be transferred from BMS to Xero. The following information will be exported:

  • Accounts (Contacts)
  • Accounts from the Chart of Accounts
  • Items from:
    • Service
    • Work types
    • Products
    • Discount types
    • Expense types

Exporting Accounts (Contacts)

In this section, you will be able to transfer accounts and account data from BMS to Xero as Contacts.

  1. In the Xero wizard, Choose Export> Accounts.
  2. Load the BMS accounts with or without filtration on Name/Code.
  3. Select the BMS accounts you wish to export and click “Next”
  4. Click on “Show Transaction logs” to view the export result.
  5. You can make sure the Accounts were successfully exported from BMS to Xero by logging in to Xero and going to Contacts.

Exporting Chart of Accounts

Here you can load the account codes defined in BMS'sChart of Accounts and export them to the chart of accounts of Xero.

  1. In the Xero wizard, Choose Export> Chart of Accounts.
  2. Click on “Load Chart of Accounts”.
  3. You can filter by Account/ Code or filter by Type.
  4. Select the COAs you wish to export and click “Next”.
  5. You can view the export results by clicking on “Show Transaction logs”.
  6. To verify if the COAs were successfully exported login to your Xero Account then go to Settings> Chart of Accounts

Exporting Items

For the items, you will be able to export different types of items from BMS to Xero, and that includes Services, Work Types, Expense Types, Discount Types, and Products. The items exported will end up as Inventory items under the Xero account.

  1. In the Xero wizard, Choose Export>Items
  2. Choose the item types from which you want to export. You can select one of the following item types :
    • Service
    • Product
    • Work Type
    • Discount type
    • Expense Type
  3. Click “Next”. The types of items selected earlier will be displayed.
  4. Choose the items to be exported and click “Next”.
  5. You will be directed to a page showing that the export is being processed.
  6. You can click on “Show Transaction Logs” to review the steps performed in the process of export.
  7. You can make sure your data was successfully exported by logging into Xero > Inventory.

Exporting Invoices to Xero

Invoices are from the most important parts of this integration, the ability to export invoices allows you to process invoices in BMS, export those invoices once ready to Xero, and then handle the accounting process against those invoices in the Xero accounting system.

  1. Navigate to Finance> Xero> Export Invoices.
  2. There are two options on which you can filter the invoices to be exported:
    • All invoices with statuses “Ready to send” or “Sent” or invoices whose due date falls between specific ranges. The date range is limited to thirty days.
  3. Click “Next”. You can perform a filter on the result on these fields: Customer, site, or Invoice number. Once the invoices to export are chosen, click next.
  4. The request will be processed and a message showing the status of the export will be displayed.
  5.  To check the exported invoices in Xero, sign in to your Xero account.
  6.  Go to Accounts> Sales> Invoices.
  • Please note that the invoices displayed for exporting have to be in the statuses “Ready to Send” or “Sent”, and not already exported to Xero before.
  • When exporting an invoice, the process will validate the availability of the items on the invoice starting with the customer. If the customer was found in Xero, then the invoice will link to it. If not found, then the sync tool will create the customer with the invoice. Matching happens on the customer name.
  • Furthermore, the tool will validate the availability of the tax rate specified on the invoice in BMS and the items in the details of the invoice, then either link to those items or create new ones. It is recommended to always check the transaction logs after the Job has completed, to review which invoices were exported successfully and which failed.
  • Its also recommended noting the Job Number (Job#) of the job being processed in case of any issue, so the support team can track the job and the transactions that were processed.

Importing Xero Payments

Following the export of invoices from BMS to Xero, the accounting process might include receiving payments against those invoices. Such process happens on the Xero side, and in order to keep both systems in sync, it is important to have the ability to import any payment that happened against an invoice exported from BMS to Xero, which will update the status of the invoices in BMS, the balance due and the related payments. Similarly to the import process explained in the previous sections, the process is fairly straight forward as follows:

  1. Navigate to Finance> Xero> Import Payments.
  2. You will be directed to a page that performs a filter on Payments-related fields. There are fields on which you can filter the payments to import.
    • From and To Date
    •  Invoice Number
    •  Invoice Reference
    •  Invoice Contact
  3. Click “Next” to load the payments.
  4. Select the payments you want to import and click “Next”.
  5. Your request will be processed.
  6. Check the transaction logs to determine if the import was successful.
  7. To view the imported payments, go to Finance> Payments.
  8. Payments that are not related to invoices that were originally exported from BMS to Xero will fail to be exported with a message indicating so.
Refer to this guide for Data mapping details - Data mapping : Xero and BMS
Refer to this guide for FAQs | BMS with Xero
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us