Skip to main content
LetCompliance

Help centre: Letting agents

How do I import my agency’s landlords, properties and tenants?

In the agency workspace, open Properties, choose Import and upload your Excel or CSV file, one row per tenant. Landlord columns match each property to a landlord client, or add the client, with their fee and service; a branch column puts it in a branch.

Rent, client money and every landlord’s statement in one workspace, from £24 a month.

Bringing the book across

1. Switch to the agency workspace, open Properties and choose Import.

2. Download the template there. In a workspace it carries the agency’s own columns: landlord, fee, service, branch and Right to Rent.

3. Fill one row per tenant, repeating the address for joint tenants and for each room of an HMO. Or upload the export from your old software as it is: the importer reads the headings, not their order.

4. Upload the Excel or CSV file, or paste the rows, check the preview, and confirm. Rows with a problem are listed with the reason, and every other property still imports.

The landlord columns

  • landlord_name, landlord_email and landlord_phone: the property is linked to the client with that email, or a new client is added
  • landlord_address: the client’s postal address, printed on documents that must give it
  • fee_type: % of rent, Fixed £ a month, Let-only fee, No fee, with fee_value for the figure
  • management_type: Full management, Rent collection, Let only

The fee and service are set only on a client the import adds. A client already on your book is never changed by an import.

Branches

A branch column puts each property in the branch with that name. A name that matches none of your branches is kept as typed and listed back to you; members pinned to a branch do not see that property until it matches.

Right to Rent

Three columns record each tenant’s check: right_to_rent_checked_on, right_to_rent_check_type, and right_to_rent_permission_end for a time-limited right.

What is not imported

Rent history. The importer takes the current rent, and the ledger starts from the day you begin recording. An opening balance for each landlord client is entered on the client’s page.

Running a small agency? Read what software small letting agents use, and what the agency plans cost.

Where this lives

Properties.

Open it in LetCompliance

Still stuck? Ask LetCompliance directly. A person reads it.

Run the whole let from one login.

Let and manage every landlord’s property from one workspace: adverts and referencing, the signed tenancy, rent and arrears, repairs and inspections, then each landlord’s statement and the client money report from the same records. Certificates, deposits and deadlines are tracked alongside.

Agency plans start at £24 a month, with unlimited branches and seats on every plan, a 14-day agency trial and no card.