If you are going to operate using a Custodial Scheme to deal with your tenants deposits, you must first set up the account in Xero.
Go into your Xero. Select Chart of Accounts within Settings followed by Add Account
Set up as follows;
Note – Ensure that you tick the box that Enables payments to this account. You also have the option to view the account from you Xero dashboard.
Select Financials from the subheadings followed by Bank Accounts. From here select Add Bank Account and set up as follows. Adjust the DPS section of the name to any alternative scheme that you may use.
Now that both bank accounts have been created, it is time to map them. To do this, select Financials followed by Synchronise and Settings under the Xero tab. Select Mapping Bank Accounts
From here, map the deposit account in Arthur with the account that was set-up in Step 1. Once you have selected the right account select Save Mapping.
Note – If you did not select the bank that enables payments to this account then it will not appear on this list, hence the importance of doing this.
On the tenancy, add a transaction with the transaction type Registered deposit charge. This will create the charge in the tenant deposit statement (filter statement).
Select Save Transaction and conduct a synchronisation between Arthur and Xero.
Go into your Xero’s bank reconciliation page and reconcile the bank line with the relevant deposit invoice posted by Arthur.
Once you conduct a bank transfer to the custodial scheme (in real life), you will be met by a spent item in Xero.
From here, you would select Create and fill in the fields as follows;
Initially, the deposit needs to transfer back into the main tenant account in preparation for its return. This is created in Arthur using the Add Transaction within the tenancy, and use transaction type “Deposit Transfer to Rent Account”
*Ignore this step if there are no deductions to the tenant.*
If there are deductions, you must undergo two steps, one in Arthur and one in Xero.
This is done within the tenancy in Arthur. Enter a transaction e.g. sundry charge or disbursement depending on what you’re deducting. This will decrease the amount owing to the tenant and count as a deduction.
In Xero (this will be after you sync)
Go onto your Bank Reconciliation page. If there are any deductions, the Custodial Scheme will send you directly the funds. You must deal with these in order to level off the nominal account within Arthur. Find the received item from the Custodial Scheme and follow these steps.
Who – Select the custodial scheme
What – The Nominal Account set up for your custodial
Why – Description
Units/Properties – Tracking codes for unit and properties
It is now time to remit to the tenant. This is done in the ‘Close tenancy’ function within the tenancy screen in Arthur. On the left click on more and select Close Tenancy. At the point of closing the tenancy you will be prompted to enter a bank account from where the refund is coming from. You will choose the Xero account set up in section one (titled – How to Set up your Deposit Custodial Account). The refund process is now complete.
Our support staff are ready to help with any technical issues.
To get in touch please use our online chat below