If you have chosen to reconcile with Xero using a Settlement Account this article will explain how.


There are two ways to do this:


Option 1: Manually creating an entry for each line on your bank statement.

Option 2: Automatically using a transfer rule to create the matching entry.


See instructions for both processes below.


Manual bank reconciliation in Xero

  1. When you setup Xero integration with SimpleClinic you will have selected a "settlement account". A settlement account is simply a virtual account in Xero for your business, and will hold transactions from SimpleClinic, before they are allocated or "reconciled" to other accounts in Xero.
  2. The settlement account was created in Xero as a current asset account that was BAS excluded and able to take payments. During the reconciliation process you will be transferring funds from the settlement account into the matching bank account for your business.
  3. Your bank reconciliation will have lines for each merchant settlement from your bank and from HICAPS if used. See screenshot. 
  4. Add a contact in the Who field on the right hand side. This is not the invoice name. The invoice name and payment is already tracked against the contact. Use a contact name like "Merchant Settlements".
  5. From What field, select the settlement account when you initially setup your Xero integration.
  6. Make sure the Tax Rate is set to BAS Excluded. It should select this automatically from the account.
  7. Click the green OK button and that merchant summary will be reconciled. Repeat for as many merchant summaries you have in your bank statement or bank feed.


Rule-based Reconciliation


You can create a rule to match each of the merchant settlement transactions automatically.

  1. To create a rule, select the Create Rule drop down in Xero.
  2. Filter the list of conditions that appear in step 1 to define a condition that matches your specific bank / settlement combination.
  3. Set the contact. Use or select a contact name like "Merchant Settlements".
  4. Leave Step 3 as is.
  5. Complete Step 4 choosing your settlement account and ensuring the tax rate is BAS Excluded.
  6. For Step 6, select any bank account to run the rule against, or select to run the rule against all bank accounts.
  7. For Step 8, give the rule a name and click Save.


This will now automatically apply the rule to matching bank statement lines.


Also, if you are using HICAPS, you can create a matching rule for HICAPS transactions.