XERO Integration

Introduction

The Meshed Platform can be integrated with Xero – a popular accounting software commonly used by education institutions and organisations.


The interchange of data between the Meshed Platform and Xero, using the Meshed Xero API Integration Module, eliminates the need to double handle data.


Integration provides the ability to sync financial information:

  • Invoices for Student fees can be managed and recorded within the Meshed Platform and exported to Xero.
  • Settled payments can be imported from Xero to the Meshed Platform to reconcile the transactions between the two platforms.



Overview

The Meshed Platform integrates with Xero using a Xero API to achieve following objectives:

  1. Send invoices created in Meshed Higher-Ed to Xero.
  2. Once Payment is made in Xero against invoices, retrieve the amount paid from Xero to settle it in Meshed Higher-Ed.

Meshed Group has developed a Xero console engine which can be run at desired interval of time (once a day, every 12 hours, every 2 hours, etc) to interchange data between the two systems.


Note: Integration is not real time. Engine will run based upon scheduled time.


Sending Meshed Platform Invoices to Xero

Sending invoices to Xero:

  • Create Invoices in Meshed Higher-Ed. Once the engine runs at the scheduled time, the invoices will be created in Xero.




  • Invoice ID from Meshed Higher-Ed will be used to map invoices between the two Systems; Xero and Meshed Higher-Ed.
  • InvID in Meshed Higher-Ed is mapped to the Number column in Xero.
  • Invoice Number in Meshed Higher-Ed is mapped to the Ref column in Xero.
  • If there are multiple line items in a Meshed Higher-Ed invoice, in Xero individual invoices will be created for each line item.
  • Meshed Group can implement custom logic to send only invoices which are due in a certain date range.


  • After a sent invoice is created in Xero, a flag in Meshed Higher-Ed indicates that invoices have been sent to Xero.



  • If the Tuition Fee for a Course is GST inclusive in Meshed Higher-Ed, this is reflected in Xero:



 

Retrieving Payment Information from Xero

Settling a transaction in the Meshed Platform once payment is made in Xero:

  1. Log into Xero and record payment amounts for invoices (fully or partially).
  2. Once the engine runs at the scheduled time, payment information will be settled in Meshed Higher-Ed.




Agent Commission and Bonus Adjustment

Agent Commission and Bonus Adjustment during the Settlement Process:

  • Log into Xero and open the relevant invoice.



  • Deduct Agent Commission and Agent Bonus from the invoice and save it in Xero.



  • Make the payment in Xero.




  • After the engine processes, the paid invoice will be settled in Meshed Higher-Ed and Agent Commission and Agent Bonus will also be settled.




  • Note: In a Xero invoice while adding line items, the description text should be “Agent Commission” and “Agent Bonus” to ensure the integration functions correctly.


Deleting an Invoice in Xero

If an invoice is deleted in Meshed Higher-Ed, after the engine processes the invoice it will be deleted from Xero if the invoice is in the “draft” section of Xero.

  • Log into Meshed Higher-Ed and delete the invoice from the system. Once the engine runs at the scheduled time, the invoice will be removed from Xero.




Transactions Log in the Meshed Platform

To view the records of transaction information:

  • Invoices sent to Xero, Payment information received from Xero, Log of Transaction in a particular iteration can be viewed in Meshed Higher-Ed by navigating to Admin > Document Repository > Xero


 

Limitations

The Xero integration has the following limitations:

  • If an invoice created in Xero is deleted by the user in Xero, the same invoice cannot be sent again from Meshed Higher-Ed.
  • Xero only allows for the creation of 60 invoices per minute.
  • If a partial payment is made in miscellaneous fee in Xero, it can’t be settled back in Meshed Higher-Ed (Partial payment settlement applies only to Tuition fees)



Client Integration Information 

To integrate respective Meshed Higher-Ed platform with Xero, Meshed Group provides a public key certificate to the Client. Using this information, the Client will need to generate the following information and provide it to the Meshed Group:

  1. Consumer Key
  2. Consumer Secret

Note: Meshed Group will need to create a key pair by using these details. The key expiry date also needs to be defined when creating the key.


Pre-requisite for Integration

In Meshed Higher-Ed, Clients need to setup Account Codes prior to using the Xero integration.  The Account Code information needs to be identical in both the Xero and Meshed Higher-Ed Systems.

To create an Account Code in Meshed Higher-Ed:

  • Navigate to Accounts > Account Setup > Ledger Value
  • Select Fee Type
  • Select Course Type
  • Enter the Account Number
  • Enter the Description
  • Click Add