What the file needs
Three columns must be present in some form: the first line of the address, the town or city, and the postcode. The importer matches on the heading text and accepts the obvious variations, so address, address line 1 and street all land in the same place.
What else it will take if you have it
- Tenants, one row each: name, email, phone, start date, rent and deposit. Repeat the address for joint tenants, and for each room of an HMO
- The rent, and how often it is due when that is not monthly
- Gas safety, EICR, EPC, fire risk assessment and legionella dates, and the EPC rating
- The licence and its expiry, and the insurance renewal date
- The mortgage: lender, balance and the date the deal ends
- What each property cost and when, and what it is worth now, so its equity and loan to value are there from the first day
- In your own account, whose tax return each property is in (yours, a limited company’s, or not yours) and your share of it
- In an agency workspace, each landlord’s postal address, fee and service for a client the import adds, and each tenant’s Right to Rent check: the day it was made, how, and for a time-limited right the day the permission ends
Columns it does not recognise are ignored and listed back to you by name, so nothing is silently dropped. Rows with a problem are listed with the reason. A property waits until all of its rows are right, and every other property still imports, so you do not lose a hundred good rows to one bad postcode.
What it does not import
Rent history. The importer takes the current rent figure, not a ledger of past payments. If you are arriving from another platform with years of transactions, export them and keep the file: the rent ledger here starts from the date you begin recording.
Bringing in more later
Upload the file again and choose Update properties you have. Each row finds its property by postcode and first address line, you see every change before it is made, and a blank cell never clears anything.
If you have no export
The import screen has a template with every column and four example rows: a flat let to two joint tenants, and an HMO with one room let and one empty. Overwrite the examples with your own. Any left in are refused, so they never become properties.
Having it imported for you
On a paid plan you can email your spreadsheet, or an export from the software you use now, to hello@letcompliance.com instead, and LetCompliance imports the properties and tenants for you, included in the plan.
