Integration with Xero: payments

Payment integration is an optional component of the Case Manager Xero integration and you can choose whether to use it.

Before you run this process for the first time contact Support to set up the technical connections between your Case Manager database and your Xero database. You also need to have the web version enabled and turn on a system setting, see Set up Xero integration for details. You should carefully read through this page before implementation, including the notes at the bottom.

Once payment integration has been set up, you should stop adding payments in Case Manager.

You should also stop journalling payments in Case Manager, see below for details.

The process

As indicated in the diagram below, payment information for Case Manager invoices is entered in Xero.

Each time a payment is added to a Case Manager invoice Xero automatically sends the payment information to Case Manager, where a matching payment transaction is created against the invoice. Case Manager invoices are identified in Xero as any invoice with the "CM-" prefix in its invoice number.

Naturally information about payment changes or deletions against such invoices is also sent to Case Manager.

Thus, in this integration, Xero payments are considered to be the originals and the Case Manager payments are the copies. An invoice payment change in Xero (adding, editing or deleting a payment) is mirrored automatically in Case Manager.

The integration is achieved with Xero's Webhooks technology. It aims to send the payment's details as soon as possible, so you should be able to go immediately to Case Manager and see the matching payment.

Payment mapping

Below is a Xero payment and the matching payment in Case Manager.

  1. The payment date is the same for both.
  2. The Reference number is optional in Xero.
  3. If a value has been entered in Xero it will be displayed in the Reference number field in the Case Manager payment.

  4. The Contact is the invoice contact's company, as detailed in Invoice mapping.
  5. Inv # has CM- added to the invoice number.
  6. The invoice's due date is calculated and displayed, see Invoice mapping.
  7. Xero's Total is the invoice total.
  8. The payment amount is the same for both.
  9. In Case Manager the payment is identified as a Xero payment in the Notes: field.

Important notes

  • Only Xero invoices prefixed with "CM-" are eligible for synchronisation of payments.
  • There are two ways to create payments in Xero: paying an invoice or performing a bank reconciliation. They both have the same outcome from the point of view of Case Manager.
  • Note that Xero Credit Notes are not considered to be payments and they will not be exported to Case Manager.

  • If you edit a cash payment in Xero and apply it against a Case Manager invoice this is interpreted as a new Xero payment against the invoice and the payment will be sent to Case Manager.

When you delete a payment in Xero it is sensible to check that the corresponding Case Manager payment has been deleted.

Payment matching and mirroring

Xero payments are the originals and the Case Manager payments are the copies. An invoice payment change in Xero (adding, editing or deleting a payment) is mirrored automatically in Case Manager.

The first step at Case Manager is to match arriving Xero payments to any existing Case Manager payments. The first time a match is found, a note is made in the Case Manager payment.

The next step is to mirror payment amounts (or to delete payments altogether) so that the Case Manager payment fully mirrors the Xero payment.

There are three situations where full mirroring does not occur:

  • When you modify or delete a payment in Xero that has been journaled in Case Manager

  • When a Case Manager payment was part of a multi-invoice payment in Case Manager
  • The Case Manager payment is undisturbed: neither matched or mirrored.

  • When a manually entered Case Manager payment does not match any Xero payment in date and amount
  • The Case Manager payment is undisturbed.

Once payment integration is under way you would be very unlikely to encounter these situations.

However, be aware that when you are transitioning from double-entering payments in Case Manager and in Xero to entering payments only in Xero there may be times when they occur.

Further information

When you add a part payment in Xero, the invoice's entire collection of part payments is sent to Case Manager for review. Usually you do not need to be concerned about the details, however they may be relevant when transitioning from double-entering your payments.

Other topics