Switching letting agent software is safe when the client money moves last and is proved first. Export everything from the old system in a set order, run both systems side by side through one month end, and switch the old one off only when each landlord's opening balance in the new system agrees to the penny with the old system's final reconciliation. Then keep the old records for as long as your scheme and the law ask, and tell landlords and tenants what changes for them.
The money is the part with no margin. Client money belongs to the landlords and tenants it is held for, and every client money protection scheme must require its members to "keep records and accounts that show all dealings with client money" (the 2018 client money regulations, regulation 5). Property details, tenants and certificates can be typed in again if something is missed. A balance that moves by a pound in the move is a pound you will have to explain to a landlord, and perhaps to your scheme.
Before you export anything
- 1Choose the cut-over date. The first day of a month, straight after a month end you have reconciled and signed off, gives both systems a clean line to start from
- 2Get the old provider's export in writing. Ask for every table in CSV, plus PDFs of the statements, ledgers and reconciliations, and ask how long you keep access after the contract ends
- 3Read the data protection terms on both sides. Your old provider processes your landlords' and tenants' data for you, and UK GDPR requires its contract to say that, at your choice, it deletes or returns all of that data when the service ends (Article 28(3)(g)). Ask for the return before the end date, and for deletion only once you have checked the export. The new provider needs the same kind of contract, and you may only use one that gives sufficient guarantees to protect the data (Article 28(1))
- 4Freeze what you can. Agree new landlord terms, fee changes and new branches either before the cut-over or after the parallel month, not during it
What to export, and in what order
Each layer hangs off the one before it: a tenancy needs its property, a property needs its landlord, and a ledger means nothing until it is attached to both. The open items change daily, so they come last, on the cut-over day itself.
| Order | Export | Check before you move on |
|---|---|---|
| 1 | Landlords: names, postal addresses, emails, fee terms and service level, signed terms of business | One record per landlord, no duplicates from old spellings |
| 2 | Properties: address, landlord, branch, management type, licence and its expiry | Every property has a landlord |
| 3 | Tenancies and tenants: start date, rent, rent day and frequency, every tenant and guarantor, Right to Rent check dates and any permission end date | Rent and rent day match the agreement |
| 4 | Ledgers and balances: each landlord's ledger, tenant ledgers, the client cash book, fees earned but not yet transferred, unpaid supplier invoices, the last three signed reconciliations | The landlord ledgers add up to the client bank balance on the cut-over date |
| 5 | Deposits: amount, scheme, reference, protection date, date the Prescribed Information was given, and which deposits sit in your client account under an insured scheme | Matches the scheme's own list of your deposits |
| 6 | Documents: agreements, Prescribed Information, inventories, notices served with proof of service | Each file named by property and date |
| 7 | Certificates and their dates: gas, electrical, EPC, licences, alarm checks | Each expiry date read from the certificate, not copied from a field nobody has checked |
| 8 | Open items: arrears per tenant, open works orders, notices running, landlord approvals awaited | Each one has a named person on the first day |
Landlord bank details for payouts deserve their own care. Re-enter them in the new system from a source you trust and check them with the landlord by phone on a number you already hold, never from an emailed spreadsheet.
The format checks that save a week
Most migration errors are spreadsheet errors. Keep the raw export untouched and work on a copy, and check these before importing:
- Dates. One format throughout. A day and month swapped on a tenancy start date moves its rent day and its next rent review
- Pounds and pence. Some systems export amounts in pence, some with a minus sign for money out, some with brackets
- Leading zeros. Spreadsheets drop them from account numbers, references and some postcodes
- Merged names. Joint tenants in one cell need splitting into separate tenants
- Closed records. Ended tenancies and former landlords belong in the archive you keep, not in the live import
Count the rows at each step: landlords out of the old system, landlords into the new one. The two numbers should match, or you should know why not.
Run both systems side by side through one month end
A parallel month proves the new system produces the same figures before anyone relies on them. Using a cut-over date of 1 November:
- 131 October. Reconcile the client account in the old system and sign it off. Its landlord balances become the new system's opening balances
- 2During November. Record every receipt, payment and fee in both systems. Keep rent collection running in one system only, so no tenant is charged twice
- 330 November. Draw every landlord's statement in both systems and compare them landlord by landlord, line by line. Reconcile the client account in both
- 41 December. If every statement and both reconciliations agree, the new system becomes the book of record and the old one goes read-only
Where a November statement differs, trace it before December starts: a fee taken at a different rate, a cost posted to the wrong property, a rent received date that put it in the wrong month. Tracing a reconciliation difference walks through the usual causes.
Opening balances, to the penny
Every landlord's opening balance in the new system has to equal their closing balance in the old system's signed reconciliation on the cut-over date, and the three figures of the three-way check have to agree.
Worked example. The old system's reconciliation for 31 October:
| Line | Amount |
|---|---|
| Client bank statement balance, 31 October | £48,210.00 |
| Less: payment to Landlord B sent 31 October, not yet through the bank | £2,400.00 |
| Add: tenant's card payment recorded 31 October, reaching the bank on 2 November | £950.00 |
| Adjusted bank balance | £46,760.00 |
| Client cash book balance, 31 October | £46,760.00 |
| Landlord A ledger | £12,345.67 |
| Landlord B ledger, after the £2,400.00 payment | £8,014.33 |
| Landlord C ledger, including the £950.00 rent | £26,400.00 |
| Total of landlord ledgers | £46,760.00 |
The adjusted bank balance, the cash book and the ledgers all come to £46,760.00, so the move can start. The opening balances entered in the new system, dated 1 November, are £12,345.67, £8,014.33 and £26,400.00.
The two timing items need carrying across too. When the £2,400.00 leaves the bank and the £950.00 arrives in early November, the new system's reconciliation has to explain both, because neither was recorded there. Write the list of uncleared items on the cut-over date and keep it with the October reconciliation.
If your client account also holds tenancy deposits under an insured scheme, they sit in the bank balance but in no landlord's ledger. List them separately, so the three-way check still agrees. How the three figures are built is set out in client accounting for letting agents.
Keep the old records
Before the old subscription ends, download what you must keep into files you control: every landlord statement, the ledgers, the cash book, each signed reconciliation, the deposit records and the tenancy files. Read-only access to an old system usually ends with the contract, and the export is your record of everything before the cut-over.
How long each kind of record is kept, and which rules set the period, is in the retention table on letting agent record keeping. The periods differ: client money records follow your scheme's rules, anti-money laundering records have a fixed period after which the personal data must be deleted, and tax records follow HMRC's. Keep each for its own period, not one blanket figure.
Tell landlords and tenants
Landlords want three things: the date of the first statement from the new system and how it will look, confirmation that their balance carried over (give the figure), and how they can see their account. Their payout bank details should not change, so say so, and say that you will never ask for bank details by email.
Tenants need to know whether anything about paying the rent changes. If the rent account or the way rent is collected changes, write to them from a channel they already know, well before the next rent day. A Direct Debit set up through the old system is usually tied to that system, so each tenant will need to authorise a new one.
Two notices are easy to miss. Your privacy information must name the recipients of personal data, or their categories (UK GDPR, Article 13(1)(e)); if yours names the old provider, update it. And changing software is not changing client money protection scheme, so the 14-day notice to clients in the scheme rules does not apply, unless you change scheme at the same time. The scheme duties are in client money protection for letting agents.
Moving to LetCompliance
Bring the book across in one file, and the balances in by hand, to the penny. When moving your agency to LetCompliance, one CSV with a row per tenant brings in the properties, tenants and landlords: the landlord email column files each property under its landlord client, matched on the email or created with the name beside it, and a branch column files it under its office. The same rows carry rent, deposits, the gas, electrical and EPC expiry dates, each landlord's postal address, fee and service, and each tenant's Right to Rent check, and every row is checked and shown to you before anything is imported. A sheet uploaded again updates the properties already there, so branches can move one at a time. On a paid plan you can email the old system’s export to hello@letcompliance.com instead, and LetCompliance imports the properties and tenants for you, included in the plan.
Certificates go in as files, many at once, with the dates filled in where the reading is clear. An owner or admin enters each landlord's opening balance on their client page, dated the day you move, and it goes on that landlord's first statement and into the client money report. There is no import for a rent ledger, so rent is recorded from the day you move and the first statements are for that month: the old system's statements stay your record of what came before.
Reconcile client account then sets the bank balance, the cash book and each landlord's ledger side by side to the penny, and a bank line that is not in the records, such as an old payment clearing in the first week, gets a note saying what it is. The month end page shows rent, statements, payments, fee transfers and the reconciliation for the month in one place. Direct Debit rent goes to the agency's own Stripe account, and each tenant authorises their own. LetCompliance holds no client money and no deposits: they stay in your client account and with your deposit scheme.
The agency plans run from £24 a month for up to 5 properties to £129 a month for unlimited properties. Every agency plan has every agency tool and unlimited seats and branches; only the number of properties and the storage differ.