Setting Up The Xero Integration
Login to your dashboard and select the "Settings" icon located at the bottom of the left-hand menu, and then select the "Apps" page.
Click the "Enable Integration" button in the Xero integration box. A popup dialog will redirect you to allow Oncord to access Xero.
After clicking the "Connect to Xero" button, you will be presented with the below page which will allow you to give Oncord API access to Xero. Select the organisation you would like to synchronise with and click the "Authorise" button. You will be redirected back to your dashboard.
You will be presented with configuration options the first time you manually synchronise Xero and Oncord. Check the options carefully and configure the integration appropriately.
Important: Map Accounts for Payment Methods:
Synchronisation also occurs between "Payments" in Xero, to "Receipts" in Oncord. This area defines the mapping between the two systems.
- For direct deposit accounts, you should select the bank account that customers pay into.
- For PayPal, you should select your PayPal account Xero.
- For credit card payments, it is recommended you create a new "Clearing Account" in your "Chart of Accounts" called "Credit Card Clearing". Refer to this article: http://developer.xero.com/documentation/api-guides/handling-payment-processor-receipts-in-xero/
- Cash and other manual payment methods may also use a settlement account.
- It is recommended that all payment methods are linked to a Xero account.
To perform the first manual synchronisation and configure the integration, select the "Synchronise button" in the Xero box displayed on the Integrations page.
You will be presented with a configuration form which will allow you to setup how Xero and Oncord interact. If you'd like to access this form again after configuring the integration, click the "Configuration" link for Xero on the Integrations page of the dashboard.
Payment Reconciliation Notes
When configured correctly, payments should reconcile and synchronise as follows:
Customer pays via Direct Deposit
Oncord does not take payment immediately, invoice is UNPAID
Customer pays via direct deposit. Bank statement line is allocated to this invoice. Invoice is PAID in Xero
Oncord syncs and invoice is PAID in Oncord.
Customer pays via PayPal
Oncord takes payment immediately, invoice is marked PAID in Oncord
In Xero, a payment is allocated to the PayPal account.
When reconciling your PayPal account, each customer payment for invoices should show a green Match to the invoice.
Customer pays via Credit Card:
Oncord takes this payment immediately, invoice is marked PAID
Payment is allocated by Oncord automatically in Xero to your Credit Card Clearing Account (DR).
When your lump sum payment comes in the next day or two, this should be allocated to the Credit Card Clearing Account (CR)
At the end of this process, this account should have a balance of $0
Customer pays via EFTPOS
Oncord takes payment immediately, invoice is marked PAID
Payment is allocated by Oncord automatically in Xero onto an EFTPOS clearing account (DR).
When your lump sum payment comes in the next day, this should be allocated to the EFTPOS Account (CR)
Customer pays via Cash
Oncord automatically marks invoice as PAID.
Operations depend on how cash payments are handled in Xero.
If you do not have it syncing the receipt from S8, then when reconciled in Xero, it will pull and you will get an over payment in S8.