Clients who self manage are less likely to encounter problems compared to those that manage for 3rd parties. That is because the former simply have to handle the tenant’s statement and are simply posting rents, while the latter has an owner statement and are posting remittances and most issues arise because the balance on these statements to do not balance with their counterpart on Xero. For this reason, understanding the two systems is paramount to avoid problems.
If the Arthur team has not onboarded you then it is likely you will be unaware of the nuances of such a relationship and if you’re unfamiliar with Xero then the likelihood is you will cause issues for yourselves. Our onboarding service includes 4 hours of training.
This article is detailed in both:
The two systems are connected via Xero API (Advanced program interface) which controls the data between the two systems and defines how they behave together. Warning messages that appear during sync will give a very good indication of where the problem is. It is always worth looking carefully at the logs if you notice a problem as they are quite descriptive in identifying an issue.
If you are having trouble synchronizing (i.e. the sync won’t even start without erroring) please read ‘Connection problems with Xero’
Refunds: Xero does not like on account refunds unless they are allocated to a credit note (either in Arthur or Xero). If you enter an on account refund to a tenant or payment to a property owner in Arthur without fully allocating it to credit in Arthur first, it will not post to Xero.
Where have you added transactions?: It is essential that you add a transaction in the correct area, be it at ‘Property, Unit or Tenancy’ level. If you try and add a tenancy transaction to property or unit there will be no option to allocate it to a tenancy statement
Editing transactions: If a transaction has been edited after it has already been synchronized, you will need to run sync on all records in order for this to update in Xero. The best practice is to void transactions and recreate it if you would like to resolve it efficiently by yourself.
Voided transactions: Generally speaking most things voided in Arthur should automatically void in Xero, but anything voided in Xero will definitely be voided in Arthur. Voided Property Owner charges in Arthur will also need to be voided manually in Xero. You will see the following message during the synchronization, if you have lots of property charges you need to void, it’s best to do it in Xero because it will void in Arthur too.
Often transactions are posted to Xero with an advanced date. It is easy to be fooled that it hasn’t gone across because most reports on Xero run as at today’s date. This especially happens when looking at Aged receivables/payables reports in Xero and the balances look wrong. You can always see if a transaction has gone across by looking in the respective Tenant/Property Owner/Contractor accounts and viewing all bills
Click on your company name > Settings > Advanced settings
On Xero, ‘Lock Dates’ are a feature that prevents you from entering a transaction after a specific date. Hence any transaction posted after the dates entered after the ‘Lock Dates’ will not be posted. You can enter these dates as shown below;
Should a transaction occur after this period, you must remove the ‘Lock Dates’ and then add them again with dates that will allow the transaction to occur within.
Upon reconciling a rent charge in Arthur, this creates a bill towards the Property Owner in Xero. This eventually forms part of your remittance in Xero.
If this bill is reconciled in Xero, this will prevent your remittance from syncing to Xero.
Solution: Locate the bill that is reconciled in Xero, “Remove and Redo” the associated payment. Then you are free to remit that transaction
After undoing a remittance in Arthur, it is necessary that you undo the corresponding remittance in Xero before you remit again. Otherwise, your remittance will not post to Xero
Solution: Undo the remittance in Xero as suggested in this guide: https://www.arthuronline.co.uk/knowledgebase/how-to-undo-a-property-owner-remittance/
The ‘Create’ feature on Xero is extremely powerful and is useful when dealing with bank transactions unrelated to Arthur. However, when create is used if an invoice has not been suggested, this prevents the invoice from being reconciled. This can make transactions that are correctly paid
Solution: Remove and Redo any transactions where ‘Create’ was used that relate to any invoices or remittances posted by Arthur, and reconcile correctly
If an invoice has been reconciled, or a credit note refunded, but they are done through a bank account that isn’t mapped to Arthur. This will stop the payment and the respective refund from coming back through into Arthur.
Solution: Set-up the bank account in Arthur, map this bank account within ‘Mapping Bank Accounts’ to the corresponding bank in Xero.
The transaction type in Arthur is mapped to nominal codes in Xero. When these nominal codes have been archived or deleted, this stops those transactions from going into Xero.
Solution: Unarchive the nominal codes, run a sync to ensure transactions post over
Our support staff are ready to help with any technical issues.
To get in touch please use our online chat below