How to Export Invoices from SMS to Xero with Multiple Item Lines

How to Export Invoices from SMS to Xero with Multiple Item Lines

Idea
Overview
This tutorial will provide information on how the Student Management System automatically exports Invoices with Multiple line items to Xero.


Info
NOTE: This exclusive feature is only available for Performance Package subscribers. Unlock the full potential of your SMS with the Performance Package. To upgrade your plan and access this feature, please contact our Support team.

Alert
IMPORTANT


An item line will be created for each Student Invoice item line. The associated account code used for the item line in Xero will be as per the following logic:
  1. The Account Code will be set to match the one that was set for the related Fee in the Program Instance of the Enrolment.
  2. If the related Program Instance Fee does not exist or has not been set, then it will use the default Account Code specified in Xero Export Options for the related Fee Type.
  3. Additionally, the invoices will only be exported to Xero if it meets ALL of the following conditions:

o   The invoice has not been exported to Xero yet.

o   The creation date of the invoice (Date Created) is greater than or equal to the Date of First Invoice.

o   The invoice has already been paid, OR

o   The invoice is unpaid and its due date is within the number of days specified in Export Unpaid Invoices – Days Before Due Date.

Example: If Export Unpaid Invoices – Days Before Due Date is set to 10, unpaid invoices with a due date within the next 10 days or less will be included in the export. For example, if today's date is 05/03/2025, invoices with a due date of 15/03/2025 or earlier will be exported.



A scheduled system task will run every 2 hours to check for invoices that are qualified to be exported to Xero. All exported invoices will then appear in the “Invoices” section of Xero Accounting Software under “Business” menu.

Info

Invoice Status Colour Legend

  • 🔴 Red – Overdue: The invoice is past its due date.
  • 🟡 Yellow – Not Issued: The invoice has not yet been issued. It will only be issued once the record's status changes to the status specified in the Invoice On setting.
  • 🟣 Purple – Purchase Order: The invoice is associated with a Purchase Order and will not be paid individually.
  • 🔵 Blue – Purchase Order Invoice: The invoice is the actual invoice generated from a Purchase Order.


  1. To see exported invoices from SMS to Xero:
    1. Go to Finance
    2. Go to Invoices Tab
    3. Click "Exported to Xero" dropdown list to filter the invoice view:
      1. Select N/A will not include the "Exported to Xero" as a search criteria.
      2. Select NO to exclude invoices exported to Xero.
      3. Select YES to include invoices exported to Xero.
    4. Click Search

Refer to the image below on where to find the dropdown list in the SMS.



Info
NOTE: 
  1. Once Invoice is paid, it can no longer be edited since it is already exported to XERO.
  2. The Invoice Number in the SMS is the same as the Reference No. in Xero and can be used for searching/sorting of invoices.


Notes
Related tutorials
  1. How to Integrate and Set up SMS with Xero
  2. Voiding Xero Invoice from the SMS
  3. Setting SMS Invoice as Paid if Paid in XERO
Congratulations on completing this tutorial. We hope this has been helpful to you and your organisation. For any questions or concerns regarding this function, please reach out to the contact support via email.