How to reconcile payments in Xero that were posted/completed in webSAM.


TABLE OF CONTENTS

Outline

 

Any payments completed in SAM must be reconciled in Xero using the payment clearing account.


The payment clearing account is usually a general ledger code that should have been set up when your SAM/Xero integration went live:

image 


The payments completed directly in Xero will not need to be reconciled using the payment clearing account, please contact/talk to your accountant for the standard reconciliation process.

 

In Xero, you can view the ‘Customer Invoice Report by Paid’ or the ‘Detailed transaction report – for the Payment Clearing Account’ for receipt reconciliations.

 

Reconciliations


You will need to use the payment clearing account in Xero:

  • Start by going into ‘Dashboard’ in Xero and clicking on Manage > Reconcile Account


  • Once in the reconciliation screen, you will find your statement transactions which have been imported from your bank feeds on the left-hand side of the screen. On the right-hand side of the screen, you will be able to match, create and transfer transactions.

  • When reconciling, you will need to ‘Create’ a transaction and link it to the ‘payment clearing account’.

     

Who: Name of the contact

What: Select the ‘SAM payment clearing account’

Why: A brief description


  • When all relevant details have been entered you can click on the ‘Ok’ button to continue


This will then remove the transaction from your reconciliation screen. Your ‘SAM Payment Clearing Account’ will now be credited and your Bank account (that you reconciled from) will be debited.


If all transactions receipted in SAM have been reconciled in Xero, your SAM Payment Clearing Account should balance and be zero.

If a cheque is processed as a receipt in SAM but has not yet been presented it is best to leave it in the clearing account until it is presented in the bank.

 

See this Xero article for more information


Payment Report


The Payments Report will display the payments made in SAM and also the Xero payments made against SAM invoices.

The report can be filtered by payment type, summary or detailed views. It can be used to reconcile the payments made for a defined period.