On the first day: properties and tenants
Open Properties and choose Import. Upload your Excel or CSV file as it is, or paste the rows with the headings at the top: headings such as Address, Postcode, Rent and Gas expiry are matched by their words, not their order. Use one row per tenant, repeating the address for joint tenants and for each room of an HMO. The preview lists any row with a problem and why, and every other property still goes in. Up to 500 rows go in at a time, so a larger portfolio goes in parts. Upload the sheet again later to update what is there.
Next: certificates
Drop the certificates on Add many certificates at once in Certificate renewals. They are read one at a time while you check and save the first rows, and Confirm all confident saves every row read with confidence in one go. A file over 4 MB is not read, but it is still filed on the property for you to date by hand.
Next: rent already paid, and this year’s money
For each tenancy that began before you joined, mark the earlier months paid, still owed or left out. Then import this tax year’s bank statements as CSV, so your income and costs since 6 April are in one place before your first Making Tax Digital update.
What takes longer, and why
- Direct Debit. Each tenant authorises their own mandate from a link, and a request not completed in 14 days expires. Each collection starts on the due date. Bacs confirms it about three working days later, and Stripe then pays it into your bank on your payout schedule.
- Paperwork you have to find. A certificate you cannot put your hand on has to come from the engineer or the register before its date can go in
- The rent history. The import takes the current rent, not a ledger of past payments: the rent ledger starts from the day you begin recording
For a letting agency
An agency workspace has its own take-on import: landlords, properties, tenants, fees, services and branches from one sheet, then an opening balance for each landlord client.
Starting on LetCompliance
Sign up, then add your first property or choose Import on Properties. Every new account starts with 3 days of the premium tools, with no card and no limit on properties. Making Tax Digital, the notices and the tax pack come with every paid plan, from £7.99 a month, with no VAT added.