If you are going to operate using a Custodial Scheme to deal with your tenants deposits, you must first set up the deposit control account in Arthur.
Select “Financials” from the subheadings followed by Bank Accounts. From here select “Add Bank Account” and set up as follows. Adjust the custodial section of the name to any alternative named scheme that you may use.
Map Arthur Bank Account to QuickBooks
Synchronise Arthur and QuickBooks. You will now be able to find and use this account in QuickBooks.
Go into the Tenancy > Add Transaction type “Registered deposit charge”. This will create the charge on the tenant deposit statement.
Select Save Transaction then conduct a synchronization between Arthur and QuickBooks
Go into QuickBooks > Banking and match the 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 QuickBooks.
From here, you would select the Transaction and fill in the fields as follows;
Complete this by using the “Add” feature in QuickBooks. This will credit the Custodial Scheme Account.
Carry out the closing tenancy as shown in the article
No entry will go through the bank account in QuickBooks as the credit will be created in QuickBooks as a credit to the custodial account.
If you are refunding the tenant directly, select your client bank account as the ‘Remittance bank account'( in the image above). You can then reconcile the tenant remittance transaction against the payments (refund) made to the tenant on QuickBooks.
In QuickBooks (this will be after you sync)
Go onto your Banking page. If there are any deductions, the Custodial Scheme will send you the funds directly. 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
Payee – Select the custodial scheme
Category – The Account set up for your custodial scheme
Memo – Description
Class – Tracking codes for unit and properties
Our support staff are ready to help with any technical issues.
To get in touch please use our online chat below