Guide for landlords

Excel or rental management software: when a spreadsheet is enough

For one or two flats with a fixed rent, an Excel or Google Sheets spreadsheet is often enough. Software pays off once you collect meter readings every month, split the utilities, issue invoices and chase late payers. This guide compares what a spreadsheet does with what software does, and shows how to switch without retyping anything.

· Written by the AxiRent team

When is Excel enough?

If you let one or two flats, the rent is the same every month and the tenant pays the utilities to the suppliers directly, a sheet with the tenant, the amount and the payment date does the job. It is free, flexible, and you already know how to use it.

What matters is that there is one sheet and it is kept up to date: then you can always see who has paid and who is late.

Where does a spreadsheet start to get in the way?

Each of these jobs is small on its own, but with five flats they add up to dozens a month, all done by hand:

  1. Meter readings: the tenant sends them by message or photo, and you retype them and work out the consumption.
  2. Invoices: every month you build a document, keep the numbering straight and send it by email.
  3. Reminders: you have to notice a late payment and write to the tenant yourself.
  4. History: who paid what and when is spread across several files and emails.
  5. Working together: once someone else looks after the flats too, the copies of the file start to differ.

What does rental management software take over?

Software keeps the same data in one place and does the repeating work itself. The tenant sends meter readings as a photo, the consumption is worked out from them, invoices and reminders go out on their own, and in the tenant portal the tenant sees their own invoices and payments.

  1. Readings. Excel: you retype them. Software: the tenant photographs the meter.
  2. Invoices. Excel: you build and send them. Software: issued and sent automatically.
  3. Reminders. Excel: you notice and write. Software: sent on the days you set.
  4. Tenant questions. Excel: you answer “how much do I owe?”. Software: the tenant sees it in the portal.
  5. Cost. Excel: you already have it. Software: one property is free, more on a plan.

What about the tenants' personal data?

A sheet with tenants' names, phone numbers and ID numbers holds personal data, and the GDPR requires it to be protected against unlawful processing and loss (GDPR art. 5(1)(f) and art. 32). When copies of the file travel by email or sit on several computers, that is harder to do.

In software the data sits in one place, and each tenant sees only their own records.

How do you switch without retyping?

You do not retype the sheet: the AI import reads Excel, CSV, PDF or a photo and sorts properties, tenants, tenancies and readings into place, and you review everything before it is saved. Step by step: how to move your rental spreadsheets out of Excel.

With AxiRent one property is free with no time limit and no card, so you can start with one flat and compare it with your sheet. More properties: see pricing.

Sources

Excel and Google Sheets are described by what they generally do, and AxiRent's features as they are on the day of the check. The data protection requirements are quoted from the GDPR as published on EUR-Lex.

Common questions

Is Excel good enough for rental bookkeeping?

For one or two flats with a fixed rent, yes. Once meters, invoices and reminders come in, the manual work grows every month with every flat.

Is Google Sheets better than Excel?

Google Sheets lets several people work in one file, so the copies do not drift apart. The other limits are the same: readings, invoices and reminders are still done by hand.

Will I lose my spreadsheets if I switch?

No. The import only reads your file and does not change it, and the sheet stays on your computer or drive.

How much does rental management software cost?

With AxiRent one property is free with no time limit and no card. More properties are priced by plan: see pricing.

Rent day without the spreadsheet

One property free, with no card and no time limit.

UAB “Terra IT”, Kaunas, Lithuaniainfo@axirent.com+370 600 06 265Mon–Fri 9:00–18:00 (Vilnius time)