Understanding analysis codes, How they work and the basics of setting up custom ones

Created by RevQore Support, Modified on Tue, 26 Mar 2024 at 12:04 PM by Ella Kitching

Analysis Codes are transactions that behave in certain ways on a statement. They describe the details of your transactions on a ledger. Arthur provides you with a set of default codes that tell a transaction how to behave. Two of the most common ones used are

Direct rent
Rent charge

These are codes that relate to rent. Direct rent is used by self managing landlords while Rent charge is used by agencies where the rent is owned by an owner

Default Analysis codes provided include:

Charges

Contract Fee Charge – Generic code for a admin fee to prepare a contract
Deposit Transfer to Rent Account – This code is used when transferring a deposit from the tenancy deposit account to the tenant rent account.
Direct Rent – Code used when self managing a tenancy. i.e there is no property owner statement. This is linked to charging rent to a tenancy
Rent Charge – Code used when managing on behalf of someone else. i.e there a property owner statement. This is linked to charging rent to a tenancy
Disbursement Charge (Recharge) – This is used when charging a tenant/owner for a bill you paid to a third party (should always be two transactions created, one receivable and one expenditure for your business)
Disbursement Charge against a Float Statement – Allows you to hold charges against your float in a separate property owner ledger so you can separate them from the main owner account. All transactions that use this code can only be viewed on ‘property owner float statement’.
Head Agent Commission – This is used where you have a agent that collects your rent and then pays you less their commissions.
Letting Commission Charge – This is used by an agent when setting up charges to be paid by the property owner. T
Management Fee Charge – This is used by an agent when setting up charges to be paid by the property owner. T
Reference Fee Charge – This is often used to charge a tenant for a reference
Service Charge – Charge will usually cover maintenance and repair work in communal areas.
Sundry Charge – This is used for any generic charge to a tenant/owner; the money you receive is revenue for you company (e.g. tenant find fees/admin fees)
Tax Deduction – In cases where withholding tax is made against an overseas property owner, you can use this code to analyse the amount of tax deducted.
Tenant Opening Balance – This transaction has been created for Xero users, who when they set up their opening balances may want it to appear on a different section of the balance sheet rather than the same account their rents go into. This can be remapped, but please speak to a member of the team before using this transaction type.

Receipts

Payment made to Property Owner – This is used by the property manager, when the property owner asks for a sum of money to be sent immediately (outside of a remittance). This will then be deducted from the amount to be paid to the owner when you process their Property Owner Remittance.
Property Owner Float Receipt – This is used by the property managers when the property owner pays a sum of money direct to hold for a float.
Property Owner Receipt – This is used by the property manager when the Property Owner makes a direct payment to the manager. For example, if the owner pays £1000 to a property manager, for future charges at the end of a tenancy, such as cleaning. .
Registered Deposit Receipt – This code is used when receiving the registered deposit. This code enters the funds directly into the tenant deposit account.
Tenancy Receipt – This is used when a tenant has paid a sum of money. This can also be used when presenting a scenario of receiving local authority rent credits.

How do these transactions behave

Transaction above fall under two main categories:

Charge
Reciepts

Charges

Debit the statement (charge the tenancy or owner)
Credit the statement (credit the tenancy or owner- negative charge)

Receipts

Credit the statement (receive money)
Debit the statement (pay money out of the statement)

Below shows how these are displayed on a statement:

Create your own custom codes

Arthur allows you to create bespoke custom codes which can be mapped directly to your accounting software's (Xero) chart of accounts. To create a code go to Financials>Analysis Codes: