Exporting Invoices from SMS to Xero with Multiple Item Lines

Exporting Invoices from SMS to Xero with Multiple Item Lines

Overview

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


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 due date of the invoice is less than or equal to today’s date.



A scheduled system task will run daily at 12:00 p.m. AEST 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.



  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.


Related tutorials

    • Related Articles

    • How to Export Invoices from SMS to MYOB with Multiple Item Lines

      OVERVIEW This tutorial serves as a guide and will state what the required conditions are and when will the invoices from the SMS export to MYOB. Location in SMS: Students Page > Financial Tab > Student Payment Plan Table IMPORTANT Make sure to ...

    • How to Integrate and Set up SMS with Xero

      Overview In this tutorial, we will show users how to integrate Xero Accounting Software with the Student Management System allowing users to export invoices to Xero, mark invoices as paid in the SMS and void invoices that are deleted in the SMS. This ...

    • How to Manually Create and Edit Student Invoices in the SMS

      Overview Your SMS comes with financial management features that allow you to create payment plans, issue invoices and accept payments for your student enrolment. In the SMS, there are multiple ways to create invoices for your student fees depending ...

    • Setting SMS Invoice as Paid if Paid in XERO

      Overview In this tutorial, we will outline how to set your exported invoices in the SMS to "Paid" when you process the payment in Xero. For users with existing Xero integration, this will give information on how the Student Management System gets ...

    • Managing and Exporting Invoices

      OVERVIEW In this tutorial, we will show how you can view, check and export invoices from Finance. This also includes steps on how you can accept payment and send any invoice-related email to students. Navigation Instruction: Follow us through our ...